Please make it very effectively and all apa format and minimum of 5 ref and 5 pages

Description




PLEASE BE IN TIME


SUBJECT- DATA WAREHOUSE


MINIMUM OF 5 REFERENCES AND 5 PAGES

PLEASE MAKE IT GOOD ONLINE RESEARCH AND ANSWER EACH INCH OF QUESTION VERY VERY DEEPLY


this assignment, the section “Data Analysis” will be added to this report. The report will be submitted as the first draft of the Key Assignment.


  • Week 4: Data Analysis

    • Define what online analytical processing (OLAP) means.
    • Discuss what OLAP tools are available for use in a data warehouse.
    • Discuss how you will utilize OLAP to query the warehouse and perform data analysis tasks. Give examples.


Note: This is the Key Assignment draft that you are also submitting to the Discussion Board.


Worked Example

Please 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 4

The data warehouse committee has received the first 3 phases of the data warehouse design document (requirements defined; physical, conceptual, and logical design; and extract, transform, and load [ETL]). The data warehouse committee would like to see the new and improved customer data that are now available in the data warehouse. They want to be able to query the data warehouse to see the customers’ account information, sales, and marketing information.

Note that the worked example includes material from previous worked examples. The new material will be found under the Week 4 sections of the Table of Contents.

Please be in time

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
1. MDDB
3
DATA WAREHOUSE DESIGN DOCUMENT
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)
Analyze Data: Discuss online analytical processing (OLAP) tools that will be utilized to query
the warehouse and perform data analysis tasks.
Below is an example of an OLAP data model which may be used for Sky Products’ data
warehouse.
(Microsoft TechNet, 2013)
The above model could be used to create the sample Product by Customer report for Sky
Products.
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
Microsoft Technet. (2013). Chapter 13: OLAP services. Retrieved from
http://technet.microsoft.com/en-us/library/cc966471.aspx
10

Purchase answer to see full
attachment

We offer the bestcustom writing paper services. We have done this question before, we can also do it for you.

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.