Computer Solutions Inc. would like to perform hardware
inventory for all of their office computers and monitors. They currently have
asset tags on them and have all of the information stored in a SQL database.
The current method of inventory is to scan the asset tags into a blank Excel
document that they then compare manually to the database to ensure that the
equipment is there. Ideally, they would like the inventory results stored in a
data warehouse for automatic verification and inventory history.
Solution Development Plan Overview:
The following is an example of how a summary would be
created for this BI Solution. It would include a quick description of the
problem and how it would be solved.
Below are some examples of how data can be transformed and
stored in this BI solution. This shows how we will be able to transform any
piece of data that is not very descriptive into a more user friendly version.
Below is an example
of the existing inventory data from Computer Solutions. This is what the
employee uses as they go around and perform the inventory of the company’s
computers
Below is an example of the existing database from Computer
Solutions. It is a simple database that stores what hardware they have, what it
is (computer tower, monitor, etc.), and where it is located.
Upon performing the ETL process on the customer’s SQL
database and inventory Excel documents, we should be able to create a data warehouse
that can store the records for each inventory and provide accurate reports.
Here is our projected members of the BI Solution Development
team and their roles:
Our estimated Hours for completion are:
This should be the initial schedule projection for the development
of the whole BI Solution:
We have reviewed Computer Solution’s current Licensing and
Solution requirements and found the following:
- The Customer already has an SQL server available.
- The Customer already has a DBA that can maintain the BI Solution servers.
No comments:
Post a Comment