INFO 360 FINAL EXAM VCU
The process of data analytics includes which of the following?
-Prescriptive analytics -Descriptive analytics -Predictive analytics
Regulatory and compliance information can be created and maintained from a centralized location when ___ is integrated into an enterprise resource management solution.
-financial management systems software
Uses of Data Analytics in Business
-improved and effective decision making -improved customer service -increased efficiency of production and operation processes -improved patient experiences and internal procedures in healthcare
Which of the following statements about the Python programming language are true?
-uses a syntax that is easy to learn and read
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 can simulate human problem-solving capabilities. AI includes technologies like machine learning and deep learning.
What features make Python popular for data analytics?
Active developer community Supports graphics and visualization tools Open-source nature
One of the first computer-aided design programs ever developed was also among the first to be integrated into ERP systems. This popular program is ___ .
AutoCAD
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 Agility in analytics and data analysis Data proficiency
ERP software integrates several software packages into a single platform. An example of one of these software packages is ___ software, that engineers use in the design process.
CAD
What features make Tableau popular with data analysts?
Complex data visualization capabilities Ability to handle data from multiple sources Intuitive drag-and-drop interface
When working in Tableau, users can assume which 3 roles?
Creators Viewers Explorers
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.
Data Facts Metrics
Trends in data analytics include which 3 of the following?
Data analytics as a core business function Scalable AI Composable data
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
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?
Data strategy Understanding context Curiosity
Understanding, predicting, and planning for future events and outcomes.
Data visualization Data structuring Data reporting
The main tools used by data analysts include which 3 of the following?
Databases and query languages Spreadsheets Data visualization tools
There are several best practices that can be applied to ensure effective development and interpretation of data visualizations. Select 3 of these best practices.
Define the purpose Inclusion of data Use color
Because they integrate data from various operational areas within the organization through modules, __ systems allow managers to view reports from across the organization.
ERP
Which of the following are correct statements about iotis useful for data analytics?
Enables the discovery of relationships between data sets Integrates with other programming languages such as Python
What key outcome can IoT analytics achieve for businesses?
Enhances consumer engagement through personalized experiences
Characteristics of databases include which 3 of the following?
Fields Characters Records
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
There are a number of different business software applications that can be integrated with an ERP system. Select 3 commonly included application modules.
HR CRM PM
ERP software integrates several software packages into a single platform. An example of one of these software packages is ___ software, that stores employee compensation and performance information.
HRM
Characteristics of spreadsheets include which 2 of the following?
Information is organized into cells Data is structured in rows and columns
With accounting management software, organizations can not only structure basic accounting information, but track a variety of other resources including which 2 of the following?
Intangible assets Tangible assets Human Resources
Advantages of integrating project management software into an enterprise resource planning system include which 3 of the following?
Integration allows for projects to be divided into phases, subprojects, and tasks to make data analysis and project monitoring easier. Integration provides management with the ability to assign project management tasks and responsibilities. Integration provides a centralized location where data is stored and easily retrieved, allowing management to review planning, management, and analysis of an organization's project.
Which of the following are supported by AI?
Learning from data to make predictions and decisions Automating typing corrections in texts or emails Generating textual content from minimal user input
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
When working in Microsoft Power BI, which 3 tiers are available?
Power BI Desktop Power BI Premium Power BI Pro
Which of the following accurately cover key features of Microsoft Power BI?
Provides data transformation and modeling capabilities Includes interactive data visualizations Offers self-service access for end-users
What are the challenges associated with using SQL databases?
Requirement for skilled database administrators High cost of some SQL database versions Complexity in setup and management
Cloud-based ERP solutions are usually offered as ___.
SaaS
Trends in data analytics include which 3 of the following?
Scalable AI Data analytics as a core business function Composable data
Five steps of the data project lifecycle
Sensing Collection Wrangling Analysis Storage
ERP systems can be integrated with financial management systems to provide centralized access and management of financial data. The benefits of this type of integration include which 3 of the following?
Structured compliance architecture Improved visibility The ability to generate financial reports
The size of Big Data ranges from
Terabytes to zettabytes
Benefits of Cloud-based ERP, over on-premises ERP solutions, include which 3 of the following?
They have lower IT infrastructure expenses. Organizations using cloud-based ERP have reduced IT labor expenses. Cloud-based ERP allows organizations to access reports from remote locations.
Which of the following are uses of IoT analytics in business?
To optimize business processes by identifying inefficiencies To personalize products and services based on customer usage To reduce downtime by predicting equipment failures
Which the following best describes the focus of predictive analytics?
Understanding, predicting, and planning for future events and outcomes.
Big Data Includes
Unstructured data Semistructured data Structured data
line chart
Used to compare values over time.
scatterplot
Used to diagram pairs of numerical data. Help to determine if there is a correlation between two variables.
bar chart
Used to display slices of information. Allow for comparing one group of data to other groups.
pie chart
Used to represent part-to-whole relationships in a data set.
Which of the following statements about the Python programming language are true?
Uses a syntax that is easy to learn and read
Big data is characterized by
Variety Volume Velocity
Questions that data analysts often ask include which 3 of the following?
What overall outcomes and results that are needed? What are the time constraints for the project? Who will receive the information and analysis? What is the question that is being asked? Am I answering the question?
What functionalities does Tableau provide for data analysis?
What-if scenario analysis Data preparation and cleansing
data anonymization
a way to eliminate or encrypt private and sensitive information
ERP software provides value by integrating several software packages into a single platform. An example of one of these software packages is ___ software, that records ledger journaling and billing.
accounting
ERP software takes data from computer-_ design (CAD) files and decodes the design and manufacture specifications into usable information for use throughout the manufacturing process.
aided
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
In the initiation process of project management the client and project manager determine if the project is feasible or SMART. The A in SMART refers to ___, which is the first question asked in determining feasibility.
attainable
A key component, and major advantage, of an ERP is its ___.
centralized data base
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 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
Big Data together with data analytics is used for
creating new services and products. identifying market trends. anticipating customer needs
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 ___ ecosystem.
data
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
data analyst
The process of converting the format of data from one form to another is called
data transformation
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
In a database, data is organized in complex and meaningful collections specified by the database administrator. These collections are referred to as
fields
Systems that allow organizations the ability to measure cash flows, calculate tax liabilities, maintain compliance to legal and accounting regulations, and optimize profitability are ___ management systems.
financial
predictive analytics
focuses on the future by using probability analysis techniques with data mining and statistical modeling
prescriptive analytics
focuses on the future by using probability analysis techniques with data mining and statistical modeling
While ERP systems offer many competitive advantages to users, particularly those in upper management, a significant disadvantage is their ___.
high costs
One disadvantage of ERP systems is that they often have steep ___ curves, making it difficult for users to implement or even comprehend a new system without significant training.
learning
Descriptive Analytics
looks to uncover trends in data sets. It answers questions such as, "what happened?" or, "what is going on that causes a specific outcome?"
Project scheduling and project communications are two functions provided by project __ (PM) software.
management
Data and information in an ERP can in some ways be equated to a fishing tacklebox in that different information is usually accessed through different ___.
modules
Qualitative data that is not categorized is called nominal data. Qualitative data that is categorized (ranked, for example) is considered ___ data.
ordinal
pii
personally identifiable information
Design elements that can lead to misleading data visualization include exaggerated or improper scaling. This can most often occur when presenting data in the form of a ___.
pictogram
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 ___ BI.
power
Collections of related fields in a database are referred to as ___.
process
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
The integration of transaction ___ systems (TPS) with ERP has the ability to reduce labor costs. Due to the streamlined nature of transaction reporting, the services of accounts receivable or payroll may be reduced or eliminated
processing
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
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
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
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
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
Along with identifying wanted or needed products, CRM software allows organizations to accomplish which 3 of the following?
ultimately increase sales maintain customer engagement and relationships identify and attract prospective customers
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 ___ tools.
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 _____ tools
visualization
Six Step Process for Data-Driven Decision Making
· Ask · Prepare · Process · Analysis · Share · Act
Skills Data Analysts Possess
· Technical writing skills · Experience with computer code including SQL, Python, and Oracle · Strong analytical and problem-solving skills · Experience with data visualization software including Tableau and Power BI · Microsoft Excel and spreadsheet experience · Effective time management and the ability to multitask and to meet deadlines · Oral communication and presentation software skills
