Mastering ETL: Data Cleansing with SQL Server Integration Services from Pluralsight

The integrity of the data used for analysis is a major step in any data-related project. This course will teach you how to develop SQL Server Integration Services (SSIS) packages, used for data cleansing activities, to ensure data integrity.

Data cleansing is a major part of every project that uses data to create information.

In this course, Mastering ETL: Data Cleansing Techniques for SQL Server Databases, you’ll gain the ability to create SQL Server Integration Services (SSIS) packages specifically tailored for data cleansing tasks.

First, you’ll explore how to integrate data coming from different sources and identify possible data cleansing tasks, like handling duplicate data, dealing with missing values (delete, ignore, or fill-in data), fixing up formats, and correcting errors.

Next, you’ll discover several ways in which SSIS packages can help you clean your data, using derived columns, fuzzy grouping / fuzzy lookup, and data conversions.

Finally, you’ll learn techniques to maintain and verify data integrity after the cleansing process in SSIS.

When you’re finished with this course, you’ll have the skills and knowledge of various data cleansing techniques, performed in SSIS, needed to ensure the integrity of your data.

What's inside

Syllabus

Course Overview

Load and Cleanse Data with SSIS Packages

Handle Complex Data Transformations in SSIS

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Provides a solid foundation by teaching SSIS packages, a core skill for cleansing data

Ideal for learners seeking to ensure data integrity, as it teaches techniques for handling errors and missing values

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Mastering ETL: Data Cleansing with SQL Server Integration Services with these activities:

Review Basic SQL

Show steps

Refreshing your knowledge of basic SQL will ensure that you have a solid foundation for working with data in SSIS packages for data cleansing.

Browse courses on SQL

Show steps

Review your notes from a previous SQL course
Complete a few practice exercises
Take a quick online quiz to test your understanding

Create a comprehensive study guide covering all course materials

Show steps

Reinforce your understanding of the course concepts by organizing and summarizing the materials.

Show steps

Gather all course notes, quizzes, and exams
Review and organize the materials into a coherent structure
Create summaries, diagrams, and other visual aids to enhance understanding

Join a Study Group for Data Cleansing

Show steps

Participating in a study group will provide you with opportunities to discuss the course material, share your experiences, and learn from your peers.

Browse courses on Data Cleansing

Show steps

Find a study group or create your own
Meet regularly to discuss the course material
Share your experiences and insights

14 other activities

Expand to see all activities and additional details

Show all 17 activities

Review fundamental concepts of data cleaning and normalization

Show steps

Strengthen your understanding of data cleaning principles and normalization techniques, ensuring a solid foundation for effective data cleansing in SSIS.

Browse courses on Data Cleaning

Show steps

Review materials from previous courses or resources
Complete practice exercises or quizzes

Review Data Cleansing: Theory and Practice

Show steps

Reviewing the theory and practice of data cleansing will enhance your understanding of the techniques used in SSIS packages for data cleansing.

View Data Cleaning on Amazon

Show steps

Read the book's introduction and chapter 1
Identify the key concepts of data cleansing
Review the techniques used for data cleansing

Follow SSIS Tutorials on Data Cleansing

Show steps

Following tutorials will provide you with practical guidance on developing SSIS packages for data cleansing tasks.

Browse courses on Data Cleansing

Show steps

Search for SSIS tutorials on data cleansing
Select a tutorial that matches your skill level
Follow the steps in the tutorial

Participate in study groups or discussion forums dedicated to SSIS data cleansing

Show steps

Engage with peers to exchange knowledge, discuss techniques, and troubleshoot data cleansing challenges, fostering a collaborative learning environment.

Browse courses on SSIS

Show steps

Join online forums or discussion groups related to SSIS data cleansing
Participate in discussions, ask questions, and share your experiences
Collaborate with others on data cleansing projects or assignments

Practice SQL Server Integration Services (SSIS) data cleansing tasks

Show steps

Develop proficiency in using SSIS packages for data cleansing, ensuring data integrity and accuracy.

