Aug 28, 2025 · 11 min read · This refers to the process of customising the appearance of the visuals within a report to make them more appealing, insightful, and easier to interpret. Some of the reasons why we format visuals include; Enhanced readability: Makes it easier for us...
Join discussion
Aug 6, 2025 · 8 min read · Introduction to Data Modeling What is a Data Model? A data model is the foundation of your Power BI report. It defines how data tables are connected and how they interact with each other. Think of it like a map that tells Power BI how to find and rel...
Join discussionJun 9, 2025 · 3 min read · As I dive deeper into Week 4 of the Cyber Shujaa program, I'm learning how to turn raw data into actionable insights. In this article, I walk you through how I transformed raw hotel booking data into a clean star schema, developed meaningful DAX meas...
Join discussion
May 23, 2025 · 1 min read · If you're learning about data warehousing, you’ve likely come across terms like Star Schema and Snowflake Schema. In this blog, we’ll focus on one of the most important models — the Snowflake Schema in Data Warehouse. This guide is specially written ...
Join discussionNov 4, 2024 · 4 min read · 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...
Join discussionOct 24, 2024 · 45 min read · Dimensional Data Modeling 정의 Data Warehouse 설계에서 데이터를 구조화하는 중요한 기법 특히 OLAP (Online Analytical Processing) 시스템에서 주로 사용되며, 데이터를 분석하기 용이하게 구성하는 것이 목표 이 Modeling 은 크게 3 가지 구성 요소로 나눌 수 있습니다. Fact Table Dimension Table Summary Table Fact Table ...
Join discussion
Sep 20, 2024 · 3 min read · Understanding 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:...
Join discussion
Sep 17, 2024 · 11 min read · Introduction 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...
Join discussion
Aug 16, 2024 · 6 min read · Cover 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...
Join discussion
Dec 14, 2023 · 4 min read · 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...
Join discussion