Completing portfolio project and two milestones

Assignment Help Basic Computer Science

Reference no: EM132652667

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: EM132652667

Questions Cloud

Data Science is vastly growing field : Data Science is vastly growing field. Part of what makes this such significant field to be in is its applicability to many other fields-nearly every industries

Identify the particular information provided by the company : Identify the particular information (i.e. the amount or any other specific information) provided by the company in their reports

Strategic knowledge management plan : You need to develop a formal succession plan. You need to develop a strategic knowledge management plan.

Calculate the balance of share capital and retained earnings : Calculate the balance of Share capital and Retained Earnings accounts at 31 December 2019 (Profit for the year ended 31 December 2019 was $800,000)

Completing portfolio project and two milestones : A brief description of lessons learned in completing the Portfolio Project and the two Milestones.

Which of the statements is wrong : Lalaine, Erin and Gia are partners with capital balances of P336,000, P540,000 and P190,000. Upon admission of Selena, which of following statements is wrong

Describe cloud-based collaboration : Define collaboration. Define and describe cloud-based collaboration. Evaluating a cloud-based collaborative solution.

Potential security-ethical-social-moral issue : Identify and describe one real or potential security/ethical/social/moral issue that is raised by Information System/Information Technology in your environment

Establishing security culture : Review the section on Establishing a Security Culture. Review the methods to reduce the chances of a cyber threat noted in the textbook.

User Account

All Pages