Beginning Data Modeling for DW
Hello, Please bear with me as these are a beginner's struggle to implement the DW the best way possible. I recently started studying about Kimball modeling. I would like to ask a few questions on common practices on modeling the DW. I need to

Modeling tool with support for hierarchies
Hi, this is my first post to this forum so please be nice! hehe I'm at the beginning of a fairly large DWH project (by Norwegian standards) and I have been reviewing data modeling tools recently. However, there seems to be a general lack of support

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

Geospatial Modeling
Are there any resources I can reference for modeling geospatial data? In our particular case, we are modeling a pipeline as the basic "fact" where the geographic location is of particular importance. In addition we need to model the location

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,

Some very basic question regarding overall ETL and Modeling strategy/best practices for Data warehouse project
Hi One of my client has multiple source OLTP system (due to acquisition) which stores same type of data e.g. order, sales amount etc now they might be called by different name according to source system but they mean the same e.g. one might call is

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

Dimension Modeling Design challenge - Help Needed
Guys, Help me out identifying what’s wrong with my model. I am able to get to the right data, but size of the fact table is arguably high and not gladly acceptable. Let me show you the picture (tip of the iceberg) Data table in transaction db is

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

Data Modeling question (not really dimensional though)
All, I have been trying to work through a data model for storing formulas that will be consumed by ETL. We are trying to avoid storing the formulas in our ETL and want to have a generic data structure to use. My quick example is for an Item, say Item

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,

Further reading for Recursive Hierarchy Data Modelling
Hi all I need to research Recursive Hierarchy Data Modelling in depth. I have read: www.dbmsmag.com/9809d05.html Can any readers of this forum point me in the direction of any other _detailed_ material on this subject? With anticipatory

Dimensional Model from a Hierarchical Data Source
Hi, I am facing a rather challenging situation which I don't believe is peculiar because someone/people may have resolved it before. Here we go... My data source is hierarchical from which I have been tasked with creating a dimensional model. While