2 days - Data Analytics using Excel 365, 2021 - level 3
Training Provider: GENETIC COMPUTER SCHOOL PTE LTD
Course Reference: TGS-2023019361
S$260
Original: S$520
Save S$260
About This Course
This course is designed to empower the learner to use Excel as a statistical and analytical tools, to clean data and organize the data to get data-driven insights and helps stakeholders to make informed decisions.
What You'll Learn
Learning Outcomes:
LO1: Able to understand and apply useful statistical functions to compute, gather, review, analyzed data.
LO2. Able to use formulas and Excel data analysis to get statistical data from dataset.
LO3: Able to use tools and techniques to easily recognize trends and patterns in dataset.
LO4: Able to gather summary output report to stakeholders for further analysis.
Topics Covered:
• Level of Data
• What is Data Analysis?
• Clean the dataset using Power Query
• Power Query Editor, Best Practices in Applied Steps
• Column Profiling, Data Quality and Distribution
• Errors handling, Data Layout, Bring in Folder data to Power Query
• Unpivot and Pivot – (4 types)
• Group By, Ranking, Conditional Column (if condition)
• Append Queries and Merge Different Tables Queries ( get latest price list )
• Join Kinds, Date and Time transformation, Output to Pivot Table, Pivot Chart
• Data Model, DAX Measures, Power Pivot
• Create graphs - Histogram, Forecasting with Moving Average, Correlation, Linear regression, Boxplot
LO1: Able to understand and apply useful statistical functions to compute, gather, review, analyzed data.
LO2. Able to use formulas and Excel data analysis to get statistical data from dataset.
LO3: Able to use tools and techniques to easily recognize trends and patterns in dataset.
LO4: Able to gather summary output report to stakeholders for further analysis.
Topics Covered:
• Level of Data
• What is Data Analysis?
• Clean the dataset using Power Query
• Power Query Editor, Best Practices in Applied Steps
• Column Profiling, Data Quality and Distribution
• Errors handling, Data Layout, Bring in Folder data to Power Query
• Unpivot and Pivot – (4 types)
• Group By, Ranking, Conditional Column (if condition)
• Append Queries and Merge Different Tables Queries ( get latest price list )
• Join Kinds, Date and Time transformation, Output to Pivot Table, Pivot Chart
• Data Model, DAX Measures, Power Pivot
• Create graphs - Histogram, Forecasting with Moving Average, Correlation, Linear regression, Boxplot
Entry Requirements
• Minimum 1 year of working experience (know how to use Excel pivot tables, basic excel graphs)
• Speak, listen and read English at a proficiency level not lower than the WPL Level 4, and manipulate numbers at a not lower than the WPN Level 4.
• Minimal education qualification is GCE ‘O’ Level, GCE ‘N’ Level or ITE certificate.
Course Details
Back to All Courses
Note: To apply for this course, visit the SkillsFuture website or contact the training provider directly.
More Courses from GENETIC COMPUTER SCHOOL PTE LTD
This module enables candidates to understand the concepts and skills relating to the fundamentals of...
Presentation Essentials is designed to equip learners with the essential skills for effective presen...
This course "3 days – Office 365 – Advanced Excel 2021 and Data Analytics – level 2" is desig...