Why Power BI is essential for business intelligence - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to load data into Power BI.

Power BI

let Source = Excel.Workbook(File.Contents([1]), null, true)

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

Adatabase

Bdata.csv

C"data.xlsx"

DTable1

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting quotes around the file name

Using a table name instead of a file path

The file path must be a string with quotes, like "data.xlsx" to load an Excel file.

2fill in blank

medium

Complete the DAX formula to calculate total sales.

Power BI

Total Sales = SUM([1][SalesAmount])

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

AOrders

BProducts

CCustomers

DSales

Attempts:

3 left

💡 Hint

Common Mistakes

Using a table without the SalesAmount column

Using Customers or Products tables incorrectly

The 'Sales' table contains the 'SalesAmount' column to sum for total sales.

3fill in blank

hard

Fix the error in the DAX measure to calculate average sales.

Power BI

Average Sales = AVERAGE([1][SalesAmount])

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

ACustomers

BSales

COrders

DRegions

Attempts:

3 left

💡 Hint

Common Mistakes

Using a table without the SalesAmount column

Using unrelated tables like Customers or Regions

The 'Sales' table contains the 'SalesAmount' column needed for the AVERAGE function.

4fill in blank

hard

Fill both blanks to create a filter that shows sales greater than 1000.

Power BI

Filtered Sales = CALCULATE(SUM(Sales[SalesAmount]), Sales[SalesAmount] [1] 1000)

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

A>

B<

C&&

D||

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>'

The filter uses '>' to select sales greater than 1000.

5fill in blank

hard

Fill all three blanks to create a calculated column for profit margin percentage.

Power BI

Profit Margin % = DIVIDE(Sales[[1]] - Sales[[2]], Sales[[3]]) * 100

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

ARevenue

BCost

DSalesAmount

Attempts:

3 left

💡 Hint

Common Mistakes

Using SalesAmount instead of Revenue for denominator

Swapping Revenue and Cost columns

Profit margin is calculated as (Revenue - Cost) divided by Revenue, then multiplied by 100 for percentage.