Course Objectives

Able to use Excel to do correlation, regression analysis on variables, for prediction. Using moving average and forecast functions to project forecast.

Course Duration

16 Hours

Mode of Training

Classroom

Target Audience

Design for learner to use Excel to do correlation, regression analysis on variables, for prediction. Using moving average and forecast functions to project forecast.

Certification

Successful trainees will receive a Statement of Attainment (SOA) issued by SSG

At the end of the course participants will be able to:

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

·        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