Welcome to My Data Visualization Portfolio

Discover insightful and interactive dashboards designed using Power BI. Each project showcases data-driven decision-making solutions across various industries.

Featured Projects

visualization

Pizza Sales Performance dashboard

This interactive Power BI dashboard analyzes pizza sales data to identify key business insights, optimize sales strategies, and enhance decision-making. The report tracks sales trends, customer behavior, best-selling products, and peak demand times, helping stakeholders improve marketing and inventory planning.

Click here

Key Metrics & Insights:

✅ Total Orders – Measures overall pizza sales performance.
✅ Average Sales per Order – Calculates revenue per transaction to understand customer spending habits.
✅ Best-Selling Product – Identifies the most popular pizza based on sales volume and revenue.
✅ Average Order Value (AOV) – Analyzes the typical order size to track sales trends.
✅ Sales by Category & Size – Breaks down revenue based on pizza type (e.g., Veg, Non-Veg) and size (Small, Medium, Large).
✅ Busiest Days & Time of Year – Determines peak demand periods to optimize staffing and inventory.

Technologies Used:

🛠 Power BI, DAX, Data Cleaning, Data Visualization, SQL SERVER, EXCEL

Business Impact:

📈 The dashboard helps in identifying top-performing products, optimizing promotions for peak hours, and improving inventory planning based on busiest days and seasons.

Call centre dashboard

Call Centre Dashboard

Designed an interactive Power BI dashboard to analyze call center performance, focusing on key metrics like customer satisfaction, call answer & abandonment rates, ASA (Average Speed of Answer), agent performance, and call trends. The dashboard provides data-driven insights to enhance operational efficiency and customer service strategies.

Click here

Key Features:

  • 📈 Total Calls vs Resolved Issues – Track the resolution rate.

  • ⏳ Average Handling Time – Monitor call durations.

  • 😀 Customer Satisfaction Scores – Measure user feedback.

  • 👨‍💼 Agent Performance Metrics – Evaluate agent productivity.

  • ✅ Calls Answered vs Abandoned – Analyzes call resolution trends with percentage metrics.

Technologies Used:

🛠 Power BI, DAX (Data Analysis Expressions), SQL, Data Cleaning, Data Visualization.

Challenges & Solutions:

🔹 Handling Missing Data: Used data transformation techniques in Power BI to clean and standardize datasets.
🔹 Optimizing Performance: Used calculated columns and optimized DAX measures for real-time dashboard performance.
🔹 Enhancing Usability: Designed intuitive visuals and added filters to improve interactivity.