Abstract
The article details a business case for Sylt Fish Specialties GmbH as a practical application of Business Intelligence tools and procedures. Acting as an official report from a management consultancy firm, the document provides technical advice on the digital optimization of the company’s procedures. A reporting system is made available to the company that utilizes a BI dashboard using Apache open-source technology. A Data Warehouse and associated data models were developed and presented to the company as a digital solution. Finally, test analyses were completed to present the functionality of the proposed system.
Executive Summary
Our sample analyses show that a blossoming company like Sylt Fish Specialties can scale profits using clever analysis of daily business. Being able to monitor company metrics in an efficient and cost-effective manner such as this is the most advantageous way to increase profits. When the company wants to know which hour to offer a discount on Black Cod, they can rely on the developed dashboard to understand the trends as they are happening; when the concern is about supplier performance for seafood logistics, it is also important to have quick dashboard access to understand the data. Apache Druid and Superset were used here in tandem to reflect the accessibility and power of the designs; but there are many options available that are up to the discretion of the client and what they are comfortable investing in. The recommendation to use open-source technology as a reporting system for company data is strong due to the vast open- source development support given to Apache products. The versatility of using custom Python scripts to develop reports and design dashboards in a framework written completely in Python (Superset) adds a gained advantage to the designed system because Python knowledge is common in the education path of data analysts.
Solution
The idea that Online Analytical Processing (OLAP) is an extremely advantageous system to use for business intelligence is at the heart of our design decision for this business case. Apache Druid as an OLAP database and DWH is currently in use by profitable companies such as eBay, Netflix, AirBnB, and Nielsen; companies that require high-level batch and real-time processing of data.
Read the full paper here!