Course Outline

Introduction to Power BI Desktop
  • Versions, license types, and program capabilities
  • Main applications
  • User interface overview
  • Report, card, and visualization – the main components of the program
  • Power BI cloud services – possibilities and limitations
First Power BI Models
  • Working with a ready-made data model – one table with data
  • Basic visualizations – linking 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-based visualizations – map and cartogram
  • Visualization filter, card, and report
Working with a Multi-Table Model
  • Tables, relationships, and data model in analysis
  • Automatic and manual table joining using relationships
  • Data optimization and modification when attached to the model
  • Creating calculated columns
  • Introduction to data modeling and joining
Power Query Data Model for Power BI Desktop
  • Data source types for Power Query – possibilities and limitations
  • Text/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)
  • Combining 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, 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 web page

Requirements

About the Course

This course allows participants to master knowledge in creating interactive data visualizations using Power BI tools, based on models created with Power Query.

Participant Profile

This course is aimed at individuals who create reports and analyses, compile summaries using Microsoft Excel, and wish to analyze larger datasets using a new tool, thereby gaining greater flexibility and professional presentation of their work. Familiarity with Microsoft Excel, including tables and pivot charts, is recommended. Basic knowledge of data import from CSV files, Access databases, and spreadsheets.

Benefits for Participants

Upon completing the course, participants will be able to retrieve, transform, and present data in a concise 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