Power BI 3 – Quiz

Instructions:
1. Load each provided table (Customers, Products, Date Table, and Sales) into Power BI.
2. Identify which tables are fact and dimension tables.
3. Perform necessary transformations where required.
Hint: The Sales table is the fact table, while Customers, Products, and Date Table are the dimension
tables. (100 to 1,200 characters) *

1. What is the purpose of a fact table in a star schema? *

Storing descriptive attributes of entities

Storing transactional data and numerical metrics

Only holding text-based information

Acting as a backup table

2. Which of the following is NOT a characteristic of a dimension table? *

It contains foreign keys linking to fact tables

It stores textual and descriptive data

It contains aggregated numerical values

It provides context to the fact table

3. Which column in the Sales table should be used to create relationships with the Customers
table? *

Product_ID

Customer_ID

Date_ID

Transaction_ID

4. In Power BI, how do you establish relationships between tables? *

Using Excel formulas

Using DAX queries

Using the Manage Relationships feature

Importing the tables multiple times

5. Which table should contain the primary key for the Product ID column? *

Sales

Customers

Products

DateTable

6. What transformation should be applied if some rows in the Customers table contain missing
Age values? *

Remove the entire Customers table

Replace missing values with a default age

Ignore missing values

Remove all rows with missing values

7. Why is it important to transform and clean data before creating relationships in Power BI? *

To make the dataset look more appealing

To ensure accurate reporting and avoid relationship errors

To add unnecessary complexity to the data model

To increase file size

DATA ANALYSIS - POWER BI

Power BI 3 – Quiz