Advanced Data Analytics Exam 1 || 100% Valid Solutions.
According to the EY Analytics Competency Framework, accountants should develop the
following level of proficiency with Alteryx. correct answers Master
Alteryx can be described as correct answers A self-service data and analytics platform that allows
users to create intuitive and repeatable data processes with no code.
Excel has built-in language, called_____________, that allows you to program macros. correct
answers Visual Basic for Applications (VBA)
According to ETL Case 5, using macros to automate tasks has the following benefits: correct
answers 1.) Saves Time
2.) Performs the task in an identical fashion each time
3.) Automation is less likely to introduce errors in the data because of human error
4.) Makes tasks easier to audit
What's a recorded macro in Excel? correct answers A recording of steps you've taken that you
can play back as often as you like.
The___________ is primarily a consumer of analytics and utilizes analytics to optimize business
solutions and provide better insights and efficiencies. While they are a specialist in the area of
business they are a "generalist" in terms of analytics. correct answers Business analyst
The _______________ are analytics specialists who construct databases, develop analytics
scripts and models, and design visualizations and dashboards for analytics consumers. Think of
these individuals as the producers of analytics. correct answers Analytic modeler.
A ______________ is a sequence of one or more characters specifying the boundary between
distinct data attributes. correct answers Delimiter
, In ETL Case 4, you were asked to prepare a single, flat file (i.e., spreadsheet) to reflect all of the
journal entries in the JELineItems tab in the data file and also include all the additional data
fields from remaining tabs in the workbook for each of these journal entries. Although you can
use the VLOOKUP function to fill some of the data, it cannot be used for all columns. The lab
encouraged you to use _______________ instead of VLOOKUP. correct answers Index and
Match
According to the Financial Management article entitled "In Excel, INDEX MATCH is a Winning
Combination," the ________________ function is used to return a value or the reference to a
value from within a table or range (list). correct answers Index
Analytic technology experts who create infrastructure, configure and implement business
intelligence (BI) applications, and establish data standards and management procedures for
sustainable operations of analytics solutions. These are considered ENABLERS of analytics
correct answers Analytic architechts
4 V's correct answers Volume, Velocity, Variety, Veracity
_______is a means of extracting value from data and is used to assess data with technological
tools correct answers Analytics
Despite sophisticated tools for data analytics what still remains and important aspect in
analytics? correct answers The human element: Critical Thinking and Judgement
What is included in the behavioral alignment? correct answers 1.) Culture and mental models
2.) Organization and process design
3.) Learning and development
4.) Incentives and rewards
What are the 5 Components for the flow if data in an AIS? correct answers 1.) Type of AIS
According to the EY Analytics Competency Framework, accountants should develop the
following level of proficiency with Alteryx. correct answers Master
Alteryx can be described as correct answers A self-service data and analytics platform that allows
users to create intuitive and repeatable data processes with no code.
Excel has built-in language, called_____________, that allows you to program macros. correct
answers Visual Basic for Applications (VBA)
According to ETL Case 5, using macros to automate tasks has the following benefits: correct
answers 1.) Saves Time
2.) Performs the task in an identical fashion each time
3.) Automation is less likely to introduce errors in the data because of human error
4.) Makes tasks easier to audit
What's a recorded macro in Excel? correct answers A recording of steps you've taken that you
can play back as often as you like.
The___________ is primarily a consumer of analytics and utilizes analytics to optimize business
solutions and provide better insights and efficiencies. While they are a specialist in the area of
business they are a "generalist" in terms of analytics. correct answers Business analyst
The _______________ are analytics specialists who construct databases, develop analytics
scripts and models, and design visualizations and dashboards for analytics consumers. Think of
these individuals as the producers of analytics. correct answers Analytic modeler.
A ______________ is a sequence of one or more characters specifying the boundary between
distinct data attributes. correct answers Delimiter
, In ETL Case 4, you were asked to prepare a single, flat file (i.e., spreadsheet) to reflect all of the
journal entries in the JELineItems tab in the data file and also include all the additional data
fields from remaining tabs in the workbook for each of these journal entries. Although you can
use the VLOOKUP function to fill some of the data, it cannot be used for all columns. The lab
encouraged you to use _______________ instead of VLOOKUP. correct answers Index and
Match
According to the Financial Management article entitled "In Excel, INDEX MATCH is a Winning
Combination," the ________________ function is used to return a value or the reference to a
value from within a table or range (list). correct answers Index
Analytic technology experts who create infrastructure, configure and implement business
intelligence (BI) applications, and establish data standards and management procedures for
sustainable operations of analytics solutions. These are considered ENABLERS of analytics
correct answers Analytic architechts
4 V's correct answers Volume, Velocity, Variety, Veracity
_______is a means of extracting value from data and is used to assess data with technological
tools correct answers Analytics
Despite sophisticated tools for data analytics what still remains and important aspect in
analytics? correct answers The human element: Critical Thinking and Judgement
What is included in the behavioral alignment? correct answers 1.) Culture and mental models
2.) Organization and process design
3.) Learning and development
4.) Incentives and rewards
What are the 5 Components for the flow if data in an AIS? correct answers 1.) Type of AIS
