Power Query in Data Analysis Training Course Tech For Development (T4D)

Need Help?

Free Courses Researchers

Power Query in Data Analysis Training Course

Intermediate | 5 days | Face to Face / Online / Elearning | Certificate

Course Overview

Course Summary

Course Title	Power Query in Data Analysis Training Course
Organization	Tech For Development (T4D)
Venue	Tech For Development (T4D) Training Centre
Duration	5 days
Target Industries
Target Job Roles
Course Fees (Face-to-Face)	USD 1,500/KES 99,000 (Exclusive of VAT)
Course Fees (Virtual)	USD 1,000/KES 70,000 (Exclusive of VAT)
Training Modes	Virtual and face-to-face training
Payment	Payment should be made to the Tech For Development (T4D) bank account on or before the start of the course
Accreditation	Tech For Development Certificate of Course Completion

Course Overview

In a data analysis course, the integration of Power Query serves as a vital component in equipping participants with the essential skills for efficient data transformation and analysis. Power Query, a robust tool embedded within Microsoft Excel and Power BI, enables users to seamlessly connect to various data sources, clean and reshape data, and merge information from multiple datasets. Through this module, participants gain a comprehensive understanding of Power Query's interface, functionalities, and advanced features, allowing them to perform tasks such as data cleaning, merging, and custom column creation with ease.

Duration

5 Days

Target audience

Data Analysts
Business Analysts
Data Scientists
Financial Analysts

Organizational Impacts

Improved efficiency in data preparation processes
Enhanced data accuracy and consistency
Streamlined reporting and analytics workflows
Reduced time spent on manual data handling

Personal Impacts

Enhanced skills in data transformation and automation
Increased proficiency with Power Query for personal and professional use
Ability to manage and manipulate complex datasets more effectively

Course Objectives

Understand the basics of Power Query and its interface
Learn techniques for importing and cleaning data from various sources
Automate data transformation tasks to save time and reduce errors
Integrate data from multiple sources for comprehensive analysis
Develop practical skills through hands-on case studies

Course Modules

Course Outline

Module 1: Introduction to Power Query

Overview of Power Query interface and features
Understanding data import options
Basic data cleaning techniques
Case Study: Importing and cleaning a dataset from Excel

Module 2: Data Transformation Techniques

Applying filters and sorting data
Using functions for data manipulation
Creating custom columns and calculations
Case Study: Transforming sales data for quarterly reports

Module 3: Data Integration and Combining Sources

Merging and appending queries
Combining data from different sources (Excel, SQL, etc.)
Resolving data conflicts and duplicates
Case Study: Integrating data from multiple departments for a unified view

Module 4: Automating Data Refresh and Workflow

Setting up automatic data refresh schedules
Creating and managing query parameters
Using Power Query with Power BI for advanced analytics
Case Study: Automating a weekly data update process for a business dashboard

Module 5: Advanced Power Query Techniques

Advanced data transformation functions
Handling complex data scenarios
Optimizing Power Query performance
Case Study: Handling and transforming large datasets for detailed analysis

Course Administration

Methodology

Instructor-led sessions use a blended learning approach combining presentations, guided practical exercises, web-based tutorials, and group work, delivered by seasoned industry experts. All facilitation and course materials are in English, so participants should be reasonably proficient in the language.

Accreditation

Upon successful completion of this training, participants will be issued a Tech For Development Certificate of Course Completion

Training Venue

The training will be held at the Tech For Development Training Centre. The course fee covers the course tuition, training materials, two break refreshments, and lunch. All participants will additionally cater to their travel expenses, visa application, insurance, and other personal expenses.

Accommodation & Airport Transfer

Arranged upon request.For reservations contact the Training Officer:
Email: [email protected]
Phone: (+254) 790 824 179

Tailor-Made

This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our T4D Training Centre or at a convenient location.

Payment

Payment should be transferred to the T4D account through a bank on or before the start of the course. Send proof of payment to [email protected].

Related Courses

Course Reviews

Based on 0 participant feedback

No reviews yet for this course. Be the first to share your experience!

Write a Course Review

Please share your honest feedback below.

Overall Rating *

5 / 5 (Excellent)

Full Name *

