Business Intelligence with Power BI
Course Overview
| ID | 2401001 |
| Duration | 2.0 days |
| Methods | Lecture with examples and exercises. |
| Prerequisites | Experience with Business Intelligence concepts |
| Target group | Business Intelligence Developer |
Objectives
Get an overview of Power BI
Learn the components of Microsoft Power BI for Business Intelligence
Integrating data
Use Power Query and M for data integration
Modeling data
Define data models suitable for reporting
Develop with Data Analysis Expressions (DAX)
Develop measures, calculated columns, and tables with DAX
Present data
Use appropriate visualizations and report designs
Deploy and manage reports
Use the Microsoft Power BI Online Service for deployment
Overview
This seminar will show you how to use Microsoft Power BI and its components to implement Business Intelligence and reporting. You will learn how to load and transform tabular data with Power Query and M and build a data model suitable for reporting. You will develop calculated columns, tables, and measures with Data Analysis Expressions (DAX) to create interactive reports with various visualizations. Finally, you will see how to use data models and reports in the Microsoft Power BI Online Service deploys and manages.
Dates
Zurzeit stehen keine offenen Termine zur Verfügung. Nutzen Sie alternativ die Inhouse‑Option.
Learn with customized examples and content—precisely tailored to your requirements.
Your benefits at a glance
- Flexible preferred date
- Customized content
- Intensive exchange
- High practical relevance
Topics
- Understanding the architecture of Microsoft Power BI
- Integrating data with M and Power Query
- Modeling data appropriately for reporting
- Creating columns, tables, and measures with DAX
- Designing reports with various visualizations
- Deploying and managing Power BI reports
Description
Learn how to use Microsoft Power BI to implement data integration, data modeling, and report creation for Business Intelligence.
Services
- Lunch / catering
- Help with hotel / travel
- Comelio certificate
- Flexible: free cancellation up to one day before
Comelio Media
Still looking for additional reading? Discover suitable specialist books in our catalog.
Content
Business Intelligence and Reporting with Microsoft Power BI
Components and architecture of Business Intelligence with MS Power BI - Model/report development cycle - Microsoft Power BI Desktop (Report View, Data View, Relationship View) and Microsoft Power BI Online Service
Integrating data with Power Query
Queries and their settings, data pane, and M Editor - Loading and structuring data from different sources - Power Query Editor and its functions for filtering, sorting, aggregation, and transformation - Power Query and the M scripting language - Data gateways - Composite models with multiple sources - Custom aggregations
Modeling data
Introduction to data modeling - Modeling view in Power BI Desktop - Normalization and normal forms - Relationships, primary keys and foreign keys, data filtering and filter direction - Modeling for BI: Star and galaxy schema, facts, and dimensions
Data Analysis Expressions (DAX)
Developing measures, calculated columns, and calculated tables with DAX - Calculations with CALCULATE - Working with time and date - Using relationships - Filter context - DAX scripts with variables, operators, functions, and logic
Creating reports
Visualizations: Creating and formatting tables, matrices, and charts - Interactivity: Navigation, filters, hierarchies, and drill-down - Slicers and filter cards - Bookmarks - Filter pane - Mobile layout - Report designs
Deploying and managing Power BI reports
Deployment in the MS Power BI Online Service - Management / Administration and Updates - Reports and Dashboards
Instructor
Marco Skulschus studierte in Wuppertal und Paris Ökonomie mit Schwerpunkt Wirtschaftsinformatik und arbeitet schon seit mehr als 10 Jahren als Dozent und Entwickler für Datenanalyse-Lösungen mit dem Microsoft BI Stack. Er ist auch als Fachbuch-Autor tätig und war in verschiedenen Forschungsprojekten im Einsatz.
Publications
- MS SQL Server - T-SQL Abfragen und Analysen (Comelio Medien )
978-3-939701-93-4 - MS SQL Server - Implementierung, Administration und Programmierung mit T-SQL (Comelio Medien )
978-3-939701-71-2 - MS SQL Server 2014 - XML-Integration mit T-SQL (Comelio Medien )
978-3-939701-97-2 - SQL und relationale Datenbanken (Comelio Medien )
978-3-939701-52-1