Browse courses on SSIS

Show steps

Import the provided sample data
Create a new SSIS package
Design and implement data cleansing tasks
Execute the SSIS package and review the results

Practice data cleansing exercises on sample datasets

Show steps

Gain hands-on experience with data cleansing techniques by working through guided exercises.

Browse courses on Data Cleansing

Show steps

Download sample datasets provided by course instructor
Apply data cleansing techniques covered in the course
Verify data integrity using the methods taught in the course

Identify Data Cleansing Tasks in Real-World Data

Show steps

Performing practice in data cleansing will enhance your ability to handle real-world data and develop SSIS packages for data cleansing tasks.

Browse courses on Data Cleansing

Show steps

Gather a dataset with real-world data
Identify the data cleansing tasks that need to be performed
Apply data cleansing techniques to the dataset
Evaluate the results of the data cleansing process

Follow online tutorials or documentation to expand your understanding of SSIS data cleansing techniques

Show steps

Explore additional resources and best practices to enhance your skills in SSIS data cleansing, ensuring continuous learning and growth.

Browse courses on SSIS

Show steps

Identify reputable online resources or documentation
Follow step-by-step tutorials to learn new techniques
Read articles or whitepapers to gain insights into advanced concepts

Create a custom SSIS template for data cleansing tasks

Show steps

Develop a reusable framework to streamline future data cleansing processes.

Show steps

Identify common data cleansing tasks and their corresponding SSIS components
Build a template that encapsulates these tasks and their configurations
Test and refine the template to ensure its accuracy and efficiency

Build an SSIS Package for Data Cleansing

Show steps

Applying SSIS in a project will enhance your understanding of the package's capabilities and reinforce the techniques you've learned for data cleansing.

Browse courses on Data Cleansing

Show steps

Define the data cleansing requirements
Design and develop an SSIS package that meets the requirements
Test and deploy the package

Create an SSIS data cleansing solution for a real-world data set

Show steps

Apply the concepts learned in the course to solve a practical data cleansing challenge, demonstrating mastery of SSIS capabilities.

Browse courses on SSIS

Show steps

Identify a data set with real-world data cleansing requirements
Design and develop an SSIS package to cleanse the data
Create a report or documentation that explains the data cleansing process and results

Build a data cleansing pipeline for a real-world dataset

Show steps

Apply the skills learned in the course to a practical scenario, solidifying your understanding.

Browse courses on Data Integration

Show steps

Gather and explore a dataset that requires data cleansing
Design and implement a data cleansing pipeline using SSIS
Evaluate the effectiveness of the pipeline by assessing data quality metrics

Create a Documentation for Data Cleansing Techniques

Show steps

Documenting data cleansing techniques will help you solidify your understanding and provide a valuable resource for future reference.

Browse courses on Data Cleansing

Show steps

Identify the data cleansing techniques covered in the course
Write a clear and concise description of each technique
Create examples to illustrate the use of the techniques

Contribute to Open-Source Data Cleansing Projects

Show steps

Contributing to open-source projects will allow you to gain practical experience with data cleansing and collaborate with other developers.

Browse courses on Data Cleansing

Show steps

Find an open-source data cleansing project that interests you
Contribute to the project by fixing bugs, adding features, or improving documentation
Collaborate with other developers to enhance the project

Career center

Learners who complete Mastering ETL: Data Cleansing with SQL Server Integration Services will develop knowledge and skills that may be useful to these careers:

Data Integration Specialist

A Data Integration Specialist is an IT professional who specializes in integrating data from multiple sources into a single, cohesive data warehouse. They use tools such as SSIS to extract, transform, and load data from source systems into the data warehouse. This course can help you build a strong foundation in SSIS, which is essential for success as a Data Integration Specialist.

See salaries and explore the career path for Data Integration Specialist

ETL Developer

An ETL Developer is an IT professional responsible for designing, developing, and maintaining data integration and transformation processes. They use tools such as SSIS to extract data from source systems, transform it, and load it into target systems. This course can help you build a strong foundation in SSIS, which is essential for success as an ETL Developer.

