Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Using Power BI with Excel

via LinkedIn Learning

Go to class Write review

Overview

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

Syllabus

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

Taught by

John David Ariansen and Madecraft

Reviews

4.6 rating at LinkedIn Learning based on 846 ratings

Start your review of Using Power BI with Excel