Power BI

IT Help Desk Dashboard – FP20 Analytics Challenge

  • Built interactive Power BI dashboard for 97K+ IT service tickets
  • Tracked SLA compliance, resolution time, and agent performance

Maven Analytics – Sales CRM Data Challenge

  • Built a Power BI dashboard to track sales team performance and opportunity outcomes.
  • Analyzed CRM data to reveal top products, key accounts, and regional sales trends

Emergency Room Analytics Dashboard

  • Created Power BI dashboard for real-time ER insights and operational efficiency.
  • Enhanced understanding of patient flow and demographics and fro better resources allocation

Pizza Sales Analytics Dashboard

  • Built a Power BI dashboard with SQL-backed KPIs to analyze sales trends, customer behavior, and product performance.
  • Delivered interactive insights on revenue, order patterns, and top-selling items to support data-driven decisions.

HR Analysis Dashboard

  • Built Power BI dashboard to track salary, hiring, exits, and workforce diversity.
  • Used DAX for advanced metrics and insights.

SQL

SQL Case Study - Food Delivery Orders

  • Extracted customer and driver insights using SQL and window functions
  • Optimized queries and delivered recommendations to improve operations

SQL Case Study - Employee Performance Mapping

  • Built 20+ SQL queries to analyze employee performance, roles, and project assignments
  • Used views, functions, and indexing to optimize HR reporting and insights.

SQL Case Study - Real-Time Weather Analytics Project

  • Designed SQL database to analyze real-time weather trends across locations
  • Queried geospatial and time-based patterns using joins and aggregations.

Python

Mercedes Benz Manufacturing

  • Analyzed manufacturing parameters using machine learning
  • Enhanced car safety and reliability through predictive models

Diabetes Prediction – Data Science Capstone Project

  • Cleaned and explored medical data to identify key predictors
  • Built and compared models to classify diabetes using Python

Excel

Uber Rider Analysis Dashboard

  • Built an interactive Excel dashboard to analyze trip and rider trends
  • Visualized payment, timing, and vehicle preferences using Pivot tools

BigBasket Sales Dashboard

  • Built Excel dashboard to analyze sales by product, market, and team
  • Used Pivot Tables, Charts, and formulas for key insights

Restaurant Tip Prediction Project

  • Gained hands-on experience in cleaning data, performing multiple linear regression, and interpreting statistical
  • Transformed raw data into actionable insights using pivot tables and charts, uncovering key tipping patterns

MS Access

Salon Management Software

  • Developed software to streamline operations and improve client experience for salons and spas
  • Enhanced productivity and profitability with user-friendly, advanced features.


Have a Question? Click Here