Power BI Excel Integration
4.6 (21 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
7,499 students enrolled

Power BI Excel Integration

Using Microsoft Power BI, Excel, Power Query and Power Pivot together | G Com Solutions
4.6 (21 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
7,499 students enrolled
Created by Grant Gamble
Last updated 5/2020
English
English [Auto]
Current price: $41.99 Original price: $59.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 2 articles
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • In this course, you will learn all the different ways of using Power BI and Excel in conjunction
Requirements
  • This course requires Power BI Desktop (freely available) and Microsoft Excel
Description

Microsoft Power BI and Excel form a natural pairing and work well together. In this course by G Com Solutions, you will learn all the different ways of using Power BI and Excel in conjunction and the benefits of integrating these two powerful and versatile environments.

We start the course with a side-by-side comparison of Power BI and Excel BI, using Power Query in both environments to connect with data and carry out data transformations. Then comparing data modelling and DAX in Power BI to the data modelling experience in Excel Power Pivot. And we end our side-by-side comparison by looking at how to import an Excel Power Pivot data model into Power BI and build a report from it.

We then move onto discussing the different Excel-related operations which can be initiated from within the Power BI service. Here, we’ll look at techniques such as importing Excel tables and uploading entire Excel workbooks into an app workspace. We also examine the different options for exporting data to Excel from Power BI visuals, as well as using the Analyze in Excel feature to build Excel reports based on Power BI datasets.

Next, we switch over to Excel for a look at Power BI workflows which can be initiated from within Excel. In this module, we will use the Power BI Publisher for Excel add-in to pin Excel content to Power BI dashboards. We’ll also discuss how we can use Power BI’s dashboard subscription feature as a method of distributing Excel content throughout an organisation.

In the final module, we examine the different techniques and considerations involved in importing Excel data into Power BI desktop. This includes techniques such as connecting to hidden sheets and filtering out the total row from Excel tables.

In summary, this course will provide you with all the practical insights you need to be aware of when using Power BI in conjunction with Microsoft Excel.

Who this course is for:
  • This course is designed for users familiar with both Excel and Power BI
Course content
Expand all 23 lectures 01:57:56
+ 1. Excel and Power BI Common Features
4 lectures 33:33
2. Creating a relationship
08:42
3. Creating DAX calculated columns
07:57
4. Importing a Power Pivot data model
06:16
+ 2. Excel from the Power BI Service
4 lectures 31:38
1. Importing Excel Tables
07:00
3. Exporting data
09:03
4. Analyze in Excel
07:57
+ 3. Power BI Service from Excel
7 lectures 17:47
Power BI Publisher no Longer Available
00:23
1. Installing Power BI Publisher for Excel
03:22
2. Pinning Content to Power BI Dashboards
03:27
3. Subscribing to Excel Dashboards
03:44
4. Using the Pin Manager
02:36
5. Workspace compatibility
01:36
6. Connecting to Power BI Datasets
02:39
+ 4. Connecting to Excel data
6 lectures 32:45
1. Excel data objects
08:07
2. Hidden sheets
04:57
3. Blank columns
04:35
4. Password
02:12
5. Total row
05:54
6. Quick Practice
07:00