NorthWind Traders

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)