Modeling Healthcare Measurements
I'm trying to figure out how to best model a DataWarehouse Star Schema structure to capture certain medical information that will answer the questions we ask. First the questions to put in some context: 1) How many distinct patients had a BMI in the

Data Warehouse Modeling
Hello there, Considering the case that i am assigned to work on, which is to decide on the most appropriate schema to be chosen for the Data Warehouse / Business intelligenece Project. First of all, i would like to know the available options for me,

Normalized Data Store + Dimensional Modeling
Hi there Kimball forum, and welcome to my first topic :-), I just received my "Kimball's Data warehouse Toolkit Classics" on monday. Unfortunately I still can not find the hint, how to solve my design problem. We have a bit overcomplicated database

Migration to Dimensional Modeling - Testing
Hello, I migrated a relational database to dimensional modeling database. I need to test that all the information in the source system is there in the target system. One technique which can be used is... - to calculate the number of records in the

Modeling help on dimension with many boolean value
Hi I'm really stuck on how to model a user need/business need Basically, we are in the healthcare and we have a software that manage the work of the paramedics in ambulances. There is a table that store all standard informations about the work of

Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion
I've been dimensional modelling for well over 10 years, and strongly held the opinon that only a dimensional model would work for an EDW, however i'm now begining to think that there are certain requirements that lead to a 3NF design for an 'Enterprise

Need help with modeling employee and degrees earned
Requirements: 1) Provide monthly employee counts that can be sliced by an employee's degree granting institution(s) and/or institutional research activity levels 2) Count new hires by their highest degree earned at time of hire and/or by terminal

Data Warehouse for survey data
Hi All, Working with a company which uses Salesforce.com heavily. They have a large number of custom fields, and great volatility in them - frequently adding and deleting them when they cease being relevant (They collect survey data for their clients).

Data Modeler EDW - responsibilities
Hi all, I need to describe the core responsibilities of a data modeler for an EDW in the format of responsible for developing the logical and physical design for ... Standard stuff regarding experience with 3NF, Star / Snow flake, etc. would apply,

Data Vault v's Dimensional Model
Seems to be a lot of interest over at LinkedIn around the DataVault model. I wondered what the thoughts were about it. When would you use it v's a Dimensional Model or even a 3NF for a data warehouse. more info here:

2 sources using Dimensional Modeling Workbook
We are using Kimballs Generic Dimensional Modeling Workbook and it is really great! But now we have 2 sources to the same target and are not sure about how to document that. Anyone now about a best practice for how to document this in the Generic

DatawareHouse modeling (factless table)
Hi everyone ! (To begin, I want to apologize for the bad english i'm gone use cause im french canadian) system i'm using : Sql Server 2005 Ent SSAS 2005 (For cube) SSIS 2005 (For ETL) I'm in the process of building a datawarehouse for the

DIFFERENCE between Dimensional Modeling and Cube ?
Isnt cube part of Dimensional Modeling (Facts and Dimensions) ?

Dimension modeling for academic data
What am doing some initial planning of the steps I need to take to create a DW for a medical school. Tables would include students, courses, exams, questions, exam_questions, grades, stats and such. If a fact table is where I would store performance

Modeling a fact with multiple sources
We have a situation where multiple business processes will generate a recommendation. A recommendation is a set of instructions, estimated costs, risk analysis, etc. for identified hazards. Examples of various business processes that generate these