Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Data Analytics > DAX Power Bi models > Flashcards

DAX Power Bi models Flashcards

1
Q

What two tables are used in a Star Schema Design?

A

Fact Tables
Demension Tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What data is listed on Fact Tables

A

Observation or events of business activity.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What kind of data is stored on Dimension Tables?

A

Business entities (people, places, concepts, dates …)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are 6 components of a DAX formula?

A
  1. DAX Function
  2. DAX operators
  3. References (to model objects)
  4. Constant Values
  5. DAX Variables
  6. Witespace
How well did you know this?
1
Not at all
2
3
4
5
Perfectly

Data Analytics (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions