Course Outline
Introduction to Power BI Desktop
- Versions, license types, and program capabilities
- Main applications
- User interface overview
- Report, card, and visualization – the main components of the program
- Power BI cloud services – possibilities and limitations
First Power BI Models
- Working with a ready-made data model – one table with data
- Basic visualizations – linking 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-based visualizations – map and cartogram
- Visualization filter, card, and report
Working with a Multi-Table Model
- Tables, relationships, and data model in analysis
- Automatic and manual table joining using relationships
- Data optimization and modification when attached to the model
- Creating calculated columns
- Introduction to data modeling and joining
Power Query Data Model for Power BI Desktop
- Data source types for Power Query – possibilities and limitations
- Text/CSV files – editing and converting information
- Spreadsheets and their elements as data sources for visualizations (worksheet, range)
- Relational databases (Access, SQL Server) – importing relationships
- Direct queries (Direct Query - SQL)
- Combining custom data sources: SQL + CSV + Web Pages
- External data (online store, accounting software, data warehouse)
- Introduction to the M language and creating a data model
- 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 web page
Requirements
About the Course
This course allows participants to master knowledge in creating interactive data visualizations using Power BI tools, based on models created with Power Query.
Participant Profile
This course is aimed at individuals who create reports and analyses, compile summaries using Microsoft Excel, and wish to analyze larger datasets using a new tool, thereby gaining greater flexibility and professional presentation of their work. Familiarity with Microsoft Excel, including tables and pivot charts, is recommended. Basic knowledge of data import from CSV files, Access databases, and spreadsheets.
Benefits for Participants
Upon completing the course, participants will be able to retrieve, transform, and present data in a concise 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
Much practice during the training
Katarzyna Grzeskowiak - mTab Sp. z o.o.
Course - Power BI - wizualizacja danych
Machine Translated
The pace was very good. It might have been too fast for some, but it was ideal for the group's level. The instructor focused the training on skills that will be useful in our specific work.
Agnieszka Bohonos-Kolek - mTab Sp. z o.o.
Course - Power BI - wizualizacja danych
Machine Translated