POWER BI · RETAIL
EPOS Market Share Dashboard
Value share, category & brand performance with month, 3-month and year-on-year growth across retail accounts. Recognised with a Certificate of Appreciation.
BI & DATA ANALYST · KARACHI, PAKISTAN
FARHAN AHMED
Business
Intelligence &
Data Analytics.
I turn complex business data into clear insights, interactive dashboards, and automated reporting solutions.
POWER BI · SQL · PYTHON · AUTOMATION
Transforming data
into decisions.
01 — ABOUT
I'm Farhan,
a BI & Data Analyst.
More than just dashboards. With 3+ years at Smollan, I work across the full BI cycle — gathering requirements, building Power BI dashboards, analysing data with SQL and Python, and automating reporting so insights reach stakeholders on time.
My focus: helping business teams understand performance, monitor field execution, and spend less time on repetitive reporting.
QUICK FACTS
Based inKarachi, Pakistan
DepartmentOperational Intelligence
StudiedBS CS · Sukkur IBA
Experience3+ years
LanguagesUrdu · Sindhi · English
“From raw rows to the last KPI.”
02 — SKILLS
The toolkit behind the insights.
BI & Visualization
- Power BI
- DAX
- Power Query
- Dashboard design
Data
- SQL
- Python
- Excel
- Data cleaning
- Analysis
Automation
- Automated email reporting
- Python scripting
- Reporting workflows
Integration
- Google Chat API
- Chatbot development
- Database integration
Business
- KPI reporting
- Requirements gathering
- Stakeholder collaboration
03 — WORK
Dashboards that teams use every day.
POWER BI · FIELD EXECUTION
OSA Availability Dashboard
On-shelf availability by region, category and distributor, with top available / missing SKUs and new-product tracking.
POWER BI · AUDIT
Price Tracking Dashboard
Executive summary of store audits: price positioning, discount overview and price-point distributions by category.
01
Automated Email Reporting System
Designed the backend and mechanism for automated email reports, now used across multiple accounts.
10–15+ hrs saved / week
Python · SQL
02
Magnum Merchandising & Audit Analytics
Power BI reporting for field execution and audit performance.
Power BI · DAX
03
BA Activity Dashboards
Reporting for Nido and Fruita Vitals brand-ambassador activities.
Power BI
04
Imtiaz BA Programme Reporting
Business associate programme reporting.
Power BI · Excel
05
Unilever Reporting & Dashboards
Supporting business reporting and dashboard solutions.
Power BI · SQL
06
People Team Chatbot
A Google Chat bot that answers employee people-team queries instantly.
Google Chat API
04 — EXPERIENCE
The path so far.
Aug 2024 — Present
BI & Data Analyst
Smollan · Operational Intelligence
Own dashboards and automation for multiple FMCG accounts; built the Automailer reporting system.
Oct 2023 — Aug 2024
Business Intelligence Executive
Smollan
Built Power BI reports for field execution, audits and BA programmes.
Sep 2023 — Oct 2023
Information Technology Intern
Internship
Supported IT operations and data tasks.
Graduated 2023
BS Computer Science
Sukkur IBA University
Foundation in databases, programming and data structures.
05 — ACHIEVEMENTS
Impact through data.
10–15+
hours of manual reporting saved per week
Through the automated email reporting system used across accounts.
CERTIFICATE OF APPRECIATION
EPOS Dashboard
Awarded by Smollan Pakistan on behalf of Unilever in recognition of my contribution to developing an EPOS Dashboard.
06 — CONTACT
Let's make data work smarter.
© 2026 Farhan Ahmed · BI & Data Analyst