1:041 M2 Assignments 19SPCSCI580350 DATA WAREHOUSING The Quick Links give quick access to some of the climate data sources. You can also explore some of the other links in the left-hand side panel if you want to. step 2: Define Fact and Dimension Tables Apply the four-step dimensional design process to complete the following tasks: 1. Describe the business process the proposed data warehouse is going to model and how it involves the usage of weather data. (5 points) 2. After considering the grain of the fact table illustrate two dimension tables one dimension must be specifically on the weather data and measurements collected, the other dimension is of your choice as long as it is related to a usiness purpose described in the above task. (10 points) 3. Describe and illustrate the fact table for the proposed data warehouse. (10 points) The following requirements are specific for this assignment: of the data warehouse you Clearly identify the weather data sets (include the URL to the data) which the design of fact table is based on (5 Calendar To Do Inbox 1:041 M2 Assignments 19SPCSCI580350 DATA WAREHOUSING described in the above task. (10 points 3. Describe and illustrate the fact table for the proposed data warehouse. (10 points) The following requirements are specific for this assignment Clearly identify the weather data sets (include the URL to the data) which the design of fact table is based on (5 points). Your data may come from any data source linked in the above web page Follow the examples in Chapter 3 to define and illustrate the fact table. Use clear descriptive labels to identify the data Illustrate the dimensions linked to the fact table, again as shown in the examples in Chapter 3; Save your design and decision making process in a document. e . You may use Word or Excel to complete this assignment and create your ta document as Climate FS where FS are your first and last name initials. bles. Name y our Submit the document here. Calendar To Do Inbox 1:041 M2 Assignments 19SPCSCI580350 DATA WAREHOUSING The Quick Links give quick access to some of the climate data sources. You can also explore some of the other links in the left-hand side panel if you want to. step 2: Define Fact and Dimension Tables Apply the four-step dimensional design process to complete the following tasks: 1. Describe the business process the proposed data warehouse is going to model and how it involves the usage of weather data. (5 points) 2. After considering the grain of the fact table illustrate two dimension tables one dimension must be specifically on the weather data and measurements collected, the other dimension is of your choice as long as it is related to a usiness purpose described in the above task. (10 points) 3. Describe and illustrate the fact table for the proposed data warehouse. (10 points) The following requirements are specific for this assignment: of the data warehouse you Clearly identify the weather data sets (include the URL to the data) which the design of fact table is based on (5 Calendar To Do Inbox 1:041 M2 Assignments 19SPCSCI580350 DATA WAREHOUSING described in the above task. (10 points 3. Describe and illustrate the fact table for the proposed data warehouse. (10 points) The following requirements are specific for this assignment Clearly identify the weather data sets (include the URL to the data) which the design of fact table is based on (5 points). Your data may come from any data source linked in the above web page Follow the examples in Chapter 3 to define and illustrate the fact table. Use clear descriptive labels to identify the data Illustrate the dimensions linked to the fact table, again as shown in the examples in Chapter 3; Save your design and decision making process in a document. e . You may use Word or Excel to complete this assignment and create your ta document as Climate FS where FS are your first and last name initials. bles. Name y our Submit the document here. Calendar To Do Inbox
