Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Using Power BI with Excel


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