Star schema concept in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to define the central table in a star schema.

Power BI

FactTable = [1]

Drag options to blanks, or click blank then click option'

Aa table that stores only dates

Ba table that stores only descriptive attributes

Ca table that stores unrelated data

Da table that stores measures and keys

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing fact tables with dimension tables

Thinking dimension tables hold measures

The fact table is the central table in a star schema that stores numeric measures and foreign keys to dimension tables.

2fill in blank

medium

Complete the code to identify a dimension table in a star schema.

Power BI

DimensionTable = [1]

Drag options to blanks, or click blank then click option'

Aa table that stores numeric measures

Ba table that stores only keys

Ca table that stores descriptive attributes

Da table that stores aggregated data

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up dimension tables with fact tables

Assuming dimension tables hold numeric measures

Dimension tables store descriptive information that helps explain the facts, such as product names or customer details.

3fill in blank

hard

Fix the error in the DAX expression to create a relationship between fact and dimension tables.

Power BI

Relationship = CREATE_RELATIONSHIP(FactTable[[1]], DimensionTable[DimensionKey])

Drag options to blanks, or click blank then click option'

AFactKey

BDimensionKey

CMeasure

DDate

Attempts:

3 left

💡 Hint

Common Mistakes

Using the dimension key column from the fact table instead of the foreign key

Using measure columns instead of keys

The fact table uses a foreign key (FactKey) to link to the dimension table's primary key (DimensionKey).

4fill in blank

hard

Fill both blanks to complete the DAX formula that calculates total sales from the fact table.

Power BI

TotalSales = SUM(FactTable[[1]]) + SUM(FactTable[[2]])

Drag options to blanks, or click blank then click option'

ASalesAmount

BDiscountAmount

CQuantity

DCost

Attempts:

3 left

💡 Hint

Common Mistakes

Using quantity or cost instead of sales and discount amounts

Mixing measure and key columns

The total sales can be calculated by summing the sales amount and discount amount columns from the fact table.

5fill in blank

hard

Fill all three blanks to create a calculated column that categorizes sales as High, Medium, or Low based on Quantity.

Power BI

SalesCategory = IF(FactTable[[1]] > 100, "High", IF(FactTable[[2]] > 50, "Medium", "[3]"))

Drag options to blanks, or click blank then click option'

AQuantity

CLow

DSalesAmount

Attempts:

3 left

💡 Hint

Common Mistakes

Using different columns for the two conditions

Putting a numeric value instead of a string label in the last blank

This formula checks the Quantity column twice to assign categories: above 100 is High, above 50 is Medium, else Low.