Microsoft Excel to Power BI (2025)
58mIntermediate2025-12-12
Authors
Madecraft
Full-Service Learning Content Company
Tom Themeles
Course details
In this course, Tom Themeles—an author and expert in data science, AI, and cybersecurity education—shows you how to strategically use Excel and Power BI together to clean data, build models, and share insights. Learn best practices for connecting the tools, avoiding common pitfalls, and creating workflows that scale with your business needs. This course helps you build up your ability to switch confidently between Excel and Power BI to support smarter, faster analysis.
Company logo for Madecraft; the letter M configured as part of a printing press
Learning objectives
Differentiate between the core functions of Excel and Power BI in business intelligence.
Apply Power Query in Excel to automate and clean raw data.
Connect Excel Pivot Tables to live Power BI datasets for dynamic analysis.
Build data models in Power BI using fact and lookup tables.
Design visualizations that fit the needs of different platforms and audiences.
Develop a collaborative, scalable workflow using both tools in tandem.
Company logo for Madecraft; the letter M configured as part of a printing press
Learning objectives
Differentiate between the core functions of Excel and Power BI in business intelligence.
Apply Power Query in Excel to automate and clean raw data.
Connect Excel Pivot Tables to live Power BI datasets for dynamic analysis.
Build data models in Power BI using fact and lookup tables.
Design visualizations that fit the needs of different platforms and audiences.
Develop a collaborative, scalable workflow using both tools in tandem.
Skills covered
Power BIBusiness AnalyticsBusiness IntelligenceSpreadsheetsMicrosoft ExcelData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftOne-Off
Concepts
Introduction
- Tailor a BI system for success
Comparing Excel and Power BI
- Compare core uses - Excel vs. Power BI
- Start data analysis with Excel
- Elevate business analytics with Power BI
- Choose the right tool - Excel vs. Power BI
- Evaluate data management and governance
Modeling with Excel and Power BI
- Prepare data with Power Query
- Apply advanced functions in Excel
- Perform modeling and analysis in Excel
- Build Power BI DAX models
Visualize and Share Results
- Compare visualization - Excel vs. Power BI
- Create data visualizations in Excel
- Design dashboards with Power BI
Work Smarter Across Your Tools
- Collaborate in the cloud
- Avoid common pitfalls
Conclusion
- Turn your tools into a strategy