Data Warehousing and Reporting Structures
In this module, we will look at how to create a data warehouse database and why you would want to.

You are going to create a simple data warehouse database using a simple OLTP database as its source. Please fill in the provide spreadsheet to plan the design of your data warehouse and then create a SQL script that creates the database you have designed. I have provided you with a starter spreadsheet called "BISolutionWorksheets.xlsx." Please use that for the assignment.
Follow these steps to complete the assignment:
1. Review and run the "1-NorthwindLite-This creates the OLTP DB.sql file."
2. Review and complete the "2-BISolutionWorksheets.xlsx spreadsheet."
3. Review and complete the "3-DWNorthwindLite_StarterScript.sql."
4. Place the resulting SQL script file and either the completed spreadsheet file into a folder, zip it, and submit it to Canvas.

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Data Warehousing and Reporting Structures Data Warehousing and Reporting Structures
    $64.00 for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Database Development Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Upload a file
    Continue without uploading

    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats