Data Warehouse Lab Work 10
Final Project Practicum II
In this practicum, students are required to perform data cleansing on the given dataset as the first step of the Final Project Practicum. Below is the module along with the dataset.
Module
Dataset
All articles on this blog are licensed under CC BY-NC-SA 4.0 unless otherwise stated.
Related Articles
2022-06-20
Data Warehouse Lab Work 12
Final Project Practicum IVIn this practicum, students are required to perform Extract, Transform & Load (ETL) on the provided dataset as part of the final stages of the Practicum Final Project. In the initial process of data analysis, data scientists must follow several basic steps to ensure the accuracy of the output. One of the methods is Extract, Transform, and Load, commonly referred to as ETL. Since its emergence in the 1970s, ETL has drawn the attention of companies for storing thei...
2022-06-15
Data Warehouse Lab Work 11
Final Project Practicum IIIIn this practicum, students are required to perform data cleansing on the given dataset as the first step of the Final Project Practicum. Below is the module along with the dataset. ModuleDownload Module 11 DatasetDownload Dataset
2022-05-19
Data Warehouse Lab Work 6
Merge DataMerge Data or Data Merging is the process of combining two or more sets of data into a single data set. This process is necessary when you want to analyze or process large amounts of raw data that are stored separately in various types of files, worksheets, or data tables. Before analysis, the data needs to be merged to facilitate and expedite the analysis or data processing. ModuleDownload Module 6 DatasetDownload Dataset
2022-04-11
Data Warehouse Lab Work 4
Structured TransformationStructured transformation is the systematic and structured conversion of the original data measurement scale into another form, making it easier to analyze variability in the data. The expected output is also in the form of cleaner and more structured data. In today's practical session, we will perform a simple data transformation by combining header data with content data separately and changing the data format from CSV to Microsoft Excel format. You can download...
2022-05-23
Data Warehouse Lab Work 7
Preparation for Final Project IExercises before working on the final project for the Data Warehouse course. ModuleDownload Module 7 DatasetDownload Dataset
2022-06-06
Data Warehouse Lab Work 9
Final Project Practicum IData CleansingData Cleansing is a process of detecting and correcting (or removing) corrupt or inaccurate data sets, tables, and databases. Inaccurate data includes empty data that has no value or contains NULL/NaN values. The goal of data cleansing is to ensure that when the data is processed later, there will be no errors resulting from incomplete or missing data. In this practicum, students are required to perform data cleansing on the given dataset as the fir...
Comments