Data Analytics Quiz- Questions and
Answers
Define Data Analytics and explain how a university might use its techniques to recruit and attract
potential students? Definition: The process of evaluating data with the purpose of drawing
conclusions to address business questions.
A university could use data analytics to establish a statistical correlation between let's say income
or geographic area and the likelihood that a kid will be successful at post-secondary education.
They could then target advertising campaigns towards those demographics.
Why is identifying the question such a critical first step in the IMPACT process cycle?
The first step in the impact model is about understanding a business problem that needs
addressing. Having a concrete and specific question that is potentially answerable by data
analytics guides the next steps in the data analytics process.
Among the advantages of using a relational database is enforcing business rules. Based on your
understanding of how the structure of a relational database helps prevent data redundancy and
other advantages, how does the primary key/foreign key relationship structure help enforce a
business rule that indicates that a company should not process any purchase orders from
suppliers who do not exist in the database? In a database, you have multiple tables (ex.
Customers, purchase orders, etc.). When you have a primary/foreign key relationship, it
maintains data integrity, so you cannot create a new purchase order without having an existing
customer to link it to.
Regarding the data request form, why do you think it is important to the database administrator
to know the purpose of the request? What would be the importance of the "To be used in" and
, "intended audience" field? The data administer is most familiar with the data and may be
able to help the analyst get the data needed to address the question. There also might be some
sensitivities as to who gets access to what data to ensure that the appropriate data is provided for
the intended analyst and audience.
How might the data reduction approach be used in auditing? Data reduction is when you
have a massive data set (big data) and you narrow it down by removing redundant data to get a
subset of the data to base your decision off of. Data reduction can be used in auditing whenever
the auditor is testing a company's internal control systems. Let us say they only want to look at
transactions for a specific year, by using data reduction they can narrow down the data to what is
relevant for the current year.
How does fuzzy match work? Give an accounting situation where it might be most useful.
Fuzzy matching enables you to join two data sets together where a regular join may fail.
Fuzzy matching identifies nonidentical duplicates of a data set by specifying the parameters to
match on. Fuzzy matching uses algorithms to decides how similar two words or phrases are.
Fuzzy matching could be used in accounting to prevent invoice fraud. For example, is someone
submitted the same invoice more than once, software with fuzzy matching can help catch the
duplicate invoice even if it's not identical to the original.
Explain Exhibit 4-2 and why these four dimensions are helpful in describing information to be
communicated? This exhibit maps out the 4 types of visualizations. These are helpful
because your approach to presenting the information will differ depending on the message you
are trying to convey (declarative or exploratory) and whether the information is qualitative of
quantitative.
Answers
Define Data Analytics and explain how a university might use its techniques to recruit and attract
potential students? Definition: The process of evaluating data with the purpose of drawing
conclusions to address business questions.
A university could use data analytics to establish a statistical correlation between let's say income
or geographic area and the likelihood that a kid will be successful at post-secondary education.
They could then target advertising campaigns towards those demographics.
Why is identifying the question such a critical first step in the IMPACT process cycle?
The first step in the impact model is about understanding a business problem that needs
addressing. Having a concrete and specific question that is potentially answerable by data
analytics guides the next steps in the data analytics process.
Among the advantages of using a relational database is enforcing business rules. Based on your
understanding of how the structure of a relational database helps prevent data redundancy and
other advantages, how does the primary key/foreign key relationship structure help enforce a
business rule that indicates that a company should not process any purchase orders from
suppliers who do not exist in the database? In a database, you have multiple tables (ex.
Customers, purchase orders, etc.). When you have a primary/foreign key relationship, it
maintains data integrity, so you cannot create a new purchase order without having an existing
customer to link it to.
Regarding the data request form, why do you think it is important to the database administrator
to know the purpose of the request? What would be the importance of the "To be used in" and
, "intended audience" field? The data administer is most familiar with the data and may be
able to help the analyst get the data needed to address the question. There also might be some
sensitivities as to who gets access to what data to ensure that the appropriate data is provided for
the intended analyst and audience.
How might the data reduction approach be used in auditing? Data reduction is when you
have a massive data set (big data) and you narrow it down by removing redundant data to get a
subset of the data to base your decision off of. Data reduction can be used in auditing whenever
the auditor is testing a company's internal control systems. Let us say they only want to look at
transactions for a specific year, by using data reduction they can narrow down the data to what is
relevant for the current year.
How does fuzzy match work? Give an accounting situation where it might be most useful.
Fuzzy matching enables you to join two data sets together where a regular join may fail.
Fuzzy matching identifies nonidentical duplicates of a data set by specifying the parameters to
match on. Fuzzy matching uses algorithms to decides how similar two words or phrases are.
Fuzzy matching could be used in accounting to prevent invoice fraud. For example, is someone
submitted the same invoice more than once, software with fuzzy matching can help catch the
duplicate invoice even if it's not identical to the original.
Explain Exhibit 4-2 and why these four dimensions are helpful in describing information to be
communicated? This exhibit maps out the 4 types of visualizations. These are helpful
because your approach to presenting the information will differ depending on the message you
are trying to convey (declarative or exploratory) and whether the information is qualitative of
quantitative.
