Course programme

You will do
face-to-face virtual workshops
You will study online with a live teacher
with whom you can communicate and fully interact in real-time

Power BI function

1
content and tools
- Learning the interface of the Power BI data analysis program
- Loading data in different formats into Power BI, collecting information for analytics from sites
Tools
1. Analytics in Power BI
2. Power BI interface
3. Programme goals
4. Data for work
5. Data sources
6. Ways of loading data
7. Work with requests
8. Preparation of data for analysis
You will practice
You will learn
Requests
Data import
Data sources
Power BI desktop

Data sources

2
content and tools
- Loading data into BI and forming a clear table
- Grouping data and combining queries
Tools
1. Data operations
2. Interface Power Query
3. Data preparation
4. Grouping in Power BI
5. Creating of custom column
6. Ways of connecting the data
7. Combining data from different sources
You will practice
You will learn
Updating requests
Data conversion
Grouping
Power Query

Data modeling

3
content and tools
- Loading data from a file and creating a summary of income
- Create links between data from different sources
- Working with filters for visualisation and tables
Tools
1. Principles of building a data model
2. Organising tables into a complex structure
3. Schemes for building data models
4. Managing connections between tables
5. Creating Data Models
6. Setting up data models
7. DAX data analysis language
8. Creating directories
You will practice
You will learn
Breaks
Tables
Managing connections
Data connections

DAX Data analysis language

4
content and tools
- Creating calculated columns, writing measures
- Creating a calculated table, visualising the result in a table
Tools
1. Built-in calculations
2. Creating and Applying Measures
3. Function sum, average, count
4. Function sumx, averagex, countax
5. Function distance count function, filter
6. Calculated columns
7. Creating calculated tables
8. Group by function
You will practice
You will learn
Calculated tables
Measures
Calculated columns
DAX language

Data visualisation

5
content and tools
- Preparing a visual component for data
Tools
1. Creating visual elements
2. Visual elements setting
3. Design tools
4. Types of visualisation
5. Creating Graphs and Tables
6. Applying filters
7. Preparing reports for external users
You will practice
You will learn
Filter
Diagrams
Schemes
Charts

Excel tools for working with data

6
content and tools
- Creating a simple table
- Sort cells based on the selected criteria
- Multi Level sorting
- Applying simple filtering
- Creation of utm tags
Tools
1. Program workspace
2. Working with data in cells
3. Sorting cells based on criteria
4. Change the style and colour of cells
5. Making hyperlinks
You will practice
You will learn
Hyperlinks
Formats and Values
Sorting in cells
Data entry and processing

Functions and formulas

7
content and tools
- A task with a mathematical function.
- Analyse the number of requests on a particular topic. Sorting this information into the table
Tools
1. Apply formulas in tables
2. Simple and complex calculations using mathematical functions
3. Data Analysis with Logic Functions
4. Statistical functions for analysing data in cells
5. Working with Text Functions
6. Absolute and relative links
You will practice
You will learn
Links
"if" function
Mean
Calculations and formulas

Working with date and time functions

8
content and tools
- Calculation of dates
- Creating names for cells and ranges
Tools
1. Adding and subtracting dates
2. Subtract dates with functions
3. Adding days, weeks, months to a date
4. Creating Named Cells and Ranges
5. Conditional Data Formatting
You will practice
You will learn
Named cells
Summation
Formatting
Data and time

Work with data

9
content and tools
- Calculation of profitability of sales
- Summarising subtotals in the table
- Data protection in the table.
Tools
1. Adding subtotals
2. Merging multiple tables into one
3. Standard Filtration
4. Working with advanced filter
5. Lock Cells and Sheets for protection
6. Hiding data in a cell
You will practice
You will learn
Data protection
Data aggregation
Advanced Filter
Subtotals

Analyse data with pivot tables

10
content and tools
- Create a pivot table for total sales
- Creation of a pivot table on the results of sales with a breakdown by region and seller
- Calculation of % completion of the plan.
Tools
1. Building pivot tables
2. Filtering Data in a pivot table
3. Adding fields for calculation
4. Sorting and grouping data
5. Pivot table Formatting
6. Consolidation of data in one document
You will practice
You will learn
Consolidation
Filter
Sorting & Formatting
Pivot tables

Data visualisation

11
content and tools
- KPI calculation
- Building a chart with company performance data
- Create a complex chart with sales growth data
Tools
1. Creating diagram
2. Multilevel axis labels
3. Binding labels to cells
4. Complex diagram
5. Scatter plot
6. Lollipop diagram
You will practice
You will learn
Template
Complex diagram
Secondary axle
Basic Diagrams

Dynamic diagrams

12
content and tools
- Creating diagram to track daily sales
- Application of automatic data addition
- Making a chart of the exchange rate by years with time control
Tools
1. Building dynamic diagrams
2. Automatic data addition
3. Tracking data with diagrams
4. Adding a Series to a diagram
5. Diagrams with controls
6. Diagrams with a choice of displayed data
You will practice
You will learn
Data adding
Diagram management
Automation
Dynamic diagrams

Working with histograms and graphs

13
content and tools
- Making sparklines
Tools
1. Create a standard chart
2. Working with dynamic charts
3. Histogram with overlap
4. Normalized distribution histogram
5. Stacked histogram
6. Construction and design of the sparkline
You will practice
You will learn
Sparkline
Dynamic charts
Histogram
Standart charts

External sources

14
content and tools
- Setting up Power Query and Power Pivot
- Import and export of documents
Tools
1. Export and import of information
2. Transferring data to Google Sheets
3. Working with databases
4. Using the Power Query add-in
5. Power Pivot add-in features
6. Differences between Power Query and Power Pivot
You will practice
You will learn
Power Pivot
Power Query
Import to Google Sheets
Data export

Dashboard in Excel

15
content and tools
- Setting up Power Query and Power Pivot
- Import and export of documents
Tools
1. Export and import of information
2. Transferring data to Google Sheets
3. Working with databases
4. Using the Power Query add-in
5. Power Pivot add-in features
6. Differences between Power Query and Power Pivot
You will practice
You will learn
Power Pivot
Power Query
Import to Google Sheets
Data export
You will do
face-to-face virtual workshops
You will study online with a live teacher
with whom you can communicate and fully interact in real-time