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 20, 2024Dimensional Data Model for Airbnb and VRBOUnderstanding the Business Domain Before diving into the data model, it's crucial to understand the key entities and relationships in an online marketplace for short-term homestays. Here are the primary entities: Users: Guests and hosts Properties:...analytics engineering
Freda Victorlearndataengineering.hashnode.devยทSep 17, 2024Automating a Scalable Data Pipeline with AWS Glue, Athena, and TerraformIntroduction In todayโs data-driven world, companies need to process large volumes of data quickly and efficiently to derive meaningful insights. As a data engineer, youโre tasked with building robust, scalable systems that extract, transform, and lo...AWS Glue
Analytics Engineering Digestthatjuanpablo.hashnode.devยทAug 16, 2024Dimensional Data Model for Ride-Sharing App AnalyticsCover photo credits: Ehsan Haque via Pexels "Dimensional models are gracefully extensible to accommodate change. The predictable framework of a dimensional model withstands unexpected changes in user behavior" - Ralph Kimball Understanding the Busi...analytics engineering
Sweta_Sarangiswetasarangi.hashnode.devยทDec 14, 2023What is star schema?A star schema is a multi-dimensional data model designed to facilitate the organization, understanding, and analysis of data within a database. It is applicable to various data management tools such as data warehouses, databases, data marts, and othe...Blogging
The Analyst Geektheanalystgeek.hashnode.devยทAug 18, 2023Different database design approaches Star schema and Relational schema.Star Schema and Relational Schema are both database design approaches used to structure data for efficient storage and querying, but they have different focuses and characteristics. Let's explore the differences between them: Data Modeling Approach:...SQL
Ashish GSashishgs.hashnode.devยทMar 18, 2023Dimensional ModellingWhat is Dimensional Modelling in Data Warehouses? Dimensional modelling (DM) is a data structure technique optimised for data storage in a Data warehouse. The purpose of dimensional modelling is to optimise the database for faster retrieval of data. ...75 readsDatabases
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