Freelance Data Analysts in Johar TownFreelance Data Analysts in Johar Town
ProjectsPeople
Abubakar Chan's avatar
Abubakar Chan
proLahore, Pakistan
AI Integration & Automation Engineer | Full-Stack Web Apps
$50k+
Earned
63x
Hired
4.9
Rating
97
Followers
ANYTHING_EXPERT

Expert

REPLIT_EXPERT

Expert

+2
AI Integration & Automation Engineer | Full-Stack Web Apps
Cover image for Provider Portal for Healthcare MSO
Provider Portal for Healthcare MSO
1
12
Cover image for Magnai | UK Public Affairs
Magnai | UK Public Affairs
3
28
Cover image for Humoni - secure housing in under 72 hours
Humoni - secure housing in under 72 hours
2
79
Cover image for Wellbeing Wizard AI
Wellbeing Wizard AI
6
159
Data Analyst(1)
KAZIM HAIDER SYED's avatar
KAZIM HAIDER SYED
proLahore, Pakistan
Insights from data, impact through design
6
Followers
Insights from data, impact through design
Cover image for 🚗 Driver Insights Dashboard Power BI
🚗 Driver Insights Dashboard Power BI | Data Analytics | Ride-Hailing Industry Project Overview A client in the ride-hailing space had 76M in revenue and 148K+ bookings — but zero visibility into WHY rides were failing. No one could explain the cancellations, the incomplete trips, or the growing gap between driver and customer satisfaction. I built a 5-page interactive Power BI dashboard that answered all of it. The Problem The client's data had serious blind spots: → Thousands of cancelled rides with no breakdown of fault → Auto & Go Mini vehicles had the highest incomplete ride rate (2.3K and 1.8K) → Driver ratings (4.23 avg) consistently below customer ratings (4.41) across all 7 vehicle types — with no system to catch it → Seasonal revenue dips (Q1 → Q2) were going unnoticed and unplanned → Go Sedan held 24.92% of total booking value — but had no dedicated tracking What I Delivered 📊 5-page Power BI Dashboard with full interactivity Overview — Revenue, Booking Ratio, CR by Customer & Driver at a glance Booking Ratio — VTAT trends across all vehicle types Revenue by Time — Month-wise & quarter-wise booking price analysis Cancelling — Cancelled rides breakdown by vehicle type & reason Cancelling Rides — Incomplete ride root causes + booking value vs distance scatter plot Plus: Dynamic slicers for Booking Status and Vehicle Type — so the client's team could self-serve their own filters without needing a data analyst every time. Results & Impact ✅ Operations team can now flag high-cancellation drivers proactively ✅ Vehicle maintenance triggers identified through incomplete ride spikes ✅ CX team has exact cancellation reasons — wrong address, AC issues, driver-asked-to-cancel — with counts, not guesses ✅ Revenue seasonality now visible and plannable quarter by quarter ✅ Fleet resource allocation backed by data (Go Sedan priority confirmed) Tools Used • Power BI Desktop • DAX (custom measures & KPIs) • Power Query (data cleaning & transformation) Looking for similar work? If you have messy data and need a dashboard that actually tells a story — let's talk. I specialize in turning raw operational data into clear, decision-ready visuals.
1
312
Cover image for Project Title: Pizza Sales Insights
Project Title: Pizza Sales Insights Dashboard Tools Used: Power BI | Excel | SQL | Data Cleaning Project Overview I transformed a complex dataset of pizza transactions into a high-impact, interactive dashboard designed to optimize restaurant operations. The goal was to identify peak ordering times, popular products, and sales trends to improve inventory management and staffing. Key Features & Insights Sales Performance Tracking: Real-time visibility into Total Sales ($152K) and order volumes to track growth against business goals. Peak Time Analysis: Identified that orders peak significantly during the evening hours (51.87%), allowing for better staff scheduling. Product Popularity: Segmented sales by category, showing that "Classic" pizzas drive the highest volume (15K orders). Customer Behavior: Analyzed order patterns by day of the week, pinpointing high-demand days to optimize marketing spend. The Technical Edge To build this, I performed extensive Data Cleaning and transformation to ensure accuracy across thousands of rows. I focused on a "clean-UI" design approach to ensure that even non-technical stakeholders can find answers in seconds. Why this matters for your business: "Data is just numbers until you can see the story. I build dashboards that help you stop guessing and start growing based on facts."
1
383
Cover image for ☕ Cafe Sales Dashboard |
☕ Cafe Sales Dashboard | Power BI Transformed raw cafe sales data into a clean, interactive dashboard that tells the full business story at a glance! 📊 Key Insights Covered: ✅ 10K+ total transactions tracked ✅ 8 menu items analyzed (Coffee to Smoothies) ✅ Daily sales trends monitored ✅ Payment method breakdown (Cash | Credit Card | Digital Wallet — each ~33%) ✅ In-store vs Takeaway location split (almost 50/50!) ✅ Monthly stock fluctuations identified ✅ Item-wise price vs quantity comparison 🛠️ Tools Used: Power BI | Data Cleaning | DAX | Data Visualization Data doesn't just sit in spreadsheets — it tells stories. This dashboard helps cafe owners make smarter decisions about stock, pricing & customer behavior. 📈 💬 Drop a comment if you want me to build something like this for your business
1
278
Cover image for 📊 Business Problem: The dataset was
📊 Business Problem: The dataset was unstructured, inconsistent, and difficult to analyze. Key metrics like sales trends, book performance, and publisher revenue were unclear, making decision-making challenging. 🔍 What I Fixed: ✔ Cleaned and structured messy data ✔ Removed duplicates and handled missing values ✔ Standardized formats for accurate analysis ✔ Created clear KPIs for better understanding ⚙️ How I Fixed It: I used Excel, Power BI, and data cleaning techniques to transform raw data into a fully interactive dashboard. Built visualizations like sales trends, rankings, and revenue insights to make data easy to understand. 📈 Result: Now the business can easily track performance, identify top-selling books, and make data-driven decisions. 💬 Feel free to contact me for: ✔ Data Cleaning ✔ Dashboard Creation ✔ Data Analysis Let’s turn your data into powerful insights!
1
225
Data Analyst(14)
Waqas Ali's avatar
Waqas Ali
Lahore, Pakistan
AI Developer Data Analyst and ML Expert
AI Developer Data Analyst and ML Expert
Cover image for Road Traffic Accident
Road Traffic Accident
0
3
Cover image for Wild Blueberry Yield Prediction
Wild Blueberry Yield Prediction
0
7
Cover image for Spam_Email
Spam_Email
0
3
Placeholder project card media
View more →
Data Analyst(2)
Muhammad Aamir Subhani's avatar
Muhammad Aamir Subhani
Lahore, Pakistan
Precision-Driven Data Analyst & Assistant
Precision-Driven Data Analyst & Assistant
Cover image for Real Estate Dashboard
Real Estate Dashboard
0
5
Cover image for Hospital Visit Summary & Records
Hospital Visit Summary & Records
0
3
Cover image for Purchase and Payment Track
Purchase and Payment Track
0
2
Cover image for Crypto Telegram Channel Investment Insights
Crypto Telegram Channel Investment Insights
0
7
Data Analyst(5)
Danish Yazdani's avatar
Danish Yazdani
Lahore, Pakistan
Game Design Consultant - GDD Expert
Game Design Consultant - GDD Expert
Cover image for Data-Driven Game Development Insights
Data-Driven Game Development Insights
0
0
Cover image for Garden Of Aether - GDD :: Behance
Garden Of Aether - GDD :: Behance
0
0
Cover image for Game Design: Night Claws - mobile rouge-like game
Game Design: Night Claws - mobile rouge-like game
0
2
Placeholder project card media
View more →
Data Analyst(3)
Etisam Ul Haq's avatar
Etisam Ul Haq
Lahore, Pakistan
Data Scientist: Expert in Analysis, Databases, AI🔍
Data Scientist: Expert in Analysis, Databases, AI🔍
Cover image for Swift Law - LawGPT
Swift Law - LawGPT
0
1
Cover image for Clip Insights - Capture Clip and Learn
Clip Insights - Capture Clip and Learn
0
1
Cover image for Study Buddy
Study Buddy
0
0
Placeholder project card media
View more →
Data Analyst(3)