Komandi skeið

Skeið

Power BI Next Step

-

2-dages kursus med fokus på de avancerede funktioner, når der skal bygges og vedligeholdes en Power BI løsning.

Kurset henvender sig til analytikere, controllere og andre der ønsker et bedre kendskab til
alle mulighederne der findes i Power BI.
Sted: Hotel Hilton, Torshavn, Færøerne
Dato: udskudt
Undervisere: Just Blindbæk og Jesper D. Christoffersen

Pris 10.000 kr (uden mvg).

Hvis du både tager Power BI Intro og Power BI Next Step, får du begge til 15.000 kr i alt

Dag 1

Module 1: Advanced Power Query Transformations

  • Column and Row Operations
  • Table Transformations
  • Text Transformations
  • Numeric Transformations
  • Date and time Transformations
  • Query operations

Module 2: Power Query Editor

  • Power Query Formula Language
  • Learning M syntax
  • M built-in functions
  • Data types, Lists, Records, and tables in M
  • Parameterised Queries
  • Query folding

Module 3: DAX next step

  • Aggregate Functions
  • Logical Functions
  • Mathematical Functions
  • Date and Time Functions
  • DAX evaluation Contexts
  • Calculate Function
  • Using variables
  • DAX cheat sheet

Module 4: Common Challenges with DAX

  • Time intelligence
  • Percentage of All and Parent
  • Moving Average
  • Running Total
  • Parent-Child Hierarchies

Module 5: Row Level Security

  • Different views of the data for the same Power BI report
  • Manage, create and test roles
  • Assign users to roles
  • Dynamic Security

Dag 2

Module 6: Create your own layout and theme

  • Predefined default values
  • Background image
  • Setting borders and titles
  • Themes gallery
  • Color Theme Generator
  • How to optimize for mobile

Module 7: Advanced report interactions

  • Drillthrough pages and actions
  • Bookmarks and selection pane
  • Custom navigation pane
  • Show and hide visuals
  • Report Page Tooltips
  • Exporting detail data

Module 8: Power BI service

  • Publish and consume reports
  • Dashboard vs Report
  • Create Reports and pin to Dashboards
  • Export and Subscriptions
  • Analyze in Excel
  • Integration in SharePoint and Teams

Module 9: 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 10: Administration and governance

  • Power BI Admin Portal
  • Shared and certified datasets
  • Data refresh
  • Governance options
  • Architecture

skeið virksemi

Onnur skeið

Power BI Intro

2-dages kursus med fokus alle aspekter af at bygge og vedligeholde en Power BI løsning. Hele vejen rundt med Rapportering, Modellering, Data Mashup og Levering.

-

Power BI Next Step

2-dages kursus med fokus på de avancerede funktioner, når der skal bygges og vedligeholdes en Power BI løsning.

-