Power BI - free course from Skillbox, training, Date: November 29, 2023.

7 years of experience as a consultant on the construction and implementation of BI and ERP systems. Implemented Power BI for financial accounting at OTT Technologies, a key supplier of communications equipment in Ukraine. Founded Quod Solutions Finance.

Loading data into Power BI
Learn to load data into Power BI from CSV files and become familiar with the Power Query interface.

Connecting data from different tables and resources
Learn to connect data from different sources, get acquainted with the types of connections - One to Many, Many to Many, One to One, Many to One.

Chart types and date filter
Get acquainted with the main types of charts - bar and pie charts, learn how to add a date filter to a chart.

Main types of filters and filter synchronization
Learn how to add filters to a visualization, page and report, get acquainted with Basic/Relative/Advance filters, and be able to synchronize filters between reports.

Visual filters
Learn how to create visual filters for graphs and use cross filtering.

Working with data hierarchy in graphs
Learn to use the Drill up, Drill down and Expand functions to work with data hierarchy in reports.

Detailing in reports using the Drill through pages functionality
Learn how to use the Drill through pages functions to customize the detail in your reports.

Working with world maps in charts
Learn to work with geographic data and build graphs with maps, create a map with data about site visitors.

Working with tooltips
Learn to add tooltips to charts.

Basic Metrics and DAX
Learn how to calculate Running total, Time Intelligent PQ, and Time Intelligent QQQ measures using DAX expressions.

Metrics and DAX: Using CALCULATE and Aggregate Functions
Become familiar with the CALCULATE function for changing filters applied to an expression, and learn how to work with the SUM, AVERAGE, MIN, MAX functions for data aggregation.

SUMX, AVERAGEX, ALL and SWITCH functions
Learn to work with the SUMX and AVERAGEX functions. You will understand how they differ from the standard functions SUM and AVERAGE. Learn the SWITCH function to switch between graphs and the ALL function to clear filters and create calculations across all rows in a table.

Building a Dashboard for end-to-end analytics
Create graphs with conversion rates to leads and customers, ROMI (return on marketing investment - return on investment in marketing activities).

Building a Dashboard with profit and loss charts
Create graphs with indicators of gross and net profit, expenses, and product sales by category.

Power BI Software Services
You will learn how to upload reports to the Power BI web interface, set up automatic data updating, and also get acquainted with the MyBi service.