__STYLES__
Tools used in this project
NorthWind Traders

About this project

What did I analyze? Employee performance, performance of the top 5 company/customer, freight costs, average days to complete the shipping, gross and net revenue calculation, revenue forecast for the coming months, revenue by product category.

Measures created:

  • CALCULATE + DATEADD: Combination of the measures 'Gross Revenue' and 'Last Year Gross Revenue'.

  • CALCULATE + DATEADD : Combination of the measures 'Total Freight' and 'Last Month Freight Cost'.

  • CALCULATE + DATEADD : Combination of the measures 'Total Transactions' and 'Last Month Transactions'.

  • CALCULATE + DATEADD: Combination of measures 'Net Revenue' and 'Last Month Net Revenue'.

  • CALCULATE + DATEADD: Combination of measures 'Gross Revenue' and 'Last Month Gross Revenue

Visual KPI: To relate the measures and show the performance in key areas

Matrix: Top 5 Clients in relation to Gross Revenue | Display and comparison of prices charged by Shippers

Stacked Bar Chart: Ranking of product categories by Gross Revenue

Line Chart: Net Revenue over time + forecast for coming months.

Tool: Power BI (DAX, M Language)

Discussion and feedback(3 comments)
comment-139-avatar
Ahmed  Saafan
Ahmed Saafan
about 1 year ago
Hi, can i get the full project un excel & power bi

comment-140-avatar
Dorian Junior
Dorian Junior
Project owner
about 1 year ago
Project owner
Hey Ahmed! Thank you for your comment! If you would like to get the excel file of the challenge, just go to the link below and join the challenge. https://www.mavenanalytics.io/challenges

comment-142-avatar
Bedayan Chakrabarty
Bedayan Chakrabarty
about 1 year ago
Hi, How did you calculate the net sales. Is it the sum of (unitPrice-discount)* quantity ?
2000 characters remaining