*** This is an On-Demand (self-study) course, 180-day, 24/7 access via the internet ***
(Applicable State and Local taxes may be added for On-Demand purchases, depending on your location.)
You may take this course at any time; there are no set dates. This On-Demand (self-study) training course includes expert lectures, demonstrations and exercises. Note: The 180-day course access period begins at time of purchase.
Overview
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.
What You Need to Take this Training
A Windows machine with Excel installed and a high-speed internet connection.
Looking for a Live, Instructor-led Class Instead?
If self-study training is not right for you, we have this same course in a live, instructor-led format. For instructor-led training click the below link:
Power BI Introduction for Excel Users
**Note**
While this course is designed for average end users needing to learn essential Power BI skills, we also offer a more in-depth 3-day course titled PL-300: Power BI Data Analyst. It is for IT professionals and power users who want a deeper dive into the material and/or who are preparing to pass the related Microsoft certification exam. For details, visit:
Instructor-led: PL-300: Power BI Data Analyst
Duration
You have 24/7 access for 180-days to this digital course that includes 5h 16m of video presentation. As a traditional course it would be a 2-day class.
Course Outline
Getting started
Introducing Power BI
A quick look at Power BI Desktop
A quick look at the Power BI service
Power BI and Excel
Introduction to using Excel data in Power BI
Upload Excel data to the Power BI service
Using Excel as a Data Source
Import Power View and Power Pivot to Power BI
Getting Data
Data Sources in Power BI Desktop
Connect to data sources in Power BI Desktop
More advanced data sources and transformation
Connect to SQL Server in Power BI Desktop
Connect to CSV files in Power BI Desktop
Shaping and Transforming Data
Introduction to the Query Editor
Clean and transform your data with the Query Editor
Cleaning irregularly formatted data
Modeling Data
Introduction to modeling your data
How to manage your data relationships
Optimizing data models
Introduction to DAX
DAX functions
Calculated columns in DAX
Calculated measures in DAX
Create calculated tables
Visualizations
Introduction to visuals in Power BI
Create and customize simple visualizations
Combination Charts
Modify colors in charts and visuals
Text boxes, shapes, and smart narratives
Page layout and formatting
Group interactions among visualizations
Visual hierarchies and drill-down
Using custom visualizations
R integration in Power BI Desktop
Publishing and Sharing
Introduction to the Power BI service
Publish Power BI Desktop Reports
Create and configure a dashboard
Share dashboards with your organization
Quick insights in Power BI
Ask questions of your data with natural language
Create custom Q&A suggestions
Create workspaces in Power BI
Manually republish and refresh your data
Install and configure a personal gateway
Export dashboards and reports to PDF
Printing from the Power BI Service
Publish to web from Power BI
