- Create data models with Power BI Desktop
- Use Power Query to combine data from different sources
- Create calculated columns and measures
- Create reports
- Create dashboards
- Share the reports and dashboards
Is designed for business analytics, controllers or similar rolles, that wants to start working with Self- Service Business Intelligence.
Module 1 – Introduction to Power BI
The aim of this module is to give an overview of Power BI concepts, tools and Self-Service Business Intelligence.
The following will be covered:
Module 2 – Introduction to Power BI Desktop
The aim of this module is to introduce you to the stand-alone tool Power BI Desktop, that comes as freeware independent of e.g. Office.
The following will be covered:
Module 3 – Creating a Datamodel
You will learn how to create a Data model with relations, hierarchies and finetuning.
The following will be covered:
Module 4 – DAX
The module will introduce you to the expression language DAX. You’ll learn how to create different calculations inside the data model. Calculations based on time periods are presented separately.
The following will be covered:
Module 5 – The ETL proces
In this module the ETL tool Power Query is presented. You will learn to transform data from your data sources before loading them to the Data model. Making the data model perform better and creating a more intuitive model for the end user.
The following will be covered:
Module 6 – Reporting
This module will introduce you to different aspects of the reporting tool, so you can create informative reports using different visuals such as charts, maps and slicers. Also, a lot of interactive opportunities are presented.
The following will be covered:
Module 7 – The Power BI cloud service
The aim of the module is to learn how the cloud service powerbi.com is structured, how you can share your reports- and dashboards and different technical aspects.
The following will be covered:
Kurset har stadig ledige pladser.
Kurset har stadig ledige pladser.