*** 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.
Description
*** 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.
This course is intended as a continuation of our introductory-level courses in Power BI (DA-100: Analyzing Data with Power BI and/or Excel BI Tools: Power BI for Excel Users ). It covers common intermediate-level tasks and some of Power BI’s most desirable new features.
Prerequisites
Before attending this course, students should have the general knowledge equivalent to what is covered in:
<a href=//www.onlc.com/outline.asp?ccode=bpbex1>Excel BI Tools: Power BI for Excel Users</a>.
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