Tableau dataset and practice question

  super store dataset

https://docs.google.com/spreadsheets/d/1CHSrauCoUlwtEbNtFOxE3FVXjo7vh6cN/edit?usp=sharing&ouid=105173447805752617719&rtpof=true&sd=true

 

  Sales Trends Visualization

  • : Create a line chart that aggregates Sales by Order Date (grouped by month or quarter).
  • : Add a filter for Ship Mode or Region to compare performance across segments.

  Product Performance Analysis

  • : Build a bar chart or tree map using Category and Sub-Category to display Sales, Profit, and Quantity.
  • : Highlight the top-performing and underperforming products by sorting based on Profit.

  Customer Segmentation

  • : Develop a view that segments customers by using the Customer ID/Name and Segment fields.
  • : Enable filters so users can drill down into specific segments (e.g., Consumer vs. Corporate) to see purchasing patterns.

  Geographic Insights

  • : Create a map visualization using the Country, Region, State, and City fields to show sales distribution.
  • : Integrate tooltips that display additional details like Sales and Profit when hovering over a region.

  Shipping Efficiency

  • : Create a calculated field (e.g., Shipping Delay = Ship Date – Order Date).
  • : Visualize shipping delays using a histogram or line chart to uncover trends and potential issues.

  Discount Impact Analysis

  • : Build a scatter plot to correlate Discount levels with Profit and Sales for various products.
  • : Identify the threshold where discounting starts affecting profitability negatively.

  Interactive Dashboard Design

  • : Assemble all the views into a single dashboard layout in Tableau.
  • : Add interactive filters and dashboard actions (e.g., drill-downs and cross-filtering) so users can click through to more detailed views.

 


Comments

Post a Comment

Popular posts from this blog

Power BI Practice

❓ Power BI Practice Data https://docs.google.com/spreadsheets/d/1qQ90Fru5QbNK8QjgPSVOSIlLcHFa2hXO/edit?usp=sharing&ouid=105173447805752617719&rtpof=true&sd=true Scenario: Retail Sales Performance Analysis Business Context: You are a Business Analyst at a retail chain called TrendZone . The company operates across multiple cities and sells four product categories: Electronics, Apparel, Home Decor, and Sports Equipment. Management wants to understand sales performance, profitability, and customer purchasing behavior. ❓ Power BI Practice Questions 🔹 Level 1: Basic Reporting Create a bar chart showing total sales by ProductCategory . Show a table with CustomerName, City, and their TotalSales . Use a slicer to filter data by Region and see how total profit changes. What is the average discount given per product category ? 🔹 Level 2: Intermediate DAX & Modeling Create a new calculated column: NetSales = TotalSales - Discount . Create a measure for ...
Read more

TIME SERIES ANAYSIS DATASET

 https://docs.google.com/spreadsheets/d/1Ans3hkk0RuC9tMLq8X83bFYA_6Zux8K6/edit?usp=sharing&ouid=105173447805752617719&rtpof=true&sd=true basic practice data above.. ------------------------------------------------------------------------------ ☕ Scenario: Coffee Shop Monthly Sales (Excel Practice) Context: You are analyzing monthly sales data for a chain of 5 coffee shops (Central, North, South, East, West) from January 2022 to December 2024 . 📊 Practice Tasks (for Excel) Line Chart: Plot monthly sales trend for each branch. Moving Average: Calculate 3-month and 6-month moving averages. Growth Rate: Compute month-over-month and year-over-year growth. Seasonality Check: Identify months with consistently higher or lower sales. Branch Comparison: Create a line chart comparing all 5 branches. Forecasting (Basic): Use Excel’s trendline feature to project next 6 months. Practice Dataset https://docs.google.com/spreadsheets/d/1JKiaBWRzur3E_ySpfdMOZ...
Read more