I build AI agents & internal tools that act on data
Superstore Sales Dashboard — 3-Page Power BI Report
Built an interactive 3-page Power BI dashboard using
the Superstore Sales dataset (9,994 orders across USA).
Page 1 — Sales Overview: KPI cards, monthly trend,
regional breakdown, category performance.
Page 2 — Product Performance: Top products, category
donut, profit analysis, sales vs profit scatter.
Page 3 — Customer & Shipping: Segment breakdown,
top 10 customers, monthly growth, ship mode distribution.
Tools: Power BI, DAX, Superstore Dataset
Theme: Dark professional with interactive year filter.
0
219
I’m a Data Analyst specializing in cleaning, structuring, and analyzing marketing and sales data using Python, Excel, SQL, and Power BI.
I help businesses fix broken data pipelines, resolve formatting issues, and turn raw data into accurate dashboards that support decision-making.
My work focuses on clarity, reliability, and scalability—ensuring reports remain consistent as data grows.
If you’re struggling with inconsistent data or dashboards that don’t reflect reality, I can help streamline the process end-to-end.
0
479
Sales, Customer & Marketing Analytics in Power BI
I built a complete 3-page Power BI dashboard to analyze Sales performance, Customer behavior, and Marketing ROI—all in one place.
🔍 Sales Overview
Revenue trends & top product categories
Total Sales, Orders & Average Order Value
Region-wise and payment method analysis
👥 Customer Insights
New vs Returning customers
Customer Lifetime Value (LTV) by region
Purchase frequency & repeat behavior using DAX
📈 Marketing Performance
Spend vs Revenue across Paid Ads, Social, Referral, Influencer/UGC, Email & Offline
Clear ROI comparison to identify winning and underperforming channels
🛠 Tools Used: Power BI, SQL, DAX, CSV
💡 Outcome:
This project shows how combining Sales, Customer, and Marketing data helps businesses make faster, smarter decisions.
0
344
Analytical, MIS and Expert in automating reports
Data Analyst & Power Platform Specialist
📍 Mumbai, India | 📞 +91 7021027927 | ✉️ maheshkheder329@gmail.com (mailto:maheshkheder199@gmail.com)
Analytical and results-driven Data & MIS Specialist with 5+ years of experience optimizing reporting frameworks, automating complex workflows, and designing business intelligence solutions in the financial and insurance sectors. Skilled in transforming raw data into actionable insights using Power BI, SQL, Advanced Excel (VBA), and Power Automate. Recognized for delivering end-to-end data pipelines, custom approval workflows, and robust financial models.
Core Capabilities & Technical Toolkit
Business Intelligence & Dashboards: Power BI (Expert DAX, Power Query, Dynamic RLS), SAP BO, Trend & P&L Analysis
Database & Data Architecture: SQL (Data Modeling, Query Optimization, Joins, Data Validation), Dataverse, SharePoint Lists
Process Automation: Excel VBA Macros, Power Automate (Multi-stage Approval Workflows, Data Integration)
Analytics : Data Cleaning, Data Reconciliation, Python (Data Processing & Visualization)
1
243
Integrating modern automation into daily business operations serves as a catalyst for eliminating repetitive manual overhead, drastically reducing human error, and accelerating critical decision-making cycles. By leveraging structured workflows through tools like SQL, Excel VBA macros, Power BI dashboards, and custom Python automation scripts, organizations can transform complex, fragmented datasets into dynamic, real-time reporting systems. Rather than spending valuable hours manually aggregating reports, cleansing raw data, or cross-referencing records across disparate databases, automated pipelines seamlessly process and visualize key metrics in real time. This operational shift not only enhances operational speed and analytical precision across functions like MIS and performance tracking, but it also frees up core team members to focus on high-impact strategic initiatives and proactive business growth.
Name - Mahesh Narendra Khedekar
Contact No -(+91) 7021027927 [fast responce Conntact with whatapp]
Email ID - maheshkhedekar329@gmail.com
1
160
Monthly Reinsurance Premium and Claim Register
The Monthly Reinsurance Premium and Claim Register is an advanced Excel-based reporting and administration engine tailored for insurance operations, treaty accounts, and claims management. Designed to handle high-volume bordereaux files, this solution automates premium allocations, cession calculations, and claims recovery tracking across complex reinsurance treaties.
By replacing manual spreadsheets with automated Power Query models, dynamic lookup formulas, and VBA macro pipelines, the system eliminates human calculation errors, prevents recovery leaks, and standardizes disparate insurance data streams into unified master logs. Key features include automated validation algorithms to flag cessions discrepancies, real-time tracking of paid versus pending claims, and interactive executive dashboards for audit readiness.
Whether processing proportional treaties, excess of loss accounts, or monthly bordereaux statements, this workflow cuts monthly closing timelines by up to 80%. It delivers complete, transparent data lineage, robust audit trails, and zero-error execution for finance, underwriting, and reinsurance operations teams.
1
198
Data & AI Governance Consultant | Responsible AI | Power BI
Data Specialist for Clean, Organized & Smart Reports
Data Specialist for Clean, Organized & Smart Reports
🏦 Bank Loan Portfolio Analysis | Power BI Dashboard Project
Analyzed 38,576 loan records across 50 states to give a bank's lending division a unified view of portfolio health — something they simply didn't have before.
What the data revealed:
✅ Net-positive portfolio: $435.8M disbursed, $473.1M recovered
⚠️ 13.8% bad loan rate = $28.25M net capital loss
📊 Debt consolidation drives nearly half of all loan applications
⏳ 73% of borrowers chose 60-month terms over 36-month
📍 60%+ of repayments concentrated in just 5 states (CA, NY, FL, TX, NJ)
Tools used: PostgreSQL → Excel → Power Query → Power BI + DAX
Built two interactive dashboards:
→ Summary: KPI cards, good vs. bad loan segmentation, loan status grid
→ Overview: Trends, geographic maps, term/purpose/employment breakdowns
The next phase? Building a predictive risk scoring layer using DTI, interest rate, and employment length to flag at-risk loans before they default.
Open to feedback from data folks in the community 👇
#PowerBI #DataAnalytics #SQL #DAX #BankingAnalytics #PortfolioAnalysis #DataVisualization
0
50
Every hospital generates thousands of data points daily but without the right lens, it's just noise.
Built this Healthcare Analytics Dashboard to turn patient records into decisions. From tracking $1.4B in revenue across admission types to spotting a consistent dip in monthly billing trends the numbers tell a story most teams never get to read.
The insight that stood out? Diabetes and Obesity quietly lead revenue by medical condition which says a lot about where healthcare demand is heading.
This is what data visualization is actually for not prettier reports, but faster, clearer thinking.
Tools: Power BI · DAX · PostgreSQL · Power Query
0
81
I Built a two-page Power BI dashboard on 190K+ FMCG transactions — tracking revenue, SKU performance, promotional impact, and delivery across 3 channels and 3 regions. Uncovered a balanced 33% revenue split across all channels and identified the top 3 revenue-driving SKUs for smarter inventory decisions.
Tools: Power BI · DAX · Excel
0
108
📊 Sales Tracking Dashboard | Excel + Power BI Project
Built an end-to-end interactive Sales Tracking Dashboard covering 2021–2024 across the entire US market.
Top-Line Numbers:
💰 Total Sales: $19,28,888
📈 Total Profit: $2,47,962
👥 Total Customers: 8,314 across all years
What the dashboard reveals:
🏆 Best-selling sub-categories: Phones ($2,79,464) and Chairs ($2,77,058) lead the pack — together accounting for nearly 29% of all sales
📅 Profit growth year-on-year:
→ 2021: $49,556 → 2022: $61,618 → 2023: $81,786 — consistent upward trajectory across Furniture, Office Supplies & Technology
🗺️ Geographic concentration: California dominates at $3,90,145 in sales. New York ($2,46,517) and Texas ($1,51,436) follow. West Virginia sits at the bottom with just $536 — a clear signal for regional strategy review.
📦 Technology drives profit — highest-margin category across all 4 years, despite Furniture holding significant volume
🧾 Seasonal trends: Q4 is king — November ($2,34,013) and December ($2,41,464) are the strongest months. February dips to just $59,640 — opportunity for targeted campaigns.
👤 Top customer by profit: Tamara Chand at $8,981, followed by Raymond Buch ($6,939) and Sanjit Chand ($5,757)
Tools used: Microsoft Excel · Pivot Tables · Power Query · Charts & Slicers · Dashboard Design
This project sharpened my ability to turn raw transactional data into a clean, decision-ready visual — with filters for state, date, year, sub-category, and month.
Open to feedback! 👇
#Excel #DataAnalytics #SalesDashboard #DataVisualization #BusinessIntelligence #MicrosoftExcel #DashboardDesign
0
39
"From Data Chaos to Business Clarity."
"From Data Chaos to Business Clarity."
Next.js Full Stack Developer | Data Analyst
Next.js Full Stack Developer | Data Analyst
View more →
An Excel Expert - Specializing in Data Analysis
An Excel Expert - Specializing in Data Analysis
View more →
Data Analytics & Visualization Expert 🎯
Data Analytics & Visualization Expert 🎯
