☕ Interactive Excel BI Dashboard | Analyzed 149K+ sales transactions using Power Query & Pivot Tables to uncover $698K revenue insights & growth trends. 📈

Building an interactive Microsoft Excel dashboard to allow the users to quickly identify trends in coffee bean sales.

This Power BI dashboard is tailored for marketing strategists to analyze sales trends and customer behavior. It offers key insights that enable the identification of sales opportunities and the optimization of marketing campaigns, ultimately enhancing business sales.

This project showcases a complete data cleaning and basic analytics workflow on a real-world-style employee health dataset, simulating inconsistencies often found in raw data. It includes both uncleaned and cleaned Excel files, plus a pivot-based dashboard to derive insights.

Excel data into dashboards

This Personal Income & Expense Tracker is designed to help individuals manage their finances by tracking income sources and expenses on a monthly basis. Created using Excel by Shaikh Minhaj as part of Assignment 1 from the Codebasics Data Analytics Bootcamp

This project showcases a complete data cleaning and basic analytics workflow on a real-world-style employee health dataset, simulating inconsistencies often found in raw data. It includes both uncleaned and cleaned Excel files, plus a pivot-based dashboard to derive insights.

This project showcases a dynamic sales dashboard built in Microsoft Excel. It transforms raw transactional data into actionable insights, visualizing product performance, sales trends over time, and quantity/revenue distribution, aiding in quick decision-making.

An analytical overview of call center operations aimed at improving service efficiency and customer satisfaction. The project leverages performance metrics and operational data to deliver insights through detailed reporting.

Built a refreshable ETL pipeline in Excel using Power Query and the Olist E-Commerce dataset. Imported, cleaned, transformed, validated, and merged multiple datasets into a single analytical table, demonstrating data cleaning, multi-table joins, validation checks, and analytical modelling workflows.

GST Reconciliation project comparing GSTR-1 and GSTR-3B to identify mismatches.

Interactive Retail Sales Dashboard in Microsoft Excel featuring Pivot Tables, Pivot Charts, Slicers, KPI analysis, and business insights for retail sales data.

Interactive Excel dashboard analyzing sales, profitability, and delivery performance to generate actionable supply chain insights.

Interactive Excel dashboard project using Pivot Tables, Charts, Slicers, and Data Analysis techniques to generate business insights.

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

Interactive Excel sales dashboard analysing Superstore revenue, profit, regional performance, product trends, and KPIs using PivotTables, charts, slicers, and advanced Excel analytics techniques for business reporting and decision-making.

A data-driven study on UPI usage, user perception, security trust, and challenges in India using Excel Dashboard & Survey Analysis

Interactive Sales Analysis Dashboard built with Advanced Excel, Power Pivot (Data Model), Pivot Tables, Dynamic KPIs, Slicers, Timeline, and Business Intelligence techniques.

Excel-based crash incident analysis (2019–2023) with data cleaning, pivot tables, visualizations, and an interactive dashboard.

📊 Analyze U.S. crash data from 2019-2023 with Excel to uncover trends and insights, enhancing road safety and understanding crash behavior.