i4Q- Analytics Dashboard

General Description

i4QAD is a reporting interface that allows monitoring industrial data with fully flexible visualisation drill-down charts and a flexible dashboard to provide meaningful analytics to users on a real-time basis using incremental algorithms. This i4Q solution provides a graphical interface where it is possible to visualise any kind of Data and/or other types of information provided by other solutions.

This solution has the main function of providing visual analytics tools and methods to the i4Q project. The i4Q Analytics Dashboard can be used via a Web Application or through the provision of a deployment bundle that can be deployed on-premises or on the cloud and is based on Apache Superset which is an open-source software cloud-native application for data exploration and data visualisation being able to handle data at petabyte scale.

Features

  1. Providing visual analytics tools and methods

  2. Support real-time stream data visualisation

  3. Feasibility of receiving input data in various formats and connecting to most of the SQL based data sources through SQLAlchemy

  4. Ability to manage users authentication and data asset permissions

  5. customised visialisation dashboard based on I4Q look and feel

ScreenShots

i4Q Dashboard with multiple sample charts

Dashboard

i4Q Dashboard loading charts

Lazy loading

Druid web console

Druid console

Comercial Information

Authors

Company

Website

Logo

KNOWLEDGEBIZ

https://www.knowledgebiz.pt

Knowledgebiz

UNINOVA

http://www.uninova.pt

Uni Nova

IKERLAN

http://www.ikerlan.es

logo example

ENGINEERING

http://www.eng.it

logo example

CERTH

http://www.iti.gr

logo example

License

Apache License 2.0

Pricing

Subject

Value

Payment Model

One-off

Price

0 €

Associated i4Q Solutions

Required

It can operate without the need for another i4Q solution.

Optional

  1. i4Q Services for Data Analytics

  2. i4Q Big Data Analytics Suite

  3. i4Q Data Repository

System Requirements

  • Docker and Docker Compose on Linux, Mac OS X, or other Unix-like OS. (Windows is also supported through Windows Subsystem for Linux(WSL)2)
    • 16 GB RAM

    • 4 CPU

    • Hardware virtualisation support

Installation Guidelines

Resource

Location

Last release (v.0.1.0)

Link

There are two configurations to run i4q dashboard in docker:

1- Run only superset dashboard in docker

Analytics dashboard can be started up without building using a prebuild docker image from Gitlab registry of the project.

  1. Login to Gitlab registry

    • $ docker login registry.gitlab.com
      
  2. Pull i4qdashboard docker image. You can pull image with specific tags. Check Registry and container section of project in Gitlab. Below command will pull the latest build of i4qdashboard

    • $ docker pull registry.gitlab.com/i4q/ad/i4qdashboard:latest
      
  3. Run i4qdashboard in a container

    • $ docker run -d -p 8080:8088 --name i4qdashboard registry.gitlab.com/i4q/ad/i4qdashboard:latest
      
  4. Access UI on localhost:8088

2- Run superset dashboard with kafka and druid services in docker

  1. Login to Gitlab registry

    • $ docker login registry.gitlab.com
      
  2. Run the docker compose

    • $ docker-compose -f docker-druid-kafka.yml up --build -d
      

Optionally load example datasets and dashboards

$ docker exec -it i4qdashboard superset load-examples

NOTE: consult develop branch here for more options and to build from source

User Manual

This solution is built based on Apache Superset which is an open-source software cloud-native application for data exploration and data visualisation. The latest guidelines and user manual for Apache Superset can be found here: https://superset.apache.org/docs/intro

Data Streaming Configuration

In order to create a data streaming pipeline for visualisation, the Druid is used as the middleware. The latest guidelines of Apache Druid for the pipeline configuration can be found here: https://druid.apache.org/docs/latest/design/index.html