SQL Database and Reporting
Capabilities & Solutions
SQL Database Server
Kroger, a national grocery chain, had been utilizing Microsoft Access and Excel as part of a database management system. Each day an employee would gather text files from both external and internal systems. This data was manually transferred into Excel and later imported into Microsoft Access. Over 100 reports were then created in Access and emailed to a contact at each location.
One employee contained all knowledge of the process, which prevented others from fulfilling those duties in the event of an absence. Additionally, the current method would not keep up with growth into thousands of retail locations. We had three problems to solve:
- Lack of a scalable architecture
- Manual data entry from multiple sources
- Manual report generation and delivery
SQL Database Server | Working with the Kroger’s IT department, we constructed a specific architecture that provided immediate relief and allowed for future growth. After establishing a solid SQL database schema, we designed an extensive framework to accommodate all necessary data points.
Import Mappings & Automated Routines | To improve both accuracy and reliability, our techs created import mappings and automated routines, which acquired data from diverse sources before importing information into the new database. These routines run on a regular basis automatically and honors the client’s fiscal calendar.
Automated Reporting | The original Excel reports included tabular data, charts, graphs and pivots. We reproduced all reports, including powerful Excel pivot reports, which are automatically sent to all subscribers throughout the country on a daily, weekly, quarterly, or period-end basis.
Custom Dashboard | We created a custom dashboard allows internal business users to control all aspects of the operation, reducing time lost and increasing accuracy.
Composable introduced a formal database, created mappings of all data sources, created reporting and automated all operations. Creating an easy to use custom dashboard gave control of the reporting process details. Not only can Kroger select a set of individuals to control the workflow, they are able to monitor regular activity. Composable Systems provided Kroger with the tools necessary to manage the system themselves.