Is this a theoritical question? It seems odd that the same field would reference two tables, which means that the same data point has to be true in two different...

The second...

My favourite example, a table of Marriages with exactly two attributes: Husband and Wife. Both attributes are candidate keys because clearly we don't want to allow the same person to...

Although SSIS does right fairly well to excel files, I find I have to employ inelegant "tricks" when it...

I have not found what I consider a good MDX book that seems to focus on writing MDX queries for SSAS. Even one closely titled to that, something like...

You don't give enough information to give exact advice. However, I don't see the words "grain" or "level of granularity" in your question. A fact table is an...

I'm not sure I follow this completely, but my initial inclination would be to make this a single dimension with the initial heirachical attribute having as its data either Product...

Just because there are multiple paths doesn't mean that they are all equally valid. Just as in other things there are accepted practices that exist for good reason, so...

This is true on the face of it, although whether that overhead is significant depends on the number of rows...

I don't ever recommend dropping and recreating the warehouse from scratch, although I've seen that as a solution from some consultants. It's faster to develop but ultimately (and as...

I did mean to add the word difficult. Odd that I dropped an entire word. Letters I understand... I have altered the previous post.

If the only requirement is to run SSRS reports, the operational databases shouldn't be used and the data can be one day old, I would report off a restored backup...

Great article. Lots to think about. Any thought to testing deleting the rows to be updated so that everything is then an insert. I'm not necessarily keen...

While a signed book would be cool, the seminar would be the part I'd be most...

Don't worry that you're a long way. These take time. BI is a good path to go down. You should find it worth it.