Desktop Interface

Detailed AnalyticCreator UI

With AnalyticsCreator Desktop users can:

  1. Data Warehouse Creation
    Automatically generate and structure your data warehouse, including fact tables and dimensions.
  2. Connectors
    Add connections to various data sources and import metadata seamlessly.
  3. Layer Management
    Define and manage layers such as staging, persisted staging, core, and datamart layers.
  4. Package Generation
    Generate integration packages for SSIS (SQL Server Integration Services) and ADF (Azure Data Factory).
  5. Indexes and Partitions
    Automatically configure indexes and partitions for optimized performance.
  6. Roles and Security
    Manage roles and permissions to ensure secure access to your data.
  7. Galaxies and Hierarchies
    Organize data across galaxies and define hierarchies for better data representation.
  8. Customizations
    Configure parameters, macros, scripts, and object-specific scripts for tailored solutions.
  9. Filters and Predefined Transformations
    Apply advanced filters and transformations for data preparation and enrichment.
  10. Snapshots and Versioning
    Create snapshots to track and manage changes in your data warehouse.
  11. Deployments
    Deploy your projects with flexible configurations, supporting on-premises and cloud solutions.
  12. Groups and Models
    Organize objects into groups and manage models for streamlined workflows.
  13. Data Historization
    Automate the process of creating historical data models for auditing and analysis.