This article serves as an introductory overview of MS Fabric and as a resource for a basic evaluation of this tool. It also functions as a hub for additional articles, where individual concepts and topics are covered in more detail. The target audience consists of individuals considering trying, learning or implementing Fabric in their organization.… Read More »
This article is intended primarily for managers, IT specialists, and technical decision-makers who are evaluating Microsoft Fabric and are considering its implementation. It is also intended for the broader professional audience that is exploring Fabric, as well as for educational purposes. The text focuses on the principles of Fabric Data Factory, key technical concepts, and… Read More »
I haven’t written anything about Excel for a long time, and today I’ve chosen the XLOOKUP function, which I shamefully haven’t described here yet. The function was officially introduced in September 2019, initially in Office 365 versions, and gradually became a standard part of Excel, including older versions. The main reason for introducing XLOOKUP is… Read More »
This article is a technical guide on how to implement a bulk table import using a single pipeline in Fabric Data Factory (or Azure Data Factory) by using a ForEach container and an external JSON configuration file. This approach enables easy addition, removal, and modification of tables without changing the pipeline itself. The JSON file… Read More »
This article is a list of commands and techniques for working with SQL Server, which are routine for advanced T-SQL developers. If you are interested in SQL basics, I recommend the SQL tutorials overview. STRING_SPLIT with the “ordinal” parameter for parsing text The newer version of the STRING_SPLIT function, available from SQL Server 2022, extends… Read More »
In the previous article Slowly Changing Dimension (SCD 2) – Snapshots I demonstrated how to implement historical tracking of dimensional data in the Silver layer within Fabric using dbt snapshots. These snapshots are already prepared and provide a complete history of dimensional changes (using the valid_from and valid_to attributes). In the Gold layer, however, we… Read More »
In several previous articles, I discussed how to configure ADLS Gen2 for storing source .parquet data and also how to connect ADLS Gen2 directly to the Fabric Lakehouse using a shortcut. To recap – in the Fabric environment, we have a prepared Bronze Lakehouse, and within this lakehouse, we have a connection to the parquet… Read More »
In the previous article – Fabric – ADLS Gen2 and Parquet – Storage Configuration and Bronze Data Format – I described how Azure ADLS Gen2 is set up for storing and archiving our source parquet files. In order to upload our source data into the Fabric Bronze layer and subsequently process it using dbt, we… Read More »
In a data architecture based on the Medallion Architecture approach, the Bronze layer represents the first stage of data processing – this is where raw, minimally transformed data from various source systems arrive. In the Fabric article series, we implement a data solution where the Bronze layer is implemented as a Lakehouse in Fabric in… Read More »
As part of the series of articles on the Microsoft Fabric platform, we focus on various features and artifacts of this data workspace environment, covering data acquisition (ingest), transformation, analytics, and data product management for efficient and secure development, orchestration, and operation of data solutions within a single integrated ecosystem. The primary artifacts that we… Read More »