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
