Course Outline
Introduction to Power BI Desktop
- Versions and license types and software capabilities
- Main applications
- Overview of the user interface
- Report, page, and visualization – main components of the software
- Power BI cloud services – capabilities and limitations
Initial Power BI Models
- Working with a ready-made data model – single table with data
- Basic visualizations – linking visual elements with 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 map chart
- Visual filters, cards, and report filters
Working with a Multi-Table Model
- Tables, relationships, and data models in analysis
- Automatic and manual table merging using relationships
- Optimization and modification of data attached to the model
- Creating calculated columns
- Introduction to modeling and merging data
Power Query Data Model for Power BI Desktop
- Data source types for Power Query – capabilities and limitations
- TXT/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)
- Merging 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 columns, and table 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 reports to PDF format
- Sharing reports in the cloud
- Embedding reports on SharePoint sites and public websites
Requirements
About the Course
This training enables participants to acquire knowledge on creating interactive data visualizations using Power BI tools, based on models created with Power Query.
Participant Profile
Individuals involved in report creation and analysis, who compile summaries using Microsoft Excel and wish to analyze larger volumes of data using a new tool, thereby gaining greater flexibility and professional presentation of their work results. Proficiency in using Microsoft Excel is recommended, along with knowledge of pivot tables and charts. Basic understanding of importing data from CSV files, Access databases, and spreadsheets.
Benefits for Participants
Upon completing the course, participants will be able to retrieve, transform, and present data concisely using Power BI reports.
Benefits for the Organization
Improved readability of created summaries and reports. Access to new forms of information presentation.
Notes
Familiarity with Microsoft Excel is recommended.
Testimonials (7)
1. Well-organized knowledge, presented in a completely simple way. 2. Live resolution of our examples. 3. Addressing all the challenges we encountered at work. 4. Using the remaining time for interesting insights related to the training topic. 5. Positive attitude from the instructor.
Judyta Berdzik - PwC Business Services Sp. z o.o.
Course - Power BI - wizualizacja danych
Machine Translated
learning how to organize data and ensuring its aesthetic processing
Patrycja Bialowolska - PwC Business Services Sp. z o.o.
Course - Power BI - wizualizacja danych
Machine Translated
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
