This dashboard is designed specially for sales/business executives to visualize the annual revenue performance of facilities, products and sales representatives in their business. It incorporates the sales analyses of up to 20 sales representatives, products and the industries that the company currently holds. While calculations are made accordingly in Excel using various worksheet formulas, the query results are visualized by charts or interacive maps in the dashboard. In this dashboard total revenue for each region is displayed on the map which is interactive and acts as a control to filter results by the region. The map is supported with additional graphs that display the revenue by sales representative, industry and product in particular. This dashboard is especially useful for companies with large product portfolios, large customer-dealer marketing networks, and that conduct worldwide sales operations. SpreadsheetWEB supports over 500 maps covering every region and country which makes it ideal to generate interactive dashboard that contains regional data, i.e. by country, state, province, county, etc.
Figure 1. Sales Dashboard with Interactive Mapping (Excel Version)
Data can be transmitted to the dashboard from a database or can be entered manually into the spreadsheet. The user is empowered to treat the content in the most suitable way for their specific choices. SpreadsheetWEB requires no extra programming or programming knowledge. Basic knowledge of Excel is sufficient. The whole process is optimized to effectively reduce the usage of extra spreadsheets, and transfer the complete treatment to the web. SpreadsheetWEB also offers a user management module to set access control and exclusive security features.
Figure 2. Sales Dashboard with Interactive Mapping (Web Application)
