R50 aa5e35199390181d5fd877008e538135
Power BI, Business Analysis

Sales and Traffic Dashboard

Добавлено 30 янв 2023 в 18:12
Dashboard link

Client requested a new report that will show information of:

Sales Analytics:

GMV : This is the Gross Merchanside Value or The Total Sales Generated (in USD)
Products Sold
Average Selling Price: Derives from the following division: GMV / Products Sold

Traffic Analytics:
Total Users who visited each product’s page
Total users who bought each product
Conversion Rate: (Total users who bought each product) / (Total Users who visited each product)

Example of Business questions:

1) How we can monitor the dynamics of GMV by month?

2) When was the highest value of CR?

3) How is the GMV shared by countries, channels and brands?

4) What is the most popular brand and product amongst visitors and buyers?

5) Which country has the highest Selling price for Brand E?

Data model

Selected data sample consists of two fact tables – traffic and sales. To create relations between them properly it’s better to create separated dimension tables – Product, Channel, Brand, Country and Calendar (as date table). Also, we can create them via DAX but in this case, we could have a problem with large data model size and low model performance in future. Then we can connect two tables based on snowflake scheme.
84bf63538b 140e347126 0eab88f82b F3aa0d4bca 89e4674aa9