Q1 Decision makers in XYZ company need to analyze the organization's financial performance in order to determine whether departments' expenditures are over or under budget thus, deriving actionable decisions. Table 1 provides information extracted from the organization's data warehouse on the budgeted expenses against actual expenses of the company's departments over one year period of time. Q1 Qi Q2 Q2 Q3 Q3 04 Q4 Dept. Budget Actual Budget Actual Budget Actual Budget Actual Distribution 390,000 375,000 395,000 382,000 400,000 390,000 410,000 408,000 Facilities 675,000 693,000 800,000 837,000 750,000 713,000 750.000 790,000 HR 350,000 346,000 350,000 342,000 350,000 340,000 350,000 367,000 IS 950,000 925.000 850,000 890,000 875.000 976,000 900.000 930,000 Table 1: Departments' yearly performance A) Use the most appropriate basic visual chart covered in class to show, for each department, the percentage variance between the budgeted and actual exrences over each of the four quarters. Variance%= ((budgeted expense - actual expense)/ actual expense)* 100(a positive value indicates that the departmentis spending less than the budgeted amount, whereas negative values indicate that expenses are more than anticipated). B) Use the most appropriate basicvisual chart covered in class to visualize the difference between the departments' overall budget values against overall actual values over the four quarters. C) As a decision maker, draw one informative conclusion from each chart (A) and (B) using your own words. Q2 Suppose that a data warehouse consists of the three dimensions, supplier[surname, type] customer[cust name, email, mobile), location[street, city, country), and the two measures units..seld and sales amount(in SAR). A) Draw a Star schema diagram for the above data warehouse. Include the appropriate attributes for dimension and factor tables (DT and FT).B) Explain how Snowflake schema can provide better representation over Star schema. In the given 3D warehouse above, determine which DT will be affected when implementing the Snowflake model? C) What specific OLAP operations (roll-up, drill down, dice, slice) should be performed (based on the above schema (A)) in order to list the total sales of each supplier in Saudi Arabia? Q1 Decision makers in XYZ company need to analyze the organization's financial performance in order to determine whether departments' expenditures are over or under budget thus, deriving actionable decisions. Table 1 provides information extracted from the organization's data warehouse on the budgeted expenses against actual expenses of the company's departments over one year period of time. Q1 Qi Q2 Q2 Q3 Q3 04 Q4 Dept. Budget Actual Budget Actual Budget Actual Budget Actual Distribution 390,000 375,000 395,000 382,000 400,000 390,000 410,000 408,000 Facilities 675,000 693,000 800,000 837,000 750,000 713,000 750.000 790,000 HR 350,000 346,000 350,000 342,000 350,000 340,000 350,000 367,000 IS 950,000 925.000 850,000 890,000 875.000 976,000 900.000 930,000 Table 1: Departments' yearly performance A) Use the most appropriate basic visual chart covered in class to show, for each department, the percentage variance between the budgeted and actual exrences over each of the four quarters. Variance%= ((budgeted expense - actual expense)/ actual expense)* 100(a positive value indicates that the departmentis spending less than the budgeted amount, whereas negative values indicate that expenses are more than anticipated). B) Use the most appropriate basicvisual chart covered in class to visualize the difference between the departments' overall budget values against overall actual values over the four quarters. C) As a decision maker, draw one informative conclusion from each chart (A) and (B) using your own words. Q2 Suppose that a data warehouse consists of the three dimensions, supplier[surname, type] customer[cust name, email, mobile), location[street, city, country), and the two measures units..seld and sales amount(in SAR). A) Draw a Star schema diagram for the above data warehouse. Include the appropriate attributes for dimension and factor tables (DT and FT).B) Explain how Snowflake schema can provide better representation over Star schema. In the given 3D warehouse above, determine which DT will be affected when implementing the Snowflake model? C) What specific OLAP operations (roll-up, drill down, dice, slice) should be performed (based on the above schema (A)) in order to list the total sales of each supplier in Saudi Arabia