What advice would be offer to an organization

Assignment Help Other Subject

Reference no: EM132653619

Assignment: • Use the star schema developed in Portfolio Milestone 1 - Option 1 in Module 3; incorporate your instructor's feedback.

• Use the tables created in Portfolio Milestone 2 - Option 1 in Module 5; incorporate your instructor's feedback.

Develop and execute the SQL commands to populate the fact and dimension tables by extracting data from the Northwind OLTP database and loading the data into the tables within the Northwind Data Warehouse. Your ETL workflow should consist of selecting the required variables from the source database and tables and inserting the required variables into the destination database and tables. After you have populated the tables, construct an SQL command to count the number of rows in each table. Capture a screenshot of the row count for each table. Finally, construct an SQL command to list the first ten rows of each table. Capture a screenshot of each listing.

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

• Changes to your business process, business questions, and fact table grain from Module 5

• Updated version of the star schema incorporating your instructor's feedback from Module 5

• Screenshots of the row counts and table listings

• Listing of SQL commands used in this assignment

• A brief description of lessons learned in completing the Portfolio Project and the two Milestones. Based on your lessons learned, what advice would be offer to an organization embarking on building a data warehouse system?

Reference no: EM132653619

Questions Cloud

Differences between sensors and intuitors : What are the differences between sensors and intuitors? List some examples.

MGT602 Business Decision Analytics Assignment : MGT602 Business Decision Analytics Assignment Help and Solution, Laureate International Universities - Assessment Writing Service

Compute the profit per customer for the retail customer : Compute the profit (loss) per customer for the retail customer and business customer first using original cost system then using the ABC System.

Difference between deterministic and probabilistic models : What is the difference between deterministic and probabilistic models? what are some example of each type of model.

What advice would be offer to an organization : Develop and execute the SQL commands to populate the fact and dimension tables by extracting data from the Northwind OLTP database and loading the data.

Do think the original cost system is broken : Based on the case, do you think the original cost system is "broken"? Why? And if your answer is yes, how can it be improved? Explain in detail.

Marketing in the achievement of business objectives : Discuss promotion and describe the role of marketing in the achievement of business objectives.

Do think bank incentive bonus plan to increase : Do you think bank's incentive bonus plan to increase the number of customers is wise? What changes, if any, would you recommend?

Identify two highly attractive opportunities for ucb : Identify two highly attractive opportunities for UCB to use data and analytics, and answer the following questions for each opportunity:

User Account

All Pages