29 Questions
One of the following is not part of aggregate functions:
Date
The primary goal of a data analyst is
Summarizing and interpreting data
The representation of data through the use of common graphics, such as charts, plots, infographics, and even animations is called
Data visualization
The process of fixing or removing incorrect, corrupted, incorrectly formatted, duplicate, or incomplete data within a dataset is called
Data cleaning
Which of the following is quantitative data
Age
Microsoft products or software specifically meant for data cleaning are called
Power Query editor
Which of the following is not part of the measure of central tendency
Standard deviation
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
The following software is used in data analysis except
Microsoft Word
What is the first step for data analysis
Gather data
In Microsoft Excel, what is the intersection of a row and column called
Cell
A group of cells is called
Cell range
All formulas in Excel begin with the following symbol
=
Which of the below will add the value of B2 to the value of C3
=B2+C3
In Power BI, the BI is an acronym for
Business Intelligence
The developers of Power BI is
Microsoft
In Power BI, DAX stands for
Data analysis expression
In Power BI, calculated fields are usually obtained from
Measure
Calculated fields are best represented in which type of chart
Card
Tableau can be connected with the following
All of the above
Tableau data fields can be divided into two namely:
Measure and dimension
In Tableau, ______ is a sequence of visualizations that work together to convey information
Story
___________ is the parent organization that manages Tableau
Salesforce
How many charts are in Tableau
24
What is the full meaning of SQL
Structured Query Language
The Database Management Systems are listed below except
Microsoft Excel
__________ is a prepared SQL code that you can save, so the code can be reused over and over again
Call procedure
The SQL statement used for retrieving records from a database is
SELECT
What is used to uniquely identify a record in a table
Primary Key
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.
General knowledge questions on data analysis, covering topics such as aggregate functions and data visualization. Test your skills in data analysis and interpretation.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
