Hi, I need help with the next sql business intelligent exercises.

Concept Question 1.1: What are the specific fact(s) that need to be tracked? I.e., what are the specific facts shown in 3D column chart? Concept Question 1.2: List the dimension attributes displayed in Figure 2.

figure 2

Concept Question 1: Suker Data Warehouse David Suker, the inventory manager for a marketing research company, wants to study the use of supplies within the different company departments. Suker's friend Ephanor, has developed a spreadsheet-based data warehouse model that she uses in her analysis of sales data. The Excel pivot table report is shown below in Figure 1 1 Year 2011 3 Sum of Value Region 4 Product 5 Balls 6 Erasers 7 Pencils East North South West ota 100 225 110 105 25180 70 90 20 60 155 10 ear AIl 13 Produc 15 Sum of Value Region 16 Agent 17 Carlos 18 Mary 19 Tere 20 Victor 21 Total East North 95 South West ota 150 60 100 20 25 300 330 100 372 334 1,336 30 125 160 259 145 12 Figure 1 Suker is interested in developing a data warehouse model like Ephanor's so he can analyze orders by department and by product. David has used Excel to produce a 3D Exploded Column Chart that is show in Figure 2