Skip to main content
AmigoFish

When Should You STOP Using Excel?

From Guy in a Cube · · 8 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.

If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.

Watch on YouTube

Not rated yet

Description

Stop feeling like you have to choose between tools and start leveraging your Excel skills to master Power BI today. Transitioning to Power BI is easier than you think when you realize you already know the core concepts like Power Query and data modeling.

If you're comfortable in Excel, you're already halfway to being a Power BI expert—you just need to see how your current skills translate. This video demonstrates how familiar tasks like data cleaning in Power Query and creating Pivot Tables are identical across both platforms. We’ll walk through a real-world dashboard demo, contrasting Excel’s XLOOKUP with Power BI’s relational modeling to show you a more efficient way to work. By the end, you’ll see how a central semantic model and standardized definitions solve the problem of inconsistent reporting, ultimately setting you up for success in Microsoft Fabric.

✅ KEY TAKEAWAYS - Learn how to apply your existing Excel knowledge of tables, filters, and formulas directly to the Power BI environment. - See a side-by-side comparison of Power Query in both tools to streamline your data cleaning and renaming process. - Move beyond XLOOKUP and learn how to build one-to-many relationships for more powerful, automated filtering. - Discover how publishing a central semantic model ensures consistent data definitions across your entire team.

🎥 RELATED VIDEOS - Power BI Tutorial for Beginners (Step-by-Step in 30 Minutes): https://www.youtube.com/watch?v=OmW9YvxSl1E&list=PLv2BtOtLblH13vCbf99BptWWk-EWx7QQG&index=1 - The Semantic Model Became the Product — Here’s Why Power BI Is Changing: https://www.youtube.com/watch?v=kv8twec4rCI&list=PLv2BtOtLblH34cKUxJ9SL2CEuMA-FMcP4&index=3 - The Power BI Expert Is GONE. Now What?: https://www.youtube.com/watch?v=GtcBK0-z6_M&list=PLVEixWa_7Rog&index=0

⏱️ CHAPTERS 00:00 Excel or Power BI 00:14 Transfer Excel Skills 01:07 Excel Dashboard Tour 01:44 Power Query Prep 02:51 Lookups to Relationships 04:35 Pivot Tables to Matrix 05:32 When Excel Breaks Down 06:38 Publishing and Sharing 07:08 Semantic Model Basics 07:37 Wrap Up and Next Steps

Yooo! 🙌 take your data skills to the next level and join fellow data professionals in our community THE CUBE: https://guyinacube.com

🌐 LET'S CONNECT! Official website: https://guyinacube.com LinkedIn: https://www.linkedin.com/company/guyinacube Facebook: https://www.facebook.com/guyinacube Instagram: https://instagram.com/guyinacube Bluesky: https://bsky.app/profile/guyinacube.com X: https://x.com/guyinacube

🎤 HOST Patrick LeBlanc

#guyinacube #powerbi #excel #dax #datamodeling #xlookup #powerquery

Back to Guy in a Cube · Report a problem