Data Warehouse Modeling

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).

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

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

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

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

Data Warehouse with high data availability

When a data warehouse is being updated by periodical ETL load, there could be significant performance impact on the end users' reports while the underlying tables are touched. The data becomes volatile and the query results could be different between

Request of information: Italian softwarehouse for federated Data Warehouse

Hello, I work for an Italian financial Company that needs to reorganize the current reporting system (mainly based on Business Objects), which is made of many Data Warehouses and Datamarts in Oracle and SAP/BI. I'm interested in a federated solution

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it

Defining technical requirements for a datawarehouse, an existing one at that

I have no experience doing requirements documentation for a data warehouse, and am hoping an experienced practitioner or two can provide some practical lessons from documenting a data warehouse. To add an extra twist, the data warehouse is already in

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

Bimbingan Teknis Pengembangan E Learning SMK RSBI Se Indonesia Di Jakarta

Pada tanggal 21 Juli sampai dengan 23 Juli 2010 , SMKN 1 Slawi mengirimkan perwakilan kaitannya dengan undangan dari Ditpsmk yaitu Bimbingan Teknis Pengembangan E Learning yang diikuti oleh seluruh SMK RSBI dari seluruh indonesia yang bertempat di Melawai

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:

ODROID-T software update.

New release can be found on this link. http://dev.odroid.com/projects/odroid-t/download * What's new - Touch screen self-calibration is added. (Don't touch the Odroid-T while booting up) - Touch screen device driver is changed from