Project: Visualizing Sales Data in Python0%

Project: Visualizing Sales Data in Python

Intermediate8 min read•Updated: 2026-10-01

Project: Visualizing Sales Data

In this capstone project, we bring together all the data visualization capabilities mastered throughout this chapter—Matplotlib's Object-Oriented Architecture, Line & Bar Charts, Donut Charts, Seaborn Aesthetics, and Multi-Panel Dashboards—to build an automated Executive Sales Analytics Visual Dashboard.

1. Project Overview & Dashboard Layout

Our application processes retail transactional sales data and generates a high-resolution, publication-quality 4-panel visual dashboard (sales_dashboard.png):

Visual Architecture Blueprint

+-------------------------------------------------------------------+
|               EXECUTIVE RETAIL SALES DASHBOARD (2026)             |
+---------------------------------+---------------------------------+
|  Panel 1: Monthly Trend         |  Panel 2: Category Breakdown    |
|  - Continuous Line Chart        |  - Horizontal Bar Chart         |
|  - Fill-between area            |  - Value annotations            |
+---------------------------------+---------------------------------+
|  Panel 3: Regional Share        |  Panel 4: Units Sold Spread     |
|  - Modern Donut Chart           |  - Seaborn Boxplot by Region    |
|  - Percentage contributions     |  - Outlier & median detection   |
+---------------------------------+---------------------------------+

2. Complete Project Implementation

1import matplotlib.pyplot as plt
2import seaborn as sns
3import numpy as np
4 
5 
6# -------------------------------------------------------------
7# 1. Dataset Initialization
8# -------------------------------------------------------------
9months = ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"]
10monthly_revenue = [120, 135, 148, 162, 190, 220, 215, 240, 265, 290, 340, 410] # in Lakhs INR
11 
12categories = ["Electronics", "Fashion", "Home & Kitchen", "Books", "Beauty"]
13category_revenue = [850, 620, 480, 290, 210]
14 
15regions = ["North", "South", "West", "East"]
16regional_sales = [38, 28, 22, 12]
17 
18# Simulated transaction-level distribution data
19np.random.seed(42)
20trans_data = {
  "Region": np.repeat(regions, 50),
  "Units_Sold": np.concatenate([
      np.random.normal(45, 10, 50),  # North
      np.random.normal(38, 8, 50),   # South
      np.random.normal(32, 7, 50),   # West
      np.random.normal(25, 5, 50),   # East
  ])
28}
29 
30 
31# -------------------------------------------------------------
32# 2. Building the Visual Dashboard
33# -------------------------------------------------------------
34def generate_sales_dashboard():
  # Set modern Seaborn visual theme
  sns.set_theme(style="whitegrid", font="sans-serif")
  
  # Create 2x2 multi-panel figure
  fig, axs = plt.subplots(2, 2, figsize=(14, 10))
  fig.suptitle("EXECUTIVE RETAIL SALES & PERFORMANCE DASHBOARD (2026)", 
               fontsize=16, fontweight="bold", y=0.98, color="#0f172a")
42 
  # ---------------------------------------------------------
  # Panel 1 (Top-Left): Monthly Revenue Growth (Line Plot)
  # ---------------------------------------------------------
  ax1 = axs[0, 0]
  ax1.plot(months, monthly_revenue, color="#2563eb", linewidth=2.8, marker="o", markersize=6, label="Revenue")
  ax1.fill_between(months, monthly_revenue, color="#3b82f6", alpha=0.15)
  ax1.set_title("Monthly Revenue Trajectory (₹ Lakhs)", fontsize=12, fontweight="bold", pad=10)
  ax1.set_ylabel("Revenue (₹ Lakhs)")
  ax1.set_ylim(0, 450)
  
  # Annotate peak Q4 festive season
  ax1.annotate(
      "Diwali & Holiday Peak\n(₹410 L)",
      xy=(11, 410),
      xytext=(8.5, 360),
      arrowprops=dict(facecolor="#1e3a8a", arrowstyle="->", lw=1.5),
      fontweight="bold",
      fontsize=9,
      bbox=dict(boxstyle="round,pad=0.3", fc="#eff6ff", ec="#3b82f6")
  )
63 
  # ---------------------------------------------------------
  # Panel 2 (Top-Right): Revenue by Product Category (Barh)
  # ---------------------------------------------------------
  ax2 = axs[0, 1]
  palette = ["#1e40af", "#3b82f6", "#60a5fa", "#93c5fd", "#bfdbfe"]
  bars = ax2.barh(categories[::-1], category_revenue[::-1], color=palette[::-1], height=0.6)
  ax2.set_title("Annual Revenue by Category (₹ Lakhs)", fontsize=12, fontweight="bold", pad=10)
  ax2.set_xlabel("Total Sales (₹ Lakhs)")
  
  # Annotate values directly at bar edges
  for bar in bars:
      w = bar.get_width()
      ax2.text(w + 15, bar.get_y() + bar.get_height()/2, f"₹{w} L", 
               va="center", fontsize=9, fontweight="bold", color="#334155")
  ax2.set_xlim(0, 1000)
79 
  # ---------------------------------------------------------
  # Panel 3 (Bottom-Left): Regional Sales Share (Donut Chart)
  # ---------------------------------------------------------
  ax3 = axs[1, 0]
  donut_colors = ["#0284c7", "#0d9488", "#f59e0b", "#e11d48"]
  wedges, texts, autotexts = ax3.pie(
      regional_sales,
      labels=regions,
      autopct="%1.1f%%",
      startangle=120,
      colors=donut_colors,
      pctdistance=0.75,
      wedgeprops=dict(width=0.45, edgecolor="white", linewidth=2)  # Donut hole!
  )
  for at in autotexts:
      at.set_color("white")
      at.set_weight("bold")
  ax3.set_title("Regional Revenue Contribution", fontsize=12, fontweight="bold", pad=10)
98 
  # ---------------------------------------------------------
  # Panel 4 (Bottom-Right): Transaction Units Distribution (Seaborn Boxplot)
  # ---------------------------------------------------------
  ax4 = axs[1, 1]
  sns.boxplot(
      data=trans_data, 
      x="Region", 
      y="Units_Sold", 
      palette="Blues_d", 
      ax=ax4,
      boxprops=dict(alpha=0.85)
  )
  ax4.set_title("Order Volume Distribution by Region", fontsize=12, fontweight="bold", pad=10)
  ax4.set_ylabel("Units Sold per Order")
113 
  # Clean up layout and save to disk
  plt.tight_layout(rect=[0, 0, 1, 0.95])
  
  output_filename = "sales_dashboard.png"
  fig.savefig(output_filename, dpi=300, bbox_inches="tight")
  print(f"Sales Dashboard successfully generated and exported to '{output_filename}'.")
  plt.close(fig)
121 
122 
123if __name__ == "__main__":
  generate_sales_dashboard()

3. Sample Execution Simulation

1Sales Dashboard successfully generated and exported to 'sales_dashboard.png'.

The resulting sales_dashboard.png image provides a clean 300 DPI executive graphic combining four key statistical and operational perspectives in a unified palette.

⚠️ Common Intermediate Mistakes & Gotchas

1. Memory Leaks During Multi-Figure Generation

When generating hundreds of charts in an automated reporting loop, always call plt.close(fig) after saving each figure to free GUI canvas memory.

2. Misleading Zero-Baseline Truncation

Truncating the Y-axis baseline on bar charts exaggerates minor differences between categories, leading to misleading data interpretation.

💻 Try It Yourself: Extension Challenge - Category Breakdown Pie Chart

Challenge

Add a sub-plot chart to the Sales Data Visualizer displaying percentage sales contribution by product category using a donut pie chart.

Complete Solution

1import matplotlib.pyplot as plt
2 
3categories = ["Electronics", "Apparel", "Home Goods", "Books"]
4sales = [450000, 280000, 190000, 80000]
5colors = ["#3b82f6", "#10b981", "#f59e0b", "#8b5cf6"]
6 
7plt.figure(figsize=(6, 6))
8wedges, texts, autotexts = plt.pie(
9    sales, labels=categories, autopct="%1.1f%%", colors=colors,
10    startangle=140, pctdistance=0.82
11)
12# Draw center circle for donut chart
13centre_circle = plt.Circle((0, 0), 0.65, fc="white")
14plt.gca().add_artist(centre_circle)
15 
16plt.title("Sales by Product Category", fontsize=14, fontweight="bold")
17plt.tight_layout()
18plt.savefig("category_donut.png", dpi=150)
19print("Donut pie chart saved to 'category_donut.png'.")
20plt.close()

Expected Output

1Donut pie chart saved to 'category_donut.png'.

Interactive Quiz• Knowledge Check

Practice Quiz

Question 1

In our dashboard project, what makes Panel 3 render as a "Donut Chart" rather than a standard solid pie chart?

Question 2

Which method was used in Panel 1 to shade the region beneath the revenue trajectory line?

Question 3

Why does the script execute plt.close(fig) at the conclusion of dashboard generation?

Question 4

What is the role of y=0.98 in fig.suptitle(..., y=0.98)?

Question 5

What statistical insights does the Seaborn boxplot in Panel 4 communicate that a simple average bar chart cannot?

🚀 What's Next?

In the next lesson, we will continue your intermediate Python journey with Project 1: Expense Tracker with CSV (14: Intermediate Projects).

👉 Continue to Next Lesson: Project 1: Expense Tracker with CSV →

Next Lesson

Project 1: Expense Tracker with CSV

Continue learning with hands-on practice, examples, and exercises in the upcoming topic.

Related Lessons

Previous Lesson	Next Lesson
Seaborn Basics	Project 1: Expense Tracker with CSV

Practice Quiz

Test your understanding of this lesson with 5 questions. Each question has one correct answer.

Previous Next

PreviousPrevNext

MSK Institute • Shikohabad

Loading Page Content...

Preparing courses, live labs, and learning resources.सामग्री लोड हो रही है, कृपया प्रतीक्षा करें...

Connecting serverPlease wait...

💻 Practical Labs🚀 Free Demo📜 Verified Certificates

Project 1: Expense Tracker with CSV

Project: Visualizing Sales Data in Python

Intermediate8 min read•Updated: 2026-10-01

Study Materials Cheatsheet

Project: Visualizing Sales Data

1. Project Overview & Dashboard Layout

Our application processes retail transactional sales data and generates a high-resolution, publication-quality 4-panel visual dashboard (sales_dashboard.png):

Visual Architecture Blueprint

+-------------------------------------------------------------------+
|               EXECUTIVE RETAIL SALES DASHBOARD (2026)             |
+---------------------------------+---------------------------------+
|  Panel 1: Monthly Trend         |  Panel 2: Category Breakdown    |
|  - Continuous Line Chart        |  - Horizontal Bar Chart         |
|  - Fill-between area            |  - Value annotations            |
+---------------------------------+---------------------------------+
|  Panel 3: Regional Share        |  Panel 4: Units Sold Spread     |
|  - Modern Donut Chart           |  - Seaborn Boxplot by Region    |
|  - Percentage contributions     |  - Outlier & median detection   |
+---------------------------------+---------------------------------+

2. Complete Project Implementation

