(Actual data and names in reports is randomized)
Here’s a look at the Excel dashboard. Here, a Walmart manager can select either all his suppliers or choose a certain selection of suppliers. Then with the buttons on the top right, the user can choose to run the dashboard update, view data, export to pdf, etc.
We chose MS Access as the database program due to three factors.
- This was a temporary project that would only be done a few quarters until it was replaced by a different process.
- The data size was small enough (ie < 200 mb) to comfortably work with Access
- The source file and requirements were in flux, so it was better not to use anything of a permanent nature requiring investment to make huge changes in the architecture and import/export process
Here’s another view of an Excel report in this project. Walmart had a good idea of what they wanted in this project, but they also asked and relied on our expertise to provide additional ideas and suggestions on how best to utilize and display the source data.
Here’s a look at some of the statistical portions of the program. With so many dynamic factors in this project, it was really challenging to put it all together in a way that didn’t sacrifice overall project consistency.
We developed some tools for Walmart to manage a program they were developing with their vendors. They did a survey of all their vendors and collected a bunch of data related to what they were doing in terms of pollution management and reducing environmental impact. We developed a series of tools for them.
1. Database system to move the source data, filter, manipulate, and push to the Excel system
2. An Excel tool to generate dashboard files for each of 30 different vendor categories
3. An Excel tool to generate statistical analysis files for reviewing validity of data for the dashboard files
Note: Actual data and names in reports is randomized