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

Social Network Analysis
University of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX