CH3 Data Analytics smartbook
In order to make understanding and interpretation of SQL queries easier, users have the ability to add comments. The symbol(s) that will tell SQL that an entry is a comment and should not be used in the query is(are) ___.
2 dashes: "- -"
The 6-step process analysts use to create data-driven decision making includes which 3 of the following?
Analysis Prepare Ask
Working on data analytics teams to extract data from large data sets, creating reports that outline key findings, monitoring key performance indicators (KPIs) to identify success or failure, and analyzing data to identify trends are just a few of the responsibilities of a data .
Analyst
Curiosity, understanding context, having a technical mindset, data design, and data strategy are the 5 essential aspects of __ thinking and skills
Analytical
Data analysts must blend facts and data with knowledge about the ___.
Business or organization
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
The 3-step data visualization process consists of exploring the data sets for pattern, then planning for visuals, and finally ___.
Creating your visuals
Characteristics of spreadsheets include which 2 of the following?
Data is structured in rows and columns Information is organized into cells
Key skills required of data analysts include which 3 of the following?
Experience with SQL and computer code Oral communication skills Technical writing skills
When working in Tableau, users can assume which 3 roles?
Explorers Creators Viewers
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
Select 3 critical factors to consider when determining the right data to select?
How will the data be collected? What types of data do you need to solve a specific problem? How much data should be collected?
Uses of data analytics include which 3 of the following?
Improved customer service Improved patient experiences and internal procedures in healthcare Improved decision making
According to Tableau, data-driven decision making (DDDM) is the uses which of the following to guide strategic business decisions that align with organizational goals, objectives, and initiatives.
Metrics Data Facts
Qualitative data that is not categorized is called nominal data. Qualitative data that is categorized (ranked, for example) is considered ___ data.
Ordinal
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 correct Reason: This choice should be selected. SELECT allows the user to choose the precise fields to be returned.
Which program is typically limited to one user at a time?
Spreadsheet
In computer programming, a set of rules and guidelines that define a specific computer language is referred to as the language's ___.
Syntax
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 correct Reason: This choice should be selected. Third-party data is sold by an entity that didn't actually collect the data.
The process of converting the format of data from one form to another is called data t
Transformation
Common SQL terms include which 3 of the following?
WHERE SELECT FROM
Improving decision making, customer service, production and operations processes are just a few of the trends in data
analytics
Protecting private or sensitive information by eliminating or encrypting information is the goal of data
anonymization
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 ecosystem.
data
SQL is quite useful when working with large data sets and is widely used in today's business environment. It allows the user to query the data contained in a
databases
Trying to answer questions such as, "what happened?" or, "what is occurring?" or "what was the ROI?", is the role of ___.
descriptive analytics correct Reason: This choice should be selected. Descriptive analytics seeks to uncover historical trends in data sets.
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
In a database, data is organized in complex and meaningful collections specified by the database administrator. These collections are referred to as
fields
Microsoft's analytics software that allows for the processing, manipulation, and visualization of data is called Microsoft BI
power
Collections of related fields in a database are referred to as ___.
records
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
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
Most databases are composed of multiple , which are groups of assigned records and fields organized in rows and columns.
tables
The graphical and structured representation of data is known as data
visualization
A data _____ uses the knowledge of processing software, business strategy, and analytical skills to deliver data and reports that guide management and executives.
Analyst correct Reason: This choice should be selected. Data analysts are employed in a variety of fields including finance, e-commerce, healthcare, government, and science.
The main tools used by data analysts include which 3 of the following?
Data visualization tools Spreadsheets Databases and query languages
A SQL statement is used to ask a question or communicate a request of the _ management system.
Database
DDDM refers to Data Driven Making.
Decision
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 correct Reason: This choice should be selected. Healthcare and financial data are two of the most compromised types of data.
When working in Microsoft Power BI, which 3 tiers are available?
Power BI Pro Power BI Premium Power BI Desktop
In the six-step process analysts use to create data-driven decisions, the step during which data cleansing occurs to ensure that high-quality data is ready for processing is the __ step.
Process
SQL, usually pronounced "sequel", is quite useful when working with large data sets. The Q in SQL stands for ___.
Query
In order to be considered open data, databases must provide access rights so that they can be ___.
Redistributed
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 known as __ AI.
Scalable correct Reason: This choice should be selected. Scalable AI is designed to be more responsive, smarter, and allows for better learning algorithms and shorter development times.
Which 3 of the following are examples of data transformation?
Standardizing names and variables across data sets The deletion of database fields or records to ensure data integrity Copying or replicating data
SQL allows users to isolate specific information contained in a database, as well as to aid in the selection, creation, addition, and extraction of data from a database. SQL stands for ___ query language. Multiple choice question. Share
Structured correct Reason: This choice should be selected. Popular SQL programs include MYSQL, Microsoft SQL, and Oracle SQL.
Which 3 of the following are major varieties of data formats?
Structured data Unstructured data Discrete data
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 TableauField 1Field 1 Tableau , Correct Unavailable, which offers licenses for Creators, Explorers, and Viewers.
Tableau
Analytical skills necessary for a data analyst 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?
Understanding context Data strategy Curiosity
Which of the following best describes the focus of predictive analytics?
Understanding, predicting, and planning for future events and outcomes. correct Reason: This choice should be selected. Predictive analytics is focused on understanding, predicting, and planning for future events and outcomes, aiming to forecast what might happen based on historical and current data.
There are three main tools data analysts and other members of an organization use to analyze data. They are spreadsheets, databases and query languages, and data
Visualization
Questions that data analysts often ask include which 3 of the following?
What overall outcomes and results that are needed? Who will receive the information and analysis? What are the time constraints for the project?
A simple formula that can be used to define success is: + organizational knowledge = problem solved.
data
