SuperSale is a global supermarket chain that operates in multiple countries, offering a wide range of products across three main categories: Furnitu

Scenario

SuperSale is a global supermarket chain that operates in multiple countries, offering a wide range of products across three main categories: Furniture, Technology, and Office Supplies. With a vast customer base and a large inventory, SuperSale generates a substantial amount of sales data.

The senior management of SuperSale possesses a comprehensive dataset that records each sale transaction. This dataset includes detailed information such as:

Customer Details: Name and ID.

Geographic Information: Location of the store, regional data, etc.

Product Information: Product name, category, sub-category etc.

Transaction Details: Date and time of sale, quantity purchased, total sale amount, profit amount, possible discounts applied, etc.

Logistics Information: Shipping mode, such as same day delivery, first, second and standard class deliveries.

The senior management recognises the importance of leveraging this rich dataset to extract valuable insights that can inform both strategic and tactical decision-making processes. They aim to use data-driven approaches to enhance customer satisfaction, optimise inventory management, improve operational efficiency, and drive revenue growth.

Some of the key objectives and areas of interest for the senior management include:

Customer Segmentation: Understanding the diverse customer base to tailor marketing strategies and product offerings accordingly. Analysing customer demographics, preferences and purchasing behaviour.

Product Performance Analysis: Evaluating the performance of products within each category to identify best-selling items, slow-moving inventory, and trends over time. Assessing factors such as sales volume, profit margins, seasonality, and product popularity.

Market Expansion Opportunities: Identifying potential growth markets and regions for expansion based on geographic sales data, population demographics, and market demand analysis.

Supply Chain Optimisation: Optimising inventory levels, distribution networks, and logistics operations to minimise costs, reduce lead times, and ensure timely delivery of products to customers.

Promotion and Pricing Strategies: Developing effective promotional campaigns, discount offers, and pricing strategies to attract customers, drive sales, and maximise profitability.

By harnessing the power of data analytics and a suitable business intelligence tool, such as Tableau, the senior management of SuperSale aims to gain actionable insights that will enable them to make informed decisions and stay competitive in the dynamic retail market landscape. As such, they have approached you to utilise your data analytics skills and extract the following insights for them.

Using the Global Superstore dataset:

Create a simple bar chart in Tableau that displays the total sales revenue for each region. Add labels to the bars to show the exact sales amount for each region. (5 marks)

Create a stacked bar chart in Tableau to visualise the distribution of sales revenue across different product sub-categories within the Furniture category. Include a reference line to show the overall average sales revenue for the Furniture category. (5 marks)

Implement a time series analysis in Tableau to identify seasonality patterns in sales revenue for the Technology category. Use a line chart to visualise the monthly sales trend over the past 3 years and highlight any recurring patterns or spikes in sales. (10 marks)

Develop a calculated field in Tableau to calculate the average shipping time for each product category. Create a table to display the average shipping time alongside the product categories. Allow users to filter the table by selecting a specific product category using a parameter. (10 marks)

Utilise calculated fields in Tableau to calculate the average discount percentage for each customer segment. Create a dual-axis combination chart to compare the average discount percentage and total sales revenue for each customer segment. (10 marks)

Design a calculated field in Tableau to calculate the cumulative profit margin for each month. Create a waterfall chart to visualise the cumulative profit margin over time and identify periods of significant growth or decline. (10 marks)

Implement a parameter in Tableau that allows users to select a specific year. Create a line chart showing the monthly trend of total sales revenue for the selected year. Include a trend line to highlight the overall sales trend throughout the year. (10 marks)

Develop a parameter in Tableau that allows users to select a specific product sub-category. Create a treemap visualisation to display the sales revenue contribution of each product within the selected sub-category. Include labels to show the exact sales amount for each product. (10 marks)

Design a dashboard in Tableau that includes a map visualisation showing the distribution of sales revenue across different countries. Add tooltips to display detailed information about sales revenue and quantity when hovering over each country. (10 marks)

Create an advanced dashboard in Tableau that integrates multiple visualisations, filters, and parameters to provide a comprehensive analysis of the Global Superstore's performance. Incorporate interactive elements such as highlight actions, dashboard actions, and URL actions to enhance user interactivity and exploration of the data.

(20 marks)

Marking Criteria

Descriptor Fail (0-39) Pass (40-49) Good (50-59) Very Good (60-69) Excellent (70+)

Understanding of management needs and scenario Lacks understanding of management objectives and scenario context. Partial understanding of management objectives and scenario context. Adequate understanding of management objectives and scenario context. Good understanding of management objectives and scenario context. Comprehensive understanding of management objectives and scenario context.

Visualisation clarity and effectiveness Visualisations are unclear, cluttered, or misleading, hindering interpretation. Visualisations are somewhat clear but may lack appropriate labelling or context. Visualisations are clear and effectively convey key insights with appropriate labelling and context. Visualisations are highly clear, visually appealing, and effectively communicate key insights. Visualisations are exceptional in clarity, aesthetics, and communication of insights.

Mastery of Tableau functionality Demonstrates poor command of Tableau functionality, resulting in inaccurate or incomplete analysis. Displays basic proficiency in Tableau functionality but may struggle with more advanced features. Demonstrates competent use of Tableau functionality, applying a range of techniques effectively. Displays advanced proficiency in Tableau functionality, utilising advanced features and techniques with ease. Demonstrates mastery of Tableau functionality, utilising advanced features creatively to produce exceptional analysis.

Depth of analysis and insightfulness Analysis lacks depth and fails to uncover meaningful insights or connections. Analysis provides some insights but may lack depth or overlook certain aspects of the data. Analysis demonstrates a good level of depth and insightfulness, uncovering valuable insights and connections within the data. Analysis is highly insightful, providing thorough exploration and interpretation of the data to uncover significant insights. Analysis is exceptionally insightful, demonstrating profound understanding and uncovering nuanced insights that drive actionable recommendations.

Clarity and organisation of presentation Presentation lacks structure, coherence, and fails to effectively communicate findings. Presentation is somewhat organised but may lack clarity or coherence in communicating findings. Presentation is well-organised, clear, and effectively communicates findings with logical flow and coherence. Presentation is highly organised, clear, and concise, effectively communicating findings with compelling storytelling and coherence. Presentation is exceptionally well-organised, clear, and engaging, demonstrating mastery in communication and compelling storytelling to convey insights effectively.