Exam (elaborations)
ITGSS CERTIFIED ADVANCED PROFESSIONAL; DATA ANALYST EXAM QUESTIONS AND VERIFIED ANSWERS
- Course
- Institution
ITGSS CERTIFIED ADVANCED PROFESSIONAL; DATA ANALYST EXAM QUESTIONS AND VERIFIED ANSWERS...
[Show more]
Content preview
ITGSS CERTIFIED ADVANCED PROFESSIONAL; DATA ANALYSTEXAM QUESTIONS AND VERIFIED ANSWERS
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
Basic SQL query - ANSWER Basic queries allow you to select data
from the database.
SELECT -- fields from the table
FROM -- table name
WHERE -- filter data
, ORDER BY -- sort data
where & order are not required statements. When used together you
need to filter the data before you sort it.
Power BI 2 main functions - ANSWER trandorm data & present data
To be a data analyst, you must be able to manually calculate every
single math calculation you need. TRUE/FALSE - ANSWER False
Which option describes parsing text? - ANSWER breaking parts of text
out of a field to create fields -- You can do this with any type of delimiter
and every program handles this a little differently, but the outcome is the
same.
Which statements are required in a basic SQL query? - ANSWER
SELECT and FROM -- SELECT lists all fields from the table, and FROM
lists the table name.
You need to create a status field in Power Query for any order that has
30 days between the start of the order and the ship date. It will provide a
status value of "Over 30 Days." Which built-in function can you use? -
ANSWER Conditional Column -- This logical function will allow us to
split the data into categories, and in this case, create a Status field with
values of "Over 30 Days" for the rows that match.
Spaces can be used as delimiters. TRUE/FALSE - ANSWER TRUE --
Spaces are invisible to the eye, but they are actual characters that can
be used as delimiters.
What are the two core functions that Power BI offers to data analysts? -
ANSWER transformation of data and presentation of data -- Power BI
offers two core functions for data analysts: transforming and presenting
data.
Master Data - ANSWER Customer and address information
project names
product names
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller luzlinkuz. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $16.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75323 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now