During their experience gained from working on implementation projects, the founders of AnalyticsCreator recognized a market need and the possibility to develop a framework to automate data warehouse creation and loading. They built a code framework in 2008, which they began to use in customer projects. However, the company AnalyticsCreator was not founded until 2017, by which point the framework had been rebuilt into a UI-based product and the vendor was able to promote it commercially.
Today the company employs eight people who are mainly focused on software development. Its headquarters is in Munich, Germany. Overall the vendor serves more than 60 direct customers and has additional customer projects which have been implemented by partners. In general, the company is partner-oriented. The software mainly helps consulting companies to implement data warehouse systems in shorter time frames than in the past. Therefore, the majority of AnalyticsCreator customers are actually systems implementers. AnalyticsCreator is 100 percent committed to Microsoft and aims to be among the best in this environment.
The software is designed for the creation of data warehouses for the Microsoft SQL Server platform and in Azure. AnalyticsCreator is independent of the modeling concept. Customers are free to use Kimball, Data Vault or other methodologies for this. Besides layers created for Microsoft SQL Server or in Azure, the solution supports the preparation of data marts for a number of BI front ends. For example, customers can automatically generate data models for Microsoft Power BI, Tableau, Looker, Cognos TM1 and Qlik Sense. Once a data warehouse environment with the appropriate data marts is set up, the runtime of the customer’s choice can be chosen for deployment. AnalyticsCreator sees itself as a design time and not a runtime environment. After initial implementation, customers may continue using AnalyticsCreator for the further development of their data warehouse system.
AnalyticsCreator’s eponymous product consists of two main components: A Windows client and a cloud-based service. The first is used to customize the data warehouse. Users can connect to data sources, declare the data semantics and set model-specific parameters. The model data is deployed to a cloud-based service called ‘AnalyticsCreator Cloud Generator’, which generates the database code and structures. The use of cloud services also opens up the possibility of sharing repositories and exchanging DW artifacts or working on data warehouse models in a distributed manner. The usability of the generated code is also worth mentioning. Generated code can still be used and processed after the AnalyticsCreator license expires.
User & Use Cases
The use cases for AnalyticsCreator are clearly defined. All our survey respondents use the tool for the (automated) design and operation of a data warehouse. The main effort is in data integration, which is undertaken by 86 percent of respondents. 72 percent also claim to use AnalyticsCreator for data preparation. This can only be explained by the fact that data preparation also includes ETL tasks from a user perspective. The tool is mainly used by implementers. This explains the very low average number of users per company. Small companies with less than 100 employees make up 69 percent of the sample, with 24 percent of respondents using AnalyticsCreator in medium-sized companies and just 7 percent in large companies.
Number of users using AnalyticsCreator
Number of technical users using AnalyticsCreator
Company size (number of employees)
Want to see the whole picture?
BARC’s Vendor Performance Summary contains an overview of The Data Management Survey results based on feedback from AnalyticsCreator users, accompanied by expert analyst commentary.Contact us to purchase the Vendor Performance Summary