Overview

Excel BI Tools: Power BI for Excel Users Course Outline: The main purpose of the course is to review the essential skills needed to take data from Excel into Power BI then transform and shape the data, model the data, create reports, then publish the reports on the Power BI cloud service.

Audience profile
The course is for individuals who are not IT professionals but need to easily create and publish reports with Power BI.

Prerequisites
Before attending this course, students should have experience creating worksheets in Excel. Familiarity with Pivot Tables is a plus, but is not required.

While this course is designed for average end users needing to learn essential Power BI skills, there is also a more in-depth version of this class. The 3-day Analyzing Data with Power BI (20778) course is for IT professionals and power users wanting a deeper dive into the material and/or who are preparing to pass the related Microsoft certification exam.

With Microsoft Power BI publisher for Excel, you can take snapshots of your most important insights in Excel, like PivotTables, charts, and ranges and pin them to dashboards in Power BI. Power BI publisher for Excel is an add-in you can download and install on desktop versions of Microsoft Excel 2007 and later.Once you have the publisher installed, you’ll see a new Power BI ribbon in Excel, where you can sign in (or sign out) of Power BI, pin elements to dashboards, and manage elements you’ve already pinned.