Technologies / Data & Analytics

Multidimensional data analysis using MS Excel and Power BI

The main goal of the course is to teach how to efficiently, quickly and effectively compile data from various sources for further analysis and reporting. In addition, the course teaches how to use the tools available in MS Excel and Power BI, which will allow you to streamline and automate tasks without having to learn VBA programming. The goal of the training is to learn how to prepare multidimensional analysis and reports.

Why choose this training?

Facing continuous technological changes, technical competencies have become a critical asset. The main goal of the course is to teach how to efficiently, quickly and effectively compile data from various sources for further analysis and reporting.

This training delivers comprehensive knowledge in technology, enabling participants to immediately apply acquired skills in their professional work.

What makes our approach unique?

At EITT, we focus on learning by doing — every training includes extensive practical components. Over 5 days of intensive training, participants work on real-world examples and scenarios, ensuring not only theoretical understanding but practical application skills.

With over 2,500 trainings in our portfolio and a 4.8/5 participant rating, EITT is a trusted partner in IT competency development for organizations of all sizes. Our trainers are experienced practitioners who share up-to-date knowledge and proven solutions.

Looking for training tailored to your team’s needs? Contact us — we’ll prepare a program customized to your requirements.

This training is part of the path:

Accountant / Finance Specialist

Training program

relative, absolute, mixed addresses
assigning names to cell ranges
appeal styles
3-W appeals
rules for using embedded functions
advanced formulas - nesting functions
discussion of the most useful built-in functions
array functions
data validation

conditional formatting
autoconspectus and data grouping
sorting options
advanced filter
Text as columns tool
object Table
subtotals
consolidation
look for a result
script manager
creating a table - data sources
modify the table layout
grouping and sorting data in a table
setting table options and table field options
adding enumerated fields
creating and modifying a pivot chart
import of text files
database queries
web search
file security
workbook protection
cellular protection
Introduction
What is PowerPivot
Essential benefits of using PowerPivot to analyze data in Excel
PowerPivot terminology and multivariate analysis
Availability of PowerPivot add-on
Creating data models
Importing data into the model, from multiple sources
From the active workbook
From other workbooks
From txt, csv files
From the databases

Refining models using DAX (Data Analysis eXpressions language)
Creating calculated columns
Necessary model adjustments using RELATED
Creating calculated measures
Creating calculated dimension elements and hierarchies
Creating calculated fields
Classified
-. Non-confidential
Creating Key Performance Indicators (KPIs)
fetching from PowerPivot models
Pivot tables and charts
Principles of proper pivot table use
Differences in the functionality of a PowerPivot-based pivot table versus a standard pivot table Fragmenters
Timeline
Downloading tables from a PowerPivot model
Introduction
What is Power Query
Installation of the Power Query add-on and discussion of its interface.
Availability of the Power Query add-on
Acquisition of data - import from external sources
From files (Excel, CSV),
Folders - creating incremental data models,
Relational databases (MS Access),

Web sources (Facebook),
Operations on data in a graphical view
Query list
List of operations
Data levels - navigator
Tools accessible from the ribbon:
Operations on rows/columns,
Filtering and sorting,
Changing data type,
Auto-filling empty fields, changing values of selected fields,
Separating and merging,
Records, lists, tables,
Grouping and aggregating,
Unpivot,
Date/time, number and text transformations,
Combining data (summing records, merging tables).
Data operations using M language

Basic built-in functions.
Variables, blocks, user functions.
Data import automation
From the World Wide Web,
From web services,
From the files.
Introduction
What is Power View
Availability of Power View add-on
Create a report using PowerView
Table,
Matrix,

Key performance indicators
Use of maps and filters in the Power View report
Creating charts / graphs
Linear
Circular
Column
Post
Spotlight
Use of fragmenters and hierarchies in charts/diagrams
Create animated dot plots (use of timeline)
Introduction
What is Power Map
Availability of the Power Map add-on
Getting acquainted with the interface of the Power Map add-on
Preparation of the data needed for the presentation in the Power Map add-on
Geocoding in Power Map
Presentation of data using different types of visualization on a map:
The use of compressed-column visualization
Column visualization - grouped
Creating a bubble visualization
Contour (among other things, creating heat islands)
Regional visualization
Working with multiple layers
Make it dynamic by adding multiple 'scenes' and transition effects
Tuning settings in charts and layers
Visualizations on dynamic maps - tracking time-varying data
Exporting a scene sequence to a video file

Delivery Methods

Online

Convenience of participating from anywhere
Interactive live sessions with trainer
Materials available for 30 days
No travel costs

On-site

Direct contact with trainer and group
Intensive hands-on workshops
Networking with other participants
Full focus on learning

Frequently asked questions

What are the prerequisites for this training?

The Multidimensional data analysis using MS Excel and Power BI training does not require specialized prior knowledge. Basic IT knowledge is sufficient.

What is the format and duration of this training?

The training lasts 5 days and is available in online and on-site format. Sessions run from 9:00 AM to 4:00 PM. We can also customize the schedule to fit your team's needs.