Tableau Sales Trends Dashboard

The goal of this assignment is to develop a dynamic and interactive sales dashboard using Tableau, leveraging the dataset from Gourmet Goods Inc. and designing visualizations similar to the provided sales dashboard in the videos below. Scenario: Gourmet Goods Inc. is a fast-growing retail company that wants better insights into sales performance, marketing impact, and consumer behavior. The marketing team has requested a comprehensive sales dashboard to track key performance indicators (KPIs) and visualize trends in sales, customer segments, and regional performance. As a Marketing Analyst, you have been tasked with developing an interactive Tableau dashboard that provides a detailed overview of sales trends, customer segmentation, and marketing performance. Assignment Requirements Using Tableau, you must create a Sales & Marketing Dashboard similar to the video below that includes the following components: 1. KPI Overview Section Total Sales ($) Total Profit ($) Total Quantity Sold (#) Show % Year-Over-Year (YoY) Change for each KPI. Include trend lines for sales and profit performance over time. 2. Sales and Profit Distribution by State Create a map visualization highlighting total sales and total profit by U.S. states. Use color coding to differentiate high- and low-performing states. Add filters for different time periods and product categories. 3. Monthly Sales Breakdown by Segment Design a line chart or area chart showing monthly sales trends for different customer segments: Direct Online Retail Wholesale Highlight the highest revenue-generating segment and key seasonal trends. 4. Total Sales by Location and Manager Create a bar chart showing sales performance by region and sales manager. Categorize regions into: West East Central South Identify top-performing managers and regions for marketing campaign effectiveness. 5. Marketing Performance Insights Compare sales before and after marketing campaigns to evaluate impact. Identify which product categories or regions respond best to marketing efforts. Use calculated fields in Tableau to create a Marketing ROI analysis. Deliverables Tableau Dashboard (.twbx or .twb file) with interactive features. Short Report (1-2 pages) summarizing: Key marketing and sales insights from the dashboard. Any challenges faced and how they were addressed. Marketing recommendations for future strategy. Submission Guidelines Submit your Tableau dashboard file and summary report via the course portal. Ensure your visualizations are clear, well-labeled, and interactive. Use appropriate colors and formatting for readability. Include a 20 - 25 minute presentation video where you walk through the workings of the dashboard and a brief summary of the analysis. The presentation should cover:Overview of the Dashboard: Introduce the key metrics and visualizations included. Data Sources and Preparation: Explain the data cleaning and preparation steps and highlight key aspects of your analysis. Detailed Walkthrough: Go through each visualization, explaining what it shows and why it is important. Key Insights and Observations: Summarize the main findings and insights from the data. Technical Aspects: Briefly discuss any technical challenges or interesting techniques used in creating the dashboard. Getting Started Open Gourmet Goods Inc. Data Set in Tableau. Identify key sales and marketing metrics to analyze. Create the dashboard layout similar to the example in the video below. Use filters, parameters, and calculated fields to generate meaningful insights. Getting Started with Tableau: What Is Tableau? Tableau is a stand-alone data visualization software that has gained tremendous popularity for its attractive output, versatility, and ease of use. Tableau is designed to allow users with little technical experience to develop attractive visualizations interactively and to drill down the data for business insights. Users can easily switch between different visualizations to select the most compelling graphs for their storytelling. In addition, Tableau allows users to create interactive dashboards, which can display real-time data, to support business decision-making. Note on Accessing Tableau for Your Assignment For this assignment, you can use Tableau Public, a free and user-friendly platform to create and share interactive data visualizations. What is Tableau Public? Tableau Public is a free platform that allows you to explore, design, and publicly share your data visualizations (also known as vizzes). You can create vizzes directly through the web authoring tool or by downloading the Tableau Desktop Public Edition at no cost. If you already have Tableau Desktop Professional Edition, you can still publish your work to Tableau Public for free. Why use Tableau Public? It’s free and accessible It provides millions of public visualizations to explore and learn from It helps you build your data skills You can create an online portfolio of your work You’ll be part of a global data community that shares, collaborates, and grows together To get started, visit: https://public.tableau.com/