This project includes calculations and visualizations in Power BI designed to evaluate sales performance, transaction behavior, customer activity, and product pricing across multiple analytical dashboards. These calculations provide a consistent foundation for understanding business performance at country, company, and user levels.
- Total Sales / Total Sales USD — Aggregates all transaction amounts to compute overall revenue, both in local currency and USD.
- Monthly Sales — Sums sales by month to analyze seasonality and year‑over‑year trends.
- Average Sale / Average Order Value ($) — Calculates the mean transaction value by dividing total sales by valid transactions.
- Sales Share by Country (%) — Determines each country’s contribution to total sales.
- Sales Variation (%) — Measures year‑over‑year percentage change in sales for trend analysis.
- Valid Transactions — Counts all approved transactions, used to assess operational throughput.
- Declined Transactions — Counts rejected transactions to monitor payment issues and system performance.
- Completed vs. Declined Transactions per Month — Breaks down transaction outcomes monthly to identify operational patterns.
- Number of Transactions / Transactions per User — Quantifies user activity and engagement.
- Max Price / Min Price — Identifies the highest and lowest product prices in the dataset.
- Most Expensive Product / Cheapest Product — Returns the product names associated with the maximum and minimum prices.
- Purchased Products — Counts distinct products purchased, useful for analyzing product diversity.
These descriptive statistics are applied to transaction values at the company level:
- Total Sales per Company
- Sales Count per Company
- Mean, Median, Max, Min
These measures help compare performance and variability across companies.
- User Sales ($) — Total revenue generated by a specific user.
- User Average Order Value ($) — Average transaction value for the selected user.
- User Valid and Declined Transactions — Transaction outcome metrics filtered at the user level.
- User Max/Min Product Price & Product Names — Identifies the most and least expensive items purchased by the user.