An Excel-based dashboard for analyzing laptop data, featuring visualizations of processor brands, GPU brands, storage types, operating systems, screen sizes, and brand distributions. Built using pivot tables, charts, and filters to provide interactive insights.

📁 Features

✅ Dynamic charts and graphs
✅ Pivot tables for interactive analysis
✅ Clean layout for easy interpretation
✅ Filters to explore specific segments

📌 Analyzed Categories

• Processor Brand (e.g., Intel, AMD)
• GPU Brand (e.g., NVIDIA, Intel, AMD)
• Laptop Brand distribution
• Operating System distribution
• Storage type distribution
• size distribution

🧩 1. Project Overview

This Excel-based dashboard is designed to help users explore and analyze key specifications of laptops using interactive visualizations and pivot tables. It provides insights into market trends by brand, processor, GPU, storage types, and other core features. Ideal for quick decision-making and data exploration without requiring coding knowledge.

🛠️ 2. How to Use

• Open the Excel file in Microsoft Excel (2016 or later recommended).
• Use the slicers/filters to select specific brands, OS types, GPU, etc.
• Hover over charts for detailed tooltips and comparisons.
• Explore different sheets for category-wise visualizations.

📂 4. Files Included

• README.md – Project description and usage instructions
• dashboard_demo.mp4 - Video demo of the excel dashboard in action
• screenshot.png – Visual preview of the dashboard
• laptop_data.csv- Source dataset file

🔍 5. Preview

📸 Dashboard Preview Screenshot https://1drv.ms/i/c/3d00aa50fbba3fef/EbpLFUfbaO9BlkiG51-BQmEBARMn3baKPco6ixCOnn8_hw?e=EffRKI

💡 6. Additional Highlights

• Interactive pivot tables for slicing and dicing data
• Clean UI with Excel slicers for filtering by category
• Multiple chart types (pie, bar, column) for visual comparison
• Automatic updates when filters are applied