See salaries and explore the career path for ETL Developer

Data Analyst

A Data Analyst is an IT professional responsible for analyzing data to extract meaningful insights. They use data visualization tools to present their findings to stakeholders. This course can help you build a foundation in SSIS, which is a valuable tool for data analysts who need to cleanse and transform data before analysis.

See salaries and explore the career path for Data Analyst

Data Engineer

A Data Engineer is an IT professional responsible for designing, constructing, and maintaining data architectures, including databases and data warehouses. They also develop and maintain data integration and transformation processes, using tools such as SQL Server Integration Services (SSIS). This course can help you build a foundation in SSIS, which is essential for success as a Data Engineer.

See salaries and explore the career path for Data Engineer

Business Intelligence Analyst

A Business Intelligence Analyst is an IT professional responsible for providing data-driven insights to businesses. They use data analysis and visualization tools to help businesses make informed decisions. This course can help you build a foundation in SSIS, which is a valuable tool for business intelligence analysts who need to cleanse and transform data before analysis.

See salaries and explore the career path for Business Intelligence Analyst

Database Administrator

A Database Administrator is responsible for managing and maintaining databases. They ensure that databases are running smoothly and that data is protected. This course can help you build a foundation in SSIS, which can be useful for database administrators who need to cleanse and transform data before loading it into a database.

See salaries and explore the career path for Database Administrator

Data Scientist

A Data Scientist is responsible for using data to solve business problems. They use data analysis and machine learning techniques to extract insights from data. This course can help you build a foundation in SSIS, which may be useful for data scientists who need to cleanse and transform data before analysis.

See salaries and explore the career path for Data Scientist

Software Engineer

A Software Engineer is responsible for designing, developing, and maintaining software applications. They may use tools such as SSIS to integrate data from multiple sources into a single application. This course can help you build a foundation in SSIS, which may be useful for software engineers who need to work with data integration.

See salaries and explore the career path for Software Engineer

Information Systems Manager

An Information Systems Manager is responsible for planning, implementing, and managing information systems. They may use tools such as SSIS to integrate data from multiple sources into a single system. This course can help you build a foundation in SSIS, which may be useful for information systems managers who need to work with data integration.

See salaries and explore the career path for Information Systems Manager

Business Analyst

A Business Analyst is responsible for analyzing business processes and recommending improvements. They may use tools such as SSIS to integrate data from multiple sources into a single system. This course can help you build a foundation in SSIS, which may be useful for business analysts who need to work with data integration.

See salaries and explore the career path for Business Analyst

Database Designer

A Database Designer is responsible for designing and developing databases. They may use tools such as SSIS to integrate data from multiple sources into a single system. This course can help you build a foundation in SSIS, which may be useful for database designers who need to work with data integration.

See salaries and explore the career path for Database Designer

Data Architect

A Data Architect is responsible for designing and developing data architectures. They may use tools such as SSIS to integrate data from multiple sources into a single system. This course can help you build a foundation in SSIS, which may be useful for data architects who need to work with data integration.

See salaries and explore the career path for Data Architect

IT Manager

An IT Manager is responsible for planning, implementing, and managing IT systems. They may use tools such as SSIS to integrate data from multiple sources into a single system. This course can help you build a foundation in SSIS, which may be useful for IT managers who need to work with data integration.

See salaries and explore the career path for IT Manager

Data Governance Analyst

A Data Governance Analyst is responsible for developing and implementing data governance policies and procedures. They may use tools such as SSIS to integrate data from multiple sources into a single system. This course can help you build a foundation in SSIS, which may be useful for data governance analysts who need to work with data integration.

See salaries and explore the career path for Data Governance Analyst

Project Manager

A Project Manager is responsible for planning, executing, and closing projects. They may use tools such as SSIS to integrate data from multiple sources into a single system. This course can help you build a foundation in SSIS, which may be useful for project managers who need to work with data integration.

See salaries and explore the career path for Project Manager