profitability-analysis

USA sales data analysis project with interactive Power BI dashboards and Python-based insights.

Power BI dashboard analyzing 61,000+ Supply chain orders across DataCo (2015-2017). Covers sales performance, profitability,delivery operations, fraud detection and strategic recommendations.

End-to-end retail analytics using SQL and Power BI. Analyzed $2.27M retail revenue using SQL and Power BI to uncover customer behavior, retention patterns, product performance, profitability drivers, and sales trends.

End-to-end SQL and Power BI analysis of global sales performance, focusing on profitability, discount strategy, and shipping cost efficiency across markets.

Using VBA Macros, we will determine if setting up a business would be profitable 15 years down the line, subject to 9 inputs, each associated with a certain uncertainty (pun intended!) using Monte Carlo simulation.

Securities management accounting analytics PoC for business line profitability, brokerage PVM analysis, and CFO reporting.

Power BI analysis of 2K clinic appointments ($938K revenue, 20.5% margin). Reveals why NY beat LA by $61K on treatment mix (whitening vs. cleaning), uncovers Chicago's 4.1% margin from high overhead, and contextualizes dentist KPIs by branch location. Built with DAX & Power Query.

Retail Business Analytics & Dashboarding project using SQL and Power BI — data validation, 360° customer modeling, profitability analysis, and executive-level KPI reporting for strategic decision-making

SQL and Power BI project analyzing profit leakage, discount effectiveness, and retail profitability. Complete end-to-end analysis with $157k in identified losses.

Power BI dashboard analyzing airline revenue, delays, passenger load, and route profitability

An interactive Streamlit business intelligence platform for analyzing Superstore sales, profitability, customers, products, operations, forecasting, predictive analytics, and AI-powered business insights.

Turning raw Amazon sales data into actionable insights — a Python-driven analysis of sales trends, demand, and profitability.

Power BI & SQL analysis of discount strategy, profitability, product pricing, customer segments, and regional performance.

Content ROI and Genre Profitability is a data analytics project focused on evaluating content performance across different Genres and Platforms using financial and engagement metrics

📊 End-to-end Vendor Performance Analysis project using Python (ETL & EDA), SQL (data modeling), and Power BI (Dashboards) to analyze vendor profitability, cost efficiency, and inventory optimization — turning raw data into actionable business insights.

Analyze and optimize the cost and profitability of a food delivery service using Python. This project includes data cleaning, cost breakdown, revenue calculation, and strategic recommendations to enhance profitability.

Executive sales dashboard built in Excel using validated transaction data, KPI calculations, profitability analysis, discount-risk controls, regional performance, executive Insights, and management recommendations.

An interactive Power BI dashboard analyzing Amazon's global sales data — covering revenue trends, regional performance, customer profitability, and segment-wise breakdowns to support data-driven business decisions.

This capstone Power BI analytics project was developed to support Techtronix Innovations, a leading AI player in the microchip and robotics industry. The project addresses key business challenges including sales strategy optimization, customer insights, inventory management inefficiencies, and identification of profitable market opportunities.

Interactive Excel dashboard for analyzing sales, profit, discounts, regions and product performance.