Podcasts by Category
- 62 - 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/@MrXLThu, 07 Dec 2023 - 38min - 61 - SQL vs. Power Query – The Ultimate Comparison
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 :)Fri, 13 Oct 2023 - 28min - 60 - 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/Thu, 24 Aug 2023 - 21min - 59 - 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.
Thu, 27 Jul 2023 - 30min - 58 - Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast)
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.Thu, 13 Jul 2023 - 26min - 57 - 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 youThu, 27 Oct 2016 - 35min - 56 - 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?Thu, 13 Oct 2016 - 22min - 55 - 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 youThu, 31 Mar 2016 - 34min - 54 - 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 notesThu, 10 Mar 2016 - 35min - 53 - 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
ConclusionsThu, 11 Feb 2016 - 26min
Podcasts similar to Chandoo.org Podcast - Become Awesome in Data Analytics
- Global News Podcast BBC World Service
- El Partidazo de COPE COPE
- Herrera en COPE COPE
- The Dan Bongino Show Cumulus Podcast Network | Dan Bongino
- Es la Mañana de Federico esRadio
- La Noche de Dieter esRadio
- Hondelatte Raconte - Christophe Hondelatte Europe 1
- Curiosidades de la Historia National Geographic National Geographic España
- Dateline NBC NBC News
- 財經一路發 News98
- La rosa de los vientos OndaCero
- Más de uno OndaCero
- La Zanzara Radio 24
- L'Heure Du Crime RTL
- El Larguero SER Podcast
- Nadie Sabe Nada SER Podcast
- SER Historia SER Podcast
- Todo Concostrina SER Podcast
- 安住紳一郎の日曜天国 TBS RADIO
- アンガールズのジャンピン[オールナイトニッポンPODCAST] ニッポン放送
- 辛坊治郎 ズーム そこまで言うか! ニッポン放送
- 飯田浩司のOK! Cozy up! Podcast ニッポン放送
- 吳淡如人生實用商學院 吳淡如
- 武田鉄矢・今朝の三枚おろし 文化放送PodcastQR