Oops, Hang Liu, let me clarify something in turn:

ease of use refers to the data model’s usage from the report writer’s perspective, not necessarily the end user or self-service perspective....

Hi Hang Liu,

Everything you're saying makes sense to me.  Thank you.  I am 100% sure I would "graduate" from the FKs in the fact table to additional dimensional work if...

@jeff,

Wait ... what?  I apologize, in that case, because all this time I thought you were arguing on the side of perf and resource usage, and all I was saying...

Hi Hang Liu,

Thank you again for your article and for this neat summary of the questions and trade-offs.  I'm glad you are continuing the series.

>While this solution may not integrate...

> Did you find it necessary to use temporal range tables, like the one in this article, to solve for those questions?  That's really what started this whole conversation.

Of course...

Yep, Jeff, here's the very crux of it:

"Better" has many facets to consider... accuracy, performance, resource usage, easy of usage, etc.

I'm going to say a lot of things below, because...

• This reply was modified 1 years, 12 months ago by Lisa Slater Nicholls.
• This reply was modified 1 years, 12 months ago by Lisa Slater Nicholls.

Fair point @jeff, but I think Ron and many other people who build DWs (or Power BI developers?) are more concerned with making the data, and potential calculations, as transparent...

I like this a lot. And will definitely use it, thank you! But this sentence in the article had me scratching my head trying to understand what you were trying...

Take a look at the connection strings here https://www.connectionstrings.com/access/, I am definitely no expert on accessing Access (in fact, when I get it right, it's usually because I've put another...

> I like the ones that ask a homework question or work related question then delete the question so nobody can find out. - lol

I am guessing the former, unless...

[accidental duplicate post, please delete]

• This reply was modified 2 years, 4 months ago by Lisa Slater Nicholls. Reason: [accidental duplicate post, please delete]

Agreed, nice approach, and I like that it is generic.  I'm going to offer an alternative that has worked for me a lot in the past -- the illustration is...

@jeff,

> This is how "myths" and "Best Practices" that aren't get started.

You are, of course, correct, sir.   In pretty much any field.

 >I've also been doing what the original meaning of...

@jeff, while I agree with you about the most important goal, I don't think Steve meant "daily" when he said "everyday".  He meant "quotidien/mundane/matter-of-fact/run-of-the-mill/as-expected".  And no, I'm not checking a...

Vich b, the difference between you and the c-level checkwriters is that you probably learned your lesson <g>.

The hamsters are going to cope with the decision, move heaven and earth...