Pages

▼
Showing posts with label DWH. Show all posts
Showing posts with label DWH. Show all posts
26 March 2025

💠🏭🗒️Microsoft Fabric: Polaris SQL Pool [Notes]

›
Disclaimer: This is work in progress intended to consolidate information from various sources and may deviate from them. Please consu...
21 October 2023

🧊💫Data Warehousing: Architecture (Part VI: Building a Data Lakehouse for Dynamics 365 Environments with Serverless SQL Pool)

›
Data Warehousing Series One of the major limitations of Microsoft Dynamics 365 is the lack of direct access to the production databases for ...

🧊Data Warehousing: Architecture V (Dynamics 365, the Data Lakehouse and the Medallion Architecture)

›
Data Warehousing Series An IT architecture is built and functions under a set of constraints that derive from architecture’s components. Usu...
03 March 2023

🧊Data Warehousing: Architecture (Part IV: Building a Modern Data Warehouse with Azure Synapse)

›
Introduction When building a data warehouse (DWH) several key words or derivatives of them appear in requirements: secure, flexible, simple,...
30 December 2020

🧊Data Warehousing: ETL (Part V: The Transform Subprocess)

›
As part of the ETL process , the Transform subprocess is responsible for bridging the gap between source and destination by leveraging SQL...
28 December 2020

🧊Data Warehousing: ETL (Part IV: The Load Subprocess)

›
As part of the ETL process , the Load subprocess is responsible for loading the data into the destination table(s). It covers in theory the ...
27 December 2020

🧊Data Warehousing: ETL (Part III: The Extract Subprocess)

›
  Data Warehousing Series As part of the ETL process with applicability to Data Warehousing, Data Migrations, Data Integrations or similar ...

🧊☯Data Warehousing: Data Vault 2.0 (The Good, the Bad and the Ugly)

›
Data Warehousing Series One of the interesting concepts that seems to gain adepts in Data Warehousing is the Data Vault – a methodology, arc...
27 November 2020

🧊Data Warehousing: ETL (Part II: An Introduction)

›
  ETL (Extract, Transform, Load) processes, technologies or tools are about extracting data from one or more data sources via a set of queri...
31 October 2020

🧊Data Warehousing: Architecture (Part III: Data Lakes & other Puddles)

›
One can consider a data lake as a repository of all of an organization’s data found in raw form , however this constraint might be too har...
24 May 2020

🧊🎡☯Data Warehousing: SQL Server Integration Services (The Good, the Bad and the Ugly)

›
Microsoft SQL Server Integration Services (SSIS) is a platform for building (enterprise-level) data integrations and data transformations so...
10 May 2019

🧊💫Data Warehousing: Architecture (Part II: Data Warehousing and Microsoft Dynamics 365)

›
With Dynamics 365 (D365) Online Microsoft made an important strategical move on the ERP market, however in what concerns the BI & Data ...