Job Title / Role

Organization

Your Feedback *

Share This Course

Date	Cost
2026 Schedules
Nairobi
14 Dec - 18 Dec	KES 99,000 \| $1,500	Register

Johannesberg
14 Dec - 18 Dec	$3,100	Register

Mombasa
14 Dec - 18 Dec	KES 115,000 \| $1,500	Register

Kigali
14 Dec - 18 Dec	$1,850	Register

Addis Ababa
14 Dec - 18 Dec	$3,100	Register

Kuala Lumpur
14 Dec - 18 Dec	$5,500	Register

Accra
14 Dec - 18 Dec	$3,200	Register

Cairo
14 Dec - 18 Dec	$4,200	Register

Cape Town
14 Dec - 18 Dec	$3,800	Register

Pretoria
14 Dec - 18 Dec	$3,100	Register

Dar es Salaam
14 Dec - 18 Dec	$2,100	Register

Naivasha
14 Dec - 18 Dec	KES 110,000 \| $1,500	Register

Kisumu
14 Dec - 18 Dec	KES 110,000 \| $1,500	Register

Arusha
14 Dec - 18 Dec	$2,100	Register

Machakos
14 Dec - 18 Dec	KES 110,000 \| $1,500	Register

Nakuru
14 Dec - 18 Dec	KES 110,000 \| $1,500	Register

Kampala
14 Dec - 18 Dec	$1,800	Register

Dubai
14 Dec - 18 Dec	$3,900	Register

Zanzibar
14 Dec - 18 Dec	$2,100	Register
2027 Schedules
Dar es Salaam
11 Jan - 15 Jan	$2,100	Register
08 Feb - 12 Feb	$2,100	Register
08 Mar - 12 Mar	$2,100	Register
12 Apr - 16 Apr	$2,100	Register
10 May - 14 May	$2,100	Register
14 Jun - 18 Jun	$2,100	Register
12 Jul - 16 Jul	$2,100	Register
09 Aug - 13 Aug	$2,100	Register
13 Sep - 17 Sep	$2,100	Register
11 Oct - 15 Oct	$2,100	Register
08 Nov - 12 Nov	$2,100	Register
06 Dec - 10 Dec	$2,100	Register

Kigali
11 Jan - 15 Jan	$1,850	Register
08 Feb - 12 Feb	$1,850	Register
08 Mar - 12 Mar	$1,850	Register
12 Apr - 16 Apr	$1,850	Register
10 May - 14 May	$1,850	Register
14 Jun - 18 Jun	$1,850	Register
12 Jul - 16 Jul	$1,850	Register
09 Aug - 13 Aug	$1,850	Register
13 Sep - 17 Sep	$1,850	Register
11 Oct - 15 Oct	$1,850	Register
08 Nov - 12 Nov	$1,850	Register
06 Dec - 10 Dec	$1,850	Register

Addis Ababa
11 Jan - 15 Jan	$3,100	Register
08 Feb - 12 Feb	$3,100	Register
08 Mar - 12 Mar	$3,100	Register
12 Apr - 16 Apr	$3,100	Register
10 May - 14 May	$3,100	Register
14 Jun - 18 Jun	$3,100	Register
12 Jul - 16 Jul	$3,100	Register
09 Aug - 13 Aug	$3,100	Register
13 Sep - 17 Sep	$3,100	Register
11 Oct - 15 Oct	$3,100	Register
08 Nov - 12 Nov	$3,100	Register
06 Dec - 10 Dec	$3,100	Register

Kuala Lumpur
11 Jan - 15 Jan	$5,500	Register
08 Feb - 12 Feb	$5,500	Register
08 Mar - 12 Mar	$5,500	Register
12 Apr - 16 Apr	$5,500	Register
10 May - 14 May	$5,500	Register
14 Jun - 18 Jun	$5,500	Register
12 Jul - 16 Jul	$5,500	Register
09 Aug - 13 Aug	$5,500	Register
13 Sep - 17 Sep	$5,500	Register
11 Oct - 15 Oct	$5,500	Register
08 Nov - 12 Nov	$5,500	Register
06 Dec - 10 Dec	$5,500	Register

