Introduction to Data Cleansing, Shaping and Synthesis
About This Course
By the end of the course, participants will be able to:
• Describe the different data quality and preparation scenarios that necessitate data cleansing and transformation.
• Perform retrieval of data from multiple sources, e.g. .csc, .xlxs
• Apply appropriate data cleansing and transformation practices to address data quality issues using Tableau Prep Builder
• Derive new data from existing data through segmentation, combination and aggregation
• Explain the limitations of data cleansing and transformation software
• Include additional data from external resources accessible through APIs, e.g. currency exchange rates
• Store cleansed and transformed data in different formats, e.g. .csv & Tableau packages
What You'll Learn
Participants are trained to retrieve data from multiple sources, recognise common data quality issues, correct data quality issues, derive new data from existing data, perform aggregation of data, supplement data with additional external sources and to store cleansed and transformed data in different formats.
Entry Requirements
Basic computer literacy. Some working knowledge of Excel is beneficial but not critical.