Modeling Healthcare Measurements

Painted into a healthcare DW "digital corner" -- or is it wrong to have keys and attributes in a single table

Here's the short version: Is it OK to have a table which contains keys from other dimensions AND includes additional fields for attributes? (Is this a dimension, outrigger, factless, or merely unusual or just wrong?) Here's the long version (with

Phil 213 Ethics and Healthcare

I bought it used from VA Bookcompany for $40, Bioethics, An Anthology Second edition, edited by Helga Kuhse and Peter Singer. ISBN:978-1-4051-2948-0 I'd like to get about $30 for it.

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

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

Dimensional modeling on HospitalStay

a different question on The Data Warehouse Toolkit, 2nd Ed. The complete guide to Dimensional Modeling. In Chapter 13 page 265 "In a hospital stay situation, however, the diagnosis group probably should be unique to the patient because it is

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

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

Big Data - Big Math and Enabling Customer Intimacy at Scale

Engagement Leader Job Opening If building and growing an early stage company is in your career plan... If you bring a comprehensive leadership and management playbook for how to deliver large-scale data-intensive solutions If you have an excellent

Dimension Modeling Design challenge - Help Needed

Guys, Help me out identifying whats 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

Customer addresses in a high volume retail environment

I have a requirement to start capturing addresses in our data warehouse for detailed analysis of customer returns. Up until now, analysis at postal code has been sufficient. The company I work is mail order, so the addresses I need to record

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

Transitive Dependency

There are many dimensional tables in our organzation has got transitive dependency in them and we are forced to adopt different SCD types like type 1 and type 2 I will explain my scenario with an example(see table below) ,the Item dimension has got