Info Systems Management Ch 3 - 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 Python popular for data analytics?
Active developer community Open-source nature Supports graphics and visualization tools
Curiosity, understanding context, having a technical mindset, data design, and data strategy are the 5 essential aspects of __ thinking and skills
Analytical
Protecting private or sensitive information by eliminating or encrypting information is the goal of data __
Anonymization
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
Characteristics of databases include which 3 of the following?
Characters Records Fields
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
In the statement: SELECT * FROM Customers, the asterisk (*) indicates that the user wants to extract all the columns of data FROM the __ table.
Customers
Characteristics of spreadsheets include which 2 of the following?
Data is structured in rows and columns Information is organized into cells
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
Which of the following activities are enabled by AI in technology?
Generating new content based on minimal user prompts Predicting user behavior based on past interactions
Which of the following are correct statements about why SQL is useful for data analytics?
Integrates with other programming languages such as Python Enables the discovery of relationships between data sets
Which of the following are challenges associated with using Tableau?
Limited to 16-column table displays Requires separate dashboards for mobile and desktop due to display issues High cost when scaling for large organizations
Match the chart or graph with the data it is typically used to represent.
Line Chart matches Choice Used to compare values over time. Pie Chart matches Choice Used to represent part-to-whole relationships in a data set. Bar Chart matches Choice Used to display slices of information. Allow for comparing one group of data to other groups. Scatterplot matches Choice Used to diagram pairs of numerical data. Help to determine if there is a correlation between two variables.
Which of the following statements correctly address how Power BI supports the needs of different users within an organization?
Offers enhanced security with Power BI Report Server in its Premium version Department managers can track data specific to their departments
How do IoT data analytics benefit organizations?
Offers insights that assist in proactive decision making Enables real-time monitoring and alerts
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
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?
SELECT FROM WHERE
Which of the following are advantages of using SQL in relational database management systems?
Simplifies the management of structured data Supports the extraction of complex relationships in 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.
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 are uses of IoT analytics in business?
To reduce downtime by predicting equipment failures To optimize business processes by identifying inefficiencies To personalize products and services based on customer usage
The process of converting the format of data from one form to another is called data
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
There are several best practices that can be applied to ensure effective development and interpretation of data visualizations. Select 3 of these best practices.
Use color Define the purpose Inclusion of 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.
Which of the following statements about the Python programming language are true?
Uses a syntax that is easy to learn and read
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
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
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
What are the main types of visuals that Power BI supports?
Comparison, correlation, distribution, data over time, part-to-whole representations, and rankings
What are the challenges associated with using SQL databases?
Complexity in setup and management High cost of some SQL database versions Requirement for skilled database administrators
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?
Data proficiency Agility in analytics and data analysis Building a data-driven community
A SQL statement is used to ask a question or communicate a request of the _ 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 __.
Database
The main tools used by data analysts include which 3 of the following?
Databases and query languages Data visualization tools Spreadsheets
DDDM refers to Data Driven __ Making.
Decision
Which 3 of the following are major varieties of data formats?
Discrete data Unstructured data Structured data
In a database, data is organized in complex and meaningful collections specified by the database administrator. These collections are referred to as ___
Fields
Data that offers free access, distribution, and usage is known as __ data.
Open
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
Which of the following is a popular Microsoft data analytics program that offers business intelligence as well as data visualization?
Power BI
When working in Microsoft Power BI, which 3 tiers are available?
Power BI Premium Power BI Pro 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
Which of the following accurately cover key features of Microsoft Power BI?
Provides data transformation and modeling capabilities Offers self-service access for end-users Includes interactive data visualizations
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 __ tools
Visualization
Questions that data analysts often ask include which 3 of the following?
What are the time constraints for the project? Who will receive the information and analysis? What overall outcomes and results that are needed?
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
Which of the following is a popular data analytics program that offers business intelligence as well as data visualization?
Tableau
Select 3 critical factors to consider when determining the right data to select?
What types of data do you need to solve a specific problem? How will the data be collected? How much data should be collected?
What functionalities does Tableau provide for data analysis?
What-if scenario analysis Data preparation and cleansing
The steps in the data project life cycle, according to Harvard University's Data Science Ready Project include which 3 of the following?
Wrangling Collection Sensing
