ITGSS Certified Advanced
Professional: Data Analyst Study
Guide
When working with data in Excel, what is your first step? - ANSWER-Ensure that the
entire data set is recognized by Excel.
Determining the count of values and basic transformation requirements in a data set is
known as _____. - ANSWER-Data profiling -- Data profiling is a high-level profile of the
characteristics of the working data. Profiling helps determine what steps you should
work through on the transformation of your data.
What should you do with every new data set before you begin to analyze the data? -
ANSWER-Profile the data -- Use data profiling to learn about data at a high level.
Profiling helps determine what steps you should work through on the transformation of
your data.
When working with data that requires transformations, which option provides you with
the most robust options in Excel? - ANSWER-Power Query -- Leveraging Power Query
allows you to transform your data into structures that are powerful and usable for data
analysis.
What is an example of a business rule for data? - ANSWER-A bundle sale is defined as
a minimum of 3 products sold at the same time. -- Business rules can be as simple as a
definition. In this case, a transaction with the same date/time with a sale of three
products is classified as a business rule.
Microsoft SQL Server - ANSWER-a relational database management system with the
primary function of storing and receiving data
What is an example of a visual element that should be included where appropriate in a
dashboard? - ANSWER-All of the answers: tooltip, data label, and visual title -- Be sure
to title, label, and add tooltips appropriately. People should be able to read a title for
context, understand the labels, and hover to get additional insight needed to support the
visual—not just see the same thing that visual already shows.
What type of command do slicers perform in a Power BI Dashboard? - ANSWER-Filter
-- Slicers are another way of filtering. They narrow the portion of the dataset that is
shown in the other report visualizations. Slicers are a useful way to filter information and
focus on a specific portion of the dataset.
, What type of information is best displayed in a paginated report? - ANSWER-a. stacked
bar chart
b. dashboard
c. list of invoices for the year
d. scatter plot
c -- Paginated reports can provide valuable reporting when your data expands over
many pages and can easily be published or printed.
You notice that the numbers for your data project do not seem to match what the team
expects. What is the first thing on your task list? - ANSWER-Verify your data set to
ensure you have all necessary data and that you have not introduced an error. -- It is a
best practice to first review your work to ensure that you did not introduce an coding
error.
What shows by default on the tooltip for any visual you create? - ANSWER-The fields
used for the visual -- By default, when you add fields to a visual, they will display in the
default tooltip.
What is not an example of data soft skills? - ANSWER-a. data storytelling
b. active listening
c. cleaning a data set in Power BI
d. programmatic thinking
c -- Using a tool like Power Query is an example of a technical hard skill used by data
professionals.
What is a critical component of every data role? - ANSWER-Documentation --
Documentation is a key component of any data project.
Which role requires more advanced math, statistics, and coding skills? - ANSWER-a.
data engineer
b. data worker
c. data analyst
d. data scientist
d -- Data scientists leverage all other roles. They will have the skills of the worker,
analyst, and engineer.
A(n) _____ translates large amounts of data sets in many tables, and maybe across
multiple systems, into data sets that others use for their reporting. - ANSWER-a. data
engineer
b. data worker
c. administrative data professional
d. business analyst
Professional: Data Analyst Study
Guide
When working with data in Excel, what is your first step? - ANSWER-Ensure that the
entire data set is recognized by Excel.
Determining the count of values and basic transformation requirements in a data set is
known as _____. - ANSWER-Data profiling -- Data profiling is a high-level profile of the
characteristics of the working data. Profiling helps determine what steps you should
work through on the transformation of your data.
What should you do with every new data set before you begin to analyze the data? -
ANSWER-Profile the data -- Use data profiling to learn about data at a high level.
Profiling helps determine what steps you should work through on the transformation of
your data.
When working with data that requires transformations, which option provides you with
the most robust options in Excel? - ANSWER-Power Query -- Leveraging Power Query
allows you to transform your data into structures that are powerful and usable for data
analysis.
What is an example of a business rule for data? - ANSWER-A bundle sale is defined as
a minimum of 3 products sold at the same time. -- Business rules can be as simple as a
definition. In this case, a transaction with the same date/time with a sale of three
products is classified as a business rule.
Microsoft SQL Server - ANSWER-a relational database management system with the
primary function of storing and receiving data
What is an example of a visual element that should be included where appropriate in a
dashboard? - ANSWER-All of the answers: tooltip, data label, and visual title -- Be sure
to title, label, and add tooltips appropriately. People should be able to read a title for
context, understand the labels, and hover to get additional insight needed to support the
visual—not just see the same thing that visual already shows.
What type of command do slicers perform in a Power BI Dashboard? - ANSWER-Filter
-- Slicers are another way of filtering. They narrow the portion of the dataset that is
shown in the other report visualizations. Slicers are a useful way to filter information and
focus on a specific portion of the dataset.
, What type of information is best displayed in a paginated report? - ANSWER-a. stacked
bar chart
b. dashboard
c. list of invoices for the year
d. scatter plot
c -- Paginated reports can provide valuable reporting when your data expands over
many pages and can easily be published or printed.
You notice that the numbers for your data project do not seem to match what the team
expects. What is the first thing on your task list? - ANSWER-Verify your data set to
ensure you have all necessary data and that you have not introduced an error. -- It is a
best practice to first review your work to ensure that you did not introduce an coding
error.
What shows by default on the tooltip for any visual you create? - ANSWER-The fields
used for the visual -- By default, when you add fields to a visual, they will display in the
default tooltip.
What is not an example of data soft skills? - ANSWER-a. data storytelling
b. active listening
c. cleaning a data set in Power BI
d. programmatic thinking
c -- Using a tool like Power Query is an example of a technical hard skill used by data
professionals.
What is a critical component of every data role? - ANSWER-Documentation --
Documentation is a key component of any data project.
Which role requires more advanced math, statistics, and coding skills? - ANSWER-a.
data engineer
b. data worker
c. data analyst
d. data scientist
d -- Data scientists leverage all other roles. They will have the skills of the worker,
analyst, and engineer.
A(n) _____ translates large amounts of data sets in many tables, and maybe across
multiple systems, into data sets that others use for their reporting. - ANSWER-a. data
engineer
b. data worker
c. administrative data professional
d. business analyst
