The second dashboard for this data set includes basic staff information. Jerseys were the top performing clothing item here. Clothing represents 23.85% of sales revenue under this selection with a net revenue of nearly 1.4$ million and 4076 units sold. It can also be noted that Bikes generate 13.73% of revenue in this region by looking at the bottom right stacked bar chart.ĭigging into United Kingdom, 2008, Quarter 2 sales within the clothing category. Using filters once again to find out more information about ‘Road Bikes’ sales in quarter 2 of 2008 within the Central Region.
ADVENTUREWORKS DATABASE ONLINE GENERATOR
Road bikes appear to generate the most revenue as well as the highest order quantities, while Touring bikes is the lowest generator of sales within the Bike area. The Sales Dashboard contains filters for Country/region and year/quarter, pie chart for region, net revenue stats and graphs, table detailing product quantities and sum net revenue as well as net revenue proportions per territory.įiltering the dashboard by sales made in Australia in the previous two quarters.ĭrilling down into Bikes to further investigate the performance of Road bikes, Mountain bikes and Touring bikes. The entire database is quite large and for this dashboard only details relating to sales and staff were targeted. Adventureworks is a free publicly available database for a fictional bike company created by Microsoft.īelow is simply a sample of the data.
This data set was imported from my Adventureworks database in SQL Server.
0 kommentar(er)
