Due diligence can be used in various contexts, however, it is typically a term from the fields of finance and mergers & acquisitions (M&A). We can interpret it in different ways. The most accurate meaning is in-depth analysis. Due Diligence – Definition, Purpose, and Importance Within due diligence, we systematically conduct an in-depth analysis of… Read More »
Before describing individual methods, indicators, and approaches, we will first create a kind of overview page containing all the key terms. Financial analysis is a broad discipline, and this summary will be useful. Here you will find definitions, categories of financial analysis, and links to individual articles that I will gradually prepare. What Is Financial… Read More »
Vertical analysis is one of the tools used in financial analysis. This method examines the proportions (ratios) of different items in financial statements. What is Vertical Analysis – Definition Vertical analysis (also called common-size analysis) provides insight into the structure of financial statements. The principle of this method is to express individual items in the… Read More »
In Fabric, Pipelines are commonly used to automate data workflows. These pipelines often need to pass authentication credentials, such as API keys or passwords (so-called secrets), to notebooks that execute some code. Although the platform allows “secure” storage of these values within the Pipeline as SecureString parameters, the actual transfer to the Notebook runtime environment… Read More »
To utilize Azure Service Principal authentication, it is necessary to first create an application and its credentials Entra ID (formerly Azure Active Directory). This authentication method will subsequently be required for us to correctly configure the profiles.yml file for connecting to Fabric, which is covered in the article – Fabric | dbt – Configuration profiles.yml for… Read More »
Microsoft Fabric is a robust cloud data platform that combines tools for data storage, management, analytics, and machine learning in a unified environment. The Fabric platform and pricing are designed to meet a wide range of organizational needs – from small teams to large enterprise solutions. This article provides an overview of pricing models, a… Read More »
This article describes the process for configuring the profiles.yml file within the dbt tool to be able to properly connect to the Microsoft Fabric SQL Endpoint using Service Principal (SPN) authentication (we covered SPN in article Fabric | dbt – Azure Service Principal (SPN) and RBAC for dbt in Entra ID). The goal is to… Read More »
For the cloud-based Warehouse built on top of MS Fabric, we already have a prepared Lakehouse and DWH environment and, among other things, a configured dbt project. Now comes an important DataOps phase: we need to think about From which environment (ideally serverless) we will batch-run the dbt project in the future. How to implement… Read More »
Microsoft Fabric is a unified data platform that connects various artifacts for developing data solutions, analytics, and BI in a single integrated environment. One of its key components is the Fabric Lakehouse, which combines the advantages of: Data Lake – scalability, low storage cost Data Warehouse – structured approach, SQL queries support This article describes… Read More »
Microsoft Fabric represents a unified SaaS platform that integrates components of the so-called modern data warehouse. Within a single platform, it is possible to handle storage through artifacts (Lakehouse/DWH), computing resources (Spark/Polaris), and tools for data flow orchestration. The Fabric architecture also provides tools for the transformation layer (e.g., Spark), which can be written and… Read More »