Alex Mercedalexmerced.hashnode.dev·Oct 30, 2024Data Modeling - Entities and EventsStructuring data thoughtfully is critical for both operational efficiency and analytical value. Data modeling helps us define the relationships, constraints, and organization of data within our systems. One of the key decisions in data modeling is ch...Discussdata-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 ...DiscussFact Data Modeling
Shreyash Banteshreyash27.hashnode.dev·Oct 3, 2024Exploring Advanced Data Architectures: Common Data Model and Master Data Model🏢🚀3. Common Data Model (CDM) Overview: The Common Data Model (CDM) is a standardized and shared data schema that helps integrate and manage data across various systems, applications, and business processes. It provides a common framework for how data i...DiscussData Science
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...Discussdata-engineering
Tanishka Marrottcloud-design-diaries.hashnode.dev·Sep 23, 2024The Multi-Tier Architectural Pattern. Making complex things *simple*I’ve been in the cloud for quite a few years now; and among the most widely adopted and trusted approaches is the multi-tier design pattern. The reason for this? It elegantly divides an application into its core components, making it easier to manage...Discuss·2 likesMulti-Tier Architecture
Iman Adekoimanadeko.hashnode.dev·Sep 23, 2024Analyzing Sales Data from a NYC Coffee ShopIn my last post, I expressed my interest in undertaking a data modeling and visualization project in Snowflake. In this post, I will guide you through the entire process, step by step. Before you begin, ensure that you have Snowflake and SnowSQL set ...Discuss·10 likessnowflake
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:...Discussanalytics engineering
Sai SrirampurforPeerDB Blogblog.peerdb.io·Aug 28, 2024Postgres to ClickHouse: Data Modeling TipsLast month, we acquired PeerDB, a company that specializes in Postgres CDC. PeerDB makes it fast and simple to replicate data from Postgres to ClickHouse. A common question from PeerDB users is how to model their data in ClickHouse after the replicat...Discuss·224 readsPostgreSQL
IT Path Solutionsitpathsolutions1.hashnode.dev·Aug 23, 2024How to Create a Data Model in Power BI: A Step-by-Step GuideCreating an effective data model is crucial for making the most out of Power BI. A well-structured data model ensures that you can analyze and visualize data efficiently. This guide will walk you through the steps of creating a data model in Power BI...DiscussPowerBI
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...Discussanalytics engineering