University of Nairobi Data Warehouse Star Schema Paper

User Generated

Dbttyrf843

Computer Science

University of Nairobi

Description

Using the star schema developed in Portfolio Milestone 1 - Option 1 in Module 3 and incorporating your instructor's feedback, develop and execute the SQL commands to create the tables, define the variables and their attributes, and apply the constraints to your fact and dimension tables.

Your deliverable for this Portfolio Milestone is a report containing the following information:

  • Changes to your business process, business questions, and fact table grain from Module 3
  • Updated version of the star schema incorporating your instructor's feedback
  • Screenshot of fact and dimension tables
  • Listing of SQL commands

Your paper should be three to five pages in length, organized and well-written, and in conformity with the CSU Global Writing Center (Links to an external site.).

In support of your response, cite and integrate at least one credible outside source, which can be your textbook. Place the sources in a reference page formatted in accordance with APA style. This reference page does not count toward the total page requirement. The CSU Global Library is a great place to find these resources.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Data Warehouse Star Schema
Data warehouse not only reports and analyze data but also is considered as the heart of
business intelligence. Data Warehouse stores both historical and current data in a central place
where analytic reports for corresponding individuals can be created. This report introduces a Star
Schema with much focus on sales evaluation and performance. I intend to add multi-layer ETL
design concepts, indexing, and partitioning to improve query execution and performance. For
quality, various correlations are analyzed among various tables and created using rigorous DQA
rules. On transition, incremental and full loading will be required in the system and data loading
will be automatic. Also, a reporting section will be implemented for customer concerns. Other
dimensions, including procurement, finance, and human resource are open for future design.
Requirement Analysis
According to table 1 below, there are interesting areas that can be used to come up with a
viable database. Sales facts are considerable, indicating that sales persons are important
individuals in the organization. They define the geographical location, customer relations,
suppliers, products and even suppliers. With this data it is possible to come up with new
performance system and make long-term reasonable judgment for better performance.
After a close look at the table and highlighting the correlations between various sources,
there is a reasonable assumption. Effective performance is determined by the number of
customers per sales...


Anonymous
I was having a hard time with this subject, and this was a great help.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags