Question

You work at a small company. Your boss has heard that creating a Data Warehouse to support a Business Intelligence effort will solve all the company's woes. You have been asked to come up with an overview of how the company would proceed. Create a proposal explaining to the boss what would be involved in a developing a data warehouse for your company. You will not be designing an actual data warehouse, but explaining what would be involved if the company were to proceed: what decisions need to be made, issues to be addressed, etc.

In your own words write a memorandum email to your not-so-tech-savy boss providing an overview of what would be involved in creating such a system for your company.

Answer 1

IF YOU HAVE ANY DOUBTS COMMENT BELOW I WILL BE THERE TO HELP YOU

ANSWER:

EXPLANATION:

Here i am giving you the explanation below

Creation of the dataware house involves following steps:

1) Design the Data Warehouse: First step is to select the design of data warehouse, select the design that suits your organization.

2) Creation of the Data preperation Area: Here we will discuss and describe what type of data we required for the data warehouse. Preperation of dataware house data is being done here.

3) Creation of Actual Data Warehouse Data: Here we describe as well as create the relation database that will hold the warehouse data.

4) Data Extraction from Systems: Here we describes , how the data will be extract from various operational systems and finally store in dataware house.

5) Cleaning and the Data Transformation: Here we describe various methods and techniques used for data cleaning and transformation, its been done before the data is store in data warehouse

6) Loding Data in Warehouse: Here we describes, how the data will be stored in the warehouse.

7) Presentation of Warehouse Data: Here we describes the process of presenting the warehouse data to the end users.

8) Data Distributions; Here in this step, we describes process of data distribution from warehouse data.

hope it helps you

RATE THUMBSUP PLEASE