Using Power BI with Excel

Learn how to clean, transform, model, and visualize data with Microsoft Excel and Power BI.

Introduction

• Transforming and refining your data

1. Excel vs. Power BI

• Power BI desktop vs. Excel
• Business intelligence (BI) with Excel
• Excel business intelligence add-ons

2. Business Intelligence with Excel

• Pros and cons of Excel
• Cleaning data in Excel
• Combining data in Excel
• Creating calculations in Excel
• Visualizing trends in Excel

3. Power BI Overview

• What is Power BI?
• Connecting to multiple data sources
• Data modeling
• Introduction to DAX
• Visualizing data

4. Business Intelligence with Power BI

• Connecting to and cleaning data
• Creating calculated columns in Power BI
• Implicit vs. explicit measures
• Building a data model
• Data tables vs. lookup tables
• Building line graphs
• Building bar charts
• Building geomaps
• Creating a slicer
• Creating a dashboard

Conclusion

• Next steps