Available Dates & Venues
Classroom Schedule
| Date | Venue | Format | Fees | Registration |
|---|---|---|---|---|
| November 2, 2026 - November 21, 2026 | Saudi Arabia - Dammam | Classroom | N/A |
Introduction
In finance, operations, commercial teams and management, professionals regularly work with business datasets, reporting requirements and key performance indicators. Clear methods, accurate information and sound judgement help teams manage complexity, improve communication and avoid preventable errors.
Microsoft Excel Power Query & Power Pivot develops practical capability in data quality, analysis and decision support, connecting core concepts to business datasets, reporting requirements and key performance indicators. Participants examine data preparation, analysis, visualisation and communication through structured examples and guided workplace scenarios. The proposed programme is designed to produce an evidence-based dashboard or analysis deliverable and help professionals make sound, explainable decisions.
This programme is designed for analysts, planners and business reporting professionals. Through structured exercises, guided discussion and a course-specific case, participants connect the subject to workplace needs and identify practical steps for further development.
Objectives
The course aims to build the knowledge, applied judgement and clear communication needed to approach microsoft excel power query & power pivot with confidence.
By the end of the course, participants should be able to:
- Explain the purpose, scope and essential terminology of microsoft excel power query & power pivot.
- Identify key inputs and professional responsibilities relevant to import and transformation workflow.
- Apply suitable tools or references to data model and relationship design.
- Evaluate a supplied workplace case involving dax measures and refresh practices.
- Review the evidence and decisions associated with quality checks and repeatable reporting.
- Document the reasoning behind an appropriate workplace or study recommendation.
- Prepare a focused action or revision plan using feedback from the final workshop.
Training Methodology
Training combines structured explanations with practical opportunities to apply, discuss and review learning.
The course includes:
- Instructor-guided explanations of microsoft excel power query & power pivot: purpose, scope and workplace relevance and the relevant professional context.
- Worked examples and guided exercises addressing import and transformation workflow.
- Sanitised data and reporting exercises.
- Dashboard, query or analytical workflow demonstrations.
- Insight communication and data-quality reviews.
- Case review, group feedback and practical application of quality checks and repeatable reporting.
- Short knowledge checks and a final action or revision plan to support further learning.
Organisational Impact
Organisations can use this programme to strengthen consistent, evidence-based performance reporting and develop the capability of relevant teams.
The training is designed to help organisations:
- Create a shared understanding of Microsoft Excel Power Query & Power Pivot: purpose, scope and workplace relevance among relevant team members.
- Improve the consistency of consistent, evidence-based performance reporting.
- Encourage well-supported decisions about data model and relationship design.
- Strengthen communication, record keeping and review across responsible functions.
- Identify capability gaps linked to quality checks and repeatable reporting for targeted follow-up.
- Use a practical an evidence-based dashboard or analysis deliverable as a starting point for coaching or operational improvement.
Corporate delivery can be discussed around the team’s roles, operational context and agreed learning priorities.
Personal Impact
Participants will gain:
- A clearer understanding of the principal concepts behind microsoft excel power query & power pivot.
- Improved ability to discuss import and transformation workflow with colleagues.
- Guided practice in data model and relationship design.
- Greater confidence in examining data, assumptions, documents or workplace evidence.
- Experience evaluating case decisions linked to quality checks and repeatable reporting.
- Feedback that supports further progress in data interpretation, reporting and analytical storytelling.
- A personal workplace application or revision plan to continue learning.
Who Should Attend?
This course is intended for:
- Business analysts and reporting specialists
- Finance and operations analysts
- Data practitioners and IT professionals
- Department managers and supervisors
- Reporting and BI teams
- Decision makers seeking more useful analytics
Recommended preparation: Basic IT knowledge is useful for technical security topics; no offensive testing is included.
Certificates
Upon successful completion of the programme and its published completion requirements, participants may receive a GenTechSkills Certificate of Completion.
The certificate documents course completion and is not presented as a third-party professional certification unless an approved arrangement is separately stated.
Course materials, digital platform access and any optional assessment arrangements should be confirmed in the quotation.
Curriculum
- 3 Sections
- 21 Lessons
- 10 Weeks
- Day 1: Microsoft Excel Power Query & Power Pivot fundamentals7 Items
- 1.11. Microsoft Excel Power Query & Power Pivot: purpose, scope and workplace relevance.
- 1.22. Identify the current work context, professional roles, expected outputs and applicable constraints.
- 1.33. Review relevant evidence, trade-offs and limitations associated with microsoft excel power query & power pivot: purpose, scope and workplace relevance.
- 1.44. Import and transformation workflow.
- 1.55. Work through a supplied scenario that requires decisions about import and transformation workflow.
- 1.66. Review relevant evidence, trade-offs and limitations associated with import and transformation workflow.
- 1.7Practical workshop: Complete linked exercises: identify a realistic microsoft excel power query & power pivot requirement, role and source of evidence; analyse a supplied scenario and document assumptions, limits and critical details.
- Day 2: Data model and relationship desig and DAX measures and refresh practices7 Items
- 2.11. Data model and relationship design.
- 2.22. Work through a supplied scenario that requires decisions about data model and relationship design.
- 2.33. Review relevant evidence, trade-offs and limitations associated with data model and relationship design.
- 2.44. DAX measures and refresh practices.
- 2.55. Work through a supplied scenario that requires decisions about dax measures and refresh practices.
- 2.66. Review relevant evidence, trade-offs and limitations associated with dax measures and refresh practices.
- 2.7Practical workshop: Complete linked exercises: compare methods or evidence with an approved guidance example or safe case; interpret results, note uncertainties and explain defensible decisions.
- Day 3: Quality checks and repeatable reporting7 Items
- 3.11. Quality checks and repeatable reporting.
- 3.22. Examine the quality and completeness of evidence or records used for quality checks and repeatable reporting.
- 3.33. Review relevant evidence, trade-offs and limitations associated with quality checks and repeatable reporting.
- 3.44. Microsoft Excel Power Query & Power Pivot: case assessment, review and next steps.
- 3.55. Integrate course evidence, review a realistic microsoft excel power query & power pivot: case assessment, review and next steps and explain the recommendations.
- 3.66. Review relevant evidence, trade-offs and limitations associated with microsoft excel power query & power pivot: case assessment, review and next steps.
- 3.7Practical workshop: Complete linked exercises: develop a concise improvement, study or quality assurance recommendation; present a case response and convert feedback into an action plan.






