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

Overview

Unleash the power of Microsoft Excel with Power BI. Learn how to clean, transform, model, and visualize data with Excel and Power BI.

Take your analysis skills to the next level. Power BI is a powerful data analytics tool that is streamlining the way business works with data. In this course, you can learn how to combine the power of a familiar tool, Microsoft Excel, with all the potential offered by Power BI. Discover how to conduct power pivots, import data, clean and shape data, as well as model data, perform calculations with Data Analysis Expressions (DAX), and visualize data with the variety of built-in charts and graphs in Power BI. Plus, explore a great primer on PivotTables and PivotCharts. By the end of this course, you will be equipped with new skills to take your data analysis to the next level.

This course was created by Madecraft. We are pleased to host this content in our library.

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

Reviews

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