Oct 14, 2025
Automate SCD Type 2 Historization in Microsoft Fabric
Managing Change in Dimensional Models
Tracking changes in transactional data from ERP and CRM systems is essential for accurate reporting. Businesses...
Get trial
English
Oct 14, 2025
Automate SCD Type 2 Historization in Microsoft Fabric
Managing Change in Dimensional Models
Tracking changes in transactional data from ERP and CRM systems is essential for accurate reporting. Businesses need to understand not only the current state of a customer, product, or order but also how that state has evolved over time. This historical perspective is critical for compliance, trend analysis, and strategic decision-making.
NEWS
Posts by Gustavo Leo:
Oct 14, 2025
Accelerate Data Warehousing in Microsoft Fabric with AnalyticsCreator
Modern enterprises need structured, governed data warehouses for financial reporting, compliance, and operational analytics—even as they adopt...
Aug 14, 2025
Native Regex in SQL Server 2025 and How It Flows Straight Through AnalyticsCreator
Executive Summary
SQL Server 2025 (public preview) introduces native regular expression (regex) functions in T-SQL: REGEXP_LIKE, REGEXP_REPLACE, and ...
Jul 24, 2025
Power BI Turns 10 – AnalyticsCreator Announces Native PBIP Generation to Mark the Milestone
Ten years ago, Microsoft launched Power BI with a bold vision: to transform how individuals, teams, and enterprises visualize, analyze, and share...
Jul 21, 2025
AnalyticsCreator Adds DuckDB for File-Based SQL Exploration
Excel remains the world’s most widely used analysis tool—but its flexibility often creates challenges for standardisation, validation, and...
Jun 13, 2025
Navigating SSIS 2025(Preview) Changes: Why It's Time to Consider Automation with AnalyticsCreator
With the release of Microsoft SQL Server 2025 (SSIS - Integration Services ) has undergone a significant evolution. While these updates modernize the...
Mar 25, 2025
Best way to integrate your SAP data into Microsoft Fabric
Organizations running SAP systems and looking to modernize their data infrastructure face a common challenge: how to unlock the value trapped in SAP...
Mar 4, 2025
Enhancing AI-Driven Data Modeling in SQL Server & Power BI
Artificial intelligence is rapidly transforming how we interact with data. From generating insightful reports to automating complex analyses, AI is...
