Chandoo.org Podcast - Become Awesome in Data Analytics

Chandoo
  • 4.3 (14)
  • TECHNOLOGY
  • MONTHLY
Chandoo.org Podcast - Become Awesome in Data Analytics

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. Subscribe now to become awesome.

Episodes

  1. 07/12/2023

    CP05: Interview with MrExcel - Bill Jelen on his incredible work ethic

    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. For more about Bill, visit his website https://mrexcel.com or his YouTube channel - https://www.youtube.com/@MrXL

    38 min

  2. 13/10/2023

    SQL vs. Power Query - What are the key differences and how I use them?

    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 since it came out in early 2012. And in this article, let me share my views on how SQL compares with Power Query. If you prefer to listen, check out the podcast episode - SQL vs. Power Query. For show-notes & resources, visit https://chandoo.org/wp/sql-vs-power-query/ Get my Power Query Essentials Course https://chandoo.org/wp/power-query-power-course/ ~ Rate & Review this Podcast. You are awesome :)

    28 min

  3. 24/08/2023

    CP03: The Ugly Truth About Power BI (actually, 4 of them)

    Power BI is one of the best data analytics platform in the world. But it is not all roses and honey. There are some ugly parts to this amazing software. In this podcast episode, let me share 4 of my frustrations with the software / platform. For more, visit https://chandoo.org/wp/cp03-the-ugly-truth-about-power-bi/ Full podcast catalog - https://chandoo.org/wp/category/podcast/ My Power BI course - https://chandoo.org/wp/power-bi-course/

    22 min

  4. 27/07/2023

    CP02: Six Tips to get a Six Figure ($100,000+) Data Job

    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.

    30 min

  5. 13/07/2023

    Top 5 Excel Skills you need to be a Successful Data Analyst in 2023

    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. In the 1st episode of Season 2 of Chandoo.org podcast I talk about, Top 5 Excel Skills you need to be a Successful Data Analyst in 2023.

    27 min

  6. 27/10/2016

    CP056: So which formulas you should care to learn?

    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 Date & time Work specific Closing remarks & resources for you

    35 min

  7. 13/10/2016

    CP055: “Yes, I am back” edition (and a bonus Excel tip)

    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 between last and this episode What next? How to extract every 6th item from a list?

    23 min

  8. 31/03/2016

    CP054: Top 10 Pivot Table Tricks for YOU

    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 unique count Spruce up with conditional formats Not so ugly pivot charts Resources & Show notes for you

    35 min

  9. 10/03/2016

    CP053: Excel Data Validation for Dummies

    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 validation rules Homework problem for you Resources & show notes

    35 min

  10. 11/02/2016

    CP052: Book Review – M is for Data Monkey by Ken & Miguel

    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 you will learn Conclusions

    26 min
  • 10 Episodes

4.3
out of 5
14 Ratings

About

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. Subscribe now to become awesome.

Information

To listen to explicit episodes, sign in.

Stay up to date with this show

Sign in or sign up to follow shows, save episodes and get the latest updates.
Select a country or region

Africa, Middle East, and India

Asia Pacific

Europe

Latin America and the Caribbean

The United States and Canada