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

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

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

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

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

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

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

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

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

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

1. Creating diagram
2. Multilevel axis labels
3. Binding labels to cells
4. Complex diagram
5. Scatter plot
6. Lollipop diagram

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

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

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

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