Digizuite™ Insights provides a self-service SQL interface, where business analytics developers can access the raw data directly, and integrate towards existing internal BI tools and user interfaces. On top of that, we also provide a powerful business intelligence reporting service built on Microsoft™ Power BI.

Self-service analytics

To support integrators that have their own cube technology and/or visualization, Digizuite™ Insights deliver a self-service SQL access. This access is only provided on request because it could potentially require some extra data warehouse setup. Within, integrators will find best practice business intelligence structures, along with all documentation.

How to access

You need a connection string provided by Professional Services. This will give access to the SELFSERVICE schema and views.

Documentation

Each view is documented individually and may be seen by invoking the spHelp stored procedure.
In the below example we are getting documentation for the "Periods" view:

EXEC [dbo].[spHelp] 'Periods'

The response output will be like this:

Description:	Contains period definitions (LY=Last Year, LW=Last Week etc). 
				These provides an easy way to add new date period dimensions without changing anything else.
Type:			Dimension

There are 4 different types of views:

1. Fact
   This type of views contains facts about actual usage.
   
   
2. Dimension
   This type contains a dimension
   
   
3. Binding
   This type is for binding other data, typically dimensions.
   
   
4. Setting
   This type contains settings that may change the output of the data (e.g. language, max, min).

Power BI

Microsoft Power BI usage and documentation is not covered here.

Language

Language is controlled by the default language in the Digizuite™ DAM Center.