Course Outline
Introduction to Power BI Desktop
- Versions and types of licenses and capabilities of the program Main applications Overview of the user interface Report, tab and visualization - main components of the program Cloud services Power BI - capabilities and limitations
First models Power BI
- Working with a ready-made data model - one table with data Basic visualizations - connecting a visual element with data Data types, locales Line, bar and scatter chart. 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 table linking using relationships Optimizing and modifying data attached to the model Creating calculated columns Introduction to data modeling and linking
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 queries (Direct Query - SQL) Combining Custom Data Sources SQL + CSV + Web Pages External Data (Online Store, Accounting Software, Data Warehouse) Introduction to M and Data Modeling Calculated Columns, Conditional Columns, and Tabular Expressions
Advanced visuals
- Key Performance Indicators (KPIs) Advanced Data Model Hierarchy Custom Visualizations from Marketplace Import Visualizations from Files (Extensions Power BI)
Sharing Reports Power BI Desktop
- Output of visualization data to a CSV file Export of the report to PDF format Sharing the report in the cloud Embedding the report on the Sharepoint website and public website
Requirements
The training allows you to master the knowledge of creating interactive data visualizations using tools Power BI, based on the model created with Power Query.
People involved in creating reports and analyses, creating statements using Microsoft Excel, wanting to analyze larger amounts of data using a new tool, while gaining greater flexibility and professional presentation of the result of their work. Ability to use Microsoft Excel, knowledge of tables and pivot charts is recommended. Basics of importing data from CSV files, Access databases and spreadsheets.
After completing the training, the participant will be able to download, transform and present data in a concise form using reports Power BI.
Increasing the readability of the created summaries and reports. Access to new forms of information presentation.
Comments
Recommended knowledge of Microsoft Excel
Testimonials (5)
dużo praktyki w trakcie szkolenia
Katarzyna Grześkowiak - mTab Sp. z o.o.
Course - Power BI - wizualizacja danych
Tempo było bardzo dobre. Dla niektórych mogłoby być za szybkie, ale było idealne do poziomu grupy. Prowadzący kierunkował szkolenie na umiejętności, które mogą się przydać w naszej konkretnej pracy.
Agnieszka Bohonos-Kołek - mTab Sp. z o.o.
Course - Power BI - wizualizacja danych
Przekazywanie wiedzy bardzo obrazowe i dostosowane do wiedzy i umiejętności szkolonych.
Dorota Mołas - Takenaka Europe GmbH Sp. z o.o. Oddział w Polsce
Course - Power BI - wizualizacja danych
Ćwiczenia praktyczne.
Zbigniew Dąbkiewicz - Takenaka Europe GmbH Sp. z o.o. Oddział w Polsce
Course - Power BI - wizualizacja danych
There are many fields and functions which I haven't recognized or I haven't been familiar with. It was really good that I could get such knowledge or skills for self-development and for database creation for company.