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 about Azure:
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 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...
May 31, 2025
How Data Mesh Can Succeed on the Microsoft Data Stack
Enterprises are embracing Data Mesh as a modern architecture to decentralize data ownership, enable self-serve platforms, and deliver domain-oriented...
May 30, 2025
How to Operationalize Data Products Without Overburdening Domain Teams
Data Mesh promises to decentralize data ownership by empowering business domain teams to deliver their own data products. It sounds great in theory:...
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 20, 2025
SQL Server 2025: Pioneering the Future of Data Management with AI Integration
Microsoft's recent announcement of SQL Server 2025 signifies a pivotal advancement in data management, seamlessly integrating artificial intelligence...
Feb 27, 2025
Managing and Interpreting Data in a VUCA World: A Microsoft Ecosystem Perspective
Markets are turbulent. Leadership must be data-driven to navigate volatility, uncertainty, complexity, and ambiguity (VUCA). Business leaders and...
Aug 28, 2024
The High Cost of Cloud Dependency
The phenomenon of lock-in, where customers become dependent on a single provider, poses significant challenges to businesses and economies. This is...
Jan 15, 2024
Reduce Prototyping Costs for Azure Data Warehouses
Prototyping a data warehouse solution in Azure can be a costly process, especially if you are using Azure Synapse Analytics. However, there are a...
Dec 20, 2023
Snapshot Historization in Azure: Trend & Data Analysis
Snapshot historization is a powerful technique that allows you to store and access historical data at specific points in time. It is particularly...
Dec 15, 2023
Optimizing Azure with Holistic Data Models & Catalog
In an increasingly data-driven world, organizations are generating and storing exponentially more data than ever before. Managing, understanding, and...
Dec 9, 2023
Data Warehouse Automation: Boost Efficiency in Azure
Data warehouse automation (DWA) is a process that uses technology to perform data warehousing tasks with minimal human intervention. It involves...
Dec 1, 2023
How AnalyticsCreator Empowers Organizations to Maximize Their Power BI and Azure Investments
Microsoft stands as a leader in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms. Its flagship BI platform, Power BI,...
Jun 16, 2023
How AnalyticsCreator Can Help Companies Make the Most of Microsoft Fabric
Microsoft Fabric: A Data Platform for the Modern Enterprise
Microsoft Fabric is a data platform that helps businesses make better decisions with...
Sep 14, 2022
New connector for exporting data from DWH to many target systems
With the latest version of AnalyticsCreator you are able to generate Azure Data Factory pipelines and also SSIS packages to export data from your ...
Aug 29, 2022
AnalyticsCreator leads a way in the BARC DWH Management survey 4 years
AnalyticsCreator automates the whole life-cycle of a #dwa - the design, the development, the deployment and the change process. You will gain...
