Data Cleaning for Everyone
Training Provider: Republic Polytechnic
Course Reference: TGS-2021009827
S$99
Original: S$330
Save S$231
About This Course
At the end of the course, participants will be able to:
• Understand the importance of Data Cleaning and the consequences of inaccurate data
• List some tools available for data cleaning
• Apply techniques such as conditional formatting, matching, text functions, find and replace, handling duplicates in Excel to manipulate data, identify potential data defects and clear unwanted data
• Apply techniques such as regular expressions to match and extract data
• Clean a dataset based on real world data
• Apply good practices when collecting data and list some of the tools available for good data collection
What You'll Learn
“Data Cleaning for Everyone” is a 1-day hands-on course designed to expose participants to real world data cleaning use cases and empower them with basic-to-advanced Data Cleaning skills.
Upon the completion of the course, participants will be able to clean and prepare data using tools such as Excel and Robotic Process Automation, thereby ensuring the accuracy and reliability of the analysis and visualization downstream.
Upon the completion of the course, participants will be able to clean and prepare data using tools such as Excel and Robotic Process Automation, thereby ensuring the accuracy and reliability of the analysis and visualization downstream.
Entry Requirements
Participants should have basic IT literacy and be proficient in Microsoft Excel.
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 Republic Polytechnic
3D (three-dimensional) Modelling and Animation introduces students to the fundamentals of 3D modelli...
The application of Computer Vision in object identification and classification is well-established s...
The course equips learners on the skills of qualitative market research such as facilitating focus g...