Coursera Microsoft Power BI Data Analyst • STUDY MODE
Practice Quiz
QUESTION 1 OF 24
Based on your observation of the first 10 records in the dataset, which product generated the highest Net Revenue?
A
ProTile Cutter
B
Luxury Paint (Blue)
C
Power Drill SetCorrect Answer
QUESTION 2 OF 24
True or False: Net Revenue for each product is calculated by subtracting the tax amount from the gross revenue.
A
TrueCorrect Answer
B
False
QUESTION 3 OF 24
What was your next step after calculating the gross revenue for each product?
A
Ensure the Gross Revenue column reflects the multiplication of the product’s price by the quantity sold.
B
Calculate each product’s Total Tax by multiplying the tax per product by the quantity sold.Correct Answer
C
Immediately analyze the trends in the Sales Rep column.
QUESTION 4 OF 24
What was the purpose of selecting the Whole Number data type for the OrderID column in the Tailwind Traders Sales data?
A
To allow OrderID to have decimal values for more granularity
B
To ensure every OrderID is consistent and avoids any reporting errorCorrect Answer
C
To convert the OrderID into a textual format for better readability
QUESTION 5 OF 24
True or False: When configuring the Purchases dataset, ensuring the Valid percentage is less than 100% in the Column Quality pane indicated no errors or empty cells needed addressing in the ReturnStatus column.
A
True
B
FalseCorrect Answer
QUESTION 6 OF 24
What purpose did the Python script serve in the exercise?
A
To transform and refine the historical currency exchange data.Correct Answer
B
To ensure data consistency and integrity for datasets.
C
To assist in the extraction of specific data elements from datasets.
QUESTION 7 OF 24
While designing and developing the data model, which tables did you establish a relationship based on One-to-one (1:1) cardinality? Select all that apply.
A
Calendar and Purchases tables.
B
Purchases and Sales tables.Correct Answer
C
Countries and Exchange Data tables.Correct Answer
D
Sales and Countries tables.
QUESTION 8 OF 24
True or False: The Net Revenue in USD for the order with Order ID 1035 is 300USD, representing the total revenue generated from this order before accounting for any deductions, returns, allowances, and discounts.
A
True
B
FalseCorrect Answer
QUESTION 9 OF 24
Which cardinality was required for the relationship between the Sales and Countries tables?
A
Many to Many
B
Many to One (1:1)Correct Answer
C
One to One (1:1)
QUESTION 10 OF 24
Which DAX function was important for determining the company’s median sales?
A
TOTALYTD
B
MEDIANCorrect Answer
C
SUM
QUESTION 11 OF 24
True or False: When calculating the Yearly ProfitMargin for Tailwind Traders, you derived the margin by dividing the total gross revenue by the net revenue from the Sales in USD table
A
TrueCorrect Answer
B
False
QUESTION 12 OF 24
Which DAX formula did you use to calculate the Year-to-Date profit?
What type of chart did you use to visualize Loyalty Points by Country?
A
Line chart
B
Pie chart
C
Clustered bar chartCorrect Answer
QUESTION 14 OF 24
True or False: The UAE has the highest loyalty points among the listed countries, leading the chart with 151 loyalty points.
A
True
B
FalseCorrect Answer
QUESTION 15 OF 24
Which of the following metrics did you use to create a Card visual? Select all that apply.
A
StockCorrect Answer
B
Quantity PurchasedCorrect Answer
C
Median SalesCorrect Answer
D
Loyalty Points
QUESTION 16 OF 24
Which features in Power BI did you utilize to enhance the Profit report’s effectiveness? Select all that apply.
A
Data drilling in visuals
B
Sorting axis in bar chartsCorrect Answer
C
Detailed labels in donut chartsCorrect Answer
D
Forecasting in Area Charts
QUESTION 17 OF 24
True or False: The area chart for Yearly Profit Margin over Time in the Tailwind Traders Profit Report was primarily created for forecasting future sales volumes.
A
True
B
FalseCorrect Answer
QUESTION 18 OF 24
Which visuals did you create to help analyze profit data in the Profit Report? Select all that apply.
A
A bar chart for Net Revenue by Product.Correct Answer
B
A column chart for Quantity Sold by Product.
C
A line chart for Median Sales over Time.
D
A donut chart for Yearly Profit Margin by Country.Correct Answer
QUESTION 19 OF 24
What was the primary consideration for optimizing the dashboard for mobile accessibility?
A
To ensure faster loading times for international data access.
B
Ensuring that crucial data is readily available on-the-go.Correct Answer
C
To allow for real-time communication with the team.
QUESTION 20 OF 24
True or False. Based on your observation of the Net Revenue by Product bar chart, the Modular Sofa Set product has the highest Net Revenue.
A
TrueCorrect Answer
B
False
QUESTION 21 OF 24
When pinning the Profit OverviewCore Visualizations, which chart type represented Yearly Profit by Country?
A
Bar chart
B
Donut chartCorrect Answer
C
Line chart
QUESTION 22 OF 24
What occurs when the Gross Revenue falls below $400?
A
Immediate changes to business strategies are initiated
B
The Gross Revenue data is reset for the next monitoring period.
C
An alert is triggered, indicating a potential financial concern.Correct Answer
D
An automated report is generated detailing the reasons for revenue decline.
QUESTION 23 OF 24
True or False: The UAE leads the Median Sales Distribution by Country visual with a value of 20.85, indicating its prominence as a key market for sales revenue and suggesting that most sales transactions in the UAE are of high value.
A
TrueCorrect Answer
B
False
QUESTION 24 OF 24
On which days of the week was the Profit Overview subscription scheduled to support strategic decision-making at Tailwind Traders optimally? Select all that apply.
A
FridayCorrect Answer
B
Tuesday
C
MondayCorrect Answer
D
WednesdayCorrect Answer
Ready to test your recall?
Based on your observation of the first 10 records in the dataset, which product generated the highest Net Revenue?