Skip to content
View Bhavnamohite's full-sized avatar

Block or report Bhavnamohite

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Bhavnamohite/README.md

Hi there, I'm Bhavna Mohite 👋

📊 Data Analyst & MIS Specialist

I specialize in transforming messy data into clean, actionable business insights using advanced Excel, SQL, Power BI, and Python.

🛠️ Technical Skill Stack

  • MS Excel: XLOOKUP, INDEX/MATCH, GETPIVOTDATA, Date Formulas (DATEDIF/NETWORKDAYS), Pivot Tables & Dynamic Dashboards.
  • Databases & BI: SQL Querying (JOINs, GROUP BY), Power BI Dashboarding.
  • Programming: Python (Data cleaning with Pandas).

Sales Performance Dashboard -
https://github.com/Bhavnamohite/Sales-Performance-Dashboard Developed an interactive Excel dashboard to track and analyze regional sales performance trends. Cleaned raw transactional datasets, eliminating duplicates and formatting discrepancies to ensure 100% data integrity. Utilized Pivot Tables, charts, and slicers to provide dynamic, visual insights for stakeholders.

E-commerce Sales MIS Report - https://github.com/Bhavnamohite/Ecommerce-Sales-MIS-Report-Excel Built a structured Management Information System (MIS) report in MS Excel to track daily and monthly e-commerce sales metrics. Implemented complex formulas (INDEX/MATCH, IF statements) to automate data compilation and reduce manual reporting errors.

Employee Performance Dashboard- https://github.com/Bhavnamohite/employee-performance-dashboard Designed a data tracking sheet to evaluate employee KPIs, attendance, and output efficiency. Transformed messy operations data into clean, visual graphs to help streamline workforce evaluation.

Blinkit Retail Analytics Dashboard – (https://github.com/Bhavnamohite/blinkit-retail-analytics-dashboard) Developed an interactive Excel dashboard analyzing ₹1.2M in quick-commerce revenue across 8,523 product lines to optimize fulfillment outlet performance.Engineered raw datasets by imputing missing values, standardizing inconsistent categorizations, and establishing absolute data integrity. Implemented advanced PivotTables, cross-connected relational slicers, and a unified corporate brand-identity layout to deliver dynamic, recruiter-ready insights on growth timelines and regional store performance.

🔗 Connect With Me

Popular repositories Loading

  1. employee-performance-dashboard employee-performance-dashboard Public

    Interactive MS Excel MIS dashboard tracking corporate workforce KPIs.

  2. Ecommerce-Sales-MIS-Report-Excel Ecommerce-Sales-MIS-Report-Excel Public

    An Advanced Excel MIS Report and interactive dashboard analyzing e-commerce sales performance and fulfillment metrics.

  3. Sales-Performance-Dashboard Sales-Performance-Dashboard Public

    A corporate-ready Business Intelligence solution that transforms raw transaction data into actionable operational insights. This project tracks $8.97M in total sales across 48K+ units, analyzing pr…

  4. Bhavnamohite Bhavnamohite Public

  5. Retail-Sales-Data-Analysis Retail-Sales-Data-Analysis Public

    An interactive Excel dashboard analyzing $1.9M in retail sales and profitability metrics.

  6. blinkit-retail-analytics-dashboard blinkit-retail-analytics-dashboard Public

    An interactive MS Excel dashboard analyzing ₹1.2M in sales data, revenue trends, and outlet performance for Blinkit.