Reference no: EM133481338

Question 1: What was the total sales revenue for each product during the last month?

Question 2: Which supplier had the highest total sales in the last quarter?

Question 3: Which branch had the highest total sales in the last year, and what was the total sales revenue for that branch?

Question 4: Which sales clerk had the highest total sales in the last six months, and what was their total sales revenue?

Question 5: What was the trend in sales revenue for each product type by sales clerk over the last year, broken down by month?

Question 6: Identify the top three performing branches in terms of total sales revenue over the last year, and compare their sales performance by product type and supplier.
Based on the 6 question,

the most appropriate level of granularity for your Fact Table, considering the analyses required.

Explain why you chose that level of granularity for the Fact Table, discussing the benefits and suitability of your choice.

Identify and discuss alternative granularity levels you considered and explain why these alternatives were not chosen.