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

MongoDB for Developers
MongoDB University Data Wrangling with MongoDB
MongoDB via Udacity Intro to Point & Click App Development
Salesforce via Udacity SAP Business Suite powered by SAP HANA
SAP Learning Desarrollo de Aplicaciones Web: Conceptos Básicos
University of New Mexico via Coursera