Course Description and Duration
Join us for a 2-day training where you'll discover the secrets of creating enterprise datasets using the powerful tools within Power BI. Gain the skills to govern your Power BI environment effectively, enabling your colleagues to effortlessly generate reports based on the datasets you curate. By the end, you'll be equipped to unleash the full potential of Power BI within your organization.
Learning outcomes
- Day 1 - Data model construction
- Introduction to Power BI and Overview of portal & desktop tool
- Licensing options
- Connecting to Data Sources
- Explain the difference between Import vs. Direct Query vs. Direct Lake
- Presentation of the Power Query Editor
- Incremental Refresh
- Modelling & Relationships Handling in Power BI
- Intro to DAX, Concepts, Measures, and Calculated Columns
- Calculated groups
- Day 2 - Advanced features
- Power BI Dataflows & Datamarts
- Workspace management
- RLS & OLS
- External tools
- XMLA Endpoints
- Deployment Pipelines
- Hybrid tables
Target audience
Data professionals that are developing the Power BI datasets, closing the gap between the Datawarehouse and the Power BI reports. This workshop is tailor-made for individuals who aspire to create Power BI datasets following best practices, ensuring optimal performance. By mastering the art of performant dataset creation, you'll pave the way for report builders to effortlessly craft meaningful reports that drive insightful decision-making. This training assumes basic knowledge of Power BI, or people who have followed either our Introduction to Power BI workshop, or our Advanced Power BI workshop for report builders.
Format
The workshop is organized as a knowledge transfer with hands-on exercises.
Cost
1.350 € per participant
More information?
For more information, contact academy@element61.be
For a complete overview of all courses, visit our academy page.