Power Pivot training in MS Excel

Catalogue index: PCO/38

  • In stock
  • Delivery: free
  • Dedicated training:
  • Producer:
  • Training level:
    • -
  • Type of training:
    • stacjonarne
PLN280.00 net / particip. PLN4,200.00  net for 1 workshop PLN344.40 gross incl. 23% VAT / particip.

product- line 1

Features

Features
Additional materials:
  • skrypt szkoleniowy, pliki do zadań i ćwiczeń
Certification:
  • TAK
Dedicated training:
Number of training hours:
  • 8
Producer:
Training language:
  • polski
Training level:
  • -
Type of training:
  • stacjonarne

Description

Company Description

Since 2012, we have been operating in the training industry, and our team consists of people who have been involved in teaching and creating modern solutions in the field of IT for many years. We spend over 600 hours a month in training rooms. This time is dedicated to training our clients but also to enriching our experiences, listening skills, and responding to your needs. We specialize in training and consulting in the field of IT. We create ready-made solutions that facilitate everyday work. Our offer includes a wide range of training for both beginners and advanced users and specialists from IT departments. The client is the most important to us! Our work makes sense when the client returns to us again and recommends us to others.

Training Description

The training "Power Pivot in MS Excel" is an advanced data analysis course that allows participants to create complex data models and dynamic reports without the need for external BI tools. Power Pivot enables the integration of data from multiple sources, creating relationships between tables, and calculations using the DAX language. The training is conducted in the form of practical workshops, allowing participants to learn by working on real examples.

Who is the Training For

The training is intended for analysts, finance specialists, controlling, sales, logistics, and anyone working with large datasets who wants to create more advanced analyses in Excel.

Goals

The goal of the training is to teach participants how to build data models, create relationships and measures, as well as prepare interactive reports.

Benefits
  • Ability to create data models in Excel
  • Creating relationships between tables without using formulas
  • Using DAX for advanced calculations
  • Building dynamic reports and analyses
  • Integrating data from various sources
  • Increasing efficiency when working with large datasets
Training Program
  • Introduction to Power Pivot – what it is and how it works
  • Importing data into the Power Pivot model
  • Creating relationships between tables
  • Creating calculated columns and measures
  • Introduction to DAX – basic functions
  • Aggregations, filters, and contexts in DAX
  • Creating KPIs and business indicators
  • Handling hierarchies and calendars in the data model
  • Creating reports using pivot tables
  • Practical case study – building an analytical model
Duration

8 hours

Price Includes
  • Practical classes with a trainer
  • Training script
  • Files with tasks and exercises
  • Certificate
  • Email consultations

Zamów szkolenie