1import matplotlib.pyplot as plt
2import seaborn as sns
3import numpy as np
4 
5 
6# -------------------------------------------------------------
7# 1. Dataset Initialization
8# -------------------------------------------------------------
9months = ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"]
10monthly_revenue = [120, 135, 148, 162, 190, 220, 215, 240, 265, 290, 340, 410] # in Lakhs INR
11 
12categories = ["Electronics", "Fashion", "Home & Kitchen", "Books", "Beauty"]
13category_revenue = [850, 620, 480, 290, 210]
14 
15regions = ["North", "South", "West", "East"]
16regional_sales = [38, 28, 22, 12]
17 
18# Simulated transaction-level distribution data
19np.random.seed(42)
20trans_data = {
  "Region": np.repeat(regions, 50),
  "Units_Sold": np.concatenate([
      np.random.normal(45, 10, 50),  # North
      np.random.normal(38, 8, 50),   # South
      np.random.normal(32, 7, 50),   # West
      np.random.normal(25, 5, 50),   # East
  ])
28}
29 
30 
31# -------------------------------------------------------------
32# 2. Building the Visual Dashboard
33# -------------------------------------------------------------
34def generate_sales_dashboard():
  # Set modern Seaborn visual theme
  sns.set_theme(style="whitegrid", font="sans-serif")
  
  # Create 2x2 multi-panel figure
  fig, axs = plt.subplots(2, 2, figsize=(14, 10))
  fig.suptitle("EXECUTIVE RETAIL SALES & PERFORMANCE DASHBOARD (2026)", 
               fontsize=16, fontweight="bold", y=0.98, color="#0f172a")
42 
  # ---------------------------------------------------------
  # Panel 1 (Top-Left): Monthly Revenue Growth (Line Plot)
  # ---------------------------------------------------------
  ax1 = axs[0, 0]
  ax1.plot(months, monthly_revenue, color="#2563eb", linewidth=2.8, marker="o", markersize=6, label="Revenue")
  ax1.fill_between(months, monthly_revenue, color="#3b82f6", alpha=0.15)
  ax1.set_title("Monthly Revenue Trajectory (₹ Lakhs)", fontsize=12, fontweight="bold", pad=10)
  ax1.set_ylabel("Revenue (₹ Lakhs)")
  ax1.set_ylim(0, 450)
  
  # Annotate peak Q4 festive season
  ax1.annotate(
      "Diwali & Holiday Peak\n(₹410 L)",
      xy=(11, 410),
      xytext=(8.5, 360),
      arrowprops=dict(facecolor="#1e3a8a", arrowstyle="->", lw=1.5),
      fontweight="bold",
      fontsize=9,
      bbox=dict(boxstyle="round,pad=0.3", fc="#eff6ff", ec="#3b82f6")
  )
63 
  # ---------------------------------------------------------
  # Panel 2 (Top-Right): Revenue by Product Category (Barh)
  # ---------------------------------------------------------
  ax2 = axs[0, 1]
  palette = ["#1e40af", "#3b82f6", "#60a5fa", "#93c5fd", "#bfdbfe"]
  bars = ax2.barh(categories[::-1], category_revenue[::-1], color=palette[::-1], height=0.6)
  ax2.set_title("Annual Revenue by Category (₹ Lakhs)", fontsize=12, fontweight="bold", pad=10)
  ax2.set_xlabel("Total Sales (₹ Lakhs)")
  
  # Annotate values directly at bar edges
  for bar in bars:
      w = bar.get_width()
      ax2.text(w + 15, bar.get_y() + bar.get_height()/2, f"₹{w} L", 
               va="center", fontsize=9, fontweight="bold", color="#334155")
  ax2.set_xlim(0, 1000)
79 
  # ---------------------------------------------------------
  # Panel 3 (Bottom-Left): Regional Sales Share (Donut Chart)
  # ---------------------------------------------------------
  ax3 = axs[1, 0]
  donut_colors = ["#0284c7", "#0d9488", "#f59e0b", "#e11d48"]
  wedges, texts, autotexts = ax3.pie(
      regional_sales,
      labels=regions,
      autopct="%1.1f%%",
      startangle=120,
      colors=donut_colors,
      pctdistance=0.75,
      wedgeprops=dict(width=0.45, edgecolor="white", linewidth=2)  # Donut hole!
  )
  for at in autotexts:
      at.set_color("white")
      at.set_weight("bold")
  ax3.set_title("Regional Revenue Contribution", fontsize=12, fontweight="bold", pad=10)
