Featured Projects
Heads up! Below you’ll find the full details of my projects. Each takes a few minutes to explore and demonstrates how I turn complex financial and business data into actionable insights. This collection includes both personal and client work, highlighting expertise in financial modeling, statement analysis, budgeting, forecasting, and data-driven decision support.
Good analysis makes insights easier to understand. In many projects, I focus on creating clear, structured, and intuitive solutions that simplify complex financial information, ensuring every outcome is professional, accurate, and easy to interpret for informed decision-making..
Combat Sports Business Insights
A Power BI solution developed for a combat sports organization to deliver clear business insights. It tracks sales performance, team metrics, and growth comparisons across month-over-month, quarter-over-quarter, and year-over-year trends. Key averages, retention rates, and performance indicators help highlight strengths and identify potential issues early.
By combining multiple views into a single dashboard, the solution enables management to monitor overall business health.
Google Trend Analysis
An interactive Power BI dashboard tracking global Google search trends for job-related keywords like accountant, data science, and finance analyst. It highlights rising terms, monitors search popularity, and compares regional interest. Users can enter any keyword to instantly update visuals showing top searches, emerging terms, and regional breakdowns.
The dashboard helps professionals explore career shifts, businesses monitor talent needs, and educators track future skills, demonstrating practical analytics and business intelligence applications.
Bike Retail Business Analysis
A SQL-based analysis of a bicycle retail business, examining customer behavior, product performance, and sales trends. The project includes change-over-time analysis, performance comparisons, customer and product segmentation, and part-to-whole contribution assessments.
The insights generated help identify top customers, optimize inventory, refine marketing strategies, and support data-driven decisions that improve overall business performance.
Superstore Sales Analysis
A Power BI dashboard analyzing sales performance across customer segments, regions, and product categories. It visualizes monthly sales and profit trends, top sub-categories, and payment preferences, while mapping sales and profit by state. Shipping modes are tracked to compare costs and delivery performance, providing insights into customer behavior and regional demand.
The analysis highlights key growth drivers, helping optimize sales strategies and improve overall profitability.
Pakistan Weather Insights
Developed a real-time Power BI dashboard using live APIs to track weather conditions across major Pakistani cities. It displays temperature, humidity, wind speed, air quality, sunrise and sunset timings, and rain probability, along with short-term forecasts and trend visualizations.
The dashboard helps users monitor current conditions, anticipate upcoming weather, and make informed decisions, demonstrating practical applications of real-time analytics and data visualization
Workforce Analytics
A workforce analytics solution built on a 1,400+ employee dataset, designed to provide insights into the entire employee lifecycle. It tracks headcount changes, attrition rates, and demographic breakdowns across factors such as age, education, tenure, and job satisfaction.
This Power BI solution helps HR teams and managers anticipate challenges, align resources, and foster a more engaged and stable workforce.
Logistics Operations Analysis
An interactive analytics dashboard built to track logistics performance across regions, product categories, and shipping modes. It highlights order volumes, customer distribution, and sub-category breakdowns while mapping state-level demand on a global scale. Seasonal trends in shipping performance are visualized to identify delivery bottlenecks and optimize ship mode selection. This Power BI dashboard provided clear insights into order patterns and customer demand, supporting better resource planning and cost efficiency in logistics operations.
Automobile Companies Analysis
A Power BI dashboard that tracks sales performance across leading automobile companies. It analyzes sales trends over time, compares results by car maker, and evaluates shipping modes like first class, second class, and standard delivery. Customer insights and feedback are integrated to reveal patterns in buying behavior and satisfaction.
This solution provides decision-makers with actionable analytics, helping them optimize strategies, identify growth opportunities, and improve overall sales performance.
Project Performance Analysis
A data-driven Power BI dashboard designed to monitor projects by status, deadlines, and budgets. It tracks utilization by project type, highlights key expense variances, and compares planned versus actual performance. The dashboard provides managers with real-time insights into on-hold, in-progress, and completed projects, with drill-down access to project-level details.
This solution helps improve resource allocation, project analytics, and business intelligence, enabling early identification of bottlenecks and keeping projects aligned with organizational goals.
Personal Finance Insights
A detailed financial Power BI dashboard built to track income, expenses, savings, and yearly trends. It offers clear visibility into revenue streams, spending categories, and budget variance across multiple years. With trend analysis, data visualization, and interactive analytics.
It enables users to analyze spending habits and track savings goals over time. the dashboard helps identify patterns, reduce unnecessary expenses, and improve long-term financial planning.
Full-Cycle Financial Statements
Developed a comprehensive Excel model for a simulated business, covering the full accounting cycle from Chart of Accounts and journal entries to Trial Balance. Created three core financial statements Income Statement, Balance Sheet, and Cash Flow Statement with revenues of PKR 700,000 and net profit of PKR 114,750. The project involved posting transactions to individual accounts and summarizing data for accurate financial reporting. This end-to-end work demonstrates practical skills in double-entry bookkeeping and Excel-based financial management.
Income Statement Insights
Developed an interactive Power BI income statement dashboard that delivers real-time insights into revenue, COGS, gross profit, EBIT, expenses, and net income. Featuring year-over-year comparisons (2019–2020), division-level breakdowns (East, North, South, West), monthly trend analysis, dynamic KPIs, automated variance tracking, conditional formatting, and a clear net income margin visualization, the tool empowers management to quickly identify profitability drivers, cost trends, and growth opportunities for faster, data-driven strategic decisions.
DCF Valuation – WACC Model
Built a professional WACC model in Excel for a Pakistani fashion sector company using 5 listed peer comparables — Gul Ahmed, Khaadi, Sapphire, Sana Safinaz, and Bareeze. Ran a manual Beta regression using 104 weekly data points and applied the Blume adjustment to derive a reliable forward-looking Beta. Calculated the Equity Risk Premium from 22 years of historical market returns, applied CAPM to arrive at a Cost of Equity of 20.88%, and computed an after-tax Cost of Debt of 6.80%, producing a final WACC of 20.04% ready for use in a full DCF valuation.
Interested in working together?
If you’re looking to work with someone who understands both finance and data, feel free to reach out. Get in touch