On this project I use Power BI to analyze data for a fictional eCommerce company I call EverMart Online. I have created two separate dashboards, one for Revenue Reporting, and the other for Customer Behavior Reporting.
For the data I use, I created three separate tables:
Products
Customers
Transactions
I made the column headers and then had ChatGPT generate the row values, I made sure all tables were connected via ID's. Find the data on my Kaggle account here: https://www.kaggle.com/datasets/chadwambles/ecommerce-transactions/data
Revenue Report Dashboard Explanation
Dynamic Data Card
Total Products Listed
On default will show the total products listed by the store.
If a product has been selected on the Total Sales by Product bar graph, the Total Products Listed will update to show the total product count for that selected product.
If a category has been selected on the Total Sales by Category doughnut chart, the Total Products Listed will update to show the total product count for that selected category.
Total Unique Customers Listed
On default will show the total customers that have made purchases from the store.
If a product has been selected on the Total Sales by Product bar graph, the Total Customers will update to show the total customer count that have purchased that product.
If a category has been selected on the Total Sales by Category doughnut chart, the Total Customers will update to show the total customer count that have purchased products in that category.
Total Transactions
On default will show the total transaction count for the store.
If a product has been selected on the Total Sales by Product bar graph, the Total Transactions will update to show the total transactions count of that product.
If a category has been selected on the Total Sales by Category doughnut chart, the Total Transactions will update to show the total transactions for the products in that category selected.
Total Revenue
On default will show the total revenue for the store.
If a product has been selected on the Total Sales by Product bar graph, the Total Revenue will update to show the total revenue of that product.
If a category has been selected the Total Revenue will update to show the total revenue all the products in that category earned.
Dynamic Line Graph
Shows progression of revenue by month.
Y-axis is Total Revenue and X-axis is each Month in a year.
If product is selected on the Total Sales by Product bar graph, then the line graph updates to show the revenue progression for that product.
If category is selected on the Total Sales by Category doughnut chart, the line chart will update to show the revenue progression for all the products in that category.
Dynamic Horizontal Bar Graph
Shows the leading product sellers by total revenue.
Y-axis is for the Products and X-axis is for the Total Revenue.
Total Products Listed on the Dynamic Data Card will update per selection.
Total Revenue Dynamic Line Graph will update per selection.
Dynamic Doughnut Chart
Shows the category split of the total revenue.
Total Products Listed on the Dynamic Data Card will update per selection.
Total Revenue Dynamic Line Graph will update per selection.
Customer Behavior Report Dashboard Explanation
Dynamic Data Card
Total Products Listed
For the Total Products Listed column, the default will show the total products sold.
If a continent is selected on the map, the Total Products Listed will update to the amount of products sold in that continent.
Total Unique Customers
For the Total Customers column, the default will show the total customers that have bought products in that continent.
If a continent is selected on the map, the Total Customers will update to the amount of customers that bought products in that continent.
Total Transactions
For the Total Transactions column, the default will show the total transactions for the store globally.
If a continent is selected on the map, the Total Transactions will update to the amount of transactions for that continent.
Total Revenue
For the Total Revenue column, the default will show the total revenue for the store globally.
If a continent is selected on the map, the Total Revenue will update to show the amount of revenue earned for that continent.
Filled Map
The map shows the four continents where products were sold for the store.
The continent with the highest amount of customer traffic will have the biggest circle on the map and the continent with the lowest amount of customer traffic will have the smallest circle.
When you hover over one of the continents a tool tip will appear with the following information:
Continent Name
Customer Total
Percentage of Total Products Sold
Percentage of Total Customers
Percentage of Total Transactions
Percentage of Total Revenue
Comments