Accra
11 Jan - 15 Jan	$3,200	Register
08 Feb - 12 Feb	$3,200	Register
08 Mar - 12 Mar	$3,200	Register
12 Apr - 16 Apr	$3,200	Register
10 May - 14 May	$3,200	Register
14 Jun - 18 Jun	$3,200	Register
12 Jul - 16 Jul	$3,200	Register
09 Aug - 13 Aug	$3,200	Register
13 Sep - 17 Sep	$3,200	Register
11 Oct - 15 Oct	$3,200	Register
08 Nov - 12 Nov	$3,200	Register
06 Dec - 10 Dec	$3,200	Register

Pretoria
11 Jan - 15 Jan	$3,100	Register
08 Feb - 12 Feb	$3,100	Register
08 Mar - 12 Mar	$3,100	Register
12 Apr - 16 Apr	$3,100	Register
10 May - 14 May	$3,100	Register
14 Jun - 18 Jun	$3,100	Register
12 Jul - 16 Jul	$3,100	Register
09 Aug - 13 Aug	$3,100	Register
13 Sep - 17 Sep	$3,100	Register
11 Oct - 15 Oct	$3,100	Register
08 Nov - 12 Nov	$3,100	Register
06 Dec - 10 Dec	$3,100	Register

Cape Town
11 Jan - 15 Jan	$3,800	Register
08 Feb - 12 Feb	$3,800	Register
08 Mar - 12 Mar	$3,800	Register
12 Apr - 16 Apr	$3,800	Register
10 May - 14 May	$3,800	Register
14 Jun - 18 Jun	$3,800	Register
12 Jul - 16 Jul	$3,800	Register
09 Aug - 13 Aug	$3,800	Register
13 Sep - 17 Sep	$3,800	Register
11 Oct - 15 Oct	$3,800	Register
08 Nov - 12 Nov	$3,800	Register
06 Dec - 10 Dec	$3,800	Register

Johannesberg
11 Jan - 15 Jan	$3,100	Register
08 Feb - 12 Feb	$3,100	Register
08 Mar - 12 Mar	$3,100	Register
12 Apr - 16 Apr	$3,100	Register
10 May - 14 May	$3,100	Register
14 Jun - 18 Jun	$3,100	Register
12 Jul - 16 Jul	$3,100	Register
09 Aug - 13 Aug	$3,100	Register
13 Sep - 17 Sep	$3,100	Register
11 Oct - 15 Oct	$3,100	Register
08 Nov - 12 Nov	$3,100	Register
06 Dec - 10 Dec	$3,100	Register

Cairo
11 Jan - 15 Jan	$4,200	Register
08 Feb - 12 Feb	$4,200	Register
08 Mar - 12 Mar	$4,200	Register
12 Apr - 16 Apr	$4,200	Register
10 May - 14 May	$4,200	Register
14 Jun - 18 Jun	$4,200	Register
12 Jul - 16 Jul	$4,200	Register
09 Aug - 13 Aug	$4,200	Register
13 Sep - 17 Sep	$4,200	Register
11 Oct - 15 Oct	$4,200	Register
08 Nov - 12 Nov	$4,200	Register
06 Dec - 10 Dec	$4,200	Register

Arusha
11 Jan - 15 Jan	$2,100	Register
08 Feb - 12 Feb	$2,100	Register
08 Mar - 12 Mar	$2,100	Register
12 Apr - 16 Apr	$2,100	Register
10 May - 14 May	$2,100	Register
14 Jun - 18 Jun	$2,100	Register
12 Jul - 16 Jul	$2,100	Register
09 Aug - 13 Aug	$2,100	Register
13 Sep - 17 Sep	$2,100	Register
11 Oct - 15 Oct	$2,100	Register
08 Nov - 12 Nov	$2,100	Register
06 Dec - 10 Dec	$2,100	Register

