Gaming_console_EXCEL/PROJECT GUIDE at main · LoganathanAnalyst/Gaming_console_EXCEL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116

# 🎮 Gaming Console Sales Dashboard – Step-by-Step Project Guide

## 📌 1. Introduction
This project focuses on analyzing gaming console sales data using an interactive Excel dashboard.
It helps identify trends, top-performing consoles, regional insights, and revenue patterns.

---

## 📌 2. Project Overview
The dashboard visually represents KPIs such as total sales, profit, console performance, region-wise trends, and category comparisons.

---

## 📌 3. Requirements
- Microsoft Excel (2016 or later)
- Cleaned gaming sales dataset (uploaded in this project)
- Basic knowledge of Pivot Tables & Charts
- Understanding of Excel formulas and slicers (optional)

---

## 📌 4. Step-by-Step Guide

### **Step 1: Import the Dataset**
- Open Excel and load the provided gaming sales data.
- Place the data in a structured table format (`Ctrl + T` recommended).

---

### **Step 2: Data Cleaning**
- Remove blanks, duplicates, and invalid entries.
- Standardize naming for consoles, regions, and categories.
- Ensure numeric fields (Sales, Profit, Revenue) are correctly formatted.

---

### **Step 3: Create Supporting Columns (If Needed)**
- Add calculated fields such as:
  - **Profit %**
  - **Sales Category**
  - **Region Group**
  - **Top/Bottom Flag**
- Use formulas like `IF()`, `VLOOKUP()`, `XLOOKUP()`, `TEXT()`, etc.

---

### **Step 4: Build Pivot Tables**
Create Pivot Tables for:
- Total Sales & Profit
- Region-wise Console Performance
- Yearly/Monthly Trends
- Category & Segment Analysis
- Top 5 and Bottom 5 Consoles

---

### **Step 5: Create Pivot Charts**
Convert Pivot Tables into clean visuals:
- Column charts for sales trends
- Bar charts for top consoles
- Pie/Donut charts for region share
- Line charts for growth
- KPI cards using shapes + formulas

Apply consistent formatting:
- Uniform color theme
- Clean labels
- Remove chart borders

---

### **Step 6: Add Slicers & Filters**
Include interactive slicers:
- Console Type
- Region
- Platform
- Year

Connect all slicers to related pivot tables for interactive exploration.

---

### **Step 7: Design the Dashboard Layout**
- Arrange KPIs at the top (Total Sales, Profit, Units Sold)
- Add charts below in a grid layout
- Use modern color themes suited for gaming
- Highlight insights using icons, conditional formatting

---

### **Step 8: Final Polish**
- Add titles and section labels
- Ensure alignment and spacing
- Lock visual elements
- Protect sheet (optional)

---

## 📌 5. Output
A clean, dynamic Gaming Console Dashboard that shows:
- 🎮 Best-selling gaming consoles
- 🌍 Region-wise performance
- 📈 Sales & profit trends
- ⭐ Top & bottom performers
- 🧩 Interactive filters for analysis

---

## 📌 6. Conclusion
This project converts raw gaming data into powerful insights using Excel.
It helps businesses and analysts understand performance, trends, and growth opportunities.

---

## ⭐ If you like this project, don’t forget to ⭐ star the repository!