Training Course in Data Analysis Using Power Query
This training course equips participants with practical skills to automate and streamline data cleaning and transformation before its in-depth analysis or reporting.
Course Overview
| 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) | USD 1100/KES 75,000 (Exclusive of VAT) |
| Course Fees (Virtual) | USD 500/KES 55,000 (Exclusive of VAT) |
| Training Modes | Virtual and face-to-face training |
| Payment | Upon successful completion of the training, participants will receive a Tech For Development Certificate of Course Completion |
| Accreditation | Tech For Development Certificate of Course Completion |
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 Modules
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
Course Administration
This instructor-led training course is delivered using a blended learning approach comprising presentations, guided practical sessions, web-based tutorials, and group work.
Accreditation
Participants will receive a Tech For Development Certificate of Course Completion.
Training Venue
Held at the Tech For Development Training Centre.
Accommodation & Airport Transfer
Arranged upon request.
Email: letstalk@techfordevelopment.com
Phone: (+254) 790 824 179
Tailor-Made
Customised training available.
Payment
Send proof of payment to letstalk@techfordevelopment.com.
