Course Outline

Introduction to Power BI Desktop
  • Versions and types of licenses and program capabilities
  • Main uses
  • User interface overview
  • Report, card and visualization – the main components of the program
  • Services Power BI in the cloud – opportunities and limitations
First models Power BI
  • Working with a ready-made data model – one table with data
  • Basic visualizations – combining a visual element with data
  • Data types, regional settings
  • Line, bar and scatter charts. 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 connection of tables using relations
  • Optimization and modification of data connected to the model
  • Creating calculated columns
  • Introduction to modeling and data fusion
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 Query - SQL
  • Connecting custom data sources SQL + CSV + Websites
  • External data (online store, accounting program, data warehouse)
  • Introduction to the M language and creating a data model
  • Calculated columns, conditional columns and tabular expressions
Advanced visual elements
  • Key Performance Indicators KPIs
  • Advanced data model hierarchy
  • Custom visualizations from the trading platform
  • Importing visualizations from files (extensions Power BI)
Sharing reports Power BI Desktop
  • Output of visualization data to a CSV file
  • Export 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 allows you to acquire knowledge in creating interactive data visualizations using tools Power BI, based on a model created using Power Query.

Participant Profile

People creating reports and analyses, creating summaries using Microsoft Excel, who want to analyze larger amounts of data using a new tool, obtaining greater flexibility and professional presentation of the results of their work. The ability to use Microsoft Excel and knowledge of pivot tables and charts are recommended. Basics of importing data from CSV files, databases Access 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 created statements and reports. Access to new forms of information presentation.

Comments

Recommended knowledge Microsoft Excel

 14 Hours

Number of participants


Price Per Participant (Exc. Tax)

Testimonials (7)

Provisional Courses

Related Categories