98 
  # ---------------------------------------------------------
  # Panel 4 (Bottom-Right): Transaction Units Distribution (Seaborn Boxplot)
  # ---------------------------------------------------------
  ax4 = axs[1, 1]
  sns.boxplot(
      data=trans_data, 
      x="Region", 
      y="Units_Sold", 
      palette="Blues_d", 
      ax=ax4,
      boxprops=dict(alpha=0.85)
  )
  ax4.set_title("Order Volume Distribution by Region", fontsize=12, fontweight="bold", pad=10)
  ax4.set_ylabel("Units Sold per Order")
113 
  # Clean up layout and save to disk
  plt.tight_layout(rect=[0, 0, 1, 0.95])
  
  output_filename = "sales_dashboard.png"
  fig.savefig(output_filename, dpi=300, bbox_inches="tight")
  print(f"Sales Dashboard successfully generated and exported to '{output_filename}'.")
  plt.close(fig)
121 
122 
123if __name__ == "__main__":
  generate_sales_dashboard()

3. Sample Execution Simulation

1Sales Dashboard successfully generated and exported to 'sales_dashboard.png'.

The resulting sales_dashboard.png image provides a clean 300 DPI executive graphic combining four key statistical and operational perspectives in a unified palette.

⚠️ Common Intermediate Mistakes & Gotchas

1. Memory Leaks During Multi-Figure Generation

When generating hundreds of charts in an automated reporting loop, always call plt.close(fig) after saving each figure to free GUI canvas memory.

2. Misleading Zero-Baseline Truncation

Truncating the Y-axis baseline on bar charts exaggerates minor differences between categories, leading to misleading data interpretation.

💻 Try It Yourself: Extension Challenge - Category Breakdown Pie Chart

Challenge

Add a sub-plot chart to the Sales Data Visualizer displaying percentage sales contribution by product category using a donut pie chart.

Complete Solution

1import matplotlib.pyplot as plt
2 
3categories = ["Electronics", "Apparel", "Home Goods", "Books"]
4sales = [450000, 280000, 190000, 80000]
5colors = ["#3b82f6", "#10b981", "#f59e0b", "#8b5cf6"]
6 
7plt.figure(figsize=(6, 6))
8wedges, texts, autotexts = plt.pie(
9    sales, labels=categories, autopct="%1.1f%%", colors=colors,
10    startangle=140, pctdistance=0.82
11)
12# Draw center circle for donut chart
13centre_circle = plt.Circle((0, 0), 0.65, fc="white")
14plt.gca().add_artist(centre_circle)
15 
16plt.title("Sales by Product Category", fontsize=14, fontweight="bold")
17plt.tight_layout()
18plt.savefig("category_donut.png", dpi=150)
19print("Donut pie chart saved to 'category_donut.png'.")
20plt.close()

Expected Output

1Donut pie chart saved to 'category_donut.png'.

Interactive Quiz• Knowledge Check

Practice Quiz

Question 1

In our dashboard project, what makes Panel 3 render as a "Donut Chart" rather than a standard solid pie chart?

Question 2

Which method was used in Panel 1 to shade the region beneath the revenue trajectory line?

Question 3

Why does the script execute plt.close(fig) at the conclusion of dashboard generation?

Question 4

What is the role of y=0.98 in fig.suptitle(..., y=0.98)?

Question 5

What statistical insights does the Seaborn boxplot in Panel 4 communicate that a simple average bar chart cannot?

🚀 What's Next?

In the next lesson, we will continue your intermediate Python journey with Project 1: Expense Tracker with CSV (14: Intermediate Projects).

👉 Continue to Next Lesson: Project 1: Expense Tracker with CSV →

Next Lesson

Project 1: Expense Tracker with CSV

Continue learning with hands-on practice, examples, and exercises in the upcoming topic.

Related Lessons

Previous Lesson	Next Lesson
Seaborn Basics	Project 1: Expense Tracker with CSV

Practice Quiz

Test your understanding of this lesson with 5 questions. Each question has one correct answer.

Previous Next