Course Outline

Introduction to Power BI Desktop
  • Versions, license types, and program capabilities
  • Main applications
  • User interface overview
  • Report, card, and visualization – main components of the program
  • Power BI cloud services – capabilities and limitations
First Power BI Models
  • Working with a pre-built data model – one data table
  • Basic visualizations – connecting 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 visualizations – map and cartogram
  • Visualization filter, card, and report filters
Working with a Multi-Table Model
  • Tables, relationships, and data model in analysis
  • Automatic and manual table linking using relationships
  • Data optimization and modification for the attached model
  • Creating calculated columns
  • Introduction to data modeling and linking
Power Query Data Model for Power BI Desktop
  • Data source types for Power Query – capabilities and limitations
  • TEXT/CSV files – editing and converting information
  • Spreadsheets and their elements as data sources for visualizations (sheet, range)
  • Relational databases (Access, SQL Server) – relationship import
  • Direct queries (Direct Query - SQL)
  • Custom data source linking – SQL + CSV + Web Pages
  • External data sources (online store, accounting software, data warehouse)
  • Introduction to the M language and data model creation
  • 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 website

Requirements

About the Training

The training aims to master the knowledge required for creating interactive data visualizations using Power BI tools, based on models created with Power Query.

Participant Profile

This training is intended for individuals who create reports and analyses using Microsoft Excel, those who wish to analyze larger datasets using a new tool while achieving greater flexibility and professional presentation of their work. A recommended skill level includes proficiency in Microsoft Excel, knowledge of tables and pivot charts, and basic data import from CSV files, Access databases, and spreadsheets.

Benefits for Participants

Upon completion of the training, participants will be able to retrieve, transform, and present data in a coherent 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.

 14 Hours

Number of participants


Price Per Participant (Exc. Tax)

Testimonials (7)

Provisional Courses

Related Categories