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.