Detaljer
2-dages kursus med fokus på de avancerede funktioner, når der skal bygges og vedligeholdes en Power BI løsning. Fokus er på “Data Creator” rollen, hvilket inkludere både Power Query, Data modellering, DAX, sikkerhed m.m.
Der vil være stor vægt på den praktiske anvendelse med en masse hands-on øvelser.
Kurset henvender sig til udviklere, analytikere, controllere og alle andre der ønsker et mere dybdegående kendskab til Power BI med fokus på “best practices”.
Forudsætninger:
- Medbring egen laptop med nyeste version af Power BI Desktop installeret
Agenda:
Module 1: Advanced Power Query Mash Up
- Importing “dirty” data from Excel, Web etc.
- Power Query Formula Language
- Add column by example
- Learning M syntax and M built-in functions
- Data types, Lists, Records, and tables in M
- Parameterised Queries
- Query folding
Module 2: Extending the data model
- Binning and grouping data
- Field parameters – KPI table
- Composite models
Module 3: Next Step DAX
- DAX evaluation Contexts
- Filter Functions
- Calculate Function
- Using variables
- DAX Patterns
- DAX cheat sheet
- Quick Measures
Module 4: Dataset development with Tabular Editor
- Online development – external tool
- Split data model from report
- Introduction to Tabular Editor
- Offline development
- Best practice analyzer
- Increase your productivity
Module 5: Take the data model to the next level
- Calculation Groups – Time intelligence
- Detailed Row Expressions
- Advanced Scripting
- Deploy to Power BI workspace with XMLA endpoint
- Memory optimizations – VertiPaq Analyzer
- Recap: Best practices
Module 6: Advanced modeling scenarios
- Multiple fact tables at different granularity
- Role playing dimensions
- Many-to-many relationships
- Benchmark data
- Survey data
Module 7: Best practice Power BI distribution
- Content workflow and deployment
- Workspaces in Power BI; Dev/test environment
- Power BI Apps; User environment
- Automated deployment with DevOps
Module 8: Securing data
- Row-level and object-level security
- Different views of the data for the same Power BI report
- Manage, create and test roles
- Assign users to roles
- Dynamic Security
