ALA - Data Analytics
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: "- -"
How does AI differ from traditional computing technologies?
AI includes technologies like machine learning and deep learning. AI can simulate human problem-solving capabilities.
What features make Tableau popular with data analysts?
Ability to handle data from multiple sources Complex data visualization capabilities Intuitive drag-and-drop interface
Which of the following are supported by AI?
Automating typing corrections in texts or emails Generating textual content from minimal user input Learning from data to make predictions and decisions
Data analysts are likely to have achieved what education level when beginning their career?
Bachelor's degree
Because many business executives desire to create a data-driven decision making culture, which 3 of the following are competencies organizations invest in to support DDDM?
Building a data-driven community Data proficiency Agility in analytics and data analysis
What are the main types of visuals that Power BI supports?
Comparison, correlation, distribution, data over time, part-to-whole representations, and rankings
What features make Tableau popular with data analysts?
Complex data visualization capabilities Intuitive drag-and-drop interface Ability to handle data from multiple sources
Trends in data analytics include which 3 of the following?
Composable data Data analytics as a core business function Scalable AI
Some of the responsibilities of a data analyst include which 3 of the following?
Data visualization Data structuring Data reporting
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. Datasets must be universally available so that anyone can use the data. The public must have access and datasets must be available for use.
Which of the following statements correctly address how Power BI supports the needs of different users within an organization?
Department managers can track data specific to their departments Offers enhanced security with Power BI Report Server in its Premium version
How do IoT data analytics benefit organizations?
Enables real-time monitoring and alerts Offers insights that assist in proactive decision making
What are the challenges associated with using SQL databases?
High cost of some SQL database versions Requirement for skilled database administrators Complexity in setup and management
Uses of data analytics include which 3 of the following?
Improved patient experiences and internal procedures in healthcare Improved customer service Improved decision making
Characteristics of spreadsheets include which 2 of the following?
Information is organized into cells Data is structured in rows and columns
Which of the following are challenges associated with using Tableau?
Limited to 16-column table displays High cost when scaling for large organizations Requires separate dashboards for mobile and desktop due to display issues
When discussing personally identifiable information (PII), which 3 of the following are usually anonymized?
Names Social security numbers Phone numbers
When working in Microsoft Power BI, which 3 tiers are available?
Power BI Pro Power BI Premium Power BI Desktop
The process of data analytics includes which of the following?
Predictive analytics Descriptive analytics Prescriptive analytics
Common SQL terms include which 3 of the following?
SELECT WHERE FROM
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
Which of the following are advantages of using SQL in relational database management systems?
Supports the extraction of complex relationships in data Simplifies the management of structured data
Which of the following are uses of IoT analytics in business?
To optimize business processes by identifying inefficiencies To reduce downtime by predicting equipment failures To personalize products and services based on customer usage
Which of the following best describes the focus of predictive analytics?
Understanding, predicting, and planning for future events and outcomes.
Which 3 of the following are major varieties of data formats?
Unstructured data Discrete data Structured data
What is a key benefit of integrating Python with Excel for data analysis?
Users can access Python directly from the Excel ribbon without needing installation.
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?
A data _____ uses the knowledge of processing software, business strategy, and analytical skills to deliver data and reports that guide management and executives.
analyst
Curiosity, understanding context, having a technical mindset, data design, and data strategy are the 5 essential aspects of __ thinking and skills
analytical
Improving decision making, customer service, production and operations processes are just a few of the trends in data__
analytics
When using color in data visualization it is important to choose colors that are representational of certain conditions or variables. For this reason, when using color to compare temperature, it is best to convey cold with the color ___.
blue
Data analysts must blend facts and data with knowledge about the ___.
business and organization
Only selecting and representing data that supports a desired conclusion or result can easily mislead and result in false conclusions. This is known as __ the data.
cherry picking
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 BLANK _ data and analytics.
composable
Measurable and counted data that can have almost any numeric value is called __data.
continuous
The 3-step data visualization process consists of exploring the data sets for pattern, then planning for visuals, and finally ___.
creating your visuals
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 BLANK ecosystem.
data
A SQL statement is used to ask a question or communicate a request of the BLANK_ management system.
database
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 BLANK
database
DDDM refers to Data Driven BLANK Making.
decision
Entry-level data analysts frequently start with no prior BLANK, 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 BLANK.
fields
Data transformation is the process of converting the __ of data.
format
There are several best practices that can be applied to ensure effective development and interpretation of data visualizations. Select 3 of these best practices.
inclusion of data define the purpose use of color
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
If you are displaying data as a percentage of a whole or you have a set of variables that make up 100%, it is usually best to us a ___ to visualize the data.
pie chart
Microsoft's analytics software that allows for the processing, manipulation, and visualization of data is called Microsoft BLANK BI.
power
The 6-step process analysts use to create data-driven decision making includes which 3 of the following?
prepare ask analysis
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
Collections of related fields in a database are referred to as ___.
records
Characteristics of databases include which 3 of the following?
records characters fields
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
When you have a large number of data points and you are comparing the relationship between two variables, a good way to visualize the data is to diagram these pairs of numerical data. This presentation is called a ___.
scatterplot
The steps in the data project life cycle, according to Harvard University's Data Science Ready Project include which 3 of the following?
sensing wrangling collection
Which program is typically limited to one user at a time?
spreadsheet
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
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.
structured
In computer programming, a set of rules and guidelines that define a specific computer language is referred to as the language's ___.
syntax
Which of the following is a popular data analytics program that offers business intelligence as well as data visualization?
tableau
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
The process of converting the format of data from one form to another is called data BLANK
transformation
Shortening the y-axis on a bar, line, or scatterplot graph can make differences seem much bigger than they actually are. This misleading data visualization element is known as ___.
truncating
Which of the following statements about the Python programming language are true?
uses syntax that is easy to read and learn
When working in Tableau, users can assume which 3 roles?
viewers explorers creators
The graphical and structured representation of data is known as data__
visualization
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 BLANK tools
visualization
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 BLANK, which offers licenses for Creators, Explorers, and Viewers.
tableau
