Course Outline
Introduction to Power BI Desktop
- Versions and types of licenses and program capabilities
- Main uses
- User interface overview
- Report, card and visualization – the main components of the program
- Services Power BI in the cloud – opportunities and limitations
First models Power BI
- Working with a ready-made data model – one table with data
- Basic visualizations – combining a visual element with data
- Data types, regional settings
- Line, bar and scatter charts. Customization of visualization elements
- Card, table, matrix – formatting objects
- Visualizations based on geographical data – map and cartogram
- Visualization, card and report filter
Working with a multi-table model
- Tables, relationships and data model in analysis
- Automatic and manual connection of tables using relations
- Optimization and modification of data connected to the model
- Creating calculated columns
- Introduction to modeling and data fusion
Power Query data model for Power BI Desktop
- Types of data sources for Power Query – possibilities and limitations
- TXT/CSV files – editing and converting information
- Spreadsheets and their elements as data sources for visualization (sheet, range)
- Relational databases (Access, SQL Server) – import of relations
- Direct Query - SQL
- Connecting custom data sources SQL + CSV + Websites
- External data (online store, accounting program, data warehouse)
- Introduction to the M language and creating a data model
- Calculated columns, conditional columns and tabular expressions
Advanced visual elements
- Key Performance Indicators KPIs
- Advanced data model hierarchy
- Custom visualizations from the trading platform
- Importing visualizations from files (extensions Power BI)
Sharing reports Power BI Desktop
- Output of visualization data to a CSV file
- Export 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 allows you to acquire knowledge in creating interactive data visualizations using tools Power BI, based on a model created using Power Query.
Participant Profile
People creating reports and analyses, creating summaries using Microsoft Excel, who want to analyze larger amounts of data using a new tool, obtaining greater flexibility and professional presentation of the results of their work. The ability to use Microsoft Excel and knowledge of pivot tables and charts are recommended. Basics of importing data from CSV files, databases Access and spreadsheets.
Benefits for the Participant
After completing the training, the participant will be able to download, transform and present data in a concise form using reports Power BI.
Benefits for the Organization
Increasing the readability of created statements and reports. Access to new forms of information presentation.
Comments
Recommended knowledge Microsoft Excel
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