Data Cleaning Training Course
Data Cleaning, also known as Data Cleansing, refers to the process of identifying and resolving issues within a dataset prior to analysis.
This instructor-led, live training (available online or on-site) is designed for data scientists, data analysts, and business analysts seeking to clean and process data effectively.
By the end of this training, participants will be able to:
- Develop an effective data cleaning strategy.
- Implement practical tools for data cleaning.
- Achieve results more efficiently.
- Learn and apply best practices in data cleaning.
Course Format
- Interactive lectures and discussions.
- Extensive exercises and hands-on practice.
- Real-time implementation in a live lab environment.
Course Customisation Options
- To request a customised version of 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 Comprehensive 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
- A foundational understanding of data analytics concepts.
Target Audience
- Data Scientists
- Data Analysts
- Business Analysts
Open Training Courses require 5+ participants.
Data Cleaning Training Course - Booking
Data Cleaning Training Course - Enquiry
Data Cleaning - Consultancy 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
Provisional Upcoming Courses (Require 5+ participants)
Related Courses
ArcGIS for Spatial Analysis
14 HoursThis instructor-led, live training in New Zealand (available online or on-site) is tailored for field ecologists and conservation managers who wish to create spatial data projects using ArcGIS.
By the end of this training, participants will be able to:
- Present spatial data as visualisations.
- Perform geostatistics on real-world data.
- Implement spatial data analysis, data processing, and mapping using ArcGIS.
- Analyse spatial data for projects within ArcGIS.
ArcMap in ArcGIS
14 HoursThis instructor-led, live training in New Zealand (online or on-site) is aimed at intermediate-level environmental scientists and archaeologists who wish to learn how to use ArcMap in ArcGIS for collecting, organising, managing, and analysing geographic information.
By the end of this training, participants will be able to:
- Understand the fundamentals of ArcMap and ArcGIS.
- Collect, organise, manage, and analyse geographic information relating to social and archaeological elements.
- Conduct spatial queries for impact evaluation.
ArcGIS from Basic to Advanced
35 HoursThis instructor-led, live training in New Zealand (online or onsite) is designed for GIS professionals and analysts, from beginner to advanced levels, who wish to learn how to effectively use ArcGIS for data visualisation, spatial analysis, and geospatial project management.
By the end of this training, participants will be able to:
- Navigate and utilise ArcGIS tools for geospatial data management.
- Create and customise 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 New Zealand (online or onsite) is designed for beginner-level IT support personnel who wish to provide robust support for ArcGIS Enterprise, effectively addressing any anomalies or failures.
By the end of this training, participants will be able to:
- Understand the architecture and components of ArcGIS Enterprise.
- Learn how to install, configure, and manage ArcGIS Enterprise.
- Gain practical skills in troubleshooting and resolving common issues.
- Develop proficiency in monitoring and maintaining ArcGIS Enterprise environments.
- Master techniques for backup, recovery, and performance optimisation.
ArcGIS Fundamentals
14 HoursThis instructor-led, live training in New Zealand (available online or on-site) is designed for beginner-level professionals seeking to master the core concepts and tools of ArcGIS.
By the end of this training, participants will be able to:
- Understand the fundamental concepts of GIS and spatial data.
- Navigate the ArcGIS interface with confidence.
- Create and manage spatial data effectively.
- Perform basic spatial analysis.
- Develop maps and visualisations.
ArcGIS Pro for Spatial Analysis
14 HoursBy the end of this training, participants will be able to:
- Understand GIS concepts and spatial data types using the latest version of ArcGIS Pro.
- Explore the user interface and assess its applications.
- Investigate ArcGIS* Pro and learn how to leverage online content.
- Manage, manipulate, and analyse your own data.
- Display and share your data in meaningful and creative ways.
Note: We will be using the latest version of ArcGIS Pro.
ArcGIS Professional Plus: Advanced GIS Data Management and Analysis
14 HoursArcGIS Professional Plus is an advanced version of ArcGIS Pro, offering extended features for geospatial data analysis, 3D modelling, automation, and enterprise collaboration.
This instructor-led, live training (online or onsite) is aimed at intermediate-level GIS professionals who wish to deepen their skills in spatial data analysis, automation, and sharing using ArcGIS Professional Plus tools.
By the end of this training, participants will be able to:
- Leverage ArcGIS Pro Plus tools for data visualisation and analysis.
- Create 2D and 3D maps with advanced symbology and geoprocessing techniques.
- Automate workflows using ModelBuilder and Python scripting.
- Integrate ArcGIS with external data services and enterprise systems.
Format of the Course
- Interactive lecture and discussion.
- Plenty of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customisation Options
- To request a customised training for this course, please contact us to arrange.
Advanced ArcGIS Pro for Spatial Analysis
35 HoursThis instructor-led, live training in New Zealand (online or on-site) 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 modelling 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.
- Utilise Python scripting for automation and complex data processing.
- Apply spatial modelling for problem-solving in real-world scenarios.
- Conduct geostatistical analysis for advanced data interpretation.
- Integrate external data sources and leverage 3D spatial data analysis.
ArcGIS with Python Scripting
14 HoursThis instructor-led, live training in New Zealand (available online or on-site) is designed for GIS analysts who wish to automate repetitive tasks within GIS workflows.
By the end of this training, participants will be able to:
- Build GIS applications using Python and ArcGIS tools.
- Develop using the ArcGIS package ArcPy with Python.
- Apply ArcGIS modules for map automation using object classes in Python.
Advanced Power Systems and GIS Integrated Solutions
70 HoursIn the evolving energy sector, integrating electrical transient analysis with precise geographic data has become a strategic imperative. Currently, reliance on fragmented data creates significant operational risks. This intensive 14-day programme in Melbourne is designed to bridge the gap between electrical engineering and geospatial management.
Advanced Geographic Information Systems (GIS)
21 HoursThis instructor-led, live training in New Zealand (online or onsite) is aimed at intermediate-level geographers who wish to deepen 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 solve complex geographical problems.
- Manage large spatial databases and perform data quality control.
- Create dynamic and interactive maps and visualisations for various applications.
- Utilise programming and automation to streamline GIS workflows.
Google Maps API for Developers
14 HoursThis instructor-led, live training in New Zealand (available online or on-site) is designed for developers looking to enhance their website or web application by integrating geo-location functionality through Google Maps.
By the end of this training, participants will be able to:
- Embed a map into a new or existing website or web application.
- Display live data that synchronises with the current location.
- Create a mashup that includes Google Maps.
- Apply best practices in CSS and JavaScript coding.
- Create a custom map for an application.
Python for ArcGIS and QGIS for Earth Sciences and Engineering Professionals
35 HoursThis instructor-led, live training in New Zealand (available online or on-site) is designed for beginner-level earth sciences and engineering professionals who wish to utilise Python for geospatial analysis in both ArcGIS and QGIS environments.
By the end of this training, participants will be able to:
- Master Python syntax and control structures to execute geospatial tasks efficiently.
- Leverage Pandas, Numpy, and Matplotlib for data analysis and visualisation in GIS.
- Manipulate and analyse vector data using the Geopandas, Arcpy, and PyQGIS libraries.
- Automate geospatial processes and workflows through Python scripting in both 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 system designed to capture, store, manipulate, analyse, manage, and present spatial or geographic data. The acronym GIS is sometimes used to refer to geographic information science (GIScience), the academic discipline that studies geographic information systems and forms a major domain within the broader field of geoinformatics.
QGIS functions as geographic information system (GIS) software, enabling users to analyse and edit spatial information, as well as compose and export graphical maps. QGIS supports both raster and vector layers; vector data is stored as point, line, or polygon features. Multiple raster image formats are supported, and the software can georeference images. In summary, QGIS allows users to create, edit, visualise, analyse, and publish geospatial information on Windows, macOS, Linux, and BSD.
In its first phase, this program introduces the QGIS interface for general use. In the second phase, we introduce PyQGIS—the Python libraries for QGIS—which enable the integration of GIS functionalities into your Python code or applications. This allows you to develop your own Python plugins tailored to specific GIS tasks.