kpi-analysis

Interactive Coffee Sales Dashboard 2026 – Streamlit Analytics

Tune your AI Agent to best meet its KPI with a cyclic process of analyze, improve and simulate

Business Analyst portfolio with end-to-end case studies, requirements artifacts, process models, and analytics. Built with Excel, SQL, Power BI, Tableau, and Salesforce.

AI Report Factory automates data storytelling, transforming raw business data into analytical, narrative-driven reports. It ingests structured datasets, computes KPIs, generates visualizations, and produces Markdown & HTML reports with actionable insights for startups, analysts, and enterprises.

End-to-end Data Analyst portfolio featuring 5 projects across SaaS, A/B testing, ecommerce, marketplace, and customer journey analytics. Showcases SQL, Python, Power BI, Tableau, Excel, data cleaning, ETL, statistical testing, KPI validation, and actionable business insights.

Business-focused social media analytics project analyzing multi-platform performance using Excel. Includes KPI analysis, dashboard development, and actionable marketing insights.

End-to-end logistics operations analytics project using SQL and Power BI. Built a relational database, created analytical views, and developed dashboards to analyze driver performance, revenue per trip, and on-time delivery trends.

A comprehensive data analytics case study simulating Zepto's inventory operations. This project showcases SQL driven data cleaning, demand forecasting, revenue modeling, and inventory optimization delivered with precision and depth.

End-to-end SQL analytics case study solving 7 real supply chain business problems across 180,519 orders. delivery performance, profitability, regional sales, and more.

Interactive Power BI dashboard for skincare brand analysis.

Power BI dashboard analysing rail operations: ticket sales, delays, revenue, and customer behaviour.

End-to-end Amazon E-Commerce analytics project using Python, Pandas, NumPy, Matplotlib, and Seaborn covering data cleaning, EDA, KPI reporting, and business insights.

Built an end-to-end analytics pipeline using Python, SQL, SQLite, and data visualization to analyze Hacker News content performance and engagement trends.

Interactive Power BI HR Analytics Dashboard for analyzing employee headcount, departments, salaries, joining trends, and job status using dynamic KPIs, charts, and filters for data-driven HR insights.

Power BI dashboard for Finance & Operations KPI analysis (FY 2023)

Power BI dashboard analyzing Shark Tank India deals, investments, startups, and investor trends.

Interactive Power BI analysis of revenue data: total revenue/expenses, average revenue, transaction volume, branch performance, payment method patterns, monthly trends, and recommendations to optimize growth, resource allocation, and operations.

End-to-end marketing analytics project evaluating campaign performance, funnel efficiency, and customer acquisition trends using SQL and Excel to generate actionable insights for business optimization.

HR Analytics project using Python and Tableau to analyze employee attrition trends, workforce KPIs, and factors influencing employee turnover through exploratory data analysis and interactive dashboards.

End-to-end Customer Churn Analysis project leveraging Python, SQL, and Power BI to uncover churn drivers, perform KPI analysis, and build interactive dashboards for data-driven decision-making.