Power BI Intermediate

Power BI is one of our most popular class series and these classes can fill weeks ahead. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get a class date you prefer, it's best to register as far in advance as possible. View More Dates Power BI is one of our most popular class series and these classes can fill weeks in advance. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get the class date you prefer, it's best to register as far in advance as possible. Power BI Intermediate Course Overview This hands-on, online instructor-led course is intended as a continuation of our introductory-level courses, PL-300: Microsoft Power BI Data Analyst and/or Excel BI Tools: Power BI for Excel Users in ` Power BI. This course covers common intermediate-level tasks and some of Power BI’s most desirable new features. Power BI Intermediate Course Prerequisites Excel BI Tools: Power BI for Excel Users or PL-300: Microsoft Power BI Data Analyst -OR- equivalent knowledge before attending this course.

Intermediate Power Query Importing from PDFs Finding data in web pages Getting tabular data Getting data by providing an example Importing the contents of a folder Using fuzzy matching to combine disparate data sets Creating custom columns in Power Query Common math & string operations M script Columns by example Intermediate Data Modeling Adding What-If Parameters Grouping and Binning Using Time Intelligence Generating DAX with Quick Measures Script Visuals Creating an R script visual Installing an R environment Creating a Python visual Installing a Python environment Advanced Report Design Using report themes Creating your own theme Conditional formatting in tables and matrices Using drillthrough in your reports Adding data-driven images Advanced Dashboard Design Using dashboard themes Using the KPI visual Using the Multi KPI visual Adding KPIs and trend analysis with DAX Strategies for adding KPIs to tables & matrices Importing from Excel data model Conditional formatting The DAX UNICHAR function Image embedding Analytics Characterizing your data Revisiting the data profiler Getting help from custom visuals Moving averages ARIMA Linear regression in R Time series forecasting in Python