What is Condeco Data Analytics?
Data Analytics provides access to a rich analytic centric data store and has been specifically designed to feed analysis tools such as Power BI, Tableau, and more. Any analysis toolset that can retrieve data from Azure Table Storage directly or via an ODBC driver, can be used.
Is future data available?
No, the dataset only contains historical data. Past and closed bookings can be analyzed to monitor trends. Data for future reporting can be obtained using the Admin API.
How often is the data updated?
The Azure Table Storage data is updated every 24-hours, but due to the inherent difficulties in analyzing partial months or even partial weeks, we advise that the analysis dataset is only refreshed monthly or weekly. Analysis toolsets usually have the ability to schedule an automatic refresh.
Does Data Analytics support a JDBC connection?
No. The Azure Table Storage will support an ODBC connection or a direct connection with any tool that supports it. It is important to stress that the Azure Table Storage datastore is not designed for direct reporting, but as a source for an analysis toolset to get data from.
Are there any future plans for constructing 3-dimensional data like a Data Cube?
No. This data store is a de-normalized datastore that allows 3-dimensional data cubes to be created using an analysis toolset such as PowerBI or Tableau.
Where is the data stored?
Azure Table storage is stored on Condeco storage in the cloud with MS Azure. The data that gets pulled from the datastore to the analysis toolset is stored on the customer site or on their cloud storage..
How does Condeco Data Analytics work?
Condeco create and populate an Azure Table Storage container and provide a URL and key. The URL and key allow your analysis tool access to the data held within the Azure Table Storage via APIs.
Can only partial data be provided, for certain locations for example?
No, data is for all rooms and all desks. However, the analysis toolset will be able to filter by rooms/desks or location hierarchy.
Do we need to have a Business Intelligence (BI) analyst to set up Data Analytics and create reports?
As some degree of BI knowledge is necessary, then yes, we recommend that the work is undertaken by a skilled analyst. Alternatively, we can recommend our partner kleene.ai who specializes in this area.
Does Condeco support the data analytics reports created by the customer?
No, we cannot support any reports created by customers or support any example reports that may have been provided.