Tilbud

Advanced Power BI

Underviser
Ásgeir Gunnarsson Data Platform MVP
Start
13. april 2023 09:00
Slut
14. april 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 komplet Power BI løsning. Det er bredt fokus på både Power Query, Data modellering, visualisering og governance.

Der vil være stor vægt på den praktiske anvendelse med en masse hands-on øvelser.

Kurset henvender sig til analytikere, controllere og andre der ønsker et mere dybdegående kendskab til Power BI.

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

Module 6: Storytelling with data

  • Introduction to Storytelling
  • Bookmarks and selection pane
  • Custom navigation pane
  • Show and hide visuals
  • Report Page Tooltips
  • Drillthrough pages and actions

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