U.S. Shopping Trends Analysis

This interactive dashboard provides a comprehensive view of shopping behaviors and customer trends across the United States. Leveraging sales, customer, and location data, it explores the relationships between purchase patterns, payment methods, subscription behavior, churn risk, and demographic segments. This dashboard is designed to support data-driven marketing, product, and customer engagement strategies by turning raw commerce data into actionable insights.

Data Source: Customer Shopping Trends Dataset

Shopping Trends Dashboard

DAX Measure Documentation

SUM('ShoppingTrends'[Purchase Amount (USD)])

This measure calculates the total sum of all purchase amounts in U.S. dollars, providing a comprehensive overview of sales performance.

AVERAGE('ShoppingTrends'[Purchase Amount (USD)])

This measure computes the average value of each order, providing insight into the typical amount customers spend per transaction.

DISTINCTCOUNT('ShoppingTrends'[Customer ID])

This measure counts the total number of unique customers by counting the distinct values in the `Customer ID` column.

COUNTROWS('ShoppingTrends')

This measure simply counts the total number of rows in the `ShoppingTrends` table, which represents the total number of individual orders or transactions.

DIVIDE(
    CALCULATE(COUNT('ShoppingTrends'[Customer ID]), 'ShoppingTrends'[Subscription Status] = "Yes"),
    [Total Customers]
)

This measure calculates the percentage of customers who have a subscription. It counts all customers with a "Yes" in the `Subscription Status` and divides it by the total number of unique customers.