Power Query Training – Beginner Level

Catalogue index: IFS/66

  • In stock
  • Delivery: free
  • Dedicated training:
  • Producer:
  • Training level:
    • Podstawowy
  • Type of training:
    • stacjonarnie; online
PLN533.33 net / particip. PLN7,999.95  net for 1 workshop PLN656.00 gross incl. 23% VAT / particip.

product- line 1

Features

Features
Certification:
  • TAK
Dedicated training:
Number of training hours:
  • 8
Producer:
Training language:
  • polski
Training level:
  • Podstawowy
Type of training:
  • stacjonarnie; online

Description

Company Description

InfoShare Academy is a leading IT academy offering comprehensive educational programs in new technologies for companies. Since 2015, we have been supporting organizations in developing technology teams through dedicated courses in Machine Learning, DevOps, Data Engineering, Python, UX/UI Design, AWS, and Kubernetes. Our training is based on practical skills and real business cases. We collaborate with over 300 industry practitioners, ensuring that our programs are tailored to current market needs. We specialize in reskilling and upskilling employees. With us, you will build effective teams implementing new technologies that will accelerate innovation and strengthen your company's competitiveness in the market. Check out our training offerings designed for companies, created to enhance your employees' competencies in the IT field.

Training Description

The Power Query training – basic level is an intensive course aimed at individuals seeking solid foundations in using the Power Query tool for effective data management and processing in Excel.

Who is the training for

The target group includes individuals who want to explore the capabilities of Power Query and automate the processes of importing, managing, and transforming data in a spreadsheet. No prior programming experience or advanced Excel knowledge is required.

Objectives

 

Benefits

As a result of the training, participants will gain solid foundations in using Power Query for importing, managing, and transforming data in Excel, enabling them to analyze and present information contained in spreadsheets more effectively.

Training Program

  • Importing data from various sources

    • Databases

    • Text files

    • Import from folder

    • Web pages

    • Excel workbook

  • Managing queries

    • Refreshing queries

    • Different forms of loading data from queries

    • Appending queries

    • Merging queries

    • Working with multiple queries

  • Transforming and cleaning data in the Power Query editor

    • Working with columns

    • Working with rows

    • Defining data types

    • Unpivoting columns

    • Pivot column

    • Grouping and summarizing data

    • Text, numeric, and date transformations

Duration

8 hours / 1 day

Price includes
  • Certificate of completion
  • Monthly access to the training recording (in case of online format)
  • Customization of the training program to the client's needs

Zamów szkolenie