Tilbud

Advanced Power BI

Underviser
Ásgeir Gunnarsson Data Platform MVP
Start
9. maj 2023 09:00
Slut
10. maj 2023 16:00
Adresse
Kanalvej 7, 2800 Kongens Lyngby   Vis kort

8.000 DKK

På lager

Status

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

    Yderligere information

    Længde

    2 dage