You are a data analyst for a retail company and are working with a large dataset of customer transactions. You have created a scatter chart in Power BI to visualize 'Total Sales Amount' on the y-axis and 'Number of Transactions' on the x-axis for individual customers. Your goal is to automatically identify natural segments of customers, such as 'high-spending, frequent shoppers' and 'low-spending, infrequent shoppers', without predefining the segment criteria. Which Power BI feature should you use on the scatter chart to accomplish this?
The correct answer is Clustering. Clustering is an unsupervised machine learning feature in Power BI that automatically finds natural groups (clusters) in data. In a scatter chart, it identifies data points that are similar based on the plotted measures, which is ideal for automatic customer segmentation based on behaviors like sales amount and transaction frequency.
Grouping is incorrect because it is primarily a manual process. You would need to select specific data points or categories to combine them, which contradicts the requirement to automatically identify segments.
Binning is incorrect because it is used to group values from a single continuous field into ranges of a fixed size, like creating age brackets from an 'Age' column. It is not designed to find segments based on two different measures simultaneously, as required in this scenario.
Creating a new conditional column is incorrect because this method requires you to manually define the rules and thresholds for each segment (e.g., using DAX or Power Query). This is not an automatic discovery process. The Clustering feature is the dedicated tool for automatically finding these patterns.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
How does clustering work in Power BI?
Open an interactive chat with Bash
What is the key difference between clustering and grouping in Power BI?
Open an interactive chat with Bash
Can clustering be used with other visuals besides scatter charts?
Open an interactive chat with Bash
Microsoft Power BI Data Analyst
Visualize and Analyze the Data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .