
Ultimate access to all questions.
You are tasked with implementing descriptive analytics on a dataset containing sales data from a retail chain spanning the last five years. The dataset includes fields such as 'Date', 'StoreID', 'ProductID', 'SalesAmount', and 'CustomerID'. Describe the steps you would take to analyze this data to identify trends in sales, seasonal variations, and the performance of individual stores. Include in your answer how you would use SQL queries to aggregate the data and what visualizations you would employ in Microsoft Fabric to represent the findings.
A
Use SQL to group data by StoreID and ProductID, then use bar charts for visualizations.
B
Aggregate data by month and year using SQL, then use line charts and heat maps for visualizations.
C
Sort data by SalesAmount and use pie charts for visualizations.
D
Filter data by CustomerID and use scatter plots for visualizations.