Data Warehouse Lab Work 7

2022-06-13

Data Warehouse Lab Work 10

Final Project Practicum IIIn 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 10 DatasetDownload Dataset

2022-04-04

Data Warehouse Lab Work 3

Output DataOutput Data is the action of storing data from transformation results or data created automatically in Pentaho. In Pentaho Spoon, Output Data can be done in many ways and in any format, but the most commonly used ones are as follows: Database (Directly inputted into the Database) CSV TXT XML JSON Microsoft Excel In this practical, you will learn how to output data in Text and CSV formats because these two formats are the most common for data storage. Database storage will be cove...

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 first st...

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-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

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