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.

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.

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.

📊 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.

End-to-end Power BI dashboard analyzing sales performance, profitability, and growth drivers with executive overview and drillthrough analysis.

This project analyzes data , focusing on key metrics such as total sales, profit, year-over-year growth, and regional performance. The dashboard visualizes insights related to help identify sales drivers and opportunities for optimization. Recommendations are provided based on the analysis to enhance sales strategies and improve profitability.

A comprehensive Power BI dashboard analyzing sales performance, customer behavior, and product trends for a retail superstore, providing actionable insights for business decision-making and strategy optimization.

关注b站主播咲间妮娜谢谢喵。

In this capstone project, I analyzed a company's inventory and sales data to produce a report using Power BI and Tableau with my findings. I also designed a ranking system that would classify items in Excel by their Gross Margin Return on Investment values.

Assessing the profitability of No-Claim-Discount (NCD) car insurance scheme, this analysis employs Markov chains and Monte Carlo simulations in R. The study aims to evaluate the current scheme design, forecast future premiums, and propose enhancements for long-term viability.

End-to-end financial analytics platform integrating synthetic data generation, DuckDB warehouse, profitability modeling, churn prediction, and Power BI executive dashboards.

Comprehensive Excel-based dashboard analyzing KPIs and sales performance of a South American restaurant chain. Includes sales trends (2021–2022), country-level distribution, customer satisfaction, and profit metrics. Designed Data Analysis and business intelligence insights, performance tracking, and strategic decision-making.

Calculateur de rentabilité pour transporteurs : je récupère le prix du gazole via l’API gouvernementale, j’intègre les coûts (heures, distance, péages, charges) et je calcule automatiquement le coût total, le CRK et la marge pour chaque tournée.

Interactive Tableau Story analyzing Superstore sales data. Evaluates profitability across regions and cities, identifying high-value markets (e.g., California, New York) and underperforming areas to optimize revenue strategy.

This repository presents a profitability analysis of the Superstore dataset, featuring customer and segment insights supported by an interactive Tableau dashboard.

Interactive sales performance dashboard for Plant Co. analyzing Year-to-Date (YTD) vs Previous Year (PYTD) metrics. Features gross profit analysis, regional performance heat maps, and account profitability segmentation.

This repository contains a Power BI dashboard designed to analyze Amazon's global sales performance. It provides dynamic, interactive visualizations of sales by region, segment, and customer, helping to uncover insights and guide data-driven business decisions.

Calculateur de rentabilité pour du fret régulier : je récupère le prix du gazole via l’API du gouvernement, j’intègre les coûts (heures, distance, péages, charges, poids aller/retour) et je calcule automatiquement le coût total, le CRK et la marge pour une ligne régulière.

Python EDA on Superstore to diagnose sales, profit and loss drivers across categories, discounts, and regions.

Offline-first profit and inventory tracker for managing sales and investor capital splits across multiple products.