Detaljer
2-dages kursus med fokus på de avancerede funktioner, når der skal bygges og vedligeholdes en Power BI løsning. Det er bredt fokus på både Power Query, Data modellering og governance.
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 og kendskab til “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
- Split data model from report
- Introduction to Tabular Editor
- 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
- Share within organization
- Content workflow
- Workspaces in Power BI; Dev/test environment
- Power BI Apps; User environment
- Power BI for mobile
- Share outside organization
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
Module 9: Administration and governance
- Power BI Admin Portal
- Governance options
- Certify datasets
- Data refresh
- Architecture