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