Training Data Analysis in MS Excel with the use of Power BI tools (Power Query and Power Pivot) - basic level

Catalogue index: PCO/35

  • In stock
  • Delivery: free
  • Dedicated training:
  • Producer:
  • Training level:
    • podstawowy
  • Type of training:
    • stacjonarne
PLN440.00 net / particip. PLN6,600.00  net for 1 workshop PLN541.20 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:
  • 14
Producer:
Training language:
  • polski
Training level:
  • podstawowy
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 "Data Analysis in MS Excel using Power BI tools (Power Query and Power Pivot) - basic level" is a practical introduction to modern data analysis methods in the Excel environment. Participants will learn the basics of working with Power Query and Power Pivot - tools that allow for the automation of data processing, modeling, and creating dynamic reports. The training is conducted in a workshop format, enabling immediate application of the acquired knowledge in practice.

Who is the Training For

The training is aimed at people working with data in Excel - analysts, finance specialists, controlling, logistics, HR, as well as anyone who wants to improve their daily work with large datasets. The goal of the training is to acquire skills in effectively importing, transforming, and analyzing data from various sources and building simple data models and reports.

Objectives
Benefits
  • Understanding the basics of Power Query and Power Pivot
  • Ability to automate data processing
  • Creating data models and relationships between tables
  • Building dynamic reports and summaries
  • Better understanding of data structure and sources
  • Time savings through automation
  • Increased efficiency in working with large datasets
  • Ability to integrate Excel with Power BI
  • Development of analytical skills
  • Preparation for further development in the BI area
Training Program
  • Introduction to data analysis in Excel and Power BI
  • Overview of the Power Query interface and its capabilities
  • Importing data from various sources (Excel, CSV, Web, databases)
  • Transforming and cleaning data in Power Query
  • Creating calculated and conditional columns
  • Introduction to Power Pivot and data modeling
  • Creating relationships between tables and building a data model
Duration

14 hours

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

Zamów szkolenie