Data Cleaning Training Course
Data Cleaning, or Data Cleansing, involves the identification and rectification of errors and inconsistencies in a dataset prior to analysis.
This instructor-led, live training (available online or onsite) is designed for data scientists, data analysts, and business analysts who want to clean and process data efficiently.
Upon completion of this training, participants will be able to:
- Create an effective data cleaning strategy.
- Apply useful tools for data cleaning.
- Achieve results more efficiently.
- Learn and implement data cleaning best practices.
Format of the Course
- Interactive lectures and discussions.
- Extensive exercises and practice sessions.
- Hands-on implementation in a live lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Course Outline
Introduction
Overview of Data Cleaning
- Why is Data Cleaning Important?
Case Study: When Big Data Is Dirty
Developing A Thorough Data Cleaning Strategy
Common Data Cleaning Tools
- Drake
- OpenRefine
- Pandas (for Python)
- Dplyr (for R)
Achieving High Data Integrity
- Complete
- Correct
- Accurate
- Relevant
- Consistent
Automating the Data Cleaning Process
Monitoring Your Data Cleaning System
Summary and Conclusion
Requirements
- An understanding of data analytics concepts.
Audience
- Data Scientists
- Data Analysts
- Business Analysts
Need help picking the right course?
southafrica@nobleprog.co.za or +27 (0)10 005 5793
Data Cleaning Training Course - Enquiry
Testimonials (2)
Using Road Safety data when doing praticals
Maphahamiso Ralienyane - Road Safety Department
Course - Data Cleaning
It was insightful and I gained a lot of data analysis skills
Mamonyane Taoana - Road Safety Department
Course - Data Cleaning
Upcoming Courses
Related Courses
Advanced Alerting and Automation with Grafana and Prometheus
14 HoursThis instructor-led live training, delivered in South Africa (either online or onsite), targets advanced-level DevOps and SRE professionals seeking to strengthen their alerting and automation expertise with Grafana and Prometheus.
By the conclusion of this training, participants will be able to:
- Create and manage advanced alerting rules in Prometheus.
- Integrate Prometheus Alertmanager with external tools using webhooks.
- Automate responses to alerts for faster issue resolution.
- Use Grafana to visualize and manage alerts effectively.
ArcGIS for Spatial Analysis
14 HoursThis instructor-led, live training in South Africa (online or onsite) is aimed at field ecologists and conservation managers who wish to create data spatial projects in ArcGIS.
By the end of this training, participants will be able to:
- Output spatial data as visualizations.
- Conduct geostatics on actual data.
- Implement spatial data analysis, data processing, and mapping with ArcGIS.
- Analyze spatial data for projects in ArcGIS.
ArcGIS from Basic to Advanced
35 HoursThis instructor-led, live training in South Africa (online or onsite) is aimed at beginner-level to advanced-level GIS professionals and analysts who wish to learn how to effectively use ArcGIS for data visualization, spatial analysis, and geospatial project management.
By the end of this training, participants will be able to:
- Navigate and utilize ArcGIS tools for geospatial data management.
- Create and customize maps with layers and attributes.
- Perform advanced spatial analysis and geoprocessing tasks.
- Automate workflows using ModelBuilder and Python.
ArcGIS Enterprise for Technical Support
14 HoursThis instructor-led, live training in South Africa (online or onsite) is aimed at beginner-level IT support personnel who wish to provide robust support for ArcGIS Enterprise, addressing any anomalies or failures effectively.
By the end of this training, participants will be able to:
- Understand the architecture and components of ArcGIS Enterprise.
- Learn to install, configure, and manage ArcGIS Enterprise.
- Gain skills in troubleshooting and resolving common issues.
- Develop proficiency in monitoring and maintaining ArcGIS Enterprise environments.
- Master the techniques for backup, recovery, and performance optimisation.
ArcGIS Fundamentals
14 HoursThis instructor-led, live training in South Africa (online or onsite) is designed for beginner-level professionals seeking to learn the fundamental concepts and tools of ArcGIS.
Upon completion of this training, participants will be able to:
- Grasp the core concepts of GIS and spatial data.
- Navigate the ArcGIS interface with confidence.
- Create and manage spatial data effectively.
- Conduct basic spatial analysis.
- Produce maps and visualizations.
ArcGIS Professional Plus: Advanced GIS Data Management and Analysis
14 HoursArcGIS Professional Plus represents an advanced tier of ArcGIS Pro, providing extended capabilities for geospatial data analysis, 3D modelling, automation, and enterprise collaboration.
This instructor-led live training, available both online and on-site, targets intermediate GIS professionals seeking to deepen their expertise in spatial data analysis, automation, and distribution using ArcGIS Professional Plus tools.
Upon completion of this training, participants will be equipped to:
- Utilise ArcGIS Pro Plus tools for data visualisation and analysis.
- Develop 2D and 3D maps employing advanced symbology and geoprocessing techniques.
- Automate workflows through ModelBuilder and Python scripting.
- Integrate ArcGIS with external data services and enterprise systems.
Course Format
- Interactive lectures and discussions.
- Extensive exercises and practice sessions.
- Practical implementation in a live-lab environment.
Course Customisation Options
- To request customised training for this course, please contact us to make arrangements.
Advanced ArcGIS Pro for Spatial Analysis
35 HoursThis instructor-led, live training in South Africa (online or onsite) is aimed at advanced-level GIS professionals who wish to use ArcGIS Pro to enhance their spatial analysis capabilities, conduct comprehensive geostatistical analysis, and apply advanced 3D modeling techniques for more effective decision-making and problem-solving in real-world scenarios.
By the end of this training, participants will be able to:
- Develop advanced skills in spatial analysis techniques using ArcGIS Pro.
- Utilize Python scripting for automation and complex data processing.
- Apply spatial modeling for problem-solving in real-world scenarios.
- Conduct geostatistical analysis for advanced data interpretation.
- Integrate external data sources and leverage 3D spatial data analysis.
Advanced Power Systems and GIS Integrated Solutions
70 HoursIn the rapidly changing energy landscape, combining electrical transient analysis with accurate geographic data has become a strategic imperative. Currently, depending on disjointed data creates substantial operational risks. This 14-day intensive programme in Melbourne aims to bridge the gap between electrical engineering and geospatial management.
Advanced Geographic Information Systems (GIS)
21 HoursThis instructor-led, live training in South Africa (online or onsite) is designed for intermediate-level geographers looking to expand their expertise in spatial analysis, data management, and GIS applications.
By the end of this training, participants will be able to:
- Apply advanced spatial analysis techniques to resolve complex geographical challenges.
- Manage large spatial databases and perform data quality control.
- Create dynamic and interactive maps and visualizations for a variety of applications.
- Utilise programming and automation to streamline GIS workflows.
Insurance in the Digital Era
14 HoursInsurance in the Digital Era provides a practical overview of how digital transformation is reshaping products, operations, and customer engagement within the insurance industry.
This instructor-led live training (available online or onsite) is designed for intermediate-level insurance professionals who wish to understand and apply digital technologies, data-driven strategies, and innovation frameworks to modernise insurance offerings and operations.
By the end of this training, participants will be able to:
- Explain the role of AI, Big Data, IoT, and automation in modern insurance workflows.
- Identify InsurTech trends and how they affect the insurance ecosystem.
- Design customer-centric strategies enabled by digital tools and data insights.
- Apply data-driven approaches to risk management and decision making.
- Develop an innovation and change management approach suitable for insurers.
- Assess real-world case studies and translate lessons into local initiatives.
Format of the Course
- Interactive lecture and discussion.
- Case study analysis and group workshops.
- Practical exercises and action planning for participants’ organisations.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
IREB CPRE – Foundation Level (Extended): Practical Requirements Engineering and Certification Preparation
14 HoursRequirements Engineering (RE) stands as a critical discipline within software and systems development, centred on identifying, documenting, and managing the needs and constraints of stakeholders to guarantee project success.
This instructor-led, live training (available online or onsite) targets intermediate-level professionals keen to deepen their grasp of practical Requirements Engineering while preparing for the IREB CPRE – Foundation Level certification exam.
Upon completion of this training, participants will be able to:
- Understand and apply the key concepts and terminology defined by the IREB CPRE Foundation syllabus.
- Identify and elicit requirements using effective and context-appropriate techniques.
- Model, document, and validate requirements for real-world projects.
- Manage requirements changes, traceability, and prioritization throughout the project lifecycle.
- Use Requirements Engineering tools and best practices to enhance communication and project outcomes.
- Be fully prepared to take and pass the IREB CPRE – Foundation Level certification exam.
Format of the Course
- Interactive lecture and discussion.
- Case-based exercises and collaborative workshops.
- Exam preparation sessions and practice questions.
Course Customization Options
- Additional modules or industry-specific case studies can be added on request.
Python for ArcGIS and QGIS for Earth Sciences and Engineering Professionals
35 HoursThis instructor-led, live training in South Africa (online or onsite) is designed for beginner-level earth sciences and engineering professionals looking to apply Python for geospatial analysis across both ArcGIS and QGIS environments.
Upon completion of this training, participants will be equipped to:
- Master Python syntax and control structures to execute geospatial tasks efficiently.
- Apply Pandas, Numpy, and Matplotlib for data analysis and visualisation within GIS contexts.
- Manipulate and analyse vector data using the Geopandas, Arcpy, and PyQGIS libraries.
- Automate geospatial processes and workflows through Python scripting in ArcGIS and QGIS.
- Develop custom Python-based geoprocessing tools for ArcGIS and QGIS to streamline operational tasks.
QGIS for Geographic Information System
21 HoursA Geographic Information System (GIS) is a framework engineered to capture, store, manipulate, analyse, manage, and present spatial or geographic data. The term GIS is occasionally employed to denote Geographic Information Science (GIScience), which refers to the academic discipline dedicated to the study of such systems, representing a significant domain within the wider field of geoinformatics.
QGIS operates as GIS software, empowering users to analyse and edit spatial information, as well as create and export graphical maps. It supports both raster and vector layers; vector data is stored as point, line, or polygon features. The software accommodates various raster image formats and can georeference images. In essence, it enables users to create, edit, visualise, analyse, and publish geospatial information across Windows, Mac, Linux, and BSD platforms.
In its initial phase, this programme introduces the QGIS interface for general usage. During the second phase, we introduce PyQGIS—the Python libraries of QGIS—which facilitates the integration of GIS functionalities into your Python code or applications, allowing you to develop custom Python plugins around specific GIS capabilities.
Requirements Analysis
21 HoursThis instructor-led, live training in South Africa (online or onsite) is designed for individuals who wish to understand requirements analysis and execute it efficiently and accurately by employing analysis techniques for their projects.
By the end of this training, participants will be able to:
- identify different types of requirements.
- understand the overall concepts of, and activities within, requirements analysis.
- be familiar with the requirements analysis methodology.
- use different requirements analysis techniques to their advantage.
- structure requirements in order to communicate efficiently with architects and developers through an iterative requirement gathering process.