samhita sarkarsamhita-sarkar.hashnode.dev·Nov 11, 2024Deciding When to Normalize or Denormalize Data for Best ResultsNormalisation and denormalisation are essentially design patterns in databases that determine how data is stored and used. Storage pattern : The key difference between normalisation and denormalisation is their storage patterns, which are essentially...1 like·54 readsDatabases
Sion Kimsionkim.hashnode.dev·Oct 13, 2024Little Bit of Analytics EngineeringThis article is a note on a book Analytics Engineering with SQL and dbt. Chapter 1. Analytics Engineering Data Analytics Lifecycle Problem definitionFirst, we need to understand the problem. Identify the business objectives and available resources t...64 readsdbt
Analytics Engineering Digestthatjuanpablo.hashnode.dev·Oct 4, 2024Dimensional Data Model for App Help Center PageIntroduction The success of a digital product heavily depends on providing users with efficient support and guidance. One of the key tools for achieving this is a well-structured help center that users can navigate to find solutions to their problems...dimensional modelling
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
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
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
