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

About the training

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.

Participant Profile

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.

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 the created summaries and reports. Access to new forms of information presentation.

Comments

Recommended knowledge of Microsoft Excel

 14 Hours

Number of participants



Price per participant

Testimonials (5)

Related Courses

Related Categories