Program Overview

Data Wrangling and Preparation with Excel

About the Course

The Data Wrangling and Preparation with Excel course is designed to introduce the general concepts of Data Science with a focus on Data Wrangling for participants with non-programming backgrounds. By the end of this course, participants will be able to wrangle data and prepare the dataset ready for Machine Learning Model.

Course Objectives

• Perform the data preparation component for the role of a junior data scientist or a data engineer or a business analyst role
• Understand the types of data and databases in the business context
• Appreciate the use of data dictionary and harness the potential of metadata for data science
• Acquire organizational dataset from data lakes and other democratized data sources for data enrichment purposes
• Structure data into an appropriate form for data analysis
• Manipulate data structures to support data-wrangling phase
• Perform data wrangling on the acquired dataset
• Address data quality issues with appropriate data cleansing technique
• Iterate the data mining process progressively with the provision of data wrangling and exploratory analysis tools

Course Description

In computer science, the phrase "Garbage in, garbage out" is particularly relevant for data analysis, where the importance of having quality and the right data format is critical to any data science project. Data wrangling is the function of transforming raw data into data that is usable down the data science process.

Target Audiences

• Participants in roles which require hands-on preparation of data but without specific knowledge or experience in coding
• Aspiring data/business analysts or data scientists looking to acquire skills in the data preparation and wrangling components
• Ideal for participants who are in or looking to acquire skills for roles such as entry-level Data Engineers/Data Analysts

Course Structure

The course is structured over five days, covering topics such as:

Day 1

• Overview of Data Science Pipeline
• What is Data Wrangling and Data Preparation?
• Data acquisition
• Understand how data scientist prepares the dataset for data modelling
• What is data discovery?
• Types of Data
• Types of Databases
• What is a Data Dictionary and Metadata
• Data Models

Day 2

• Data Preparation Phase
• Pivoting Large Dataset
• Power Pivot
• Structural Dataset Querying with Excel Lookup and Reference Functions
• Structural Dataset Filters

Day 3

• Power Query
• Exploratory Data Analysis with Charts
• Power BI

Day 4

• Dataset Cleaning with Conditional Formatting
• Dataset Control Structure with Control Functions
• Data Quality Control with Logical, Booleans and Information Functions
• Dataset Aggregation with Excel Power Functions
• Handling Unstructured Data

Day 5

• Project Presentation

Assessment

Participants will be assessed via group-based project presentation on the 5th session of the course. There will also be formative assessment and case studies to assess a participant's understanding and competency.

Entry Requirements

• Participants should preferably have passed mathematics at least 'O' Level or equivalent.
• Participants should be conversant with basic IT skills such as software installation, file management, and web navigation.
• Participants should have basic familiarity with Microsoft Excel: using built-in functions to perform some calculations.
• Participants are encouraged to complete the Foundation of Data Science before enrolling in this course.
• Participants are required to bring their laptops.

Financial Matters

Course Fees

The full course fee is S$4,905.00, which includes GST and excludes supplementary fees.

• Course fee: S$4,500.00
• GST (9%): S$405.00
• Course fee payable: S$4,905.00

Enhanced Training Support for SMEs

S$571.50

• Course fee: S$4,500.00
• Baseline SkillsFuture Funding – Grant: S$(3,150.00)
• Nett course fee: S$1,350.00
• GST (9%): S$121.50
• Enhanced Training Support for SMEs – Subsidy: S$(900.00)
• Course fee payable: S$571.50

Singapore Citizens aged 40 and above

S$571.50

• Course fee: S$4,500.00
• Baseline SkillsFuture Funding – Grant: S$(3,150.00)
• Nett course fee: S$1,350.00
• GST (9%): S$121.50
• Mid-Career Enhanced Subsidy: S$(900.00)
• Course fee payable: S$571.50

Singapore Citizens 39 years old or younger

S$1,471.50

• Course fee: S$4,500.00
• Baseline SkillsFuture Funding – Grant: S$(3,150.00)
• Nett course fee: S$1,350.00
• GST (9%): S$121.50
• Course fee payable: S$1,471.50

Singapore Permanent Residents (SPR)

S$1,471.50

• Course fee: S$4,500.00
• Baseline SkillsFuture Funding – Grant: S$(3,150.00)
• Nett course fee: S$1,350.00
• GST (9%): S$121.50
• Course fee payable: S$1,471.50

Subject Credits

Upon completion and satisfying the requirements of passing this course, learners will be awarded 12 subject credits.