Table of Contents
Individual statistics: Analyze business figures with Tableau & Co.
As a key user, you have your customers and products in mind, know the processes in-house and the competitors in the industry. Xentral aggregates the data of your entire company, from sales, revenue figures and CRM data such as Touchpoints, to order processing, warehouse and logistics. In addition accounting preparation also records payables or current costs. Incoming payments and credit notes complete the data pool and thus provide an excellent basis for analysis and for linking external tools.
Xentral already offers a lot of statistical analysis in the standard scope of delivery in our modules sales figures, turnover statistics, statistics and the management board. - all summarized under the Controlling menu item. These figures are further supplemented by a variety of ready-made reports in the module reports that can be easily used or customized to meet your own needs.
Thus, an excellent basis for further evaluations already exists. Since these often depend on the business model and the industry, there are in Xentral various options to export the basic data and then display it in the form of charts or to further process it by analyzing it in business intelligence tools (so-called BI tools). Depending on the data set and the objective, it may be necessary to modify this data before analysis (e.g. enrich, group or otherwise summarize). For this purpose, Xentral can be connected to so-called universal connectors which allow processing and distribution of data. On this topic, we are dedicated to universal connectors in another article: Task Automation without Programming.
- Direct: CSV export, reports module with FTP, GetURL, transfer module, API calls.
- Indirect: After processing via Zapier & Co.
Basically, the tools described here all work similarly: the submitted data are written to a (simple or complicated) data model and can even be linked together.
Good to know: Depending on the data situation and the user's experience, the transmitted data can be stored in a data model of any complexity in the form of tables. There, they can be linked to one another via unique identifiers (so-called IDs or UIDs) and thus also combined with each other. This procedure is basically similar to an MS Access database which also allows the combination of different tables and the linking in an intuitive way. It is practical that here the tables can come from different data sources and can be updated independently of each other.
Important: All tools described here are exemplary for many available services and programs. These vary according to functional scope, complexity, operating system, pricing models and are, among other things, cloud- or on-premises operated systems or the associated clients.
As an example, some of the most popular tools are listed below (as of: 02/2020):
- Tableau (BI): https://www.tableau.com
- PowerBI: https://powerbi.microsoft.com/en-us/
- Synesty (Data Analytics module): https://synesty.com/
- DOMO: https://www.domo.com/en
- Dundas BI: https://www.dundas.com/dundas-bi
- Birst: https://www.birst.com
- Tibco Spotfire: https://www.tibco.com/de/products/tibco-spotfire
These tools have not all been tested in conjunction with Xentral, but rather represent a starting point for your own research.