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...
Information Technology Project Management Lab Work 10
Project ReportReports in Microsoft Project serve to create and customize various types of graphical reports. By working with and updating project data, configured reports linked to the project are updated in real time. General project information reports combine charts and tables to show where each project phase, milestone, and upcoming deadline stands. Microsoft Project provides dozens of ready-made reports. In addition to these pre-packaged reports, you can also create custom reports. You c...
Data Warehouse Lab Work 8
Preparation for Final Project IIExercises before working on the final project for the Data Warehouse course. ModuleDownload Module 8
Information Technology Project Management Lab Work 9
Resource GraphResource Graph is a feature in Microsoft Project that functions to visualize the daily resource usage in a bar chart. It can also indicate resource overloads. In addition to viewing resource usage, its other function is to analyze the resources used in project management. Resource Graph is a facility provided to display reports in a graphical form, similar to other worksheets in Microsoft Project.Resource Graph has several display branches, including those provided by Microsoft ...
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
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
Information Technology Project Management Lab Work 8
Team PlannerTeam Planner is a feature in Microsoft Project that functions to organize team work (Human Resources) that has been previously entered in the Resource Sheet. Additionally, Team Planner will generate an analysis of resource usage, which can be analyzed graphically to determine whether the resources are experiencing cost increases (overallocated) or are in line with the available resources. Team Planner is also used to allocate and organize the job responsibilities of each employee ...
Information Technology Project Management Lab Work 7
Resource SheetResource Sheet is a feature in Microsoft Project that serves to determine the resources we have when working on a project. This feature can be used to manage the resources we have in completing a project. The Resource Sheet has columns containing information about the identity and size of resources, including the indicator column, resource name, type, material label, initial, group, max unit, and code. Here is an explanation of the columns and their use in each project operation...
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
Information Technology Project Management Lab Work 6
Task UsageTask Usage is a feature in Microsoft Project that allows you to schedule working hours for each task. It is adjusted based on the working hours for each day. Task Usage will be connected with Actual Work and Progress Bar, where the hour calculations in Task Usage will be calculated based on Actual Work to determine the details of how many hours the task in the project is completed. Task Usage is typically used to obtain detailed data on the project’s tasks, so that the data can be a...