Course Level:
| Course Title | Training Course in Data Analysis Using Power Query |
| Organization | Tech For Development (T4D) |
| Venue | Tech For Development (T4D) Training Center along Tala Road, Runda, Nairobi |
| Duration | 5 days |
| Target Industries |
|
| Target Job Roles |
|
| Course Fees (face-to-face training) |
USD 1100/KES 75,000 (Exclusive of VAT) |
| Course Fees (virtual training) | USD 500/KES 55,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 | Upon successful completion of the training, participants will receive a Tech For Development Certificate of Course Completion |
Course Summary
Power Query is a data-preparation and data-transformation engine embedded in Microsoft Excel and Power BI software.
The main purpose of Power Query is Extract, Transform, and Load (ETL), enabling you to automate repeated data-preparation tasks so you don’t waste time doing manual cleaning or shaping of data each time.
This training course equips participants with practical skills to automate and streamline data cleaning and transformation before its in-depth analysis or reporting.
You will master Power Query's interface, functionalities, and advanced features for tasks such as data cleaning, merging, and custom column creation with ease.
What are the Key Skills From this Course?
- Importing data from various sources (Excel, databases, etc.)
- Data cleaning and preparation
- Data transformation and reshaping
- Combining and integrating data from multiple sources
- Resolving duplicates or conflicts, consolidating datasets for unified analysis
- Automating data workflows
Duration
5 days
Who Should Attend This Course?
- Business professionals
- Market research specialists
- M&E professionals
- Data Analysts
- Business Analysts
- Data Scientists
- Financial Analysts
Course Objectives
By the end of this training course, participants will be able to:
- Understand the basics of Power Query and its interface
- Master 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 Requirements
- Proficiency in English
- Basic computer literacy
- Familiarity with Excel (entering data, basic formulas)
- Access to a laptop with MS Excel and Power BI installed
Training Approaches
- Interactive lectures
- Live demonstrations
- Hands-on exercises
- Group discussions
- Real-world case studies
- Knowledge checks and quizzes
- Collaborative group work
Course Outline
Module I: Introduction to Power Query
- Overview of Power Query interface and features
- Understanding data import options
- Basic data cleaning techniques
- Hands-on Exercise: Importing and cleaning a dataset from Excel
Module II: Data Transformation Techniques
- Applying filters and sorting data
- Using functions for data manipulation
- Creating custom columns and calculations
- Hands-on Exercise: Transforming sales data for quarterly reports
Module III: Data Integration and Combining Sources
- Merging and appending queries
- Combining data from different sources (Excel, SQL, etc.)
- Resolving data conflicts and duplicates
- Hands-on Exercise: Integrating data from multiple departments for a unified view
Module IV: 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
- Hands-on Exercise: Automating a weekly data update process for a business dashboard
Module V: Advanced Power Query Techniques
- Advanced data transformation functions
- Handling complex data scenarios
- Optimizing Power Query performance
- Hands-on Exercise: Handling and transforming large datasets for detailed analysis
Related Courses
Course Administration Details:
Methodology
This instructor-led training course is delivered using a blended learning approach and comprises presentations, guided sessions of practical exercise, web-based tutorials, and group work. Our facilitators are seasoned industry experts with years of experience, working as professionals and trainers in these fields. All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.
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 and Airport Transfer
Accommodation and airport pickup are arranged upon request. For reservations contact the Training Officer.
- Email: letstalk@techfordevelopment.com
- 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 Training Centre or at a convenient location. For further inquiries, please contact us on:
- Email: letstalk@techfordevelopment.com
- Phone: (+254) 790 824 179
Payment
Payment should be transferred to our bank account on or before the start of the course. Send proof of payment to letstalk@techfordevelopment.com
Click here to register for this course.
Register NowCustomized Schedule is available for all courses irrespective of dates on the Calendar. Please get in touch with us for details.
Want more details about our courses? Get in touch with us.
