Data Wrangling and Preparation with Excel

Overview

Part of the ModularMaster in Data Science (Non-Programming Track) programme

In computer science particularly, you may have heard of the phrase “Garbage in, garbage out”; and that’s true for data analysis, 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.

This 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.

Plan your learning path

This course can be taken as a module on its own or as part of the Graduate Certificate in Data Analytics (Non-Programming) stack and participants will earn 12 subject credits which can also be used towards completing the ModularMaster in Data Science.

Course Details

Course Dates:
Coming soon

Who Should Attend

• 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.

Prerequisites

• 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.