Planning a data warehouse Please pick data and analyze below Think about data th
ID: 2584764 • Letter: P
Question
Planning a data warehouse Please pick data and analyze below Think about data that would be in interesting to analyze, go through the step 1-3 of 7 steps to planning a data warehouse, and explain what you would do. If you want to stretch your research and technical skill, try to complete the rest of the steps. Step 1: Determine the Business Objective Step 2: Collect and Analyze Information Step 3: Identify Core Business Processes Step 4: Construct a Conceptual Model Step 5: Locate Data Sources and Plan Data Transformation Step 6: Set Tracking Duration Step 7: Implement the PlanExplanation / Answer
Planning a data warehouse is not simple as describe in theory. It is very practical and link with many processes such as business processes, information system technologies etc. Therefore it should be planned carefully. In this case I choose planning a data warehouse of customers buying patterns through internet. Here are the steps in detail to conduct planning data warehousing project.
Step 1: Determine the business objective. Normally business objective are consist of what we can ultimately achieve. As examples increase the profit, reduce cost etc. in my case main objective is identify any relation when buying goods and services through the internet by customers.
Step 2: Collect and analyses information. In this step analyses the information that gathered in various ways. Such as from questionnaires interviews etc. In my case I do the quaternary surveys to gather data for analyze
Step 3: Identify core business process. All businesses have core activities. Such as production, selling, marketing etc. in my case main activity is E selling.
Step 4: Construct a conceptual model. This is need to be done because get a more realistic conclusion o gathered data. In my case I need to develop more reliable and realistic conceptual methods for identify the buying patterns though the internet.
Step 5: Locate data sources and plan data transformation. In my case main data source is from internet. So these data need to be transferred as information to get precise understands about the scenario. Its mean gathered data should be analyzed carefully to see whether there is relationship on customers buying patterns through the internet.
Step 6: Set tracking duration. Simply this mean by the time period to conduct project planning warehouse. It depends on all the above steps. If more time is use more information can be gathered. However also it should be higher the cost
Step 7: Implement the plan. Conduct the data warehouse planning. After the compilation of all above steps plan will implement successfully by the implementers