NEW
Font size
WorksheetsCSC1207 Test Revision MCQ
Total questions: 15
Worksheet time: 3hrs 30mins
Business Intelligence (BI) helps organizations to:
Predict the future exactly
Summarize data to help make decisions
Fix computer errors
Design websites
Which of the following is NOT usually a function of a BI dashboard?
Tracking important metrics
Finding sudden operational problems
Performing advanced statistical analysis
Helping managers make decisions
Data visualization is useful because:
It automatically cleans the data
It instantly gives correct conclusions
It shows trends and patterns more clearly than raw numbers
It removes the need for analysts
Categorical data is best described as:
Data that can be measured and ranked
Data that represents labels or categories
Always numbers
Data that varies continuously
Ordinal data differs from nominal data because it:
Has categories with no order
Can only be counted in whole numbers
Has categories that can be ranked
Cannot be used in graphs
Which is an example of continuous numerical data?
Number of books sold
Product categories
Temperature over the day
Number of chairs in a room
A general change in sales over a year is best shown with:
Bar chart
Pie chart
Line chart
Tree map
A histogram is most suitable for:
Showing percentages of categories
Comparing categories
Looking at the distribution of continuous values
Mapping locations
Which is the best way to find unusual values in a dataset?
Pie chart
Look for clusters of similar values
Identify points that differ from the rest
Summarize in a table
Points, lines, and areas in a chart are called:
Channels
Dimensions
Marks
Idioms
Which is an example of an outlier?
Daily sales between 50–60 units
Consistent sales every day
One day with 500 units sold while others are around 50
Three products selling the same amount
To compare total sales across product categories, the best chart is:
Pie chart
Bar chart
Scatter plot
Box plot
A visualization may show bias if:
It has too many labels
It uses data only from one region
It is in grayscale
It is very detailed
Executive dashboards should focus on:
Raw technical data
Key metrics and summaries
Unprocessed tables
Mathematical formulas
A heatmap is most useful when showing:
How sales intensity varies across stores and days
Percentage of male vs female customers
Yearly sales trend
Age distribution of customers
