Course Outline
Introduction to Power BI Desktop
- Versions, license types, and program capabilities
- Main applications
- User interface overview
- Report, card, and visualization – main components of the program
- Power BI cloud services – capabilities and limitations
First Power BI Models
- Working with a pre-built data model – one data table
- Basic visualizations – connecting a visual element to data
- Data types, regional settings
- Line chart, bar chart, and scatter plot. Customizing visualization elements
- Card, table, matrix – formatting objects
- Geographic data visualizations – map and cartogram
- Visualization filter, card, and report filters
Working with a Multi-Table Model
- Tables, relationships, and data model in analysis
- Automatic and manual table linking using relationships
- Data optimization and modification for the attached model
- Creating calculated columns
- Introduction to data modeling and linking
Power Query Data Model for Power BI Desktop
- Data source types for Power Query – capabilities and limitations
- TEXT/CSV files – editing and converting information
- Spreadsheets and their elements as data sources for visualizations (sheet, range)
- Relational databases (Access, SQL Server) – relationship import
- Direct queries (Direct Query - SQL)
- Custom data source linking – SQL + CSV + Web Pages
- External data sources (online store, accounting software, data warehouse)
- Introduction to the M language and data model creation
- Calculated columns, conditional, and tabular expressions
Advanced Visual Elements
- Key performance indicators (KPIs)
- Advanced data model hierarchy
- Custom visualizations from the marketplace
- Importing visualizations from files (Power BI extensions)
Sharing Power BI Desktop Reports
- Exporting visualization data to a CSV file
- Exporting the report to PDF format
- Sharing the report in the cloud
- Embedding the report on a Sharepoint site and a public website
Requirements
About the Training
The training aims to master the knowledge required for creating interactive data visualizations using Power BI tools, based on models created with Power Query.
Participant Profile
This training is intended for individuals who create reports and analyses using Microsoft Excel, those who wish to analyze larger datasets using a new tool while achieving greater flexibility and professional presentation of their work. A recommended skill level includes proficiency in Microsoft Excel, knowledge of tables and pivot charts, and basic data import from CSV files, Access databases, and spreadsheets.
Benefits for Participants
Upon completion of the training, participants will be able to retrieve, transform, and present data in a coherent form using Power BI reports.
Benefits for Organizations
Improved readability of created summaries and reports. Access to new forms of information presentation.
Notes
Familiarity with Microsoft Excel is recommended.
Testimonials (7)
great labs and extensive tests questions
Martyna - EY GLOBAL SERVICES (POLAND) Sp. z o.o
Course - Power BI - wizualizacja danych
business cases, examples in the big screen, time inteligence functions, dax formulas
Manuel - EY GLOBAL SERVICES (POLAND) Sp. z o.o
Course - Power BI - wizualizacja danych
whenever I had a question, the trainer was addressing all my doubts
Sabina - EY GLOBAL SERVICES (POLAND) Sp. z o.o.
Course - Power BI - wizualizacja danych
Practice exercises, good contact with the Trainer
Mariola - EY GLOBAL SERVICES (POLAND) Sp. z o.o.
Course - Power BI - wizualizacja danych
creating the graphs :) and the workshop style - usually I'm answering work related e-mails during trainings
Karolina Cichocka - EY GLOBAL SERVICES (POLAND) Sp. z o.o.
Course - Power BI - wizualizacja danych
gain practical experience during training
Katarzyna Grzeskowiak - mTab Sp. z o.o.
Course - Power BI - wizualizacja danych
Machine Translated
The pace was very good. For some, it might have been too fast, but it was perfect for the group's level. The trainer directed the training towards skills that could be useful in our specific work.
Agnieszka Bohonos-Kolek - mTab Sp. z o.o.
Course - Power BI - wizualizacja danych
Machine Translated