Mid Term Test
Marks(25)
Time : 90 Minutes
Outline: Sales & Profit Overview - Design Superstore Dashboard
Task 1: Title
● Title: Sales & Profit Overview - Tableau Dashboard
● Subtitle: Sample Superstore Dataset
● Your Name | Roll No. | Date
Task 2: Introduction
● Project Goal: Analyze sales and profit patterns using Tableau
● Dataset: Sample - Superstore (built-in Tableau dataset)
Task 3: Objectives
● Identify top-selling products
● Analyze sales by region and category
● Track monthly sales trends
● Provide interactive filters (Year, Region)
Task 4: Data Source
● Dataset: Sample - Superstore
● Fields Used: Sales, Profit, State, Category, Sub-Category, Order Date, Region
Task 5: Dashboard Overview
● Insert full screenshot of your Tableau dashboard
● Highlight key components: Map, Bar Chart, Line Chart, Pie Chart, Filters
Task 6: Visualizations Explained
● Map: Sales by State
● Bar Chart: Top 10 Products
● Pie Chart: Sales by Category
● Line Chart: Monthly Sales Trend
● Filters: Order Date (Year), Region
Task 7: Explain Key Insights
● Best performing states and regions
● Top categories and products
● Seasonal trends and monthly peaks
Task 8: Write Data Summary report based on assignment.
● Tableau dashboard enables data-driven decision making
● Highlights strengths, opportunities, and improvement