Oct 14, 2025
Automate SCD Type 2 Historization in Microsoft Fabric and SQL Server
SCD Type 2 is essential for historical reporting, but it can be complex to implement manually. AnalyticsCreator supports metadata-driven...
Get trial
English
Oct 14, 2025
Automate SCD Type 2 Historization in Microsoft Fabric and SQL Server
SCD Type 2 is essential for historical reporting, but it can be complex to implement manually. AnalyticsCreator supports metadata-driven historization by helping teams define SCD rules and generate the structures, logic, and deployment artifacts needed for SQL Server and Microsoft-oriented data warehouse environments, including relevant Microsoft Fabric scenarios.
NEWS
Posts by Gustavo Leo:
Oct 14, 2025
Kimball Modeling in Microsoft Fabric SQL: Automated with AnalyticsCreator
Microsoft Fabric SQL provides a scalable warehouse engine, but not the modeling logic. AnalyticsCreator fills the gap by automating Kimball-based...
Aug 14, 2025
SQL Server 2025 Adds Native Regex: What It Means for AnalyticsCreator Users
SQL Server 2025 introduces REGEXP_LIKE, REGEXP_REPLACE, and REGEXP_SUBSTR to T-SQL. These work out-of-the-box with AnalyticsCreator, enabling...
Jul 24, 2025
Celebrating 10 Years of Power BI with Native PBIP Automation in AnalyticsCreator
Power BI celebrates its 10th anniversary with over 375,000 organizations relying on it globally. To mark this milestone, AnalyticsCreator now...
Jul 21, 2025
Excel as a Source: How to Automate Validation and Modeling Without Manual ETL
Excel is powerful but prone to structure drift, format inconsistencies, and version issues. Instead of building complex ETL workflows to fix it...
Jun 13, 2025
SSIS 2025 Migration: Why Manual Package Maintenance is Now a Liability
SQL Server 2025 introduces breaking changes for SSIS. Organizations still relying on manually maintained packages face growing technical debt and...
Mar 25, 2025
Microsoft Fabric SAP Integration: Architecture, Best Practices & How AnalyticsCreator Accelerates Migration
Organizations running SAP systems and modernizing their data landscape often face the challenge of unlocking value from SAP data and integrating it...
Mar 4, 2025
How Metadata Supercharges AI: Why Strong Data Models Improve AI-Generated SQL Queries
Artificial intelligence is rapidly reshaping how organizations work with data—from automating complex analyses to generating real-time insights. But...
