
Ultimate access to all questions.
You have been given a dataset from a retail company containing sales data with fields such as 'Date', 'StoreID', 'ProductID', 'SalesAmount', and 'PromotionFlag'. Your task is to perform exploratory analytics to uncover patterns and insights that could improve sales strategies. Describe the steps you would take, including the types of analyses you would perform and the visualizations you would use in Microsoft Fabric to represent your findings.
A
Use SQL to group data by StoreID and ProductID, then use pie charts for visualizations.
B
Aggregate data by Date and SalesAmount, then use bar charts and line charts for visualizations.
C
Filter data by PromotionFlag and analyze correlations with other variables using heat maps.
D
Sort data by Date and use scatter plots for visualizations.