LinkedIn Learning: Learning Data Analytics:
1 Foundations- Questions and Answers
Data governance involves _____. People, technology, and processes—the best data
governance will include not only people, but technology and processes to ensure that data is the
highest quality, secured and meeting requirements.
Changes we make to our data in Power Query are recorded in _____. Applied Steps—
when making changes to the data in Power Query, it automatically tracks each step in the
Applied steps.
You need a report for every day that occurred in a period of time. To determine if you had
transactions on those days, which join would you use between your transactions table and date
table? Outer join—in order to pull every date from a range of dates you will tie your
transactions table to a date table through an outer join.
Which option is not a reusable data set? Order transactions—will change and be an
overall part of the data we report and visualize. However, it is not what we consider reusable,
like a date table or postal code data
_____ code is written by recording macros in Microsoft Office. VBA (Visual Basic for
Applications)—code language that runs Microsoft Office products. When you create a macro, it
is coding in the VBA.
In Power Query, merge queries allow us to _____. Join data together—merge queries are
the database equivalent to writing a select query
, What command do you use to create aggregated data sets in Power Query? Group By—
will allow you to group data and add aggregate functions like SUM, COUNT and AVERAGE
There are many reasons to change case of any data. Using Proper() changes case to proper in
Excel. What is the equivalent command in Power Query? Transform > Capitalize each
word is the same outcome as using the Proper() function in Excel
It's not always obvious when looking at large data sets that data is duplicated. Which command
in Excel lets you easily highlight duplicate values? Excel Conditional Formatting has a
highlight option that will immediately apply formatting that shows duplicated data
What is not an example of a logical function? Average is not considered a logical
function, but an aggregate function
Merge Columns replaces what function in Excel? Concat() and Concatenate() both
combine values in Excel, and the outcome of Merge Columns is the same as both of these
commands in Excel.
Which role needs the most technical and working experience? Data scientist- typically
have lots of real-world working experience. They are fluent in coding, math, and statistics, as
well as all other required data roles, like data engineering, data cleaning, and reporting outcomes.
What is a form of data cleaning and transformation? Deleting columns or adding
calculations to an Excel spreadsheet
1 Foundations- Questions and Answers
Data governance involves _____. People, technology, and processes—the best data
governance will include not only people, but technology and processes to ensure that data is the
highest quality, secured and meeting requirements.
Changes we make to our data in Power Query are recorded in _____. Applied Steps—
when making changes to the data in Power Query, it automatically tracks each step in the
Applied steps.
You need a report for every day that occurred in a period of time. To determine if you had
transactions on those days, which join would you use between your transactions table and date
table? Outer join—in order to pull every date from a range of dates you will tie your
transactions table to a date table through an outer join.
Which option is not a reusable data set? Order transactions—will change and be an
overall part of the data we report and visualize. However, it is not what we consider reusable,
like a date table or postal code data
_____ code is written by recording macros in Microsoft Office. VBA (Visual Basic for
Applications)—code language that runs Microsoft Office products. When you create a macro, it
is coding in the VBA.
In Power Query, merge queries allow us to _____. Join data together—merge queries are
the database equivalent to writing a select query
, What command do you use to create aggregated data sets in Power Query? Group By—
will allow you to group data and add aggregate functions like SUM, COUNT and AVERAGE
There are many reasons to change case of any data. Using Proper() changes case to proper in
Excel. What is the equivalent command in Power Query? Transform > Capitalize each
word is the same outcome as using the Proper() function in Excel
It's not always obvious when looking at large data sets that data is duplicated. Which command
in Excel lets you easily highlight duplicate values? Excel Conditional Formatting has a
highlight option that will immediately apply formatting that shows duplicated data
What is not an example of a logical function? Average is not considered a logical
function, but an aggregate function
Merge Columns replaces what function in Excel? Concat() and Concatenate() both
combine values in Excel, and the outcome of Merge Columns is the same as both of these
commands in Excel.
Which role needs the most technical and working experience? Data scientist- typically
have lots of real-world working experience. They are fluent in coding, math, and statistics, as
well as all other required data roles, like data engineering, data cleaning, and reporting outcomes.
What is a form of data cleaning and transformation? Deleting columns or adding
calculations to an Excel spreadsheet
