Chandoo

Chandoo

Creator
0 followers

Excel, dashboards, Power BI, analytics techniques for business/finance.

The Excel Trick that Saves Me Hours on MIS Reports 💡
VideoMay 7, 2026

The Excel Trick that Saves Me Hours on MIS Reports 💡

The video demonstrates an Excel‑based workflow for answering common MIS compliance questions by merging an employee roster with a training log. The presenter shows how to link the two tables via employee ID, add helper columns, and apply COUNTIFS to...

By Chandoo
Live Power Query Data Cleaning Masterclass [FREE Workbook]
VideoApr 25, 2026

Live Power Query Data Cleaning Masterclass [FREE Workbook]

The video is a live masterclass that walks viewers through using Power Query for data cleaning, transformation, and management inside Power BI, with identical steps applicable to Excel. The presenter provides a free sample workbook—a fabricated 1,000‑employee dataset—so participants can follow...

By Chandoo
Excel Data Cleaning Trick💡for Uneven Rows of Data #EXCEL
VideoFeb 20, 2026

Excel Data Cleaning Trick💡for Uneven Rows of Data #EXCEL

The video demonstrates a practical Excel formula chain for turning uneven, single‑column data into a clean multi‑column table. By leveraging the LET function, the presenter creates local variables for the raw data and a custom delimiter, then substitutes empty cells...

By Chandoo
Build Your First Power BI Report in One Hour (Free Masterclass + Sample Files 📂)
VideoFeb 14, 2026

Build Your First Power BI Report in One Hour (Free Masterclass + Sample Files 📂)

The livestream walks viewers through building a complete Power BI report in roughly an hour, using a fictitious "Awesome Clinic" dataset. The instructor opens a blank Power BI file, imports three pre‑packaged tables—patients, doctors, and a calendar—then demonstrates how to clean, model,...

By Chandoo
How to ACTUALLY Use AI + PYTHON to Analyze Data (Real-Time Example)
VideoFeb 5, 2026

How to ACTUALLY Use AI + PYTHON to Analyze Data (Real-Time Example)

The video demonstrates how AI tools like Google Gemini can write Python code in real time to load, merge, and analyze a hospital data set within Google Colab. The presenter walks through three escalating tasks—basic exploratory analysis, answering a specific...

By Chandoo
Forget Complex DAX, Use This Instead in Power BI
VideoJan 30, 2026

Forget Complex DAX, Use This Instead in Power BI

The video demonstrates how Power BI’s new visual‑calculation feature can replace traditional, complex DAX formulas when building month‑over‑month change visuals. Starting from a simple total‑amount measure, the author adds a ‘versus previous’ visual calculation, which automatically creates a field‑minus‑previous‑field expression. By editing...

By Chandoo