Show overview
Chandoo.org Podcast - Become Awesome in Data Analytics has been publishing since 2014, and across the 9 years since has built a catalogue of 62 episodes. That works out to roughly 35 hours of audio in total. Releases follow a roughly quarterly cadence, with the show now in its 2nd season.
Episodes typically run twenty to thirty-five minutes — most land between 26 min and 44 min — though episode length varies meaningfully from one episode to the next. None of the episodes are flagged explicit by the publisher. It is catalogued as a EN-US-language Technology show.
The catalogue appears to be on hiatus or wound down — the most recent episode landed 2.4 years ago, with no new episodes in over a year. The busiest year was 2014, with 27 episodes published. Published by Chandoo - Microsoft Excel MVP, Training & Data Analysis Specialist.
From the publisher
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.
Latest Episodes
View all 62 episodes
S2 Ep 5CP05: 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. The post CP05: Interview with MrExcel – Bill Jelen (on his incredible work ethic) appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
S1 Ep 4SQL 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?!? The post SQL vs. Power Query – The Ultimate Comparison appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
S2 Ep 3CP03: The Ugly Truth About Power BI (actually, 4 of them)
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.
S2 Ep 2CP02: 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. 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.
S2 Ep 1Top 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. 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.
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 The post CP056: So which formulas you should care to learn? appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
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? The post CP055: “Yes, I am back” edition (and a bonus Excel tip) appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
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 The post CP054: Top 10 Pivot Table Tricks for YOU appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
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 The post CP053: Excel Data Validation for Dummies appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
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 The post CP052: Book Review – M is for Data Monkey by Ken & Miguel appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered
In the 51st session of Chandoo.org podcast, let's discuss most frequently asked questions about VLOOKUP. What is in this session? In this podcast, What is VLOOKUP? What happens when VLOOKUP can't find the value? Should my list be sorted? Is VLOOKUP slower than INDEX + MATCH? What if my list has multiple matches? How to fetch 2nd / 3rd matching item? How to fetch all matching items? How to fetch items matching multiple conditions? How to speed up VLOOKUP? Why doesn't my VLOOKUP work? What to do in case of errors? Resources for you The post CP051: VLOOKUP FAQs – Most frequently asked questions about VLOOKUP – Answered appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
CP050: Fifty Excel Tips to make you awesome
This is going to be epic!!! In the 50th session of Chandoo.org podcast, we have 50 Excel tips to make you awesome. What is in this session? In this podcast, Thank you message Fifty tips in 5 buckets Shortcuts & Productivity Formulas Managing Data Charts Using Excel better The post CP050: Fifty Excel Tips to make you awesome appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
CP049: Don’t do data dumps!!!
In the 49th session of Chandoo.org podcast, let's talk about data dumps! What is in this session? In this podcast, What is a data dump Examples of data dump Why we dump Ways to avoid data dumps Go for information dumps Sort the dump Filter the dump Give a table Resources for you The post CP049: Don’t do data dumps!!! appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
CP048: How to create animated charts in Excel?
In the 48th session of Chandoo.org podcast, let's make some animated charts!!! What is in this session? In this podcast, Announcements Why animate your charts? Non-VBA methods to animate charts Excel 2013's built-in animation effects Iterative formula approach VBA based animation Cartoon film analogy Understanding the VBA part Example animated chart - Sales of a new product Resources and downloads for you The post CP048: How to create animated charts in Excel? appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
CP047: Best Excel tools for Entrepreneurs
In the 47th session of Chandoo.org podcast, let's see how Excel can make you an awesome entrepreneur. What is in this session? In this podcast, Why Excel for entrepreneurs Key areas of a business owner's work Projects & to dos Finances Customers & marketing Planning & strategy Processes & workflows 5 features of Excel that help Conclusions The post CP047: Best Excel tools for Entrepreneurs appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
CP046: Gantt charts & project planning using Excel
In the 46th session of Chandoo.org podcast, let's talk about gantt charts and project plans. What is in this session? In this podcast, A brief intro to Excel 2016 What is a Gantt chart? How Gantt charts can help us? How to create Gantt charts in Excel Using bar charts with invisible series Using conditional formatting and formulas Using ready-made templates Resources on Gantt charts & project planning Conclusions The post CP046: Gantt charts & project planning using Excel appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
CP045: Introduction to Monte Carlo Simulations in Excel
In the 45th session of Chandoo.org podcast, let's get in to Monte Carlo simulations. What is in this session? In this podcast, Quick personal updates - 200km BRM and book delay History of Monte Carlo simulations Monte Carlo simulations - an example How to do simulations in Excel Formulas VBA Data Tables Using data tables to run simulations - case study - estimating Pi value Things to keep in mind when setting up your simulation models Resources on Monte Carlo simulations in Excel Conclusions The post CP045: Introduction to Monte Carlo Simulations in Excel appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
CP044: My first dashboard was a failure!!!
In the 44th session of Chandoo.org podcast, let's talk about failures. What is in this session? In this podcast, Book announcement about Dashboards for Excel Story of my first ever dashboard Important lessons - Requirement Analysis for dashboards Resources for creating awesome dashboards Podcasts Books Courses The post CP044: My first dashboard was a failure!!! appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
CP043: My favorite time saving features of Excel, Revealed.
In the 43rd session of Chandoo.org podcast, let's talk about top time saving features of Excel. What is in this session? In this podcast, Quick announcement about Awesome August My 9 favorite time saving features of Excel Remove Duplicates Tables Pivot Tables Auto fill Format Painter Find & Replace VBA / Macro Recorder Auto save Auto complete / Intellisence Recap & Conclusions The post CP043: My favorite time saving features of Excel, Revealed. appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
CP042: Financial Analysis & Modeling concepts – 101
In the 42nd session of Chandoo.org podcast, Let's talk about money. We are going to learn about various concepts that are vital for doing financial analysis and building models. What is in this session? In this podcast, Quick announcement about Awesome August 5 key finance concepts Time value of money Compound interest Risk free rate of return Net Present Value - NPV Internal Rate of Return - IRR Case study - Uber vs. Your car Conclusions The post CP042: Financial Analysis & Modeling concepts – 101 appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.