Sachin Nandanwarwww.azureguru.net·Nov 5, 2024Implement Medallion architecture with SCD Type 2 in Microsoft Fabric - Part 2In the first article of the series on Medallion architecture in Fabric we looked into the process of load, cleanse and transfer of data from the bronze layer to the Silver layer.In this blog post we would move further and delve into the process of mo...39 readsMedallion architecture with SCD Type 2 in Microsoft Fabricmicrosoftfabric
prakhar singh rajawatnormadicdba.hashnode.dev·Nov 4, 2024Introduction to Dimensional Modelling.Dimensional modelling is considered as one of the most recognized and preferred techniques for presenting Analytical Data because it addresses two Main requirements: Delivers data that is understandable to Business people. Delivers faster query per...Data Modellingdimensional data modeling
Gyuhang Shimplto001.hashnode.dev·Oct 24, 2024Data Engineer 가 알아야 할 Data Modeling (Korean)Dimensional Data Modeling 정의 Data Warehouse 설계에서 데이터를 구조화하는 중요한 기법 특히 OLAP (Online Analytical Processing) 시스템에서 주로 사용되며, 데이터를 분석하기 용이하게 구성하는 것이 목표 이 Modeling 은 크게 3 가지 구성 요소로 나눌 수 있습니다. Fact Table Dimension Table Summary Table Fact Table ...Fact Data Modeling
Analytics Engineering Digestthatjuanpablo.hashnode.dev·Sep 27, 2024Dimensional Data Modeling for an E-Commerce StoreIntroduction: Understanding the Business Process In an online retail environment like Walmart, there are multiple critical processes involved in fulfilling customer orders. These include capturing customer details, managing product inventories, proce...data-engineering
Ayodele Adeniyithe-ayodele-adeniyi.hashnode.dev·Aug 7, 2024Designing a Dimensional Model for Sales Analysis and SQL Queries for a car repair shop Using an Invoice.The image above is the Entity Relationship Diagram as inspired by the invoice sample here. You can access a better view of the image in the Google Drive here. DESCRIPTION OF EACH TABLE AND COLUMN Definition of Primary Keys for Each Table Primary keys...2 likesSQL
Cavin Karemadata-engineering.hashnode.dev·Aug 4, 2024Data Warehousing SeriesWhat are dimension tables? Dimension tables group related attributes that provide context to a business process. They contain associated context with a business process or measurement event. Dimensions are descriptive in nature, they typically descri...data
ByteHousebytehouse.hashnode.dev·Nov 3, 2023Data modelling techniques: Navigating the complexitiesThis blog post is Part 4 of ByteHouse’s 5-part series titled Data Modelling: Unlocking Insights, One Model at a Time This series will cover the following topics: Basics of data modelling and data models Data modelling vs. data architecture The dat...Data Modelling: Unlocking Insights, One Model at a Timedata-engineering
Ian Santillanievsantillan.hashnode.dev·Jun 28, 2020Four-Step Dimensional Design ProcessThe four key decisions made during the design of a dimensional model include: Select the business process. Declare the grain. Identify the dimensions. Identify the facts. The answers to these questions are determined by considering the needs of...Dimensional Model
