This dataset is designed for dashboard creation practice for analysts and data visualization learners. It simulates retail store sales data and helps you:

• Analyze regional performance
• Compare product categories over sales
• Understand customer and payment trends
• Track key KPIs like revenue, average discount, and number of items sold
• Segment data by customer types and payment modes

It is ideal for creating Power BI, Tableau, or Excel dashboards, where you can:

• Use filters and slicers for categorical fields
• Create bar, pie, and line charts for sales trends
• Use KPIs and scorecards for numerical summaries
• Build dashboards for stakeholder insights

Here is a Dashboard that is Created using this Dataset:

To get the dataset : https://github.com/slidescope/data/blob/master/Slidescope_Retail_Store_Sales_Enhanced_2025.csv

To get the Power BI File Contact Us

🧾 Columns Overview:

Field Name	Type	Description
Transaction_ID	ID (Unique)	Unique identifier for each sales transaction
Store_Region	Categorical	Region of the store (North, South, East, West)
Product_Category	Categorical	Type of product sold (Electronics, Apparel, Grocery, Furniture)
Payment_Method	Categorical	Payment mode (Cash, Credit Card, UPI, Wallet)
Customer_Type	Categorical	Customer category (New, Returning, Member, Guest)
Sales_Amount	Numerical	Total sale amount in INR
Discount_Percent	Numerical	Discount applied in %
Items_Sold	Numerical	Number of items sold in the transaction

Here are the top calculated fields you can create:

---

🔢 1. Gross_Amount

Formula:

Gross_Amount = Unit_Price * Items_Sold

Total amount before any discount.

---

💸 2. Discount_Amount

Formula:

Discount_Amount = (Discount_Percent / 100) * Gross_Amount

Actual discount value in ₹.

---

✅ 3. Net_Sales_Amount

Formula:

Net_Sales_Amount = Gross_Amount - Discount_Amount

The final amount after discount — this becomes your revenue.

---

💰 4. Average_Price_Per_Item

Formula:

Average_Price_Per_Item = Net_Sales_Amount / Items_Sold

Useful for understanding price trends after discounts.

---

📊 5. Effective_Discount_Per_Item

Formula:

Effective_Discount_Per_Item = Discount_Amount / Items_Sold

---