Machakos
11 Jan - 15 Jan	KES 110,000 \| $1,500	Register
08 Feb - 12 Feb	KES 110,000 \| $1,500	Register
08 Mar - 12 Mar	KES 110,000 \| $1,500	Register
12 Apr - 16 Apr	KES 110,000 \| $1,500	Register
10 May - 14 May	KES 110,000 \| $1,500	Register
14 Jun - 18 Jun	KES 110,000 \| $1,500	Register
12 Jul - 16 Jul	KES 110,000 \| $1,500	Register
09 Aug - 13 Aug	KES 110,000 \| $1,500	Register
13 Sep - 17 Sep	KES 110,000 \| $1,500	Register
11 Oct - 15 Oct	KES 110,000 \| $1,500	Register
08 Nov - 12 Nov	KES 110,000 \| $1,500	Register
06 Dec - 10 Dec	KES 110,000 \| $1,500	Register

Zanzibar
11 Jan - 15 Jan	$2,100	Register
08 Feb - 12 Feb	$2,100	Register
08 Mar - 12 Mar	$2,100	Register
12 Apr - 16 Apr	$2,100	Register
10 May - 14 May	$2,100	Register
14 Jun - 18 Jun	$2,100	Register
12 Jul - 16 Jul	$2,100	Register
09 Aug - 13 Aug	$2,100	Register
13 Sep - 17 Sep	$2,100	Register
11 Oct - 15 Oct	$2,100	Register
08 Nov - 12 Nov	$2,100	Register
06 Dec - 10 Dec	$2,100	Register

Kisumu
11 Jan - 15 Jan	KES 110,000 \| $1,500	Register
08 Feb - 12 Feb	KES 110,000 \| $1,500	Register
08 Mar - 12 Mar	KES 110,000 \| $1,500	Register
12 Apr - 16 Apr	KES 110,000 \| $1,500	Register
10 May - 14 May	KES 110,000 \| $1,500	Register
14 Jun - 18 Jun	KES 110,000 \| $1,500	Register
12 Jul - 16 Jul	KES 110,000 \| $1,500	Register
09 Aug - 13 Aug	KES 110,000 \| $1,500	Register
13 Sep - 17 Sep	KES 110,000 \| $1,500	Register
11 Oct - 15 Oct	KES 110,000 \| $1,500	Register
08 Nov - 12 Nov	KES 110,000 \| $1,500	Register
06 Dec - 10 Dec	KES 110,000 \| $1,500	Register

Nakuru
11 Jan - 15 Jan	KES 110,000 \| $1,500	Register
08 Feb - 12 Feb	KES 110,000 \| $1,500	Register
08 Mar - 12 Mar	KES 110,000 \| $1,500	Register
12 Apr - 16 Apr	KES 110,000 \| $1,500	Register
10 May - 14 May	KES 110,000 \| $1,500	Register
14 Jun - 18 Jun	KES 110,000 \| $1,500	Register
12 Jul - 16 Jul	KES 110,000 \| $1,500	Register
09 Aug - 13 Aug	KES 110,000 \| $1,500	Register
13 Sep - 17 Sep	KES 110,000 \| $1,500	Register
11 Oct - 15 Oct	KES 110,000 \| $1,500	Register
08 Nov - 12 Nov	KES 110,000 \| $1,500	Register
06 Dec - 10 Dec	KES 110,000 \| $1,500	Register

Mombasa
11 Jan - 15 Jan	KES 115,000 \| $1,500	Register
08 Feb - 12 Feb	KES 115,000 \| $1,500	Register
08 Mar - 12 Mar	KES 115,000 \| $1,500	Register
12 Apr - 16 Apr	KES 115,000 \| $1,500	Register
10 May - 14 May	KES 115,000 \| $1,500	Register
14 Jun - 18 Jun	KES 115,000 \| $1,500	Register
12 Jul - 16 Jul	KES 115,000 \| $1,500	Register
09 Aug - 13 Aug	KES 115,000 \| $1,500	Register
13 Sep - 17 Sep	KES 115,000 \| $1,500	Register
11 Oct - 15 Oct	KES 115,000 \| $1,500	Register
08 Nov - 12 Nov	KES 115,000 \| $1,500	Register
06 Dec - 10 Dec	KES 115,000 \| $1,500	Register

