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. It is headquartered in Munich, Germany. Overall the vendor serves more than 100 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 modeling 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. AnalyticsCreator is continuously expanding its integration with the Microsoft world and has also started work on a Snowflake integration.
User & Use Cases
The use cases for AnalyticsCreator are clearly defined. 93 percent of survey respondents use the tool for ‘Data Warehousing/BI’ and 89 percent use it for ‘Data Warehouse Automation’. The main effort in data warehousing is in data integration, which is undertaken by 79 percent of respondents. Data integration is where automation can really pay off and save time and money. The tool is mainly used by implementers. This explains the very low average number of users per company, despite the fact that 11 percent of the respondents to this survey are from large organizations and 32 percent are from midsize companies. AnalyticsCreator is mainly used as a tool for implementing projects or in individual divisions. However, 33 percent of users use the product for central data provisioning in the company or in several divisions.
Extend of usage in the company
Total number of users per company
Total number of developers per company
Number of users using AnalyticsCreator
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