Imagine that you are working with the data analytics department of an organizati
ID: 3794388 • Letter: I
Question
Imagine that you are working with the data analytics department of an organization that is exploring the use of data warehousing in the context of marketing intelligence analysis; if you are unfamiliar with the concept of marketing intelligence, you may benefit from using an online search tool such as Wikipedia to familiarize yourself with the term. You have been asked to explain what information is needed in order to begin discussing data warehouse and data mart requirements.
Identify and describe the data warehouse or data mart requirements in this situation. As part of your explanation, address the fact that the impact of business requirements on data attributes, such as data hierarchy, storage, quality, and structure, will influence the source identification process.
Review the software applications available in the market and identify the importance of their attributes for different environment.
Explanation / Answer
Dataware House: Its basically refer to the system that can be used for the reporting as well as for the analysis of data. In dataware house, we have huge amount of data accumalated from various sources of the organization. This data is being used for the organization analysis and for making various decisions.
The use of dataware house in context of marketing intelligence analysis is as follows:
1) Dataware house is the core component of the business intelligence.
2) Here data is being stored from various heterogeneous sources, so its now a single point to get all the data and for doing analysis.
3) Its also have clean data that is relevant to the organization, its help organization in making various decisions.
4) Fast access as well as multiple query support.
5) Its very easy to create data reports on the bases of your requirements.
Organization can implement the dataware house by go to the 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.