Want to be an AWESOME DATA ANALYST? Chandoo.org Podcast is the place to go. Learn how to use popular Data Analytics software like Power BI, Excel, SQL and more with your host Chandoo – an award winning author, speaker and YouTuber.
…
continue reading
1
CP05: Interview with MrExcel – Bill Jelen (on his incredible work ethic)
38:19
38:19
Lejátszás később
Lejátszás később
Listák
Tetszik
Kedvelt
38:19
Bill Jelen is one of my most favorite people on earth. That is why I wanted to have him as my first guest when I restarted the podcast. Even though I recorded this few weeks ago, only now I got around to publishing it. Please enjoy the conversation with Bill. Listen to this episode Resources for this podcast episode More about Bill: MrExcel.com (Bi…
…
continue reading
1
SQL vs. Power Query – The Ultimate Comparison
28:25
28:25
Lejátszás később
Lejátszás később
Listák
Tetszik
Kedvelt
28:25
On the left side, we have a veteran warrior with 37 years of data battle scars and redundant six pack. They call him SQL. On the right side, there is a young challenger with transformative powers and “never say undo” attitude. He goes by the moniker Power Query. Who is going to win this battle?!? I have been using SQL for 25 years and Power Query s…
…
continue reading
1
CP03: The Ugly Truth About Power BI (actually, 4 of them)
21:47
21:47
Lejátszás később
Lejátszás később
Listák
Tetszik
Kedvelt
21:47
Power BI is one of the most prominent data analytics technology out there. Power BI is also one of the most marketed and hyped technology out there. Unfortunately, both of these statements are true. In a world where data is the buzz word, Power BI (or other similar platforms like Tableau) appeal to CXOs as panacea for all their data troubles. But, …
…
continue reading
1
CP02: Six Tips to get a Six Figure ($100,000+) Data Job
30:18
30:18
Lejátszás később
Lejátszás később
Listák
Tetszik
Kedvelt
30:18
So you want a 6 figure data job? In this podcast episode, I am going to share 6 strategies and tactics to land a $100k+ data job. Episode outline: My experience of working in a a 6 figure ($100k+) data job 6 strategies Build wide data skill base Cultivate deep technical skills in 1-2 areas Develop business & functional knowledge Cultivate interpers…
…
continue reading
1
Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast)
26:33
26:33
Lejátszás később
Lejátszás később
Listák
Tetszik
Kedvelt
26:33
Ladies & gentlemen… I have an exciting announcement. I am relaunching my podcast!!! It only took me 7 years, but Chandoo.org podcast is now BACK! I am planning to make regular episodes on Excel, Power BI, SQL & Data Analytics. Why I am starting it again? Over the last year, I have been thinking about about restarting the podcast. I listen to a lot …
…
continue reading
1
CP056: So which formulas you should care to learn?
35:27
35:27
Lejátszás később
Lejátszás később
Listák
Tetszik
Kedvelt
35:27
In the 56th episode of Chandoo.org podcast, let me answer the chicken and egg question of Excel users. How many formulas should you care to learn? What is in this session? In this podcast, Two personal updates 3 legs of formula writing Function knowledge Operators Referencing 6 categories of must-know functions Basic math Conditions Lookups Text Da…
…
continue reading
1
CP055: “Yes, I am back” edition (and a bonus Excel tip)
22:36
22:36
Lejátszás később
Lejátszás később
Listák
Tetszik
Kedvelt
22:36
Ladies & gentlemen, its time we revived the much loved Chandoo.org podcast. In the 55th episode, I do a lousy imitation of Arnold Schwarzenegger’s famous “I will be back” and tell you why there was such a long gap between episodes, my plans for reviving our podcast and more. What is in this session? In this podcast, Why there was such a long gap be…
…
continue reading
1
CP054: Top 10 Pivot Table Tricks for YOU
34:49
34:49
Lejátszás később
Lejátszás később
Listák
Tetszik
Kedvelt
34:49
In the 54th session of Chandoo.org podcast, let’s make you awesome in Pivot Tables. What is in this session? In this podcast, Quick updates Top 10 pivot table tricks Adding same value field twice Tabular layouts GETPIVOTDATA & 2 bonus tricks Relationships & data model One slicer to rule them all Show only top x values Relative performance Show uniq…
…
continue reading
1
CP053: Excel Data Validation for Dummies
35:26
35:26
Lejátszás később
Lejátszás később
Listák
Tetszik
Kedvelt
35:26
In the 53rd session of Chandoo.org podcast, let’s talk about data validation. What is in this session? In this podcast, What is data validation How Excel DV compares with database & software DV? Types of data validation rules List & custom rules explained Input & error messages Alternatives to data validation Enhancing data validation Removing data…
…
continue reading
1
CP052: Book Review – M is for Data Monkey by Ken & Miguel
26:19
26:19
Lejátszás később
Lejátszás később
Listák
Tetszik
Kedvelt
26:19
In the 52nd session of Chandoo.org podcast, let’s discuss monkeys, Ok, I am kidding. We are going to talk about M is for Data Monkey book. What is in this session? In this podcast, Updates: Why so much gap between episodes? Quick introduction to Power Query Why you should get this book? What is in this book? A very cool example of the techniques yo…
…
continue reading