Learning Data Analytics - LinkedIn

There are many ways to document a process. One useful tool that is built into Windows operating system is the _____. Snipping Tool Microsoft Screenshots Steps Recorder PrtScrn

Steps Recorder

Which shortcut allows you to create a basic chart visual in Microsoft Excel? F12 F3 F4 F11

f11

A ReadMe me file will often contain rules and _____ on what you should do before proceeding. information relationships coding syntax

information

What kind of join requires that there is a record in both of the joined tables/columns? left outer inner outer right outer

inner

The result of a(n) _____ join for two tables/columns/etc. always contains all records of the "left" table, even if the join-condition does not find any matching record in the "right" table. right outer inner left outer outer

left outer

Getting data to a _____ format can help you do more with it. raw queried customized aggregated

raw

If you're a beginner to data analysis, what is the first thing you should check when you build data queries? workflow diagrams calculations differentials record counts

record counts

If you have verified data, and it's been vetted through your team, then you want to be sure you keep it in a way you can _____, without having to start back over. remove recalculate requery reuse

reuse

Interactive filters that filter your pivot are called _____. filters slicers sorters data

slicers

Finding existing data is critical to an analyst. What is not a great way to accomplish this? Start completely scratch. Work backwards from existing data or reports. Determine how the report is built today. Learn where the report is generated and how.

start comp

Headings of our data often span left to right across columns. You can _____ the data to read it in a vertical flow. flip highlight transpose select

transpose

Learning syntax is one of the first big hurdles for any analyst. Which of the following are NOT recommended for learning syntax?

trial and error

Data and the roles of analysis are constantly evolving. In general, the role and the tools will _____ by organization. vary build stop continue

vary

's important to have _____ and checks and balances, so that when you release your results, everyone is in agreement with what you discovered. a verification process solid estimations the latest and most expensive analysis technology findings that you arrived at without consulting others

verfication

t's always best to work with source data. Which is an example of source data? Where data is initiated and lives. Systems that capture data that is specific to them, but doesn't naturally speak to other systems. Systems where the data structure rarely changes. all of these answers

all

All of the following are common actions when cleaning data, except: removing errors (data that isn't controlled when entered can have errors) altering (data should be reconfigured in order to meet goals) validating (comparing the data you have against the verified "truth") standardizing (ensuring data has a standard)

altering (data should be reconfigured in order to meet goals)

Suppose you are looking at a chair, and first identify the chair's color, height, and width. Then, you note the chair's manufacturer and warranty date. In the world of data analysis, the second set of information is an example of _____. : hidden data visible data secondary data data

data

When building charts that are consistently the same you may want to set the ____ chart. line bar column default

default

When working with data sets that are built for us, they may often have _____ data. You can use Remove Duplicates to remove these this data. redundant calculated duplicate highlighted

duplicate

What is likely the most common type of delimiter you will find in data when you want to split it? ~ / , fixed width

,

You can easily select data in an Excel data sheet by using the shortcut Ctrl + ____. CTRL + C Ctrl + A CTRL + V CTRL + X

A

A top goal for a data analyst is to turn multiple lines of data into something easier to read and interpret, and make it more meaningful. What kind of data does an analyst work with? text or .csv files databases spreadsheets all of these answers

All

Data analysis is the process of _____ data for business decision-making. cleaning transforming inspecting all of these answers

All of these answers

What is an example of a business rule? You need to join tables to build data sets. You will use data tools to complete reporting. You need functions to build better reports Employees that have completed a process are entered into the next system

Employees that have completed a process are entered into the next system.

_____ are labels for data, while _____ tie values together into one entity. Records; field heading Field headings; records values; records Integers; field headings

Field headings; records

Which is the following is not true of pasting charts into Microsoft Powerpoint? It gives you a smart tag to adjust the options. It allows you to modify how the chart interacts with the data. It allows you to update the data. It pastes as an image.

It pastes as an image.

Data ____ ensures that we have quality data. queries calculations governance measures

Governance

If you want to improve a process and create better data reports from existing ones, what is something you should ask for (or create if it doesn't exist)? excel spreadsheet software database access Workflow Diagram

Workflow Diagram

Pivots with large values can often be more readable when you Show Values As _____. Percentage of Row Total Percentage of Column Total Percentage of Grand Total all of these answers

all

What is a useful strategy to use when you are missing data? concatenate (tie fields together to create a single field) use IF or and/or case statements use basic math functions like addition, subtraction, division and multiplication all of these answers

all

When can data truth can be incorrect? when not all data is entered when dta updates are not complete when historical data is not represented properly all of these answers

all

When it exists, a data dictionary can give you a document of the _____. fields relationships tables all of these answers

all

When should you use a pivot in your data? when you are learning your data when you are trying to determine the best ways to display your data when you want to answer basics questions about your data all of these answers

all

Analysts engage in all of the following activities, except:

changing data values