Welcome to AnalyticsCreator Docs

Deliver Governed Data Products at Scale

AnalyticsCreator combines data modeling, historization, CI/CD, lineage, and documentation into a single platform — enabling data teams to build, automate, and govern analytics with confidence.

Everything you need to build, automate, and ship governed data products with AnalyticsCreator — from modeling and historization to CI/CD and documentation generation. Use the search above or jump into a category below.

Pro Tip:

Every page in these docs mirrors the product’s UI and terminology — so you can follow along in AnalyticsCreator without switching context.

Quick Start

Explore by Category

Getting Started

Welcome to the AnalyticsCreator Documentation. In this Getting Started section, you can choose from the following sections: Installation System Requirements Download and Installation Understanding AnalyticsCreator

User Guide

You can launch AnalyticsCreator in two ways: From the desktop icon After installation or streaming setup, a desktop shortcut is created. Double-click the icon to start AnalyticsCreator. From the installer window Open the downloaded AnalyticsCreator installer. Instead of selecting Install, click Launch (labeled as Number One in the image below). A window will appear showing the available AnalyticsCreator Servers, which deliver the latest version to your system. This process launches AnalyticsCreator without performing a full installation, assuming all necessary prerequisites are already in place.

Reference

AnalyticsCreator Reference guide The AnalyticsCreator is the central storage location for all metadata related to your data warehouse projects. It serves as the foundation for organizing and managing the various elements of a data warehouse, ensuring consistency, scalability, and efficient collaboration across teams. What is the AnalyticsCreator Repository? The repository stores all Data Warehouse Project metadata information, including details about data sources, transformations, layers, and configurations. It is designed to act as a centralized structure where users can: Define and manage data warehouse artifacts. Configure and store database objects and workflows. Organize elements into logical folders for better accessibility. While the repository encompasses all metadata, not every item within it needs to be actively used, allowing flexibility in managing large and complex projects. Repository Structure The repository is organized into folders, with each folder representing a specific Data Warehouse artifact or database object. These objects include but are not limited to: Connectors: Configurations for connecting to external data sources like MSSQL, Oracle, or SAP. Layers: Hierarchical structures for organizing data, such as staging, core, and data marts. Packages: Collections of related objects or configurations for deployment. Indexes: Structures to improve query performance by optimizing data retrieval. Roles: Access controls and permissions for users interacting with the data warehouse. Galaxies, Hierarchies, Partitions, and Parameters: Components used in data modeling to define relationships, subsets, and configurations. Macros and Scripts: Reusable logic and code snippets for data transformations and operations. Object Scripts: Scripts tied to specific data objects for precise customizations. Filters: Tools for selecting or excluding specific data based on defined conditions. Predefined Transformations: Built-in processes to streamline common data processing tasks. Snapshots: Static copies or versions of data at specific points in time for auditing or rollback purposes. Deployments: Configurations and workflows for deploying changes to the data warehouse. Groups: Logical groupings of related objects or users for better management. Models: Representations of the structure and relationships within the data warehouse. Types of Repositories AnalyticsCreator supports three types of repositories, offering flexibility in storage and collaboration: SQL Server Repository Stored in Microsoft SQL Server databases. Ideal for centralized storage and multi-user collaboration in larger projects. Local File Repository Stored locally on your system. Suitable for individual users or small-scale projects requiring minimal setup. AnalyticsCreator Cloud Repository A cloud-based storage solution. Enables seamless collaboration and remote access, making it ideal for distributed teams. Both the SQL Server Repository and Cloud Repository are essentially Microsoft SQL Server databases with a predefined schema to store all AnalyticsCreator metadata. No additional software is required for setup. Key Benefits of the Repository Centralized Management All metadata is stored in one location, ensuring consistency and reducing redundancy. Scalability Supports projects of all sizes, from small, local setups to large, multi-user cloud environments. Flexibility Allows users to organize, customize, and manage artifacts based on project requirements. Collaboration With SQL Server or Cloud repositories, teams can work collaboratively on shared projects. Best Practices for Using the Repository Organize Folders: Group objects logically to reflect the structure and purpose of your data warehouse. Use Appropriate Types: Select the repository type that best suits your project scale and team collaboration needs. Regular Backups: For SQL Server and local repositories, ensure regular backups to prevent data loss. Optimize Performance: Use indexes, filters, and partitions effectively to manage large datasets efficiently. Version Control: Keep track of changes and maintain versioning to facilitate rollback if necessary. The AnalyticsCreator Repository is a robust and versatile solution for managing metadata, enabling you to build scalable and efficient data warehouses. Its flexibility across storage types and comprehensive feature set make it a cornerstone of AnalyticsCreator's functionality. Let me know if you'd like further enhancements!

Manage Objects

Manage Objects This page outlines the available operations for managing metadata objects within the AnalyticsCreator environment. Each operation supports key data platform activities such as object creation, editing, refreshing, and exporting, enabling efficient lifecycle control of models, connectors, and filters.

Tutorials

To become familiar with AnalyticsCreator, we have made certain data sets available. You may use these to test AnalyticsCreator: Click here for the Northwind Data Warehouse

Functions

Ger started by clicking on one of these sections: Main Functionality GUI Process support Data Sources Export Functionality Use of Analytics Frontends