Power BI introduktion

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

10.000 DKK

Status

Detaljer

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 alle de nye Self-Service Business Intelligence muligheder der findes med 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: 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

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

Yderligere information

Længde

2 dage

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