NEW
Font size
WorksheetsCB23IC3_Visualization Tools using R
Total questions: 50
Worksheet time: 25mins
Business Intelligence primarily helps organizations in:
Entertainment
Decision making
Software development
Hardware maintenance
Which of the following is NOT a component of Power BI?
Power BI Desktop
Power BI Service
Power BI Mobile
Power Query SQL
Power BI Desktop is mainly used for:
Data entry
Data visualization and modeling
Email communication
Web browsing
The importance of data analysis in business is to:
Guess outcomes
Enable data-driven decisions
Replace managers
Increase expenses
Power BI can import data from:
Excel
SQL Server
Web pages
All of the above
The "Get Data" option in Power BI is used for:
Formatting charts
Importing data sources
Writing SQL queries
Adjusting themes
The Power BI Desktop interface includes:
Home, View, Modeling tabs
Only Insert tab
File tab only
Control panel
Which Microsoft tool does Power BI closely integrate with?
MS Word
MS Excel
MS Paint
MS Access
Installing Power BI Desktop requires:
Microsoft Store or official download
Mobile app store
BIOS installation
Control Panel only
Which step comes first in Power BI usage?
Creating dashboards
Importing data
Writing DAX formulas
Publishing reports
Which of the following is a feature of Business Intelligence?
Random guessing
Predictive analysis
Manual data entry
Hand-drawn reports
Power BI Service is also known as:
Power BI Cloud
Power BI Web
Power BI Excel
Power BI Desktop
Importing data from various sources in Power BI ensures:
Only text data is used
Flexibility in analysis
Manual entry is compulsory
Data duplication
The shortcut to open Power BI Desktop is usually found in:
Command Prompt
Start Menu
Control Panel
BIOS
Which view in Power BI Desktop allows you to see tables and columns?
Data View
Report View
Modeling View
Dashboard
Data transformation in Power BI is mainly done using:
Power Query Editor
MS Paint
Windows Explorer
PowerPoint
Data cleaning involves:
Adding duplicate values
Removing errors and inconsistencies
Hiding data
Encrypting data
Relationships between tables in Power BI are defined by:
Primary and foreign keys
Excel formulas
Images
None of the above
Which type of relationship is NOT supported in Power BI?
One-to-One
One-to-Many
Many-to-Many
Infinite-to-Infinite
DAX stands for:
Data Analysis Expressions
Data Analytical XML
Dynamic Array Execution
Data Access Extension
A calculated column in DAX is used to:
Create new rows
Create new values based on expressions
Delete duplicates
Store images
Which of the following is NOT a data transformation step?
Filtering rows
Replacing values
Changing data types
Adding animations
The "Manage Relationships" dialog is used for:
Formatting visuals
Editing table joins
Changing chart titles
Importing images
The star schema is commonly used in Power BI modeling because it:
Looks attractive
Simplifies queries and improves performance
Stores raw uncleaned data
Is required by Microsoft
Which DAX function calculates the total of a column?
SUM()
COUNT()
AVERAGE()
MAX()
In Power BI, a measure is:
A stored table
A calculation evaluated on demand
A data type
A column property
A one-to-many relationship in Power BI typically links:
Fact table to dimension table
Two unrelated tables
Images to text
Dashboards to visuals
DAX is mainly used for:
Data cleaning
Creating calculations and measures
Designing dashboards
Writing SQL queries
A common data transformation step to merge multiple tables is:
Append or Merge queries
Export as CSV
Delete all nulls
Rename columns
Data modeling in Power BI helps in:
Building relationships and logical data structures
Adding pictures
Formatting fonts
Hiding dashboards
A bar chart is best used for:
Comparing categories
Showing trends over time
Displaying proportions
Mapping locations
A line chart is commonly used for:
Geographical data
Time-series trends
Comparing proportions
Showing hierarchy
A pie chart is suitable when:
You want to show parts of a whole
Comparing many categories
Showing changes over time
Displaying raw data
In Power BI, formatting visuals includes:
Changing colors and labels
Writing SQL queries
Importing datasets
Adding relationships
Interactive features in Power BI include:
Slicers and filters
Video animations
Hyperlinks
None of the above
A dashboard in Power BI is:
A collection of visualizations
A single pie chart
An Excel worksheet
A SQL script
Which visualization type is best for geographical data?
Map visualization
Line chart
Scatter plot
Pie chart
Which chart is most suitable for showing distribution of data?
Histogram
Line chart
Donut chart
Gauge
Formatting titles, legends, and labels in charts helps in:
Increasing storage space
Better presentation and understanding
Data cleaning
Importing datasets
Power BI allows you to make visuals interactive by:
Applying slicers
Applying filters
Cross-highlighting
All of the above
A scatter plot is best used for:
Relationship between two variables
Showing percentages
Displaying maps
Showing a timeline
Which visualization shows progress toward a goal?
Gauge chart
Line chart
Histogram
Pie chart
The donut chart is similar to:
Pie chart with a hole in the center
Bar chart
Line chart
Scatter plot
A stacked bar chart helps in:
Showing category-wise contribution in a total
Displaying single value
Representing maps
Creating pivot tables
The map visual in Power BI requires:
Geographic data (city, state, latitude, longitude)
Only numerical values
Images
DAX formula only
Cross-highlighting in Power BI means:
Selecting data in one visual affects others
Highlighting with a pen
Applying bold fonts
Adding hyperlinks
Filters in Power BI can be applied at:
Visual level
Page level
Report level
All of the above
A card visualization in Power BI is used to show:
A single aggregated value (like total sales)
A distribution
A relationship between variables
A geographical map
Which chart is best for hierarchy data (e.g., region → state → city)?
Tree map
Histogram
Scatter plot
Pie chart
The main advantage of interactive visualizations is:
User-driven exploration of data
Static reporting
Manual calculations
Reduced storage space
