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

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.