Data Analyst & Automation

Dubai

+971-506153643

PROJECT 1

Essa Hanif

August 7, 2025

Problem:

Businesses often manage inventory in messy Excel files, making it difficult to quickly identify low stock, track total inventory value, or generate professional summaries for decision-making. Manual reporting is repetitive, error-prone, and time-consuming.

Solution:

I built a Python automation pipeline that takes raw Excel inventory data, cleans it, and generates a professional report with clear tables and visual charts. The report highlights low-stock items, stock distribution, and overall inventory value. I also included an executive summary so decision-makers can instantly understand the key issues without digging into raw data.

Here, I will paste relevant screenshots of charts, tables and provide links to relevant excel sheets and reports.

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

Table 1: Cleaned inventory

| Product ID | Product Name | Opening Stock | Purchase / Stock in | Number of

Units

Sold | Hand In

Stock | Cost

Price Per Unit

(USD) | Cost

Price

Total

(USD) | Stock value | | --- | --- | --- | --- | --- | --- | --- | --- | --- | | P101 | Laptop | 50 | 20 | 10 | 60 | 1200 | 72000 | 72000 | | P102 | Monitor | 40 | 15 | 5 | 50 | 500 | 25000 | 25000 | | P103 | Keyboard | 60 | 25 | 15 | 70 | 50 | 3500 | 3500 | | P104 | Headpho nes | 30 | 10 | 3 | 37 | 100 | 3700 | 3700 | | P105 | Smartpho ne | 70 | 30 | 20 | 80 | 900 | 72000 | 72000 | | P106 | Tablet | 45 | 18 | 8 | 55 | 700 | 38500 | 38500 | | P107 | Router | 55 | 22 | 12 | 65 | 150 | 9750 | 9750 | | P108 | External Hard

Drive | 25 | 12 | 5 | 32 | 200 | 6400 | 6400 | | P109 | Wireless Earbuds | 35 | 15 | 7 | 43 | 80 | 3440 | 3440 |

Keyboard | 25 | 10 | 4 | 31 | 100 | 3100 | 3100 | | P118 | Gaming Mouse | 30 | 12 | 6 | 36 | 80 | 2880 | 2880 | | P119 | Gaming Headset | 20 | 8 | 3 | 25 | 120 | 3000 | 3000 |