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.

For more about Bill, visit his website https://mrexcel.com or his YouTube channel - https://www.youtube.com/@MrXL

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 :)

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/

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 interpersonal skills & present yourself better

Strong Interviewing skills

Focus on L

Listen to this episode

Subscribe to the Show

Resources for this podcast episode

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

Recommended Webcams:

Premium webcam: Elgato Facecam. I have been using Elgato Facecam for the last few months and just love it. It produces crisp, HD quality images & videos with almost no effort. Get it from Amazon.

Budget webcam: If you want a good quality webcam that produces decent video and good light capture, try Logitech c920. This was my primary webcam for more than 4 years and never disappointed me. Get it from Amazon.

Recommended Mics:

Premium mic: If your job involves a lot of talking, I suggest getting a good mic to enhance your voice quality. I use Blue Yeti Mics for my videos and livestreams and just LOVE them. Get it from Amazon.

Budget mic: I use the Plantronics Blackwire USB headset on the go and love the voice clarity it produces. Get it from Amazon.

Recommended Lighting:

The best lighting is natural light. So position your seat opposite to a window so that your face is getting natural light at angle. Try using sheer curtains to diffuse the strong direct sunlight.

Alternatively get a ring light if you work from a dark room or away from windows. I suggest this one on Amazon.

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.

Why I am starting it again?

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 this episode…

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

What is in this session?

In this podcast,

Welcome message

Top 5 (Advanced) Excel Skills

Tables

Power Query

Dynamic Arrays & Spill Ranges

Pivot Tables & Data Model

Charting & Story-telling

Listen to this session

Subscribe to the Show

Resources for this podcast

Comprehensive guides on,

Excel Tables

Power Query – Deep introduction

Power Query – Mini Course

Dynamic Arrays & Spill Ranges

Pivot Tables

Data Model & Relationships

Charting & Story-telling Examples

Advanced Excel Skills

Top 5 Excel Skills – Video

Top 5 Data Skills – Video

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.