Data Centric World

  Medallion Architecture is a data warehousing methodology that was introduced by Ralph Kimball. The architecture is designed to provide a flexible and scalable framework for data warehousing. In Medallion Architecture, data is stored in a series of layers, each layer providing a specific set of functions. One of the key layers in Medallion Architecture is the Gold Layer. In this blog post, we will take a detailed look at the Gold Layer in Medallion Architecture. What is the Gold Layer? The Gold Layer is the central layer in the Medallion Architecture. It is also known as the enterprise data warehouse layer. This layer contains the most important and trusted data in the data warehouse. The data in this layer is highly aggregated, cleansed, and integrated. The Gold Layer provides a single source of truth for the entire organization. The Gold Layer is designed to support decision-making processes at the enterprise level. The data in this layer is stored in a highly normalized format ...

In Azure Synapse Analytics, creating external tables can be a powerful way to work with large volumes of data in various file formats without loading it into the data warehouse. The CREATE EXTERNAL TABLE AS SELECT (CETAS) command is a useful feature in Synapse Analytics that allows you to create external tables directly from SQL SELECT statements. In this blog post, we will explore how to use CETAS with the OpenRowset function to create external tables in Synapse Analytics. What is CREATE EXTERNAL TABLE AS SELECT (CETAS)? The CETAS command in Azure Synapse Analytics is a powerful feature that enables you to create an external table from the results of a SQL SELECT statement. With CETAS, you can create an external table directly from the results of a query, which can be useful for creating ad-hoc reports, running data transformations, or performing other operations on data outside of the data warehouse. CETAS can be used to create external tables in various file formats, including Parqu...

The Silver Layer is an essential component of the Medallion data warehouse architecture, as it sits between the source systems and the analytical layer of the warehouse. The primary function of the Silver Layer is to prepare and cleanse data before it is loaded into the analytical layer. This is done to ensure data accuracy and consistency, making it suitable for analysis and decision-making. The Silver Layer is composed of three critical components: data integration , data quality , and data transformation . Data Integration involves collecting data from various sources and integrating it into a single dataset. This process involves extracting data from source systems, transforming it into a common format, and loading it into the Silver Layer. The goal of this component is to ensure that all data is in a consistent format, making it easier to analyze and report on. Data Quality is essential in any data warehouse. Poor data quality can lead to inaccurate reporting, flawed analyses, ...

Data wrangling, also known as data cleaning or data preprocessing, is the process of transforming raw data into a format that is more suitable for analysis . This is an important step in any data-driven project, as it ensures that the data being analyzed is accurate, complete, and relevant to the problem at hand. Microsoft Azure provides a range of tools and services that can be used to perform data-wrangling tasks. In this blog post, we will provide an overview of what data wrangling is and how to do it in Azure. What is Data Wrangling? Data wrangling is the process of transforming raw data into a format that is more suitable for analysis. This involves several steps, including cleaning, transforming, and integrating data from various sources. Cleaning: This step involves removing any duplicate or irrelevant data, correcting any errors, and filling in missing values. Transforming: This step involves converting the data into a format that is  more suitable for analysis. ...

The Bronze Layer is a critical component of Medallion Architecture. It is responsible for managing the physical data storage and retrieval from the database. In this article, we will take a closer look at the Bronze Layer, its importance in the overall Medallion Architecture, and how to implement it using Microsoft SQL Server code. What is the Bronze Layer? The Bronze Layer is the layer responsible for managing the data storage and retrieval from the database. It is responsible for creating, updating, and deleting records from the database, as well as retrieving records from the database. The Bronze Layer is also responsible for managing the data access layer of the application. The Bronze Layer is the layer closest to the database and is responsible for implementing the database access layer. The Bronze Layer provides a high-level interface for data access, allowing the application to interact with the database without needing to know the details of how the data is stored in the datab...