Zielgruppe
Der Kurs richtet sich an erfahrene Business- und Data Analysts mit etwas Erfahrung mit Visualisierungstools wie Tableau, QlikView oder Excel mit PowerPivot und dem Wunsch Ähnliches mit Power BI zu erreichen. Man sollte sich mit Power BI Desktop bzw. Power BI Service (powerbi.com) schon etwas auseinandergesetzt haben.
Kursziele
In diesem Kurs lernen Sie, Daten aus unterschiedlichen Quellen zu verwenden, Ihre Daten zu modellieren, zu visualisieren, sowie sie mittels Power BI Desktop und Power BI Service zu teilen. Ziel dieses Trainings ist es, den Teilnehmern das Know-how zu vermitteln, um Datenintegration und -analysen mittels Power BI durchzuführen.
- Importieren von Daten aus heterogenen Quellen, wie Excel, Access, ERP Systemen, Websites, Online-Services, Social Media uvm.
- Designen, verfeinern und optimieren von Datenmodellen
- Kreieren von analytischen Kalkulationen mittels Data Analysis eXpressions (DAX)
- Kreieren von interaktiven Reports und Dashboards
- Vermitteln von Erkenntnissen innerhalb der Organisation mittels Content Packs und App Workspaces
- Wirksames Einsetzen von Content auf unterschiedlichen Plattformen
Kursinhalt
Day 1
Introduction to the Power BI ecosystem
- Power BI Service at PowerBI.com
- Power BI Desktop
- Power BI Mobile
- Power BI Embedded
- Power BI Report Server
Introduction to Power BI Desktop
- Key features and navigation
- Core activities with Get Data, Model and Visualize
Modeling: Introduction-Fundamentals of Data Modeling
- Data types
- Model design
- Modeling time
- Practical cases
Get Data: Gathering and Cleansing
- Query Editor
- Data Sources
- Querying data
- Other features
- Practical cases
Modeling: Improving the Data Model
- Data model key components
Modeling: Data Analysis eXpressions (DAX) and Quick Measures
- What is DAX and why we need it
- Calculated columns and measures
- DAX functions introduction
- Practical cases
Visualize: Introduction to Visuals and Chart Interaction
- Introduction to Power BI Reports
- Visual elements
- Creating reports
- Practical cases
Visualize: Conditional Formatting Options
- Conditional formatting with the default visuals
- Custom visuals tailor-made for conditional formatting
Lab 1: Obtaining and Refining Data
Students will work with the Power BI Desktop to perform basic steps in creating queries using the Query Editor and create their first Data Model.
Lab 2: Refinements and Improvements on the Data Model
Students will enhance the Power BI Desktop Data Model by validating data types, formats and navigation paths through the data.
Lab 3: Incorporating Basic DAX Expressions
Students will create their first Data Analysis eXpressions (DAX) into the Power BI Desktop Data Model including how to define standard calculations and expressions.
Lab 4: Create a Simple Report
Students will use Power BI Desktop to build common visualizations off the Data Model including charts, graphs, slicers and maps.
Day 2
Share: Publishing to the Power BI Service
- Publishing Reports
- Building Dashboards
- Sharing Dashboards
Share: Creating and Managing Workspaces
- Personal workspace
- Group workspace
Modeling: Connecting On-Premises Data to the Power BI Service
- Power BI Gateway overview
- Gateway setup and configuration
Get Data: Advanced Data Cleansing Features
- Advanced Transformations
- Using Parameters
- M Language Introduction
- Incorporating R datasets
Modeling: Intermediate DAX Calculations
- Overview of different types of functions
- Aggregation and relationship functions
- Implementing calculations, measures, and KPIs
- Practical cases
Get Data: Working with Data for Power BI Report Server
- Extending on-premise capabilities
- User Experiences
- Moving assets to SSAS
- Data Connectivity
Share: Deploying Reports to Power BI Report Server
- Deploying reports to Power BI Report Server
- Editing and content linking
- Security and Sharing
- Developer resources
Lab 5: Building Better Visualizations
Students will use basic features offered in the Power BI Service (powerbi.com) to publish reports, create quick insights, share reports, create dashboards and ask questions against the data.
Lab 6: New Ways to Modify Reports
Students will use Power BI Desktop to modify the Data Model with pivots and leverage the M language and incorporate report filters.
Lab 7: Intermediate DAX Calculations
Students will create several new measures using Data Analysis eXpressions (DAX) in the Power BI Desktop Data Model and leverage calculations in new visuals and Key Performance Indicators (KPIs).
Lab 8: Working with Power BI Report Server
Students will publish a report from Power BI Desktop to Power BI Report Server and work with features like the Web Portal including report editing, data refresh and data source connections.
Day 3
Visualize: Custom Visuals and Custom Data Sources
- The default visuals that come with Power BI Desktop are very useful, but there are many custom visuals available to help fit specific situations.
Visualize: Advanced Visualization Techniques
- New analytical features
Visualize: Advanced Visuals with R
- Bringing Data Science into your Power BI reports
Visualize: Designing for Mobility
- Design considerations
- Features & options
Share: Power BI Service Administration
- The need to share
- The Power BI Service
- Practical cases
Lab 9: Custom Visualizations
Students will discover advanced levels of customization in the Power BI Desktop with custom visuals from the custom visuals Marketplace, R visuals, custom themes and mobile layouts.
Lab 10: Power BI Service and Power BI Report Server better together
Students will use Power BI Report Builder to create a report and publish to Power BI Report Server, create KPIs, apply Row Level Security and share content to the Power BI Service.