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-03-28
Data Warehouse Lab Work 2
Data InputData input is an action of entering data into a system, where the data can then be stored, manipulated, or processed. Inputting data in Spoon can be done in various formats, and the tools provided in Spoon are quite comprehensive and diverse. Among the data storage formats that can be input are: SQL CSV TXT XML JSON Microsoft Excel Input can be done in an unlimited manner with the data storage formats mentioned above. Besides these formats, there are many other ways, but the most ...
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-30
Data Warehouse Lab Work 8
Preparation for Final Project IIExercises before working on the final project for the Data Warehouse course. ModuleDownload Module 8
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-04-18
Data Warehouse Lab Work 5
Connected to MySQLMySQL is a multi-threaded, multi-user SQL database management system (DBMS) software with around 6 million installations worldwide. Pentaho Spoon itself supports importing and exporting data through DBMS, and one of the supported DBMS is MySQL. In this lab, you are required to connect MySQL with Pentaho Spoon. Below are the datasets stored in SQL format, and you can also download the work module. ModuleDownload Module 5 DatasetDownload Dataset
Comments
