Full BI-Stack Automation

From source to data warehouse through to frontend

• MS SQL Server 2008-2022
• Azure Data Factory Pipelines
• SQL Server Integration Packages
• SSAS Multidimensional Databases
• SSAS Tabular Databases
• PowerPivot (Excel)
• Power BI
• Tableau
• Qlik Sense

Deployment

• Visual Studio Solution (SSDT)
• Creation of DACPAC files

Modelling Approaches

• Modeling is supported by several wizards
• Top-down modeling
• Buttom-Up modelling
• Import from external modelling tool
• Dimensional/ Kimball
• Data Vault 2.0 and 1.0
• The best of two worlds: Mixed approach of DV 2.0 and Kimball
• Inmon
• 3NF
• Custom creations

Data Vault

• Support from a AC data vault wizard do create the draft model automatically
• Enhanced data vault functionality available
• Strict Dan Linstead technics implementable
• DV for small projects

Historisation Approches

• Slowly changing dimensions (SCD) typ 0,  typ 1, typ 2, mixed
• SnapShot historisation
• Gapless historisation
• Change-based calculations

Surrogate Key

• Auto-increment, long integer
• Hash key, custom definition of hash algorithm

Transformations

• Transformation wizard
• Regular transformations (Views)
• Manual transformations (Views)
• SQL Scripts
• Stored procedures
• Manualy created SSIS Packages
• Persistence of results

Azure

• Azure SQL Server
• Azure Data Factory Pipelines

Other

• Offers GDPR/DSGVO compliance design patterns
• Source metadata exploitation
• Support for roll based security (OLAP Cubes)
• Data partitioning
• Pre-deployment script and post-deployment script
• Multiple environment support
• Custom defined layers

• Windows GUI
• Embedded version control
• Multi-user development supporting distributed development
• Manual object locking possible
• Predefined templates
• Cloud-based repository
• Cloud service support available
• Data Lineage
• Macro language for more flexible development
• Predefined, datatype-based transformations
• Example: Ltrim, Rtrim, Null2string, ..
• Calculated columns in each DWH table
• Single point development: whole design in AC possible. External development not necessary
• Embedding external code
• Automatic documentation in Word and Visio
• Export to Microsoft DevOps, GitHub, ..
• AnalyticsCreator repository is stored in a MS SQL Server and can be modified and extended with additional functionality
• Online Wiki wiki.analyticscreator.com

• ETL procedure protocol
• Error handling on ETL procedures
• Consistency on ETL failure
• Rollback on ETL procedures
• Automatic recognition of source structure changes and automatic adaptation of connected DWH
• Entirely DWH lifecycle support
• Delta and full load of data models
• External orchestration/scheduling for ETL process
• Internal orchestration/scheduling for ETL process with generated MS-SSIS packages
• Several workflow configurations
• No runtime for AnalyticsCreator necessary
• Daily processing of created DHWs is run without AnalyticsCreator
• No additional licences necessary
• For design component no MS SQL Server necessary

Automatic Connectivity

• MS SQL Server
• Oracle
• SAP/Theobald (DeltaQ/Tables)
• Excel
• Access
• CSV/Text
• OLEDB (e.g. Terradata, Netezza, DB2..)
• ODBC (MySQL, …)
• OData
• Azure Blob Storage (CSV, Parquet, Avro)

Manual Connectivity

• Any data source with C-Data connector > Link to www.cdata.com
• Hadoop with partner connector
• Google BigQuery/Analytics
• Amazon
• Shop solutions
• Facebook
• LinkedIn
• Twitter

Read more about connect to a datasource in our Wiki: wiki.analyticscreator.com

Define Your Own Connectivity

In all cases of access to source data an AC-metadata-connector is created.

The AC-metadata-connector is a description of data-sources you use for more easy handling in AnalyticsCreator. AC is able to create automatically a metadata connector by extracting the data definition from your source data. it contains information about key fields, referential integrity, name of fields and description.

Ask the community for pre-build metadata connectors.

SAP Connectivity

• SAP metadata connectivity is included in all AC-packages.
• Prebuild metadata connectors to SAP are available in the AC-cloud for free.
• AC create automatically metadata connectors directly from your specific SAP system including all adaptions.
• For development time you do not need to buy a SAP-3rd party connector.
• Just for the daily loading process (at runtime) you need a purchase for example the Theobald connector.
• All SAP modules can be reached through Theobald connectors.
• AC offer a OEM license for Theobald connector

Microsoft Dynamics

• Dynamics AX
• Dynamics 365 Business Central
• Dynamics 365

Export To

• Azure blob storage
• Text, CSV files
• Using any OLEDB or ODBC driver for the receiving target system
• Automated type conversation
• Export performed by SSIS or Azure Data Factory pipelines

Push Concept

• Power BI models will be created automatically
• Tableau models will be created automatically
• Qlik models will be created automatically
• All models described here will be created at the same time

Pull Concept

• There are many BI Frontends around which allows you to connect with the specified Microsoft data. Just ask your vendor or us what is possible.
• AC offer you to develop a specific solution for your Analytics Frontend in the way that the model will be created automatically for your BI Frontend (Push concept).