FR
EN
LU
DE
Details
Goals
Create reports with Power BI Desktop
Be able to manipulate data in Power Query
Be able to manipulate a data model in Power Pivot
Prerequisite
Knowledge of the Windows work environment
Contents
Interface
- What is Power BI?
- Basic Concepts
- Components of Power BI Desktop:
- Power Query
- PowerPivot
- Power View
Import data
- Load data from different sources:
- Excel files
- Text files
- Relational Databases
- Web Pages
- Updating Data
Data Model
- Create relationships in the data model
- Add measures (aggregate calculations) to a table
- Unidirectional and bidirectional filters
- Add a column of data
- Using date and time data
- Introduction to DAX (Data Analysis eXpressions)
Visualizations
- Create a simple report
- Charts
- Tables
- Matrixes
- Slicers
- Add visualizations
- Filter a page
- Filter a report
- Explore data from a visualization (drill down)
Power Query
- Transform Data:
- Sort
- Filter
- Exclude rows depending on their positions
- Data types
- Pivoting data
- Unpivoting data
- Group Data
- Duplicate a query
- Create a reference to an existing query
- Add columns:
- Use the automatic features
- Use functions
- Combine queries:
- Append a query to another query
- Merge queries
- Add parameters
- Create a function
- Overview of the advanced editor
Online Power BI
- Share data by using the Microsoft Power BI services
Need a custom training?
None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!