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

‍
Sted: Hotel Hilton, Torshavn, Færøerne
‍

Dato: 3 & 4 NOVEMBER 2022
‍

Undervisere: Just Blindbæk og Jesper D. Christoffersen

‍

Pris 10.000 kr (uden mvg).

Dag 1

Module 1: Advanced Power Query Mash Up

• Importing “dirty” data from Excel, Web etc.
• Data profilering
• 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: Advanced data model features

• Binning and grouping data
• Field parameters – KPI table
• Performance Analyzer
• Composite models

Module 3: Next Step DAX

• DAX evaluation Contexts
• Calculate Function
• Using variables
• DAX cheat sheet

• DAX Patterns
• Greg's Quick Measures

Module 4: Take your data model to the next level

• Introduction to Tabular Editor

• Increase your productivity
• Best practice analyzer
• Advanced Scripting
• Calculation Groups – Time intelligence
• Split data model from report

Dag 2

Module 5: 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 6: 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 7: 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 8: Administration and governance

• Power BI Admin Portal

• Shared and certified datasets
• Data refresh
• Governance options
• Architecture

‍