Power BI Next Step

Underviser
Start
12. november 2020 09:00
Slut
13. november 2020 16:00
Adresse
Thorshavn, Færøerne   Vis kort

10.000 DKK

Status

Detaljer

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.

Kurset afholdes i Thorshavn på Færøerne i samarbejde med Bi3, som står for tilmeldingen: https://bi.fo/blog-post/power-bi-intro

Forudsætninger:

  • Medbring egen laptop med nyeste version af Power BI Desktop installeret

Kursus agenda:

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

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

Yderligere information

Længde

2 dage

Du kunne også være interesseret i...