Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataMedium
A marketing team is analyzing customer feedback data in Power BI. They have a dataset that includes customer comments as free-form text. The team wants to identify recurring themes and sentiment (positive, negative, neutral) from these comments to understand customer perceptions better. Which Power BI visual, combined with appropriate data preparation, would be most effective for this analysis?
- AKey Influencers visual
- BWord cloud custom visual
- CQ&A visual
- DDecomposition tree
Show answer & explanationAnswer & explanation
Correct answer: B. Word cloud custom visual
A word cloud visual is specifically designed to display the frequency of words in a text corpus, making it highly effective for identifying recurring themes. Combined with sentiment analysis during data preparation, it can visually represent sentiment-colored words.
Why the other options are wrong
- A. Key Influencers visual identifies factors that influence a metric, not themes from free text.
- C. Q&A visual allows users to ask natural language questions about their data, not to analyze themes and sentiment directly from raw text.
- D. Decomposition tree allows breaking down a metric into its contributing parts, not analyzing free-form text.
Word Cloud Visual
A word cloud is a visual representation of text data, where the size of each word indicates its frequency or importance. It's often used for quickly perceiving the most prominent terms and themes within a body of text.
- Visually shows word frequency.
- Useful for identifying dominant themes.
- Often requires text pre-processing (stop words, stemming).
Memory trick: Words form clouds, revealing the themes that loudly shout.