English
Some of Our Popular Solutions include:
Construction of a New Data Analytics platform
CHALLENGE
There are many reasons why a company might want to reorganize its data on a greenfield site: either no data warehouse yet exists in the company yet or it is more efficient to build a new one than to adapt an existing one. Even extensions of existing solutions are basically limited new implementations. Building a data warehouse requires time, capital and know-how. Mostly ELT or ETL tools are used for this purpose. This means a manual, i.e. slow and step-by-step, development process that can no longer cope with today's rapidly changing business requirements.
SOLUTION
With AnalyticsCreator, you can create a data analytics application such as a data warehouse with graphical support in no time at all, connect any data sources, transfer the data to your cube or MS Tabular model and make the analysis models available to any BI/analytics front end. In this way, you can easily connect business requirements with your data sources and map the core business logic directly in AnalyticsCreator.
If something changes in the data source, in the logic or in the process, the changes are automatically updated and published in all levels.
Benefits
Ultra Fast Prototyping
Get results in hours, not in days
Time to market of your project
up to 10x shorter
Time & Cost Savings
Automatic documentation
Drastic reduction of project risk
-1.svg){kind=icon}
Modeling instead of programming
Agile project methodology
.svg){kind=icon}
On Premise and Azure Cloud Operations
The code is freely usable without restrictions
also usable without AC
Advanced support for frontends:
Power BI, Tableau, Qlik Sense, TM1
Analytics platform modernization
CHALLENGE
The current data warehouse is outdated and no longer meets the new, extended requirements that the data basis should deliver to the analytical front end. Its performance may no longer be sufficient, adaptations are difficult to implement and it would no longer be future-proof. Additionally, the know-how about the existing data warehouse may no longer be readily available because the consultant’s employees or consultants are no longer available.
SOLUTION
AnalyticsCreator allows you to build on an existing DWH and make extensions and adjustments. If a good foundation is available, it is easy to build on top of it. Additionally, AnalyticsCreator’s reverse engineering methodology enables you to take code from an existing DWH application and integrate it into AC. This way, even more layers/areas can be included in the automation and thus support the expected change process even more extensively. The extension of a manually developed DWH (i.e., with an ETL/ELT tool) can quickly consume time and resources. From our experience and various studies that can be found on the web, the following rule can be derived: The longer the lifecycle, the higher the costs rise.
Benefits
Protect existing investment in DWHs
Utilize state-of-the-art modeling capabilities
Use reverse engineering methods
Secure knowledge
Prepare the way to the cloud
Automatic documentation
GDPR Support
Ultra Fast Prototyping
Results in hours & not in days
A data platform for Power BI
CHALLENGE
The challenge is to connect different data sources with Power BI. This involves processing large volumes of data, which can be complex. Additionally, the data needs to be historized to use the corresponding advanced analytics tools and methods. A tabular model needs to be built and much more. Power BI is one of the most popular analytics front-ends worldwide. In Power BI, you can design a multidimensional model for analytic applications and connect it to data sources in the cloud or on-site. To achieve higher data quality and meaningfulness, data is typically extracted from the source, cleansed, logically prepared, connected to correlating data, and aggregated. Additionally, model-based and technical performance optimizations are necessary. Another very relevant point is that the data historization of the source data should be implemented and stored in a data warehouse, which is not possible with Power BI. Only in this way are timely and correct analyses and reports possible.
SOLUTION
With AnalyticsCreator, you can design your data model for your analytical Power BI application and automatically generate a multi-tier data warehouse with the appropriate loading strategy. In the process, the business logic is mapped in one place in AnalyticsCreator and implemented in a wide range of Microsoft technologies. The model can be deployed in Azure SQL DB, Azure Analysis Services, Power BI or even on-premises technologies. AnalyticsCreator also gives you the ability to connect to an enormous number of data sources and deliver them to other front-end technologies. AnalyticsCreator allows you to connect to all the data sources you want and create an additional timeline that allows you to access any time-slice from the data warehouse.
Benefits
Awesome more power for Power BI
.png){kind=icon}
Orchestration of the MS BI stack on Premises & in Azure
Best practises data modelling for Power BI
High performing delta loadings
Enables slowly changing dimension concepts
Near Real-Time concepts
Single Point of Information
Data Vault 2.0 Automation
CHALLENGE
If you have many source systems, large amounts of data, or a complex data model that may change frequently, then Data Vault 2.0 modeling is ideal for building your Data Analytics Platform. Or you may have generally decided to build your Data Analytics Platform using the Data Vault 2.0 modeling approach. Either way, it is advisable to tackle such complex projects with an automation tool. Historization concepts, automated hash key generation and a transformation from the Data Vault model into a dimensional model up to the frontend (e.g. Power BI) needs to be provided.
SOLUTION
AnalyticsCreator includes a wizard that generates a first draft of a Data Vault model immediately after the source data is connected. In doing so, the developer is able to customize it and save their own template for future drafts. AnalyticsCreator alerts the developer with hints if they exceed the strict rules of DV 2.0 but does not restrict the developer. In addition, AnalyticsCreator offers the possibility to transition from the DV model to a dimensional model. The latter can lead directly to a cube or tabular technology or be transferred to a BI/analytics frontend. We call this process a hybrid approach. In addition, it is possible to use DV 2.0 achievements in a classic multidimensional model, thus combining the advantages of both worlds.
Benefits
Guided Data Vault 2.0 modeling
Support of any Data Vault paradigm
Any layer, raw vault, business vault, etc
Use of all features for multidimensional modeling
Automation in the change process
Visual representation of the models
Clarity with very large data and data models
Switch to cloud Data Analytics Platform Azure
CHALLENGE
There are numerous architectures and ideas on how to operate a data warehouse in the cloud. But which concept is the right one? More and more ERP and software providers offer operational solutions in the cloud. It therefore makes sense to connect these data sources and transfer them to your cloud data warehouse.
SOLUTION
With AnalyticsCreator, you primarily model independently, whether your data should be stored in the cloud or on-premise. First and foremost, you need to take into account the business model. At the latest possible time in the deployment process, you determine whether the model is to be built or migrated on-premises or in the cloud or on Azure. For special hybrid architectures, it is necessary to specify which areas/layers are to be stored and loaded where.
Benefits
Rapid migration from on premises to Azure
Support for Azure SQL DB, Azure Analysis Services, Azure Data Factory, Power BI
Modeling for different purposes
One modeling for different targets
Create a Data Analytics Platform from SAP Sources in the Microsoft BI Stack
CHALLENGE
Your source system is SAP. You may also want to make other data sources such as social media data, cloud data, IOT data, etc., available to your users for analytical purposes in a central data analytics platform in the cloud or on-premise. For this, you usually require expert knowledge, a significant amount of time, and the right tools.
SOLUTION
AnalyticsCreator includes special components that allow you to access your SAP source and decode the metadata from it and create an AnalyticsCreator metadata connector. In addition, predefined SAP metadata connectors are already available in AnalyticsCreator. From these, the AC-Wizard automatically creates a multi-layer data warehouse (DV 2.0 or Dimensional), which can be customized. Microsoft Tabular, Cube models, Power BI Apps, Tableau, QlikSense models are automatically generated from it. For the running operation we recommend the Theobald company data connector, which is delivered in the package on request.
Benefits
Create a highly professional DWH up to 20 times faster.
Extremely fast ROI
State-of-the-art architectures and methods are use
Transparency for business department, BICC, IT
Data lineage and automatic documentation
Collaboration features for "big enterprises”
Distributed development
No dependency on AC
SAP connectivity: ODP Objects, DetlaQ Tables, HANA, CDS Views.
Theobald connector included
Data Lakehouse Automation
CHALLENGE
Model and combine unstructured or semi-structured data in a data lake architecture and combine this or supplement it with a conventional DWH approach. The overall view of the data model must be ensured, and a data dictionary must be made available for the BI developers/analysts/business.
SOLUTION
With AnalyticsCreator you can combine the advantages of a conventional DWH and a data lake. Data Lake models or targets can be built or modeled with AnalyticsCreator.
AnalyticsCreator offers metadata-based data warehouse development. The definition of every source, table, transformation, or task is stored in the metadata database which is open and available for further use. Users have full access to the metadata, and they can manipulate this directly without using SQL scripts. The AnalyticsCreator metadata database has a very simple and user-friendly data structure that can be used in the data Lakehouse Architecture.
Benefits
One modeling for different targets
Fast shift to Azure cloud
Data Lineage & Automatic Documentation
ONE MODELING FOR DIFFERENT TARGETS
Data export
CHALLENGE
Sometimes it is necessary to use the data of a DWH outside, be it in other analytical databases, BLOB storages, cloud storages, or simply text files to process them further. Alternatively, you may want to write the data calculated in the data warehouse back into your source database. For example, you could calculate the customer debt limit in the data warehouse or use AI functions provided by Microsoft to create assumptions that you then want to reuse in your operational system.
SOLUTION
AnalyticsCreator generates SQL Server Integration Services (SSIS) packages and Azure Data Factory pipelines to export data from your data warehouse to external databases. AnalyticsCreator supports any OLEDB or ODBC driver functionality for this export. The suitable driver will write data into your target system. CSV, text files, and Azure blob storage are supported too. When you export to the Azure blob storage, you can use CSV, Parquet, and Avro formats.
Benefits
Tableau push
CHALLENGE
When using Tableau as an analytics frontend technology, it is necessary to connect it with your data sources such as a data warehouse or any source data in a structured or unstructured form. Tableau offers data transformation possibilities that enable you to transform data in the way you want to use it in the frontend. However, using Tableau without a DWH can result in significant quality degradation. The most time-consuming part of an analytics project is the data preparation, which takes up approximately 60-80% of the project time. This is why automation makes so much sense.
SOLUTION
AnalyticsCreator manages the entire design, development, and deployment process for a data warehouse. The analytics model with KPIs is also contained within the data warehouse. This “last layer” is automatically pushed into the suitable format for Tableau. With Tableau, you only need to open the file/project and the complete model is available for analytical purposes. You have direct access to the data in the data warehouse or you can pull the data out of the data warehouse. Changes in the DWH will be pushed to Tableau without needing to do it manually. Recognized data design principles require the entire data model in the warehouse; otherwise, you are taking a path with higher risks.
Benefits
Model creation for Tableau
One place of development
Deploy changes fast to Tableau
Azure Synapse Analytics
CHALLENGE
In some projects, there are significant challenges with query speed and large amounts of data. In these cases, it makes sense to use the Microsoft dedicated Synapse version. However, there are also disadvantages that should be taken into consideration.
SOLUTION
In AnalyticsCreator, you have one holistic data model and it doesn’t matter if you generate a database for Azure SQL or Azure Synapse. You can start modeling and make your decision later when you decide on the target platform. You can start with Azure SQL first and then switch to Azure Synapse
Benefits
Use the Synapse approach
One holistic data model for all approaches
Shift from SQL DB to Synapse