DAT 300 Module Six Assignment Template (Murphy)

pptx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

300

Subject

Information Systems

Date

Apr 3, 2024

Type

pptx

Pages

Uploaded by BaronKuduPerson693

The ETL Process in Brief Presented by Kaelyn Murphy

The ETL Process ◦ ETL is the process of combining raw data from various sources into a central repository like a data warehouse while maintaining data quality and trust (Knight, 2017). ◦ The ETL process contains three operations: ◦ Extract ◦ Transform ◦ Load This Photo by Unknown Author is licensed under CC BY-SA-NC

The Purpose of ETL ◦ Pulls data from source ◦ Cleans data ◦ Transforms data ◦ Loads data into the repository

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

The Importance of ETL ◦ ETL is critical to ensuring that data is transformed in a way that end users will be able to use it (Masden & Nemani, 2011). ◦ ETL systems: ◦ Removes data ◦ Formats data ◦ Structures data ◦ Ensures confidence in data ◦ Stores data in one central location

References ◦ Knight, M. (2017, October 8). What is Extract, Transform, and Load (ETL)? - DATAVERSITY . DATAVERSITY. https://www.dataversity.net/extract-transform-load-etl/ ◦ Madsen, L., & Nemani, R. (2011). <--Back to full color view ETL for Healthcare Business Intelligence. ResearchGate . https://www.researchgate.net/publication/335101286_--Back_to_full_color_view_ETL_for_Healthcar e_Business_Intelligence

DAT 300 Module Six Assignment Template (Murphy)

Related Documents