Solved by verified expert:Please be on timeNO PLAGAIRISMALL IN-APA FORMAT MINIMUM 5 referencesplease check the example attachedNote- please make sure you do it very very good online research and make a good understand on the topic before do the design.please be on timeAssignmentThe next step to be completed is to perform the data load analysis to identify the techniques that are employed to perform the extaction, transformation, and loading (ETL) process.Load Data AnalysisDescribe, in detail, the techniques that will be employed to perform extraction, transformation, and loading (ETL) of data into the project data warehouse or data mart.Worked ExamplePlease refer to the Worked Example below for an example of this assignment based on the Problem-Based Learning Scenario. The worked example is not intended to be a complete example of the assignment but will illustrate the basic concepts required for completion of the assignment and can be used as a general guideline for your own project. Your assignment submission should be more detailed and specific and should reflect your own approach to the assignment rather than just following the same outline provided in the worked example.Case Study: Problem 3The data warehouse committee has received the first 2 phases of the data warehouse design document (requirements defined and physical, conceptual, and logical design). They want to be able to have 1 true picture of their customer, which means that you need to take the data from the customer service, sales, and marketing departments and begin loading them into the data warehouse.Note that the worked example includes material from previous worked examples. The new material will be found under the Week 3 sections of the Table of Contents.please be in topic please be in timeno plagiarism all in APA format
cs683_ip3_worked_example.pdf
Unformatted Attachment Preview
Running head: DATA WAREHOUSE DESIGN DOCUMENT
Your Company Name
Data Warehouse Design Document
(Name)
(Date)
Data Warehouses: CS683
1
DATA WAREHOUSE DESIGN DOCUMENT
2
Table of Contents
Data Warehouse Requirements (Week 1) …………………………………………………………………………… 3
Company Profile ………………………………………………………………………………………………………….. 3
Data Requirements ………………………………………………………………………………………………………. 3
Design Requirements (Week 2) ………………………………………………………………………………………… 5
Load Data (Week 3) ………………………………………………………………………………………………………… 6
Data Analysis (Week 4) …………………………………………………………………………………………………… 8
Maintenance and SQL Script Creation (Week 5) ………………………………………………………………… 9
References ……………………………………………………………………………………………………………………. 10
DATA WAREHOUSE DESIGN DOCUMENT
Data Warehouse Requirements (Week 1)
Company Profile
Provide a brief description of the company (can be hypothetical) where the Data Warehouse
Design Document will be implemented. Include the company’s size, location(s), and other
pertinent information.
Data Requirements
Describe the process that you will use to gather Data Warehouse Requirements.
Detailed design: An example of Sky Products may include analysis of the sales data mart,
which includes products, promotions, and company and customer information. The source
data from the sales data mart would be staged to be input into the data warehouse. The goal
would be to provide one view of the truth as far as sales data is concerned in the Sky
Products’ data warehouse.
An example of information delivery may be a products sold by customer monthly report,
which would tell Sky Products which customer purchased which products.
a) Data Acquisition
1. Source data
2. Data staging
b) Data Storage
1. DW DBMS
2. Data marts
3. Metadata
c) Information Delivery
3
DATA WAREHOUSE DESIGN DOCUMENT
1. MDDB
2. Data mining
3. OLAP
4. Report and query
d) Management and Control
4
DATA WAREHOUSE DESIGN DOCUMENT
5
Design Requirements (Week 2)
Design the conceptual, logical, and physical design based on the requirements. An example of a
sales conceptual, logical, and physical design for Sky Products may look like the following.
Conceptual Model Design
Logical Model Design
(1KD, 2013)
Physical Model Design
(1KD, 2013)
(1KD, 2013)
DATA WAREHOUSE DESIGN DOCUMENT
6
Load Data (Week 3)
Load Data: Describe, in detail, the techniques that will be employed to perform extraction,
transformation, and loading (ETL) of date into the project data warehouse or data mart.
An example of transforming currency information into a FactCurrencyRate table is shown below:
(Microsoft, 2013)
You first must look at your source data.
(Microsoft, 2013)
DATA WAREHOUSE DESIGN DOCUMENT
Next, look at your destination.
(Microsoft, 2013)
Finally, map your source data to the destination.
7
DATA WAREHOUSE DESIGN DOCUMENT
Data Analysis (Week 4)
.
8
DATA WAREHOUSE DESIGN DOCUMENT
Maintenance and SQL Script Creation (Week 5)
9
DATA WAREHOUSE DESIGN DOCUMENT
References
1KD. (2013). Conceptual model design [Image]. Retrieved from
http://www.1keydata.com/datawarehousing/data-modeling-levels.html
1KD. (2013). Logical model design [Image]. Retrieved from
http://www.1keydata.com/datawarehousing/data-modeling-levels.html
1KD. (2013). Physical model design [Image]. Retrieved from
http://www.1keydata.com/datawarehousing/data-modeling-levels.html
Microsoft. (2013). Lesson 1: Creating the project and basic package. Retrieved from
http://msdn.microsoft.com/en-us/library/84d0b877-603f-4f8e-bb6b-671558ade5c2
10
…
Purchase answer to see full
attachment
