Using Power BI with Excel
48mIntermediate2022-02-23
Authors

John David Ariansen
Helping organizations understand and use data

Madecraft
Full-Service Learning Content Company
Course details
Are you ready to take your skills as a data analyst to the next level? Power BI is an easy-to-use analytics tool that can streamline how your organization works with data. In this course, instructor John David Ariansen shows you how to combine the power of a familiar tool, Excel, with all the potential of Power BI.
Discover how to conduct power pivots, import data, clean and shape data, and model data to present to stakeholders. Learn about performing calculations with Data Analysis Expressions (DAX) and visualizing your data with the various built-in charts and graphs in Power BI. Along the way, John gives you a short primer on how to get the most out of PivotTables and PivotCharts. By the end of this course, you’ll be equipped with new skills to take your data analysis to the next level.
Discover how to conduct power pivots, import data, clean and shape data, and model data to present to stakeholders. Learn about performing calculations with Data Analysis Expressions (DAX) and visualizing your data with the various built-in charts and graphs in Power BI. Along the way, John gives you a short primer on how to get the most out of PivotTables and PivotCharts. By the end of this course, you’ll be equipped with new skills to take your data analysis to the next level.
Skills covered
Power BIBusiness AnalyticsBusiness IntelligenceSpreadsheetsData AnalysisData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftDeep Dive (X:Y)
Concepts
0. Introduction
- 01 - Transforming and refining your data
1. Excel vs. Power BI
- 02 - Power BI desktop vs. Excel
- 03 - Business intelligence (BI) with Excel
- 04 - Excel business intelligence add-ons
2. Business Intelligence with Excel
- 05 - Pros and cons of Excel
- 06 - Cleaning data in Excel
- 07 - Combining data in Excel
- 08 - Creating calculations in Excel
- 09 - Visualizing trends in Excel
3. Power BI Overview
- 10 - What is Power BI
- 11 - Connecting to multiple data sources
- 12 - Data modeling
- 13 - Introduction to DAX
- 14 - Visualizing data
4. Business Intelligence with Power BI
- 15 - Connecting to and cleaning data
- 16 - Creating calculated columns in Power BI
- 17 - Implicit vs. explicit measures
- 18 - Building a data model
- 19 - Data tables vs. lookup tables
- 20 - Building line graphs
- 21 - Building bar charts
- 22 - Building geomaps
- 23 - Creating a slicer
- 24 - Creating a dashboard
Conclusion
- 25 - Next steps
Related courses
- Power BI: Working Together with Microsoft 365 Apps
- Advanced Power Query
- Learning Power Platform: Excel Integration
- Mastering Business Intelligence with DAX, Power BI, and Excel by Microsoft Press
- Power BI Top Skills
- Build an Interactive Business KPI Dashboard with Power BI (Guided Project)
- Excel Power Query Tips and Techniques
- Time Series Modeling in Excel, R, and Power BI