The aim of this section is to give a functional documentation of the product we are building.

Business Case

SBS Applications Visibility aims at bringing insights on applications' users thanks to logs analysis.

It can address several use cases:

Customer visibility

• Better visibility of the most used apps in order to improve the apps and facilitate sharing among users
• Measure users adherence to applications and functionalities → detect training needs/new requirements
• Usage and User monitoring allows to be proactive instead of reactive to the issues 

Process optimization

• Replace manual queries by automated process 
• Support Chromebook adoption process

Portfolio management

• Reduce the number of inactive apps
• Confirm functionality usage
• Confirm Apps usage (lack of knowledge, missing functionalities..)
• Improve licence needs forecast by a more accurate  number of users tracking

Security

• Anomaly detection
• Access reports
• Alerts with inactive/exited accounts/offboarding/transfers

High-level architecture

SBS Applications Visibility front-end is a dashboard hosted and maintained in QlikSense.

High-level architecture.

1) Data is imported into Google Cloud Storage via an ETL (Talend) or other means. The data ingested can be provided in a shared folder, a Google spreadsheet, a server, ... . 

Data is composed of 2 parts: one part is the logs of the app, the other part is the list of users with an access to the app.

2) The data is sent to BigQuery to be stored and indexed. 

3) Data Preparation is made to load the datasets that will feed the QlikSense

4) Data can be visualized in QlikSense