app_store_button

google_play_button

Device Banner Block-copy 894x1036

Astu lugude lõputusse maailma

Loe ja kuula

Training & Data Analysis Specialist

Chandoo - Microsoft Excel MVP

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.

Chandoo.org Podcast - Become Awesome in Data Analytics

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.

The post CP05: Interview with MrExcel – Bill Jelen (on his incredible work ethic) appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

CP05: Interview with MrExcel – Bill Jelen (on his incredible work ethic)

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?!?

The post SQL vs. Power Query – The Ultimate Comparison appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

SQL vs. Power Query – The Ultimate Comparison

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, just as any technology, Power BI too has it's own shortcomings. So in this episode of my podcast, let's uncover 4 ugly truths of Power BI.

The post CP03: The Ugly Truth About Power BI (actually, 4 of them) appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

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

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. 

The post CP02: Six Tips to get a Six Figure ($100,000+) Data Job appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

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

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.

The post Top 5 Excel Skills you need to be a Successful Data Analyst in 2023 (podcast) appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

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

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

The post CP056: So which formulas you should care to learn? appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

CP056: So which formulas you should care to learn?

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?

The post CP055: “Yes, I am back” edition (and a bonus Excel tip) appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

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

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

The post CP054: Top 10 Pivot Table Tricks for YOU appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

CP054: Top 10 Pivot Table Tricks for YOU

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

The post CP053: Excel Data Validation for Dummies appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

CP053: Excel Data Validation for Dummies

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

The post CP052: Book Review – M is for Data Monkey by Ken & Miguel appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

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

In the 37th session of Chandoo.org podcast, Let's debug 'em #VALUEs & #N/As.

What is in this session?

In this podcast,

 • Introduction to Excel formula errors

 • The easy kind: syntax errors

 • The triky ones: # ERRORs

 • Fixing errors - using IFERROR & ISERROR

 • Error checking & debug options

 • Using Errors deliberately - charts & data validation

 • A challenge for you - produce #NULL error

 • Conclusions

The post CP037: Error error on the wall, How do I fix you all? – Understanding & Fixing Excel Errors appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.

CP037: Error error on the wall, How do I fix you all? – Understanding & Fixing Excel Errors

Loe ja kuula

Muud podcastid, mis võivad sulle meeldida ...