Hamza Khan
Data Analyst turning raw data into insights & dashboards
Ready for work
Hamza is ready for their next project!
I developed an end-to-end Power BI solution for a cosmetics firm processing 25K+ transactions. The client faced a critical issue: Sales grew 24% YoY, but Profit dropped 12%.
Identified that discounts >31% caused negative margins. • Revealed hidden profitability in Asian markets vs. low-margin US sales. • Recommended strategies to recover ~$150K in annual profit.
1
2
102
Designed an executive-level Power BI dashboard for a retail client generating $856K in revenue (+532% YoY). The goal was to diagnose operational risks hidden by rapid growth.
I analyzed 7,000+ transaction records to uncover critical insights, identifying a 70% untapped female market and high-margin international opportunities. My final deliverable provided a data-backed roadmap to stabilize shipping cost volatility and diversify revenue streams, positioning the client for sustainable scaling toward $1.5M.
2
3
124
As Team Lead and hands-on Analyst, I drove the BI strategy for a Tier-1 Bank’s credit card launch. The challenge was competing with RAAST, which held 50% of transaction volume.
I led the gap analysis that uncovered "The RAAST Switchers"—438 IT professionals buying high-value Electronics via bank transfer. I sized this 140 Million PKR opportunity and delivered a Power BI dashboard recommending a "Tech & Lifestyle" card pilot in Hyderabad to capture this specific market share.
1
2
111
Investment Performance Monitor with Power BI
1
5