QSBA2024 practice question 5 of 10

A business analyst receives an image of a dashboard from the HR Director and is asked to recreate the image in Qlik Sense. The image shows charts for: • Company employee structure • Average employee salary by region • Geographical representation of office capacity • Company retention over time Which charts will meet these analysis requirements?

Full set: 50 questions
Answer options
A: Line chart, sankey chart, map chart, bar chart
B: Line chart, network chart, bar chart, map chart
C: Map chart, grid chart, line chart, KPI chart
D: Map chart, org chart, line chart, bar chart Correct answer
Correct Answer:
D. Map chart, org chart, line chart, bar chart
Explanation

This combination of charts directly addresses the four analytical requirements. An org chart is specifically designed to visualize hierarchical data like a company's employee structure. A bar chart is ideal for comparing a measure (average salary) across a categorical dimension (region). A map chart is the standard and most effective way to display geographical data, such as office locations and their capacity. Finally, a line chart is the best practice for showing trends and changes in a measure (company retention) over a continuous period, such as time.

Why Incorrect

A: A sankey chart is used to visualize flows and their magnitudes between nodes, not a formal hierarchical structure like a company organization. B: While a network chart can show relationships, an org chart is the specific and more appropriate visualization for a formal, top-down employee structure. C: A grid chart is used for visualizing measures across two dimensions, and a KPI object shows a single key performance indicator, neither of which is suitable for the specified requirements.

References

1. Org chart: Qlik Sense® on Windows Help, "Visualizations: Org chart". The documentation states, "The organization chart (Org chart) is good for showing hierarchical data, such as a company's organizational structure or a file system." This directly supports its use for "Company employee structure".

2. Bar chart: Qlik Sense® on Windows Help, "Visualizations: Bar chart". The documentation specifies, "The bar chart is suitable for comparing values between different groups or categories." This aligns with comparing "Average employee salary by region".

3. Map chart: Qlik Sense® on Windows Help, "Visualizations: Map". The documentation notes, "The map is used to show geographical data and present it with your measure values." This is the correct choice for a "Geographical representation of office capacity".

4. Line chart: Qlik Sense® on Windows Help, "Visualizations: Line chart". The documentation states, "The line chart is mainly used to show trends over time." This makes it the ideal chart for visualizing "Company retention over time".

Scroll to Top