Skip to content

Ashish11211/order_puchase_Dashboard_lookerstudio

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 

Repository files navigation

📊 Purchase order Dashboard (Looker Studio)

📌 Overview

This project showcases an interactive Sales Order & Order Punch Dashboard built using Google Looker Studio. It provides real-time insights into sales performance, order trends, and business KPIs.


🚀 Key Features

  • 📈 Total Orders & Sales Quantity Tracking
  • 🌍 Geographical Sales Distribution (Map View)
  • 📊 Monthly Sales Quantity Analysis (Year-wise)
  • 💰 Conversions & Revenue Breakdown
  • 👨‍💼 Salesperson Performance Analysis
  • 🛍 Top Product Sales Overview
  • 🏢 Highest Purchase Party Insights
  • 🔍 Dynamic Filters (Order No, Party Name, Date, Article, etc.)

🛠 Tools & Technologies

  • Google Looker Studio
  • Google Sheets (Data Source)
  • Data Visualization Techniques

📊 Dashboard Preview 🛠 “Based on real business scenarios”

image

📄 Download Full Dashboard (PDF): Click Here


⚙️ How It Works

  1. Data is maintained in Google Sheets
  2. Connected with Looker Studio
  3. Dashboard auto-updates with filters and controls
  4. Provides actionable insights for business decisions

🎯 Business Use Case

  • Track sales performance
  • Monitor order trends
  • Identify top-performing products
  • Analyze customer purchase behavior
  • Support data-driven decision making

⭐ Project Highlights

  • Clean & interactive UI
  • Business-focused KPIs
  • Real-time filtering
  • Professional dashboard design

⚠️ Note

This project uses dummy/modified data for portfolio purposes. No confidential company data is shared.


📫 Contact


⭐ If you like this project, give it a star!

About

Developed an interactive Sales Dashboard using Looker Studio integrated with Google Sheets, enabling real-time tracking of sales metrics, order trends, and business insights.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Contributors