Connected business intelligence & reporting

Owned by Youri Seichter (Deactivated)
Last updated: Mar 24, 2023 by Stephan Galozy
2 min read

You are looking for ways to evaluate, analyze or report the history of your service or a multitude of services?

The 3YD solution offers multiple options to handle this. The right option for you depends on what exactly you are trying to archive.

 

#

Solution

Complexity

Use Case

Advantages

Remarks

#

Solution

Complexity

Use Case

Advantages

Remarks

1

Business Analytics

Very Low

Instant and live insights into important business KPIs

  • Works out of the Box

  • No configuration required

  • Always up to date

  • Easy to access and configure

 

2

Using the build in CSV export option to analyse the data via excel or similar software

Low

Detailed order history for further analyses

  • Common data format to use with all kinds of software

  • Highly flexible

  • Only contains orders, requests and quotes. Does not contain users, MES-data, materials, settings etc.

  • Has to be configured in a third party software manually (MS Excel, Tableau, Power BI,…)

  • New or changed data has to be refreshed manually (by downloading CSV again)

3

Using the API (Application Programming Interface) to access CSV Data

Mid

Detailed order history for further analyses with automated download

  • Using CSV data as in #2, but downloading the CSV data via a single API endpoint

  • Keeps additional complexity to a minimum while always having up to date data without manual download

  • Same as #2, but trading some additional complexity for more automation

4

Using the API (Application Programming Interface) to connect to a custom system

High

Complex data gathering with programming interface

  • Allows you to access, change and delete many different data endpoints and their data like:

    • Orders, requests and quotes

    • Users, MES-data, materials and settings

  • Allows highly flexible data operations

  • High implementation effort

  • Requires knowledge about REST APIs and usually at leats one programming language

  • 3Yourmind can support, but the implementation is up to you as a customer. It must be implemented by an internal or external IT team

5

Using a direct Database Connection to either do custom database queries with SQL or via third party solutions like Tableau, Power BI, metabase etc.

High

Limitless business intelligence through direct database access

  • The most powerful way to access or even change data as all data is available to you

  • High implementation effort

  • Requires knowledge about SQL and our data model

  • Requires on-premise installation

  • 3Yourmind can support, but the implementation is up to you as a customer. It must be implemented by an internal or external IT team