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

LinkedIn Learning

Using Power BI with Excel

via LinkedIn Learning

Write review
TrainSec Ad

Master Windows Internals - Kernel Programming, Debugging & Architecture

Learn More → Boot.dev Ad

Learn Backend Development Part-Time, Online

Learn More →

Overview

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.