Using Power BI with Excel

Offered By: LinkedIn Learning

Tags

Business Intelligence Courses Data Analysis Courses Data Visualization Courses Microsoft Office 365 Courses Data Cleaning Courses DAX (Data Analysis Expressions) Courses Data Transformation Courses Data Modeling Courses

Course Description

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

Related Courses

Introduction to Office 365 Development and APIs
Microsoft via edX Office 365: Managing Identities and Services with Hands-on Labs
Microsoft via edX Compliance in Office 365: eDiscovery
Microsoft via edX Compliance in Office 365: Data Governance
Microsoft via edX Microsoft Exchange Server 2016 - 5: Hybrid Topologies with Office 365
Microsoft via edX