🎯 Business Objective:

One of the biggest challenges any Data Analyst can face 🚀 is working on a project with no structured data available.
In this project, I turned that challenge into an opportunity, by building a complete sales analytics system from scratch, starting with nothing more than a simple sales invoice in PDF format.

I developed a workflow that extracts raw sales information, transforms it into structured data, and visualizes key business insights in a fully automated dashboard.
The system now enables management and sales teams to make data-driven decisions instantly, monitor collections, and track commissions — all in one place.

Overview

The main objective of this project was to collect, clean, and analyze sales data in a dynamic and automated way.
Using Python, I created a script that extracts invoice data directly from PDF files and automatically converts it into Excel format.
To make the process accessible to non-technical users, I integrated the script into a Streamlit app, allowing anyone to upload invoices and generate structured data with just one click.

Once the data was organized, I connected it to Google Sheets, where I built a dynamic system that tracks each invoice’s payment status, calculates commissions, and updates automatically once a payment is received.
Finally, I connected the sheet to Looker Studio, where I designed a professional, interactive dashboard that presents insights clearly through charts, metrics, and filters.

Tools Used:

Python
Streamlit
Google Sheets
Looker Studio

📊 Main KPIs Tracked:

• Total Sales Volume

• Sales Timeline (monthly, quarterly, yearly)

• Total Collections and Collection Rate

• Open vs. Closed Invoices

• Percentage of Closed Invoices

• Salesperson Commission

• Top 10 Customers by Sales Contribution

• Top Performing Products

Business Impact

This system transformed a manual, time-consuming reporting process into a fully automated analytics solution.
It enabled faster, smarter decision-making, reduced errors, and saved hours of repetitive data entry every week.
Sales managers gained full visibility into collections, outstanding invoices, and team performance, while sales representatives could easily track their commissions and targets.
Ultimately, it improved operational efficiency, transparency, and financial planning across the business.

Result

From a single PDF invoice, I built a complete end-to-end analytics ecosystem — automating data extraction, organization, and visualization.
The final dashboard delivers real-time, actionable insights that empower management to make confident business decisions and recognize high-performing sales efforts.