• Home
  • Excel Power Query and Power Pivot Masterclass

Data Analytics Using Power Query and Power Pivot

Course Information

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

Venue

Course Brochure

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.

Excel Power Query and Power Pivot Masterclass

Course Code: C1097

9 Review(s) | Add Your Review

Share

What's This Course About

Excel Power Query and Power Pivot Masterclass equips you with the skills to clean, combine, model and analyse large volumes of data in Microsoft Excel using Power Query and Power Pivot. These powerful built-in tools let you automate data preparation that once took a great deal of manual work, build data models across multiple tables and create insightful reports that refresh with a single click. The masterclass is designed for analysts, finance and operations staff, and experienced Excel users who want to take their data skills further.

You will start by reviewing data with Power Query, connecting to Excel files, CSV files, folders and databases, and using the Power Query editor to clean data, remove errors and duplicates, change data types, split and merge columns, and unpivot and reshape tables. Next you will move on to data analysis with Power Query and Power Pivot, appending and merging queries, loading data into the data model, creating relationships between tables and building PivotTables and PivotCharts from the model.

The final topic covers advanced data analysis using Power Query and Power Pivot, including custom columns, parameters and query folding, writing DAX measures and calculated columns, time intelligence calculations and key performance indicators. Every topic is hands-on with realistic business datasets, so you build reusable, automated reports. By the end of the masterclass, you will be able to prepare and analyse complex data efficiently in Excel and deliver reliable, refreshable insights.

Why Take This Course?

  • Hands-On Learning Learn by doing. Every topic is practised hands-on, so you leave with skills you can use at work straight away.
  • Live Coaching Experienced instructors coach you live, answer your questions and guide you step by step.
  • Free Post-Course Consultation Stuck after class? Message your trainer any time for guidance as you apply what you have learned.
  • Always-Updated Materials Materials are refreshed to stay relevant. Log in to our LMS any time to get the latest version.

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

Topic 2: Data Analysis with Power Query and Power Pivot

Topic 3: Advanced Data Analysis using Power Query

Course Info

Prerequisite

Basic computer and file-management skills are expected. Familiarity with basic Excel worksheets, formulas and tables will help you follow the exercises.

Software Requirement

Install and test the listed software before class. Confirm the required version and account or licence access in your joining instructions. Cloud and AI services may charge subscription or usage fees.

Hardware Requirement

Bring a supported Windows laptop for full Power Pivot functionality, a power adaptor and reliable internet access. Confirm alternatives with the trainer before using a Mac.

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)

Would attend again 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
Excellent delivery and good balance between theory and practice. Learned a lot in a short time. (Posted on 2/2/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
Good hands-on training with plenty of examples. I feel much more confident applying these skills now. (Posted on 11/8/2024)
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 trainer was knowledgeable and explained the concepts clearly with real-world examples. (Posted on 7/1/2024)
Superb training 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 3/23/2024)

Items 6 to 9 of 9 total

per page
Page:
  1. 1
  2. 2

Write Your Own Review

You're reviewing: Excel Power Query and Power Pivot Masterclass

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