To create relationships between tables

To clean and transform data in Power Query

To design report layouts and visuals

To define custom calculations and measures

Denormalise the dimension tables and incorporate

all attributes directly into the fact table to reduce joins.

Create separate dimension tables for customer, product, and date, and

establish relationships with the fact table.

Use calculated columns in the fact table to

store dimension attributes and avoid the need for separate dimension tables.

Implement a snowflake schema for both fact and

dimension tables to ensure a normalized structure.

The total number of sales transactions in Australia

The sum of revenue where the country is Australia

The sum of revenue across all countries

An error due to incorrect syntax

Label everything manually, even if the chart has a legend

Use as many visual types as possible to show variety

Use 3D charts to make visuals more appealing

Keep visuals minimal and focused on key insights

The aesthetics

of a product's appearance.

The speed at

which users can navigate through a system.

The

cost-effectiveness of implementing design features.

The

functionality and ease of use of interactive elements.

Data visualisation only applies to industries directly related to

graphic design.

Data visualisation refers to the process of

visualising organised data.

Data visualisation involves creating visual representations of data to

help identify patterns, trends, and insights.

The filters applied by slicers and visuals

A special context used only in calculated tables

The evaluation of a formula across all rows in a column

The context provided by iterating functions like SUMX() or FILTER()

YTD(Sales[Revenue], Dates[Date])

CALCULATE(YTD(Sales[Revenue]), Dates[Date])

TOTALYTD(Sales[Revenue], Dates[Date])

SUMYTD(Sales[Revenue], Dates[Date])

Power BI does

not utilize primary and foreign keys in its data modelling process.

Both primary

and foreign keys serve identical functions in Power BI data modelling.

The primary

key ensures data uniqueness within a table, while the foreign key provides

context and descriptive information about the data.

The primary

key identifies unique records within a table, while the foreign key establishes

relationships between tables.

By minimising data duplication and ensuring each data attribute is

stored in only one place.

By increasing redundancy to improve data

integrity and reduce data anomalies.

By introducing data dependencies to simplify data retrieval.

By allowing for duplicate records to improve query performance.