Northwind Trader Challenge

Objective: Provide quick understanding of the company's performance in the following key areas: sales trends, product performance, key customers, and shipping costs.

Single Page: I wanted to create a single page report that provided insights for further inquiry. The brief used the words "purpose should be to allow". Sense the word "must" was not used, this report concentrated on sales and discount sales ratios to explore sales trends.

Discount Sales Ratio:

Discount cost was calculated by subtracting Sales (no discounts) by Sales (with discount). Ratios were established by dividing discount cost by sale (no discount) to determine percent of loss revenue.

Report Goal: After noticing that employees are dealing with the same customers instead of regions, the question of how discounts are established was raised. Discounts are lost revenue. Therefore, it is of interest to top executives if an employee is apt to give better discounts than other employees.

What are discounts based on? This is the question the indicators at the bottom of the report is attempting to answer and may need further exploration when looking at sales trends.