Nairobi
11 Jan - 15 Jan	KES 99,000 \| $1,500	Register
08 Feb - 12 Feb	KES 99,000 \| $1,500	Register
08 Mar - 12 Mar	KES 99,000 \| $1,500	Register
12 Apr - 16 Apr	KES 99,000 \| $1,500	Register
10 May - 14 May	KES 99,000 \| $1,500	Register
14 Jun - 18 Jun	KES 99,000 \| $1,500	Register
12 Jul - 16 Jul	KES 99,000 \| $1,500	Register
09 Aug - 13 Aug	KES 99,000 \| $1,500	Register
13 Sep - 17 Sep	KES 99,000 \| $1,500	Register
11 Oct - 15 Oct	KES 99,000 \| $1,500	Register
08 Nov - 12 Nov	KES 99,000 \| $1,500	Register
06 Dec - 10 Dec	KES 99,000 \| $1,500	Register

Naivasha
11 Jan - 15 Jan	KES 110,000 \| $1,500	Register
08 Feb - 12 Feb	KES 110,000 \| $1,500	Register
08 Mar - 12 Mar	KES 110,000 \| $1,500	Register
12 Apr - 16 Apr	KES 110,000 \| $1,500	Register
10 May - 14 May	KES 110,000 \| $1,500	Register
14 Jun - 18 Jun	KES 110,000 \| $1,500	Register
12 Jul - 16 Jul	KES 110,000 \| $1,500	Register
09 Aug - 13 Aug	KES 110,000 \| $1,500	Register
13 Sep - 17 Sep	KES 110,000 \| $1,500	Register
11 Oct - 15 Oct	KES 110,000 \| $1,500	Register
08 Nov - 12 Nov	KES 110,000 \| $1,500	Register
06 Dec - 10 Dec	KES 110,000 \| $1,500	Register

Kampala
11 Jan - 15 Jan	$1,800	Register
08 Feb - 12 Feb	$1,800	Register
08 Mar - 12 Mar	$1,800	Register
12 Apr - 16 Apr	$1,800	Register
10 May - 14 May	$1,800	Register
14 Jun - 18 Jun	$1,800	Register
12 Jul - 16 Jul	$1,800	Register
09 Aug - 13 Aug	$1,800	Register
13 Sep - 17 Sep	$1,800	Register
11 Oct - 15 Oct	$1,800	Register
08 Nov - 12 Nov	$1,800	Register
06 Dec - 10 Dec	$1,800	Register

Dubai
11 Jan - 15 Jan	$3,900	Register
08 Feb - 12 Feb	$3,900	Register
08 Mar - 12 Mar	$3,900	Register
12 Apr - 16 Apr	$3,900	Register
10 May - 14 May	$3,900	Register
14 Jun - 18 Jun	$3,900	Register
12 Jul - 16 Jul	$3,900	Register
09 Aug - 13 Aug	$3,900	Register
13 Sep - 17 Sep	$3,900	Register
11 Oct - 15 Oct	$3,900	Register
08 Nov - 12 Nov	$3,900	Register
06 Dec - 10 Dec	$3,900	Register

Date & Mode	Cost

Learning Pathways

Learning Pathways

Learning Pathways

Learning Pathways

Learning Pathways

Learning Pathways

Learning Pathways

Learning Pathways

Learning Pathways

Learning Pathways

Power Query in Data Analysis Training Course

Course Overview

Course Modules

Course Administration

Methodology

Accreditation

Training Venue

Accommodation & Airport Transfer

Tailor-Made

Payment

Related Courses

Course Reviews

Write a Course Review

Share This Course

Course Inquiry

Customize your Dates of Attendance

Stay Updated

Learning Pathways

Learning Pathways

Learning Pathways

Learning Pathways

Learning Pathways

Learning Pathways

Learning Pathways

Learning Pathways

Learning Pathways

Learning Pathways

Most requested

Most requested

Most requested

Most requested

Most requested

Most requested

Most requested

Most requested

Most requested

Most requested

Power Query in Data Analysis Training Course

Course Overview

Course Modules

Course Administration

Methodology

Accreditation

Training Venue

Accommodation & Airport Transfer

Tailor-Made

Payment

Related Courses

Introduction to IBM SPSS Statistics Training Course

Data Analysis and Visualization with Python and SQL Training Course

Advanced Graphics, Tabulations and Statistical Analysis using Stata Training Course

Course Reviews

Write a Course Review

Share This Course

Stay Updated