Data Analyst & Automation

Dubai

+971-506153643

PROJECT 2

Essa Hanif

August 21, 2025

Problem

Businesses often struggle with scattered and unorganized sales data in excel spreadsheets, making it hard to analyze current and future revenue trends, top-performing products, or customer insights. Preparing monthly reports manually is repetitive, time-consuming, and prone to mistakes.

Solution:

To solve the recurring problem, a Python automation workflow was constructed which processes raw sales data and generates a professional monthly report in minutes. The report includes key KPIs (total revenue, number of orders, average order value, unique customers), charts showing revenue trends, and a breakdown of top products and top customers. Alongside the visuals, I prepared an executive summary(Project 3) that highlights the main findings in simple, business-friendly language.

Here, I will paste screenshots of the KPI table, charts, and summary.

The link of the raw relevant data: https://docs.google.com/spreadsheets/d/1QaM5C5E-crqY8pMhYO8DsiY0Xw-Th4Gb/edit?usp=drive_link&ouid=114386478913810912886&rtpof=true&sd=true

Table 1: Monthly Revenue

Table 2: Top Products