Business Analyses with Grafana

Task

The customer operates several systems with data that is to be used to evaluate the business situation. A large part of this data is available in a raw form, which is only suitable for evaluation to a limited extent.

Solution

A data warehouse was implemented based on PostgreSQL. This is filled via several optimized ETL pipelines. The data is analyzed in Grafana with dashboards specially developed together with the business departments.

Profile

  • Industry: Pharmaceutical industry
  • Period: since 2019
  • Technologies:
    • Oracle
    • PostgreSQL
    • MS SQL
    • XML
    • Golang (ETL-Pipelines)
    • Grafana

The solution allows a significantly improved insight into the data with a very high execution speed. This may become particularly interesting for future near real-time requirements. Data-based business alignment decisions have become possible as a result.

Want to create project like this?

I will gladly contribute my experience and help you with the implementation.

Contact Me