Power BI Advanced: DAX and Advanced Reports
Description
In the "Power BI Advanced: DAX and Advanced Reports" follow-up training, we spend two days covering various aspects of data analysis with Power BI. You will learn everything required for advanced data analysis in Power BI, from the basics of accessing SQL Server data to the advanced functionality of DAX; we cover it all!
As a data analyst, you aim to use Power BI to effectively support your data analyses. But you're not just about gaining insights; you also want to design your reports so others can use them. You aim to manage and transfer them responsibly, working safely according to best practices.
Basic knowledge alone isn't enough. You want to perform advanced analyses and assist colleagues with their calculations. That's where DAX comes in: the language for powerfully shaping data models and advanced calculations in Power BI.
If you're interested in learning more about the Azure side, the Azure Data Engineering course might also be of interest. More information can be found at: Azure Data Engineering Course
After these two days, you will have achieved the following learning goals:
- Sharing reports with "clients" in your organization through Power BI Apps
- Loading and editing new data for reporting
- Performing advanced analyses with Power BI and DAX
- Independently developing measures and calculated columns with DAX
- Recognizing and implementing common patterns in DAX
Upon completion, you'll have a solid understanding of Power BI and the ability to perform advanced analyses in Power BI using DAX. You'll also know where to find more information and how to easily investigate new issues.
Prerequisites for the "Power BI Advanced" Training
This training builds on "Power BI Fundamentals." It's important that you have a good understanding of the following:
- You are familiar with the basic functions of Power BI Desktop and can independently create reports
- You understand the difference between measures and calculated columns
It's also crucial to model your data in a Dimensional Model. A correct data model means much less complex DAX logic is needed in practice.
Finally, participants need access to Power BI Desktop on their own (work) laptop.
Topics
The Power BI Advanced training spans two days and covers the following topics:
- Importing Data (ETL / PowerQuery)
- Importing data from:
- SQL Server (SQL)
- DirectQuery vs Import
- Creating a Model
- Creating a data model (star schemas): Best practices
- DAX Formulas
- Introduction to DAX
- Distinguishing between calculated columns, calculated tables, and measures
- Writing your own calculated columns
- Writing your own measures
- Complex logic: IF + SWITCH
- Variables
- Understanding DAX: how it really works
- Looking up values in other tables: LOOUPVALUE, RELATED + RELATEDTABLE
- Modifying Filter Context with: CALCULATE + FILTER
- Time Intelligence functions: DATESADD, PREVIOUSMONTH, PARALLEPERIOD + DATESYTD
- Custom Time Intelligence: Moving Average + Parameters
- Reporting
- Branding: Page Layouts + Themes
- Drillthroughs + Bookmarks
- Deployment
- Publishing to Power BI Cloud Service
- Shared Datasets
- Data refresh: On-Premises Data Gateway
- Security
- App Workspace Roles
- Publishing as an App
- Row-level security
Study Material
In the Power BI Advanced training, we use materials developed by Wortell Smart Learning. We ensure that you receive all necessary materials in time.
Available dates
| Title | Date |
|---|---|
| Power BI Advanced: DAX en Geavanceerde Rapporten (NL) Dag 1 | |
| Power BI Advanced: DAX en Geavanceerde Rapporten (NL) Dag 2 |
| Title | Date |
|---|---|
| Power BI Advanced: DAX en Geavanceerde Rapporten (NL) Dag 1 | |
| Power BI Advanced: DAX en Geavanceerde Rapporten (NL) Dag 2 |
| Title | Date |
|---|---|
| Power BI Advanced: DAX and Advanced Reports (EN) Day 1 | |
| Power BI Advanced: DAX and Advanced Reports (EN) Day 2 |
| Title | Date |
|---|---|
| Power BI Advanced: DAX en Geavanceerde Rapporten (NL) Dag 1 | |
| Power BI Advanced: DAX en Geavanceerde Rapporten (NL) Dag 2 |
| Title | Date |
|---|---|
| Power BI Advanced: DAX and Advanced Reports (EN) Day 1 | |
| Power BI Advanced: DAX and Advanced Reports (EN) Day 2 |
| Title | Date |
|---|---|
| Power BI Advanced: DAX en Geavanceerde Rapporten (NL) Dag 1 | |
| Power BI Advanced: DAX en Geavanceerde Rapporten (NL) Dag 2 |
