.jpg){kind=logo}
SNHU-DAT325.AJC1
DAT-325 - Data Validation: Quality and Cleaning
Intermediate Self-paced · 1 year access
33 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
01 / Lessons & labs
See exactly what you will learn and practice
Lessons
12 Interactive Lessons · 67 topics01 Fundamentals of Data Analysis 11 topics +
- The Importance of Quality Source Data
- Data Structure Types
- Centralized Data Benefits
- Structured vs. Unstructured Data
- Types of Data
- Typical Sources of Business Data
- Data Protection Policies
- Search Engine Optimization
- Data Life Cycle Management (DLM)
- Data Analysis Process
- Lesson Summary
02 Introduction to Data Wrangling with Python 4 topics · 5 LiveLab +
- Introduction
- Python for Data Wrangling
- Lists, Sets, Strings, Tuples, and Dictionaries
- Summary
5 LiveLab in this lesson — see the labs panel →
03 Introduction to Data Quality 2 topics +
- Impact of Data Errors
- Importance of Organizational Strategy and Data Quality in Data Analytics
04 Introduction to NumPy, Pandas, and Matplotlib 5 topics · 4 LiveLab +
- Introduction
- NumPy Arrays
- Pandas DataFrames
- Statistics and Visualization with NumPy and Pandas
- Summary
4 LiveLab in this lesson — see the labs panel →
05 Introduction to Databases and Cloud 3 topics +
- Cloud-Based Data
- Typical Databases Used for Data Analysis
- Data Modeling
06 RDBMS and SQL 5 topics · 5 LiveLab +
- Introduction
- Refresher of RDBMS and SQL
- Using an RDBMS (MySQL/PostgreSQL/SQLite)
- Reading Data from a Database in SQLite
- Summary
5 LiveLab in this lesson — see the labs panel →
07 Tools for Capturing and Analyzing Data 9 topics +
- Data Analytics Tools
- Capturing Data: Tableau Public
- Capturing Data: Google BigQuery
- Capturing Data: OpenRefine
- Overview: Hadoop-Based Environments
- Capturing and Analyzing Data in Hadoop
- The R Project
- Additional Software for Data Capture
- Lesson Summary
08 Getting Comfortable with Different Kinds of Data Sources 4 topics · 4 LiveLab +
- Introduction
- Reading Data from Different Text-Based (and Non-Text-Based) Sources
- Introduction to Beautiful Soup 4 and Web Page Parsing
- Summary
4 LiveLab in this lesson — see the labs panel →
09 Working with Data Sources 9 topics · 1 LiveLab +
- Data E-Harmony: Working with Different Departments to Bring Data Together
- The Purpose of Customer Relationship Management (CRM)
- CRM Integration: A Banking Scenario
- Obtaining Data from Email and User Forums
- Obtaining Data from Other Knowledge Bases
- Obtaining Data from CRM and Business-to-Business Frameworks
- Transaction, Payment and Inventory Data
- Using Multiple Data Sources
- Lesson Summary
1 LiveLab in this lesson — see the labs panel →
10 A Deep Dive into Data Wrangling with Python 6 topics · 7 LiveLab +
- Introduction
- Subsetting, Filtering, and Grouping
- Detecting Outliers and Handling Missing Values
- Concatenating, Merging, and Joining
- Useful Methods of Pandas
- Summary
7 LiveLab in this lesson — see the labs panel →
11 Learning the Hidden Secrets of Data Wrangling 5 topics · 5 LiveLab +
- Introduction
- Advanced List Comprehension and the zip Function
- Data Formatting
- Identify and Clean Outliers
- Summary
5 LiveLab in this lesson — see the labs panel →
12 Application of Data Wrangling in Real Life 4 topics · 2 LiveLab +
- Introduction
- Applying Your Knowledge to a Real-life Data Wrangling Task
- An Extension to Data Wrangling
- Summary
2 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
33 LiveLabs- Sorting a List
- Generating a List
- Deleting a Value from a Dictionary
- Accessing and Setting Values in a Dictionary
- Slicing a String
- Generating Arrays Using arange and linspace
- Multiplying Two Arrays
- Adding Two NumPy Arrays
- Creating a NumPy Array
- Deleting the Data
- Using Joins
- Using the Foreign Key
- Using the ORDER BY Clause
- Using the SELECT Statement
- Bypassing the Headers of a CSV File
- Reading Data from a CSV File
- Stacking URLs from a Document Using bs4
- Counting Tags
- DAT-325 Project 2
- Subsetting a DataFrame
- Grouping a DataFrame
- Dropping the Missing Values
- Replacing Missing Values in a DataFrame
- Joining DataFrames
- Concatenating Data Frames
- Counting Values
- Using the zip Function
- Using a One-Liner Generator Expression
- Using a Generator Expression
- Using the format Function
- Using a Box Plot
- Skipping the First Row of the Data Set
- DAT-325 Project 3
Labs run in your browser — nothing to install.
02 / FAQs
Questions before you start
Keep going
You might also like
Prepare for DAT-325 - Data Validation: Quality and Cleaning
One-time payment. Full access for 1 year. Start with a free trial if you want to look around first.
- 1 year of full access
- 33 LiveLab included
- Certificate of completion
No credit card required