Data Analysis Test Questions

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

One of the following is not part of aggregate functions:

Sum

Date (correct)

Count

Min

The primary goal of a data analyst is

Gathering dataset

Design database

Management of dataset

Summarizing and interpreting data (correct)

The representation of data through the use of common graphics, such as charts, plots, infographics, and even animations is called

Data visualization (correct)

Data cleaning

Data mining

Prediction

The process of fixing or removing incorrect, corrupted, incorrectly formatted, duplicate, or incomplete data within a dataset is called

Data cleaning Signup and view all the answers

Which of the following is quantitative data

Age Signup and view all the answers

Microsoft products or software specifically meant for data cleaning are called

Power Query editor Signup and view all the answers

Which of the following is not part of the measure of central tendency

Standard deviation Signup and view all the answers

A branch of advanced analytics that makes predictions about future outcomes using historical data combined with statistical modeling, data mining techniques, and machine learning is called

Predictive Analytics Signup and view all the answers

The following software is used in data analysis except

Microsoft Word Signup and view all the answers

What is the first step for data analysis

Gather data Signup and view all the answers

In Microsoft Excel, what is the intersection of a row and column called

Cell Signup and view all the answers

A group of cells is called

Cell range Signup and view all the answers

All formulas in Excel begin with the following symbol

= Signup and view all the answers

Which of the below will add the value of B2 to the value of C3

=B2+C3 Signup and view all the answers

In Power BI, the BI is an acronym for

Business Intelligence Signup and view all the answers

The developers of Power BI is

Microsoft Signup and view all the answers

In Power BI, DAX stands for

Data analysis expression Signup and view all the answers

In Power BI, calculated fields are usually obtained from

Measure Signup and view all the answers

Calculated fields are best represented in which type of chart

Card Signup and view all the answers

Tableau can be connected with the following

All of the above Signup and view all the answers

Tableau data fields can be divided into two namely:

Measure and dimension Signup and view all the answers

In Tableau, ______ is a sequence of visualizations that work together to convey information

Story Signup and view all the answers

___________ is the parent organization that manages Tableau

Salesforce Signup and view all the answers

How many charts are in Tableau

24 Signup and view all the answers

What is the full meaning of SQL

Structured Query Language Signup and view all the answers

The Database Management Systems are listed below except

Microsoft Excel Signup and view all the answers

__________ is a prepared SQL code that you can save, so the code can be reused over and over again

Call procedure Signup and view all the answers

The SQL statement used for retrieving records from a database is

SELECT Signup and view all the answers

What is used to uniquely identify a record in a table

Primary Key Signup and view all the answers

Study Notes

Data Analysis

Aggregate functions do not include Date.
The primary goal of a data analyst is to summarize and interpret data.
Data visualization is the representation of data through common graphics, such as charts, plots, infographics, and animations.
Data cleaning is the process of fixing or removing incorrect, corrupted, or incomplete data within a dataset.
Age is an example of quantitative data.
Microsoft Power Query editor is a software specifically meant for data cleaning.
Standard deviation is not part of the measure of central tendency.
Predictive Analytics is a branch of advanced analytics that makes predictions about future outcomes using historical data, statistical modeling, data mining techniques, and machine learning.
Microsoft Word is not a software used in data analysis.

Microsoft Excel

The intersection of row and column in Excel is called a Cell.
A group of cells is called a Cell range.
All formulas in Excel begin with the = symbol.
The formula =B2+C3 will add the value of B2 to the value of C3.

Microsoft Power BI

The BI in Power BI stands for Business Intelligence.
Power BI is developed by Microsoft.
DAX stands for Data Analysis Expression.
Calculated fields are usually obtained from Data modeling.
Calculated fields are best represented in a Table.
Power BI can be used to calculate, summarize, and analyze data.

Tableau

Tableau can be connected with Excel, CSV files, and SQL files.
Tableau data fields can be divided into Measure and Dimension.
A Story in Tableau is a sequence of visualizations that work together to convey information.
Tableau is managed by Salesforce.
There are 24 charts in Tableau.

SQL

SQL stands for Structured Query Language.
Microsoft Excel is not a Database Management System.
A stored procedure is a prepared SQL code that can be saved and reused.
The SQL statement used for retrieving records from a database is SELECT.
A Primary Key is used to uniquely identify a record in a table.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Description

General knowledge questions on data analysis, covering topics such as aggregate functions and data visualization. Test your skills in data analysis and interpretation.