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.

More about 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.

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. 

What can you do? 

All CRUD operations (Create, Read, Update, Delete)

Only Read the data

What kind of data?

Usually single source from a database or warehouse
(ex: SQL Server)

Can access data from anywhere and combine data from multiple sources too.

How do you use it?

You need to “WRITE” queries to use SQL. 

You “BUILD” Power Queries using the UI buttons and menu options.

Where can you use it?

Works almost universally. You can use SQL with most database systems and programming languages. 

Only with Microsoft stack of products, primarily with Power BI, Excel and Fabric.

Who can use it?

By default, you need permissions / special software to use SQL.

Almost anyone can use Power Query as it comes packaged with Excel and Power BI.

How fast is it?

Built for performance and scalability. You can use SQL to access data quite efficiently.

Can become slow and tedious as your data grows. 

Have you used both or either of these technologies? What do you think? Leave a comment with your thoughts.

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

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.

I want to preface this discussion with a huge note of thanks & gratitude for what Power BI offers. It is a beautiful technology with a few patches of ugliness.

Learn more about 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.

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.

In the podcast, I talked about creating a digital wardrobe. My recommended webcam, mic & lights are below:

Recommended Webcams:

Recommended Mics:

Recommended Lighting:

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.

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.

Over the last year, I have been thinking about about restarting the podcast. I listen to a lot of podcasts (Tim Ferris show, All-in, Tropical MBA, Office Ladies, YouTube Creators Hub to name a few). They educate, entertain and inspire me. I want to pass along some of those benefits to you. So here we go (again).

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

In this podcast,

Comprehensive guides on,

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.

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?

In this podcast,

Click here to download the MP3 file.

Podcast episodes on formulas

Articles to learn important formulas

I am happy to announce that I have a Patreon page now. If you love my podcast, head to my Patreon page to pledge a little to Chandoo.org. Thanks for your generosity and love.

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

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.

In this podcast,

Click here to download the MP3 file.

Thanks for all your generous support and love so far. I will be broadcasting new episodes twice a month from now. If you want to hear about a particular topic, share your suggestions in the comments area or email me at [email protected]

Our podcast is a great place to learn Excel on the go. There are tons of topics and back episodes to keep you busy for next marathon or month of commute. Check out our back catalog or subscribe today.

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

In the 54th session of Chandoo.org podcast, let’s make you awesome in Pivot Tables.

In this podcast,

Click here to download the MP3 file.

Comprehensive guides on,

Pivot Table Tips & Tricks

Now its your turn. Go ahead and share your favorite pivot table tricks in the comments box.

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

In the 53rd session of Chandoo.org podcast, let’s talk about data validation.

In this podcast,

Click here to download the MP3 file.

Data validation introduction & examples:

Advanced validation examples:

Data validation in play – case studies:

Additional resources:

Did you get the answer for homework? Please post your answers / explanations in the comments section.

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

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.

In this podcast,

Click here to download the MP3 file.

Download this podcast transcript [PDF]

M is for Data Monkey book

More information &  tutorials on Power Query

More resources on Power Query

Courses to help you tackle data problems

Have you read M is for data monkey? How do you like it? What other books on PQ do you read? Please share your opinions and suggestions in the comment box.

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