Business Intelligence and Dimensional

  • Experience with the data vault

    The data vault is a data warehouse design structure which varies from traditional data warehouse architecture in several ways including...

    0
    Steve Hoberman's first word was "Data"
  • Dimensional logical?

    You are sitting in a smoky bar and you hear some loud voices becoming louder at the other end...

    0
    Steve Hoberman's first word was "Data"
  • Aggregation, summarization, and abstraction demystified

    As a data modeling expert in your company, you are frequently being asked modeling advice. After dazzling your coworkers...

    0
    Steve Hoberman's first word was "Data"
  • Creative hierarchy

    An organization has a sales department with four levels, as shown in the following logical data model: Zones are...

    0
    Steve Hoberman's first word was "Data"
  • Super Star

    A star schema is designed to efficiently answer metric business questions, such as those questions that return amounts, quantities,...

    0
    Steve Hoberman's first word was "Data"
  • Recursive fact table?

    To better understand the requirements for an analytics data mart, you and a business user are standing at the...

    0
    Steve Hoberman's first word was "Data"
  • A Dimensional EDM

    One day a colleague asks you for feedback on an enterprise data model (EDM) she has been tasked with...

    0
    Steve Hoberman's first word was "Data"
  • Timeless Dimensional Model

    When I teach dimensional modeling, I always stress the need for a time dimension. Recently in a session, a...

    0
    Steve Hoberman's first word was "Data"
  • Business intelligence?

    Imagine you are a data analyst on a highly motivated business intelligence team about to start Phase 1 of...

    0
    Steve Hoberman's first word was "Data"
  • As low as you can go

    A modeler on your team is building a Consumer Complaint dimensional model. The business requirement is to allow users...

    0
    Steve Hoberman's first word was "Data"