*** 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 Power BI for Excel Users 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. The Power BI Intermediate course is intended as a continuation of the introductory-level courses in Power BI (DA-100: Analyzing Data with Power BI and/or Power BI for Excel Users). It covers common intermediate-level tasks and some of Power BI’s most desirable new features.
Audience profile
The course is for individuals who are not IT professionals but need to easily create and publish reports with Power BI**
Prerequisites
Students should have experience creating worksheets in Excel. Familiarity with Pivot Tables is a plus, but is not required. Before moving to the Intermediate class, students should have the general knowledge equivalent to what is covered in: Power BI for Excel Users or DA-100: Analyzing Data with Power BI.
What You Need to Take this Training
A Windows machine with Excel installed and a high-speed internet connection.
Do You Still Prefer a Live, Instructor-led Class?
Already know On-Demand, self-study training is not right for you? We also offer this same course content in a live, instructor-led format. For more details, click on the link below:
Power BI Training Classes
**Note: While this course is designed for average end users needing to learn essential Power BI skills, we also offer a more in-depth 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:
PL-300: Power BI Data Analyst (Instructor-led Class)
Course Outlines:
- Power BI for Excel Users 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
View outline in Word
- Power BI Intermediate Course Outline -
Intermediate Power Query
Import Data from PDFs
Connect to webpages from Power BI Desktop
Get webpage data by providing examples
Combined files (binaries) in Power BI Desktop
Use Fuzzy Matching to Combine Disparate Data Sets
Using Data Profiling
Add a Column from Examples
Add a Custom Column with M
Intermediate Data Modeling
Create and use What-If Parameters to Visualize Variables
Using Grouping and Binning in Power BI Desktop
Set and user Date Tables in Power BI Desktop
Use Quick Measures for Common Calculations
Script Visuals
Create R Visuals in Power BI Desktop
R Integration: Installing an R Environment
Create Python Visuals in Power BI Desktop
Python Integration: Installing Python
Advanced Report Design
Using Report Themes in Power BI Desktop
Use Conditional Formatting in Tables
Using Drillthrough in Power BI Desktop
Adding Data-Driven Images to Power BI Reports
Using Parameters
Create and Use Report Templates in Power BI Desktop
Advanced Dashboard Design
Use Dashboard Themes in the Power BI Service
Import and Display KPIs in Power BI
KPI Visuals
The Multi KPI Visual
The UNICHAR Function
Analytics
A tiny introduction to machine learning and predictive analysis in Power BI
Forecasting with ARIMA
Visualizing and Operationalizing R Data in Power BI Desktop
