preview

Project Comparisheet Data Analysis

Decent Essays
Open Document

Problem Statement

Your construction company currently tracks all of its information in an Excel spreadsheet. However, some information has become quite difficult to track and add in this spreadsheet, so the company has decided to move toward using a database instead. The current spreadsheet data example is as follows:

Typical information needed for a construction business would include, but not be limited to, materials inventory, balance sheets depicting revenues versus expenses, and employee information. On a small scale, these can be supported with a spreadsheet data tool. However, capturing project quote information, with the ability to establish variations in the project scope, and understand such things as the impact to the …show more content…

For instance, the project manager name, address, and phone number. In this spreadsheet, the data for project manager Holly B. Parker, must be entered three times. This redundancy opens the door for potential data errors from manual data entry.
Database Redundancies and Methods of Resolution The limitations of using a single two-dimensional table to produce meaningful information are apparent in the given example. As previously mentioned, in the current spreadsheet table structure, the same data must be entered multiple times to provide a comprehensive record for each project quote. This reflects a narrow design view, of which the potential of data entry error is duplicated if an additional field, or fields of data are required. An example would be if another team member, such as a sales representative’s information is needed. The current table structure also makes effective data query a challenge. For instance, a query of what city each project manager resides in would not be possible, as that data is embedded within the specific manager address field. To help resolve this, the file structure must be modified where the manager address field is broken down into fields for the street name and number, city, state, and zip code.
To maximize the querying capability of this specific spreadsheet, each field of data should be broken down to the most atomic level possible. In addition to the breakdown of the manager address, we

Get Access
Related
Get Access