Home › Reference Guide › Wizards

Wizards

The Wizards in AnalyticsCreator provide a guided and efficient way to perform various tasks related to building and managing a data warehouse. Below is an overview of the eight available wizards and their core functions.

1. DWH Wizard

The DWH Wizard is designed to quickly create a semi-ready data warehouse. It is especially useful when the data source contains defined table relationships or manually maintained references.

  • Supports multiple architectures: Classic (Kimball), Data Vault 1.0 & 2.0, or mixed.
  • Automatically creates imports, dimensions, facts, hubs, satellites, and links.
  • Customizable field naming, calendar dimensions, and SAP DeltaQ integration.

2. Source Wizard

The Source Wizard adds new data sources to the repository.

  • Supports source types: Table or Query.
  • Retrieves table relationships and SAP-specific metadata.
  • Allows query testing and schema/table filtering.

3. Import Wizard

The Import Wizard defines and manages the import of external data into the warehouse.

  • Configures source, target schema, table name, and SSIS package.
  • Allows additional attributes and parameters.

4. Historization Wizard

The Historization Wizard manages how tables or transformations are historized.

  • Supports SCD types: 0, 1, and 2.
  • Configures empty record behavior and Vault ID usage.
  • Supports SSIS-based or stored procedure historization.

5. Transformation Wizard

The Transformation Wizard creates and manages data transformations.

  • Supports Regular, Manual, Script, and External transformation types.
  • Handles both historicized and non-historicized data.
  • Configures joins, fields, persistence, and metadata settings.

6. Calendar Transformation Wizard

The Calendar Transformation Wizard creates calendar transformations used in reporting and time-based models.

  • Configures schema, name, start/end dates, and date-to-ID macros.
  • Assigns transformations to specific data mart stars.

7. Time Transformation Wizard

The Time Transformation Wizard creates time dimensions to support time-based analytics.

  • Configures schema, name, time period, and time-to-ID macros.
  • Assigns transformations to specific data mart stars.

8. Snapshot Transformation Wizard

The Snapshot Transformation Wizard creates snapshot dimensions for snapshot-based analysis.

  • Allows creation of one snapshot dimension per data warehouse.
  • Configures schema, name, and data mart star assignment.

By using these eight wizards, AnalyticsCreator simplifies complex tasks, ensures consistency, and accelerates the creation and management of enterprise data warehouse solutions.