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

Interprofessional Healthcare Informatics
University of Minnesota via Coursera Data Science at Scale - Capstone Project
University of Washington via Coursera Implementing ETL with SQL Server Integration Services
Microsoft via edX Introduzione a R
University of Modena and Reggio Emilia via EduOpen Практики работы с данными средствами Power Query и Power Pivot
Saint Petersburg State University via Coursera