excel-analytics

A library of Excel LAMBDA functions transforming the grid into a canvas of possibility.

Interactive HR Recruitment Analytics Dashboard built in Excel to analyze hiring trends, evaluate candidate profiles, compare candidates, and estimate hiring probability using data-driven insights.

Excel analytics of superstore sales over a period of four years and demonstrates how raw data can be transformed into a visually appealing and decision-supporting dashboard

Interactive Excel dashboard analyzing 25K+ e-commerce orders with sales, profitability, discount, and regional performance insights.

Comprehensive finance analytics project for Atliq Hardware – Excel-based dashboards and reports analyzing customers, markets, and profitability.

Evidence-based business analytics of 60 embodied AI & world model startups (2024–2026), integrating funding, technology capability, commercialization and ecosystem intelligence into a validated Strategic Positioning framework for startup benchmarking and decision support.

Detailed insight on Stock price time series dataset through the use of different data analysis techniques and forecasting models.

Transforming messy data into meaningful business and research insights, turning raw datasets into clean, actionable analyses ready for real-world impact.

Honda Motors supply chain analysis and forecasting models using Excel-based quantitative methods (MA, WMA, Linear Regression) for production planning and logistics optimization.

Interactive Power BI dashboard analyzing student placement outcomes, salary trends, work experience impact, and academic performance using SQL and Excel.

A project analyzing coffee shop sales using Excel, including data cleaning, visualization, and insights for better decision-making.

A formula-driven Excel data cleaning and analysis project that transforms messy, raw HR datasets into an automated department summary dashboard using VLOOKUP, SUMPRODUCT, and conditional logic.

A proudly vibe-coded, local-first Excel analytics desktop app built with Flet and FastAPI.

End-to-end credit card customer analytics project using Advanced Excel, Power Query, Pivot-based segmentation, scenario optimization, and executive dashboard design.

Excel Analytics Server

Interactive Excel dashboard for Amazon sales data analysis featuring pivot tables, VBA macros, and automated business intelligence insights. Educational project demonstrating advanced Excel analytics.

Vrinda Strore Annual Report in Excel with Interactive Dashboards.

Objectives : Analyze revenue trends, evaluate profitability, visualize business segment performance (FYs 2024 -2025). Tools used: Excel, Power BI, GitHub. Key Findings

Revenue management and pricing analytics - Price elasticity modeling, promotional ROI analysis, A/B testing for media industry

RetailScope is an interactive Excel dashboard built on the Kaggle Superstore dataset. It converts raw sales data into insights using pivot tables, slicers, and visuals. The dashboard highlights regional trends, category performance, discount impact, and top products — showcasing business intelligence with Excel.