Dumb data question: what is a fact table and why would it be useful for an

Report problem with this ad

Apr 30, 2021
9:53:16pm

crazY Truly Addicted User

Dumb data question: what is a fact table and why would it be useful for an

application like Power BI?

Report problem with this ad

crazY

Bio page: crazY
Joined: Sep 6, 2010
Last login: May 17, 2024
Total posts: 53,941 (30,331 FO)

Report problem with this ad

Messages

Author

Time

Dumb data question: what is a fact table and why would it be useful for an

crazY

4/30/21 9:53pm

It's a way to organize data in a reporting environment

Darzog

4/30/21 9:58pm

So, it's basically just imported data?

crazY

4/30/21 10:13pm

That's how I've always seen it.

Darzog

4/30/21 10:32pm

Thanks. Good to know. I'd never heard the term before today, so I just always

crazY

4/30/21 10:44pm

Fact tables store the quantitative observations along with IDs which will allow

4/30/21 10:33pm

So, follow up question to this:

crazY

4/30/21 11:15pm

A few things

Darzog

4/30/21 11:26pm

Following up darzog - you don’t want reporting from source system.

molodyets

4/30/21 11:31pm

And there may be situations where you de normalize it and don’t have them for something in your reporting layer

molodyets

4/30/21 11:32pm

The primary benefit of a fact/dimension data model is to maximize performance,

Megamind

5/1/21 10:55am

That makes sense. Another question:

crazY

5/1/21 11:14am

You would have something like this:

molodyets

5/1/21 11:36am

Typically you generate new IDs when you import data into your warehouse. Any

Megamind

5/1/21 11:40am

I walked away from a job that would have been a $30k year raise because of this

Megamind

5/1/21 12:05pm

This sounds miserable. I wonder how it ended up.

molodyets

5/1/21 12:13pm

It's still going. It happened in January. I'm interested to see how they do.

Megamind

5/1/21 12:31pm

I'm not sure I completely understand what you're asking

Darzog

5/1/21 11:44am

Thank you for participating in this exercise of fact tables for dummies.

crazY

5/1/21 2:46pm

Report problem with this ad

Posting on CougarBoard

In order to post, you will need to either sign up or log in.

Report problem with this ad