Learn Data Analytics with Power Query & Power Pivot Training Course in Singapore
In this Power Query Course, you’ll learn how to import data from multiple files and sources, combine and transform datasets, merge queries, and unlock a wide range of powerful data preparation techniques.
UTAP
NTUC membersSkillsFuture Eligible
Course Start Date
Schedule
- Days: 2 Days
- Duration: 14 Hours
- Timings: 9:30 AM - 5:30 PM
- 10 Anson Road, 26-08A International Plaza, Singapore 079903
Why Choose Us
- Expert Local Trainers
- Hands-on Training by experts
- Certificate of Achievement
SSG Course Details
- TGS-2023018267
- Mode of Training - Physical, in-class training
- Course Subsidy Validity - Until 31-12-2024
- Register Now
Who should take up the Power Query & Power Pivot training?
This course is designed for experienced Excel users who want to enhance their data analysis skills by leveraging the advanced features of Power Query and Power Pivot.
Business professionals
Analyst
Entrepreneur
Training Professionals
Student
Course Completion Requirements
Minimum 75% attendance is required in order to complete the course and receive the course completion certificate
Above 16 years old
High School Level English
Basic internet & computer operation skills
Data Analytics with Power Query & Power Pivot Training Course
We are now living in a time of big data, where information is being collected from more and more granular transactions resulting in a great deal of data that can be difficult to manage without the proper tools and skills.
Excel’s Power Query and Power Pivot functionality are strong solutions that allow you to organize, transform and analyze data in large datasets with ease. However, a tool is only useful as the person using it. This is why it is so important to get a complete understanding of Power Query and Power Pivot in order to take full advantage of these tools and thus elevate your level of professional data analysis.
What will you learn in the Data Analytics Course using Power Query & PowerPivot?
By the end of this course, you will be able to confidently use Power Query and Power Pivot in Excel 2016 to analyze data from multiple sources.
You will be able to:
- Get started with the Power Query and Power Pivot tools
- Visualize and interpret data effectively
- Apply advanced features to perform deeper data analysis
Who should take up the Power Query & Power Pivot training?
This course is designed for proficient Excel users who want to take their data analysis skills to the next level by learning how to use Power Query and Power Pivot effectively.
Prerequisites:
To succeed in this course, you should have prior experience using Excel 2016 and be familiar with PivotTables. A solid understanding of spreadsheet concepts and confidence in creating and analyzing basic PivotTables are recommended.
Unsure if this course is suitable for you? Take this Quick test to help you decide.
Grants available
UTAP
Union Training Assistance Programme
UTAP: Update info about UTAP funding on all pages.
SkillsFuture Eligible
SkillsFuture Credit : Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees
Data Analytics with Power Query & Power Pivot Training Course Outline
Lesson 1: Analyzing Data with Self-Service BI
Topic A: Data Analysis and Visualization for Business Intelligence
Topic B: Self-Service BI with Microsoft Power BI
Lesson 2: Connecting to Data
Topic A: Create Data Connections
Topic B: Model Data with Relationships
Topic C: Save Power BI Files
Lesson 3: Performing Advanced Data Modeling and Shaping
Topic A: Clean and Transform Data with the Query Editor
Topic B: Shape Data with the Query Editor
Topic C: Combine and Manage Data Rows
Lesson 4: Visualizing Data with Power BI
Topic A: Create Visualizations in Power BI
Topic B: Chart Data in Power BI
Lesson 5: Enhancing Data Analysis
Topic A: Enhance Analysis with Customized Visuals and Pages
Topic B: Enhance Analysis with Tooltips
Lesson 6: Modeling Data with Calculations
Topic A: Create Calculations with Data Analysis Expressions (DAX)
Topic B: Create Calculated Measures and Conditional Columns
Lesson 7: Creating Interactive Visualizations
Topic A: Create and Manage Data Hierarchies
Topic B: Filter and Slice Reports
Topic C: Create Dashboards in Power BI
FAQ’s For Data Analytics with Power Query & Power Pivot Training
What does this course cover?
It teaches practical skills to import, transform, and consolidate data from multiple sources using Power Query, and to build relational data models and perform advanced analysis using Power Pivot
Who is this course for?
Designed for experienced Excel users who are comfortable with PivotTables and basic spreadsheet functions, and who want to enhance their analytical capabilities using Power Query and Power Pivot
What are the course prerequisites?
You should have intermediate Excel 2013 or later skills, a good understanding of PivotTables and spreadsheet concepts, and access to Excel with Power Query and Power Pivot enabled.
What are the Course Completion requirements?
Minimum 75% attendance is required in order to complete the course and receive the course completion certificate.
Do I need programming knowledge to attend this course?
No programming knowledge is required. The course focuses on user-friendly, drag-and-drop tools in Power Query and Power Pivot within Excel, making it accessible even for non-technical users.