A restaurant chain producing its own spices needed to streamline oversight of the purchasing processes for the peppers used in spice production. The company's management wanted access to accurate and timely reports on the volumes of peppers purchased and related financial transactions. This information was recorded using a FileMaker application, JOGS, deployed at each location where peppers were purchased. Power BI was chosen as the primary reporting tool.
For data synchronization, we designed an application that collects new information every night from individual servers and stores it on a central server. Caching accelerates data access, eliminating the need to load live data for every request. Data access is secured using token-based authentication, and the data itself is transmitted in JSON format. This ensures secure and standardized access to the data for authorized users only.
Power BI accesses the data through an API provided by our custom application. The API processes each request based on predefined parameters and returns either cached data or, if necessary, live data from individual locations. This approach enables Power BI to connect to up-to-date aggregate information and display key reports for management.
