I help business owners and managers use Excel & Power BI to make confident, data-backed decisions.
My focus is not just on visuals, but on identifying the right numbers that highlight risks, opportunities, and clear next actions for the business.
I work closely with real business data to ensure dashboards and reports are practical, accurate, and easy to use — not just good-looking charts.
Advanced Excel (Formulas, Functions, Data Modeling)
Power Query Editor (Data Cleaning, Transformation & Automation)
Pivot Tables & Pivot Charts
Excel Dashboards & KPI Reporting
Power BI Desktop (Data Modeling & Interactive Dashboards)
AI-Assisted Analytics Tools
ChatGPT (logic building, insights, automation ideas)
Google AI Studio (analysis support & workflows)
My goal is to convert messy, raw data into clean, insight-driven dashboards that support faster and smarter business decisions.
Industry-recognized certifications supporting my expertise in Excel and Power BI.
A structured approach to turn raw data into clear insights and confident business decisions.
• Data Collection – Understanding business data sources and objectives
• Data Cleaning – Ensuring accuracy, consistency, and reliability
• KPI Definition – Identifying metrics that truly matter to the business
• Visual Design – Creating intuitive, decision-focused visuals
• Dashboard Development – Building structured, interactive dashboards
• Layout Optimization – Designing for clarity and ease of use
• Insights Generation – Highlighting patterns, risks, and opportunities
• Business Decisions – Translating insights into actionable strategies
• Final Delivery – Clean, ready-to-use dashboards with explanation
Selected dashboards and reports showcasing real business use-cases
and data-driven decision making.
Interactive Power BI dashboard tracking sales, profit, and regional performance to support faster, data-driven business decisions.
View Interactive Dashboard
Finance dashboard comparing budgeted vs actual spend across departments, highlighting variances, utilization trends, and cost control insights.
Interactive sales dashboard tracking key metrics such as total sales, orders, discounts, units sold, and monthly trends across regions and product categories—designed to support performance monitoring and data-driven sales decisions.
Interactive profit and loss dashboard tracking revenue, expenses, gross profit, net profit, and monthly performance trends—designed to support financial analysis, cost optimization, and strategic decision-making.
Comprehensive ecommerce sales dashboard tracking sales volume, customer ratings, discounts, regional performance, and category-wise contribution—designed to support data-driven decisions and improve overall ecommerce profitability.
Turning data into clear insights that support smarter, faster business decisions.
Dashboards are useful only when they clearly tell what action the business should take.
Each solution is designed to highlight patterns, risks, and opportunities so businesses
can make informed decisions with clarity.
• Identified underperforming regions and improved sales strategy
• Reduced inventory risks through reorder and stock visibility
• Improved cost control using budget vs actual variance analysis
Insight 1:
Strong overall revenue performance with ₹189M total sales, indicating solid market demand.
Decision:
Increase investment in high-performing products and regions to accelerate growth.
Insight 2:
Healthy profitability with ₹26M total profit and ~14% margin.
Decision:
Prioritize high-margin categories to further improve profitability.
Insight 3:
West region leads revenue contribution, while North region underperforms.
Decision:
Run targeted marketing and distribution expansion in underperforming regions.
Insight 4:
Electronics category dominates sales contribution.
Decision:
Ensure availability of top-performing SKUs and optimize promotions for low-performing categories.
Insight 5:
Recent months show a gradual decline in sales trend.
Decision:
Highlight seasonal campaigns and demand-generation initiatives.
Insight 6:
High units sold compared to total orders indicate strong average order value.
Decision:
Continue bundle pricing and bulk purchase incentives.
Insight 1:
High inventory risk observed with 148 out of 250 SKUs in Reorder status (~59%).
Decision:
Implement weekly reorder planning for fast-moving SKUs and assign clear replenishment ownership.
Insight 2:
96 SKUs are in Critical stock condition (~38%), indicating potential sales loss.
Decision:
Prioritize urgent procurement for critical SKUs and maintain a weekly critical SKU watchlist.
Insight 3:
48 SKUs show negative stock levels, highlighting GRN, dispatch, or posting issues.
Decision:
Perform warehouse audits and enforce GRN/Dispatch SOPs with validation checks.
Insight 4:
Stock value is highly concentrated in Electronics and Health categories, increasing capital lock-in.
Decision:
Identify slow-moving SKUs and run clearance or bundle offers to reduce excess holding.
Insight 5:
Warehouse stock distribution is uneven, with WH-West holding the highest units.
Decision:
Redistribute inventory across warehouses and optimize location-level stocking strategy.
Insight 6:
Supplier-wise contribution shows higher reorder and critical dependency on select vendors.
Decision:
Renegotiate lead times, add buffer stock, and onboard alternate suppliers for risk reduction.
Insight 7:
SKU-level reorder recommendations enable faster purchase planning.
Decision:
Use suggested order quantities to prioritize Negative → Critical → Reorder SKUs weekly.
Insight 1:
Overall budget utilization is slightly above 100%, indicating controlled overspend.
Decision:
Implement tighter expense monitoring and approval controls for the next quarter.
Insight 2:
Sales department shows the highest budget overshoot compared to other departments.
Decision:
Link sales spending with ROI tracking and campaign performance reviews.
Insight 3:
Finance and IT departments demonstrate disciplined and controlled budget usage.
Decision:
Replicate best cost-management practices from these departments across others.
Insight 4:
Monthly spending trend remains stable with no sudden spikes.
Decision:
Current budgeting model is realistic and requires only department-level fine-tuning.
Insight 5:
Expense and revenue category spending is nearly balanced.
Decision:
Explore cost optimization opportunities in expense-heavy categories.
Insight 6:
Positive total variance indicates overall overspending.
Decision:
Identify high-variance months and introduce advance approval mechanisms.
Insight 7:
Budget utilization has crossed the 100% threshold.
Decision:
Consider mid-year budget revision or introduce a contingency reserve.
Insight 8:
Overspending is concentrated in specific departments rather than organization-wide.
Decision:
Apply targeted cost control strategies instead of blanket cost cuts.
✅ “Sample dashboards created to demonstrate how real businesses use data to take better decisions.”
