Coursera Microsoft Power BI Data Analyst • STUDY MODE
Practice Quiz
QUESTION 1 OF 36
Based on the line chart representing Adventure Works’ sales revenue over time, which month recorded the highest sales revenue?
A
MarchCorrect Answer
B
April
C
January
D
February
QUESTION 2 OF 36
According to the stacked bar chart representing Adventure Works’ sales by day of the week, which day recorded the lowest total sales?
A
Tuesday
B
Monday
C
ThursdayCorrect Answer
D
Friday
QUESTION 3 OF 36
Based on the pie chart representing sales by product category, which bike type accounted for the second lowest amount of sales?
A
E-Bikes
B
BMX BikesCorrect Answer
C
Touring Bikes
D
Hybrid Bikes
QUESTION 4 OF 36
What is the fundamental role of data visualization in the field of Business Intelligence?
A
To replace raw data
B
To eliminate the need for data analysis
C
To improve the visual appeal of data reports
D
To transform complex data into understandable insightsCorrect Answer
QUESTION 5 OF 36
What type of data visualization is most suitable for comparing larger quantities or categories?
A
Pie charts
B
Tables
C
Bar chartsCorrect Answer
D
Line charts
QUESTION 6 OF 36
You are creating a report in Microsoft Power BI. You have imported, cleaned, and transformed your data. What is your next step?
A
Save your report and name it using a descriptive title
B
Add data fields in the Fields pane
C
Select a data visualization type in the Visualizations paneCorrect Answer
D
Add data by selecting the Get Data button
QUESTION 7 OF 36
What happens when you select the column header in the table visual of Microsoft Power BI?
A
The data within that column is highlighted for editing.
B
The table visual’s position on the report changes.
C
It opens a detailed view of the data within the column.
D
The column data is sorted in ascending order; selecting again sorts it in descending order.Correct Answer
QUESTION 8 OF 36
You are creating a data analysis report for the sales department at Adventure Works exploring sales of different bicycle models over the past five years. What type of visualization is appropriate to clearly and effectively demonstrate trends in bicycle sales over time for stakeholders?
A
Bar charts
B
Line chartsCorrect Answer
C
Pie charts
D
Column chart
QUESTION 9 OF 36
At Adventure Works, the financial department requires raw, detailed data and exact numbers of bicycle production quantities as part of its cost analysis and financial reporting and planning. Which visualization is best suited to presenting the production quantities in this scenario?
A
Bar charts
B
Pie charts
C
TablesCorrect Answer
D
Line charts
QUESTION 10 OF 36
As the data analyst at Adventure Works, you are responsible for creating reports to inform and improve the organization’s primary business operations. Which of the following report types are suited to this purpose? Select all that apply.
A
Sales reportsCorrect Answer
B
Marketing reportsCorrect Answer
C
External vendor reports
D
Financial reportsCorrect Answer
QUESTION 11 OF 36
As a Power BI data analyst, you need to create data analytics reports, including sales reports for businesses like Adventure Works. What purpose does the Visualizations pane serve in the analysis process?
A
To create, modify, and manage visual elementsCorrect Answer
B
To manage the data
C
To analyze the data
D
To convert the data into text-based reports
QUESTION 12 OF 36
You are creating a sales report using Power BI and need to manage and manipulate the data fields in your visualizations. When navigating through the Visualizations pane, what two main parts are available within the Fields section to accomplish this?
A
Fields wells and Format wells
B
Fields list and Format list
C
Fields list and Fields wellsCorrect Answer
D
Format list and Analyze tab
QUESTION 13 OF 36
The sales manager at Adventure Works collected monthly sales data over the last two years. The data includes information about the sales volume for different products across different regions. You want to illustrate trends over time and compare the sales. What chart type is most suitable for this purpose?
A
LineCorrect Answer
B
Area
C
Bar
D
Pie
QUESTION 14 OF 36
The project manager at Adventure Works has been allocated a fixed budget for a new project. The funding is distributed across several categories: salaries, equipment, software, training, and miscellaneous expenses. You want to create a visual representation for the project manager that displays the proportion of the total budget that each category represents. What chart type is most suitable for this purpose?
A
Area
B
Bar
C
PieCorrect Answer
D
Line
QUESTION 15 OF 36
The analytics manager at Adventure Works asks you to create a visualization that illustrates the distribution of website traffic sources, such as search engines, direct traffic, referral, and social media, as a proportion of total traffic. Which chart types are suitable for this purpose? Select all that apply.
A
Clustered bar
B
Donut
C
PieCorrect Answer
D
TreemapCorrect Answer
QUESTION 16 OF 36
Consider the following dataset for Adventure Works:
A
TotalCustomers
B
Month
C
TotalSalesCorrect Answer
D
UnitsSold
QUESTION 17 OF 36
Adventure Works ran an online ad campaign for a new product over the past month. Each week, the marketing team counted how many people viewed the ad (impressions), how many people clicked on the ad (clicks), and how many people bought the product after clicking on the ad (conversions). You want to create a report that displays how these numbers changed weekly. What chart type is the best choice for this?
A
Donut
B
Bar
C
Pie
D
LineCorrect Answer
QUESTION 18 OF 36
Which field determines the height of bars in a column chart in Microsoft Power BI?
A
Tooltip
B
X-axis
C
Y-axisCorrect Answer
D
Legend
QUESTION 19 OF 36
In Microsoft Power BI, which chart type is more suitable if you want to highlight the trends rather than the quantity of your data over a period of time?
A
Column chart
B
Pie chart
C
Line chartCorrect Answer
D
Area chart
QUESTION 20 OF 36
In Microsoft Power BI, which combo chart is most suitable for comparing multiple sets of data side by side?
A
Line and stacked column chart
B
Line and clustered column chartCorrect Answer
C
Bar chart
D
Area chart
QUESTION 21 OF 36
What is the key difference between pie and donut charts in Microsoft Power BI?
A
There is no difference between pie and donut charts.
B
A donut chart is like a pie chart with a hollowed-out center.Correct Answer
C
Pie charts can represent a large number of data categories more effectively.
D
Unlike a pie chart, a donut chart can only represent a single category of data.
QUESTION 22 OF 36
In Microsoft Power BI, what is the primary purpose of a treemap chart?
A
A treemap chart is used to visualize changes in data over time.
B
A treemap chart is used to display hierarchical data.Correct Answer
C
A treemap is used to compare multiple data series and identify trends.
D
A treemap chart is used to represent small datasets.
QUESTION 23 OF 36
What type of visualization was used to display the total monthly marketing spend?
A
Card
B
Pie chart
C
Multi-row cardCorrect Answer
D
Bar chart
QUESTION 24 OF 36
What type of visualization did you use to analyze the change in sales over time and its correlation with marketing spending?
A
Ribbon chart
B
Line chart
C
Waterfall ChartCorrect Answer
D
Pie chart
QUESTION 25 OF 36
What was the total marketing spend in three months?
A
30.5K
B
$1.04M
C
$126KCorrect Answer
D
$64.75K
QUESTION 26 OF 36
Which chart did you use to analyze the change in sales performance of different regions and changes in their rankings over time?
A
Ribbon chartCorrect Answer
B
Line chart
C
Scatter chart
D
Waterfall chart
QUESTION 27 OF 36
Based on your analysis, which region performed the best in sales compared to their advertising expenditure?
A
The South region
B
The West region
C
The North region
D
The East regionCorrect Answer
QUESTION 28 OF 36
In Microsoft Power BI, which visualization tool allows you to track a measure’s performance against a target and how the data changes over time?
A
Card
B
Multi-row card
C
KPI visualCorrect Answer
D
Gauge
QUESTION 29 OF 36
Which of the following scenarios is best suited to using a waterfall chart in Microsoft Power BI?
A
To track a single metric over time and identify trends
B
To track the changes in sales ranking of different product categories over time
C
To compare numerical data points across different categories
D
To analyze the cumulative impact of financial factors on net incomeCorrect Answer
QUESTION 30 OF 36
In Microsoft Power BI, which field in a funnel chart is used to define the different stages of a process?
A
CategoryCorrect Answer
B
Values
C
Legends
D
Tooltips
QUESTION 31 OF 36
In a scatter chart, what term describes a data point that significantly deviates from the other data points?
A
Legend
B
Axis
C
OutlierCorrect Answer
D
Cluster
QUESTION 32 OF 36
As a data analyst for a large retail chain, you have created a scatter chart in Microsoft Power BI to compare store size (X-axis) against annual sales (Y-axis) for various stores. You have also used a categorical variable Region for the color legend. While presenting the chart in a meeting, your manager asks you why some stores of the same size have different colors. How would you respond?
A
The colors represent different annual sales.
B
The colors indicate outliers.
C
The colors are assigned randomly.
D
The colors represent different regions.Correct Answer
QUESTION 33 OF 36
Imagine you’re working on a sales report using Microsoft Power BI. You want to visualize the flow of leads through different stages of your sales pipeline. You start with the initial number of leads, followed by the number who were contacted, those who were qualified, the number of proposals sent, and finally, the successful sales made. Which visualization tool in Power BI would be most appropriate for this scenario?
A
Scatter plot
B
Funnel chartCorrect Answer
C
Bar chart
D
Pie chart
QUESTION 34 OF 36
You are a data analyst at Adventure Works. Your task is to provide a visualization that allows the management to understand the ranking shift in bicycle sales over different quarters of a fiscal year across various models. Which of the following charts in Microsoft Power BI would you choose?
A
Bar
B
Funnel Chart
C
RibbonCorrect Answer
D
Line
QUESTION 35 OF 36
You are a sales manager at a growing tech company. You have been asked to track a new KPI that shows how effective the sales team is at converting leads into customers. You have calculated the percentage of potential customers who have made a purchase. Which KPI are you tracking?
A
Customer retention rate
B
Customer acquisition cost
C
Sales conversion rateCorrect Answer
D
Sales growth rate
QUESTION 36 OF 36
Which of the following statements is true about ribbon and waterfall charts in Microsoft Power BI?
A
Both ribbon and waterfall charts are used exclusively for financial data visualization.
B
Ribbon charts are used to illustrate stages in a process, while waterfall charts represent the correlation between two variables.
C
Ribbon charts are used to visualize the changes in ranking over time among various categories, while Waterfall charts are used to illustrate the cumulative impact of sequential positive or negative values.Correct Answer
D
Ribbon charts are used to display the correlation between two variables, while waterfall charts are used to track a single metric over time.
Ready to test your recall?
Based on the line chart representing Adventure Works’ sales revenue over time, which month recorded the highest sales revenue?