• Home
  • Data Analytics Using Power Query and Power Pivot

Data Analytics Using Power Query and Power Pivot

Course Information

  • Sessions 2 days
  • Duration 15 hrs
  • Level Beginner
  • Assessment NA

Venue

Download Course Brochure

Certification

  • Certificate of Completion from Tertiary Courses - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Courses.

Data Analytics Using Power Query and Power Pivot

Course Code: C1097

9 Review(s) | Add Your Review

What's This Course About

Empower your analytical skills with our comprehensive course on Data Analytics using Power Query and Power Pivot. This course is meticulously designed to equip you with the prowess of Power Query for data extraction and Power Pivot for data modelling. Learn to transform raw data into meaningful insights, streamline your decision-making process, and add value to your organization. With hands-on exercises and expert guidance, you'll master the art of data analysis in no time.

Our course is an ideal match for both beginners aiming to kickstart their journey in data analytics, and professionals keen on refining their analytical skills further. Covering a broad spectrum from basic data extraction to complex data modelling and visualization techniques, this course promises a deep-dive into the world of data analytics.

WSQ Funding

Full Fee ₵3,000.00 Before GST
GST ₵270.00 9% of fee
Baseline Nett ₵1,770.00 SG/PR age 21+ · 50% funded
MCES / SME Nett ₵1,170.00 SG age 40+ · 70% funded

Course Fee

₵3,000.00

Course Date

Course Time

Additional Note

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to info@tertiarycourses.com.gh and we will forward your queries to the subject matter experts and get back to you as soon as possible.

Cancellation & Reschedule Policy

  • We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
  • Note: the venue of the training is subject to changes due to class size and availability of the classroom. The minimum class size to start a class is 3 Pax.

Course Details

Course Details

What You'll Learn

Topic 1. Review Data with Power Query

  • Data types explained
  • Query data from a table or range
  • Query data from another Excel file
  • Load data only as a connection
  • Fill up and fill down
  • Split column by delimiter
  • Split into rows
  • Add conditional and custom columns
  • Add column by example
  • Merge columns
  • Sort and filter data in Power Query

Topic 2. Data Analysis with Power Query and Power Pivot

  • Use IF formulas
  • Nest IF and AND
  • AddDays to determine the deadline
  • Pivot data in Power Query
  • Pivot and append data
  • Pivot and don't aggregate
  • Unpivot data in Power Query
  • Unpivot warnings
  • Group By feature
  • Appending Queries

Topic 3. Advanced Data Analysis using Power Query

  • Overview of joins in Power Query
  • Walk through all six joins
  • Joins: Left or right
  • Outer join versus XLOOKUP
  • Merge with multiple fields
  • Approximate match equivalent of VLOOKUP: Binning
  • Approximate match equivalent of VLOOKUP: Conditional column
  • Cross Join
  • Drill down to create a variable in Power Query
  • Fuzzy matching by percentage
  • Merging inconsistent data with a transformation table

Course Info

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

Minimum Entry Requirement

Knowledge and Skills

  • Able to operate using computer functions
  • Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

  • Positive Learning Attitude
  • Enthusiastic Learner

Experience

  • Minimum of 1 year of working experience.

Target Age Group: 18-65 years old

Minimum Software/Hardware Requirement

Software:

Hardware: Window or Mac Laptops

Job Roles

Job Roles

  • Data Analyst
  • Business Analyst
  • Financial Analyst
  • Marketing Analyst
  • Operations Analyst
  • Business Intelligence Developer
  • Report Developer
  • Data Consultant
  • Data Manager
  • Risk Analyst
  • Compliance Analyst
  • Database Administrator
  • Systems Analyst
  • Performance Analyst
  • Strategy Analyst
  • Supply Chain Analyst
  • Product Analyst
  • Project Manager
  • Research Analyst
  • HR Analyst

Trainers

Trainers

is an accomplished IT and data specialist with over 20 years of experience in academia, ICT leadership, and professional training, with a strong focus on data analytics and Excel-based solutions. He has developed and delivered specialized training programs on Statistical Data Analysis with Excel and Visual Basic for Applications (VBA) for Excel, equipping learners with advanced data manipulation, automation, and reporting skills. His expertise extends to automating institutional reporting systems, where he successfully streamlined academic records management through Excel-based tools, integrating macros and automation to improve efficiency and accuracy. As a trainer and consultant, Dr. Siraj has taught Excel to diverse audiences, including university staff, administrative teams, and professionals in banking, security, and education, ensuring they can apply Excel for decision-making, statistical modeling, and process automation. His practical mastery of Excel is complemented by his deep knowledge of office automation and ICT project management, making him a highly sought-after trainer in data analysis and productivity tools. With his blend of hands-on technical expertise and instructional experience, Dr. Siraj stands out as a credible authority in leveraging Excel to drive organizational efficiency and data-driven strategies

Review

Customer Reviews (9)

Very useful course Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
The trainer was knowledgeable and explained the concepts clearly with real-world examples. (Posted on 6/3/2026)
Good course materials Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
The course materials were detailed and easy to reference afterwards. Great value for money. (Posted on 5/3/2026)
Very useful course Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
A very practical course. The trainer made a complex topic simple and enjoyable to learn. (Posted on 2/9/2026)
Very informative Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
The course content was comprehensive and up to date. The practical exercises were the best part. (Posted on 9/13/2025)
Learned a lot Review by Course Participant/Trainee
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Very informative and interactive. The small class size meant we got a lot of personal attention. (Posted on 7/14/2025)

Items 1 to 5 of 9 total

per page
Page:
  1. 1
  2. 2

Write Your Own Review

You're reviewing: Data Analytics Using Power Query and Power Pivot

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment