The dataset contains one sheet named “Sheet1.”
The dataset includes the following columns:
- InvoiceNo: Unique invoice identifier.
- StockCode: Item code for the products.
- Description: Product descriptions.
- Quantity: Quantity of each item purchased.
- InvoiceDate: Date and time of the transaction.
- UnitPrice: Price per unit of the product.
- CustomerID: Identifier for the customer.
- Country: Country where the transaction occurred.
Get the dataset here : https://www.kaggle.com/datasets/ishanshrivastava28/tata-online-retail-dataset
Power BI Dashboard Ideas
Here are some dashboard ideas based on the dataset:
1. Sales Overview Dashboard
- Total Revenue:
Quantity * UnitPrice
- Total Transactions: Count of
InvoiceNo
- Total Customers: Count of unique
CustomerID
- Revenue by Country: Bar chart or map visualization showing revenue distribution.
- Daily Sales Trends: Line chart of revenue over time (
InvoiceDate
).
2. Customer Analysis Dashboard
- Top 10 Customers by Revenue.
- Average Basket Size: Average
Quantity
perInvoiceNo
. - Customer Retention: Count of repeated
CustomerID
across time periods. - Country-Wise Customer Distribution.
3. Product Performance Dashboard
- Top-Selling Products: Bar chart of
Description
byQuantity
. - Revenue by Product: Bar chart of
Description
by revenue. - Average Price per Product: Average
UnitPrice
for eachDescription
. - Product Performance by Country: Matrix showing
Description
vs.Country
.
4. Time-Based Analysis
- Hourly Sales Trends: Line chart showing sales trends by hour (from
InvoiceDate
). - Monthly or Weekly Revenue Trends: Aggregated view of revenue over time.
- Peak Sales Times: Identify the hours or days with the highest transactions.
5. Geographic Dashboard
- Revenue by Country: Interactive map visualization.
- Top Products by Country: Bar chart split by country.
6. Profit Analysis Dashboard (If Profit Data is Available)
- Gross Margin: (Selling Price – Cost of Goods Sold).
- Profit by Country or Product.
- Profit Trends Over Time.
To calculate Average Basket Size (Average Quantity per InvoiceNo) in Power BI using DAX, follow these steps:
Steps:
- Open your Power BI report and load the dataset.
- Create a new Measure for Average Basket Size using the following DAX formula:
AverageBasketSize =
AVERAGEX(
VALUES('TableName'[InvoiceNo]),
SUM('TableName'[Quantity])
)
Explanation:
VALUES('TableName'[InvoiceNo])
: Retrieves all uniqueInvoiceNo
values (i.e., individual transactions).SUM('TableName'[Quantity])
: Calculates the total quantity for eachInvoiceNo
.AVERAGEX
: Takes the average of the sums across all unique invoices.
Output:
This measure calculates the average number of items purchased per invoice.
Example:
If you have:
InvoiceNo | Quantity |
---|---|
1 | 10 |
1 | 5 |
2 | 8 |
Step-by-step calculation:
- Total quantity per InvoiceNo:
- Invoice 1: 10 + 5 = 15
- Invoice 2: 8
- Average Basket Size:
- (15 + 8) / 2 = 11.5