Font size
WorksheetsData Analysis and Visualization
Total questions: 15
Worksheet time: 9mins
Which of these tools is used for data cleaning and transformation?
Power BI
Power Apps
Power Pivot
Power Query
Which of these is not an example of a relational database management system?
Ms SQL Server
MySQL
PostgreSQL
MongoDB
OracleDB
The type of data analytics that answers the question 'what happened?' is known as
(a)
You are required to carry out an analysis to answer the question 'Why?' What type of data analytics is this?
Predictive
Diagnostic
Prescriptive
Descriptive
The first step to carrying out a data analysis project is
Gathering data
Defining objectives
Cleaning data
Asking business questions
The stage in the data analysis process where you fix the inconsistencies in data to ensure data accuracy is the
Transformation stage
Visualization stage
Analyzation stage
Presentation stage
In Excel, from which tab do you import data to the Power Query editor?
Home Tab
Insert Tab
Data Tab
Formula Tab
The shortcut to turn a data range into a table in Excel, is
Cltr + T
Cltr + Table
Alt + T
Alt + Table
Which of these is an example of absolute referencing in Excel
C1
$C1
$C$1
C$1
According to the order of operation, the answer for this expression will be 5+2*5-(3+4) =
(a)
The chart that is best used to show changes in value over time is
Bar chart
Column chart
Pie chart
Line chart
The chart that is best to visualize an outlier in a data is
Line chart
Scatter plot
Bar chart
Stacked column chart
You need to visualize the relationship between two variables such as comparing life expectancy to GDP for each country in a group. Which chart would you use?
Heat map
Scatter plot
Pie chart
Bar chart
The common types of databases are
Flat file databases
Relational databases
NoSQL databases
Cloud databases
The database where related data are stored in tables and each table have relationship with other tables is
Flat file database
Non-relational database
Relational database
NoSQL database
