Sales Data Analysis & Insights

A data-driven approach using Python and Looker Studio

Project information

  • Category: Data Analytics / Python & Looker Project
  • Client: Personal Project
  • Project date: 10 March, 2025
  • Project URL: View Live

Sales Data Analysis & Insights Using Python & Looker Studio

This project analyzes sales transaction data to uncover trends, identify high-performing products, and support business decision-making using Python for preprocessing and Looker Studio for interactive dashboards.

Skills & Tools:

  • Python (Pandas, NumPy)
  • Looker Studio (Google Data Studio)
  • Data Cleaning, EDA, Visualization


    • Key Insights:
    • Sales trends fluctuated with significant spikes in Nov 2003 and Nov 2004 — possibly seasonal or promotion-based
    • Classic Cars was the top-selling product line, while Trains had the lowest performance
    • Medium-sized deals contributed the most (59.8%) to total sales, followed by small (31.2%) and large deals (8.9%)
    Recommendations:
    • Optimize marketing strategy based on seasonal trends
    • Focus more on high-performing product lines like Classic Cars
    • Address and investigate underperformance in product lines like Trains
    • Explore opportunities to increase large deal transactions