IS 3100: chapter five
Curiosity, understanding context, and having a technical mindset are all examples of _____ used in data-driven decision-making.
analytical
the graphical and structured representation of data is known as_____
data visualization
data that has been collected internally by the organization is known as _______ party data
first
data transformation is the process of converting the____ of data
format
in computer programming, a set of rules and guidelines that define a specific computer language is referred to as the languages___
syntax
there are three main tools data analysts and other members of an organizations use to analyze data. they are spreadsheets, databases, and query languages, and data_____ tools
visualization
in order to make understanding and interpretation of SQL queries easier, user have the ability to add comments. the symbols that will tell SQL that an entry is a comment and should not be used in the query is____
2 dashes "--"
a simple formula that can be used to define success is:
Data + Organizational knowledge = problem solved
microsoft analytics software that allows for the processing manipulation, and visualization of data is called Microsoft____
Power BI
when working in Microsoft Power BI, which 3 tiers are available?
Power BI Pro, Power BI desktop, Power BI Premium
providing the ability to explore and analyze data in seconds using a drag and drop interface as well as natural language processing which allows for the presentation of questions are major attributes of __________ which offers licenses for Creators, Explorers, and Viewers
Tableau
improving decision making, customer service, production and operations processes are just a few of the trends in data
analytics
improving decision making, customer service, production and operations processes are just a few of the trends in data____
analytics
a SQL statement is used to ask a question or communicate a request of the _____ management system
database
For data to be considered open data, it must have what 3 characteristics?
datasets must have access rights that allow them to be reused and redistributed, the public must have access and datasets must be available for use, datasets must be universally available so that anyone can use the data
DDDM refers to Data Driven_____ making
decision
Trying to answer questions such as "what happened?" or, "what is occurring?" or "what was the ROI?". is the role of_____
descriptive analytics
key skills required of data analysts include which 3 of the following?
oral communication skills, technical writing skills, experience with SQL and computer code
qualitative data that is not categorized is called nominal data. qualitative data that is categorized (ranked, for example) is considered _____ data
ordinal
when data is anonymized, the PII is eliminated or encrypted, PII includes names, social security numbers, addresses, and more and stands for____ identifiable information
personally
the 6-step process analysts use to create data-driven decision making includes which 3 of the following?
prepare, ask, analysis
a major trend in data analytics is the use of artificial intelligence to focus on small data, which is more precise, using small datasets that are capable of impacting decisions in the present. this is know as__
scalable
data-driven decision making (DDDM) can be facilitated through a 6-step processes of Ask, Prepare, Process, Analysis, Share, and Act. Which of these steps refers to creating visualizations and presentations for key stakeholders?
share
in the six-step process analysts use to create data-driven decisions, that step during which data cleansing occurs to ensure that high-quality data is ready for processing is the_____
sixth step
which program is typically limited to one use at a time?
spreadsheet
the main tools used by data analyst's include which 3 of the following?
spreadsheets, databases and query languages, data visualization tools
using the correct syntax allows the user to extract data from multiple fields found in data tables. In order to extract information from multiple tables, the______ command is used to indicate multiple fields in conjunction with FROM and WHERE to narrow the search and get specific results
SELECT
common SQL terms include which 3 of the following?
WHERE, SELECT, FROM
trends in data analytics include which 3 of the following?
composable data, virtual analytics?, data structuring, data visualization
the 3-step data visualization process is comprised of which of the following?
create your visuals, planning for visuals, explore data sets for patterns
in the statement: SELECT * FROM Customers, the asterisk (*) indicates that the user wants to extract all the columns of data FROM the _____ table
customers
the information technology (IT) architecture and infrastructure, software applications, programming languages, and storage technologies used for the collection, storage, analysis, and interpretation of meaningful data is referred to as the_____
data ecosystem
because many businesses executives desire to create a data-driven decision-making culture, which 3 of the following are competencies organizations invest in to support DDDm?
data proficiency, building a data-driven community, agility in analytics and data analysis
SQL, usually pronounced "sequel", is quite useful when working with large data sets. The Q in SQL stands for
query
collections of related fields in a database are referred to as____
records
in order to be considered open data, databases must provide access rights so that they can be_____
redistributed
one way to visualize a data ecosystem is to apply it to the data project life cycle. the Data Science Ready Project outlines the 5 steps of the data project life cycle. the final stage in this life cycle is:
storage; data storage involves hardware, software, and procedures for securing, and accessing data
which of the following is a popular data analytics program that offers business intelligence as well as data visualization
tableau
the process of taking components from data sources and analytics platforms to create a more user-friendly experience that makes finding critical insights easier is called ________ data and analytics
composable
someone who possesses the knowledge of processing software, business strategy, and analytical skill to deliver data and reports that guide management and executives as they create well-informed decision making is known as a data____
analyst
protecting private or sensitive information by eliminating or encrypting information is the goal of data____
anonymization
some of the responsibilities of a data analyst include which 3 of the following?
data reporting, data structuring, data visualization,
SQL is quite useful when working with large data sets and is widely used in todays business environment. it allows the user to query the data contained in a___
database
in a database, data is organized in complex and meaningful collections specified by the database administer. these collections are referred to as_____
fields
questions that data analysts often ask include which 3 of the following?
who will receive the information and analysis? what overall outcomes and results that are needed? what are the time constraints for the project?
uses of data analytics include which 3 of the following?
improved decision making, improved customer service, improved patient experiences and internal procedures in healthcare
most database are composed of multiple____ which are groups of assigned records and fields organized in rows and columns
tables
select 3 critical factors to consider when determining the right data to select?
how much data should be collected? how will the data be collected? what types of data do you need to solve a specific problem?
Uses of data analytics include which 3 of the following?
improved customer service, improved decision making, improved patient experiences and internal procedures in healthcare
entry-level data analyst is frequently start with no prior______, but go through extensive on-the-job training that teaches them how to apply information learned in college as well as training on organizational policies and procedures
experience
data analysts are likely to have achieved what education level when beginning their career?
bachelors degree
analytic skills necessary for a data analytics include the characteristics and capabilities that allow for the observation, research, and interpretation of a problem or change in a desired state. according to Google, there are five essential aspects of analytical skills including which 3 of the following?
curiosity, understanding context, data strategy
when selecting the right data, it is important to be aware of the source of the data. for example, data that is sold by an entity that didnt actually collect the data is considered____ data
third-party
when selecting the right data, it is important to be aware of the source of the data. for example, data that is sold by an entity that didn't actually collect the data is considered_____ data
third-party; third party is sold by any entity that didnt actually collect the data
the process of data analytics includes which 3 of the following?
descriptive analytics, prescriptive analytics, predictive analytics
which 3 of the following are major varieties of data formats?
discrete data, structured data, unstructured data
which 3 of the following are examples of data transformation?
the deletion of database fields or records to ensure data integrity, copying or replicating data, standardizing names and variables across data sets
