Komandi skeið

Skeið

Power BI Intro

6 - 7 September 2021

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.

Kurset henvender sig til analytikere, controllere og andre der ønsker kendskab til de nye

Self-Service Business Intelligence muligheder der findes med Power BI.

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

Dato: 6/9/2021 og 7/9/2021

Undervisere: Just Blindbæk og Jesper D. Christoffersen

Pris 10.000 kr (uden mvg).

Dag 1

Module 1: Power BI Overview

  • Short history – what is Power BI ?
  • Power BI components
  • The roadmap and future
  • Power BI Desktop UI

Module 2: Delivery of Power BI

  • Business Intelligence Investments
  • Business-Led Self-Service BI
  • IT-Managed Self-Service BI
  • Enterprise BI
  • Connecting to a data model

Module 3: Basic data mashup

  • Introduction
  • Discover data
  • Import data
  • Basic clean, transform and reshape
  • Dimensional Modeling best practices
  • Data refresh and storage modes

Module 4: Power Query Transformations

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

Module 5: Data modelling

  • Tables and relationships
  • Date table
  • Formatting and sorting
  • Grouping and binning
  • User hierarchies
  • Row Level Security with roles

Module 6: Quick measures

  • Implicit vs. explicit measures
  • Quick measures
  • Introduction to DAX
  • Setup simple measures

Dag 2

Module 7: Basic design principles

  • Minimize distraction
  • Gestalt principles
  • Group and create patterns
  • Tell a story

Module 8: Built-in Charts and Graphs

  • Configuring visuals
  • Bar, columns and line
  • Cards and KPI
  • Matrix and tables
  • Pie, Donut and Gauge
  • Maps and Geospatial visuals

Module 9: Slicers and filters

  • List / dropdown
  • Date, between / relative
  • Search in slicers
  • Sync between pages
  • Background filters

Module 10: Formatting visuals

  • Labels and legends
  • Colors
  • Conditional
  • Axis

Module 11: Report interactions

  • Interactions between visuals
  • Drill down / up
  • Drillthrough pages
  • Bookmarks and selection pane
  • Report Page Tooltips
  • Exporting / showing detail data

Module 12: Power BI service

  • Publish reports
  • Dashboard vs Report
  • Create Reports and pin to Dashboards
  • Connect to on-premises / Data Gateway

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.

6 - 7 September 2021

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.

9 - 10 September 2021