NEW
Font size
WorksheetsMCQs - Visualization Tools using R
Total questions: 30
Worksheet time: 15mins
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
