Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.
WHO SHOULD ATTEND: People who have attended the “Power BI 1 – Foundation course”, have practiced or used Power BI Desktop extensively, and want to improve their Power BI skills. WHAT YOU WILL GAIN: You will learn how to load data from several types of data source, combine tables into a data model, build more interactive visuals and write simple calculations.
WHO SHOULD ATTEND:
People who have attended the “Power BI 1 – Foundation course”, have practiced or used Power BI Desktop extensively, and want to improve their Power BI skills.
WHAT YOU WILL GAIN:
You will learn how to load data from several types of data source, combine tables into a data model, build more interactive visuals and write simple calculations.
PROGRAMME OUTLINE:
Connect to many different data sources such as databases and web pages.
Shape data so that it is suitable for analysis; pivot and unpivot data, merge and append datasets.
Apply several visuals techniques e.g. small multiples, field parameters.
Use relative date, Top N filters and other advanced filtering techniques.
Build a dimensional data model - arrange several tables in a star schema pattern.
Understand how and why to use Date tables in a dimensional model.
Write calculations in DAX e.g. ratios, time-intelligence calculations.