POWER BI INTERMEDIATE

COURSE DESCRIPTION

This course is intended as a continuation of our introductory-level courses in Power BI. It covers common intermediate-level tasks and some of Power BI’s most desirable new features.

COURSE OUTLINE

INTERMEDIATE POWER QUERY
• 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
• Columns by example

INTERMEDIATE MODELLING
• 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 drill through in your reports
• Adding data-driven images

ADVANCED DASHBOARD DESIGN
• Using dashboard themes
• Using the KPI visual
• Adding KPIs and trend analysis with DAX
• Importing from Excel data model
• Conditional formatting
• The DAX UNICHAR function

ANALYTICS
• Characterizing your data
• Revisiting the data profiler
• Getting help from custom visuals
• Moving averages
• Linear regression in R
• Time series forecasting in Python

For FULL COURSE OUTLINE, please contact us. Please contact us for the schedules and for booking a private class.

Inquire Now