WGU D552 Data Analytics for Accountants I Complete OA-Prep Package | 225 Original Practice Questions, Excel Scenarios, Answers & Rationales | 2026/2027

D552 Data Analytics for Accountants I
Review
Data Analytics - ANS>>the process of evaluating data with the purpose of drawing
nn nn nn nn nn nn nn nn nn nn nn nn



conclusiions to address business questions
nn nn nn nn nn




a way to search through large structured and unstructured data to identify unknown
nn nn nn nn nn nn nn nn nn nn nn nn



patterns or relationships - ANS>>What does data analytics provide?
nn nn nn nn nn nn nn nn nn




Untructured Data - ANS>>data that do not adhere to a predefined data model in a
nn nn nn nn nn nn nn nn nn nn nn nn nn nn



tabular format
nn nn




Structured Data - ANS>>data that are organized and reside in a fixed field with a
nn nn nn nn nn nn nn nn nn nn nn nn nn nn



record or a file, readily searchable by search algorithms
nn nn nn nn nn nn nn nn nn




Big Data - ANS>>datasets that are too large and complex for businessses existing
nn nn nn nn nn nn nn nn nn nn nn nn



systems to handle utilizing their traditional capabilities to capture, store, manage, and
nn nn nn nn nn nn nn nn nn nn nn nn



analyze these datasets
nn nn nn




Volume, Velocity, Veracity, and Variety - ANS>>What are the 4 V's of big data?
nn nn nn nn nn nn nn nn nn nn nn nn nn




Volume - ANS>>the sheer size of the data nn nn nn nn nn nn nn




Velocity - ANS>>the speed of data processing
nn nn nn nn nn nn




Variety - ANS>>the number of the types of different data q
nn nn nn nn nn nn nn nn nn nn




Veracity - ANS>>the underlying quality of the data
nn nn nn nn nn nn nn




discover the various buying patterns of their customers, investigate anomalies that
nn nn nn nn nn nn nn nn nn nn



were not anticipated, forecast future possibilities, etc. - ANS>>Companies use data
nn nn nn nn nn nn nn nn nn nn nn



analysis to:
nn nn




$2 million - ANS>>The study from McKinsey Gobal institute estimated that data
nn nn nn nn nn nn nn nn nn nn nn



analytics and technology could generate how much in value per year?
nn nn nn nn nn nn nn nn nn nn nn




1. Audits must better embrace technology
nn nn nn nn nn



2. Technology will enhance the aulity, transparency, and accuracy of the audit -
nn nn nn nn nn nn nn nn nn nn nn nn



ANS>>According to Forbes Insights/KPMG's report "Audit 2020: A focus on change",
nn nn nn nn nn nn nn nn nn nn nn



the vast majority of respondents believe that:
nn nn nn nn nn nn nn




1) asked questions by management
nn nn nn nn nn



2) find data to address those questions
nn nn nn nn nn nn nn



3) analyze the data
nn nn nn nn



4) report the results to management to aid in their decision making -
nn nn nn nn nn nn nn nn nn nn nn nn



ANS>>Responsibilities of Management Accountants:
nn nn nn nn

, D552 Data Analytics for Accountants I
Review
integrating the strategy with the IT department and gaining access to available
nn nn nn nn nn nn nn nn nn nn nn



technology tools - ANS>>What do 29% of tax departments find the biggest challenge
nn nn nn nn nn nn nn nn nn nn nn nn nn



related to executing an analytics strategy?
nn nn nn nn nn nn




Isson and Harriot - ANS>>Who created the IMPACT cycle?
nn nn nn nn nn nn nn nn




1) nn I - Identify the Questions
nn nn nn nn nn



2) nn M - master the data
nn nn nn nn nn



3) nn P - perform test plans
nn nn nn nn nn



4) nn A - address and refine results
nn nn nn nn nn



5) nn C - communicate insights
nn nn nn nn



6) nn T - track outcomes - ANS>>Steps to the IMPACT cycle?
nn nn nn nn nn nn nn nn nn




Audience, Scope, and Use - ANS>>What attributes should be considered when
nn nn nn nn nn nn nn nn nn nn



identifying the question?
nn nn nn




everythign about the data, including how to access, availability, reliability, frequency of
nn nn nn nn nn nn nn nn nn nn nn



updates, what time periods are covered to make sure data coincide with the timing of
nn nn nn nn nn nn nn nn nn nn nn nn nn nn nn



the business problem and so on. - ANS>>To master the data, you should know:
nn nn nn nn nn nn nn nn nn nn nn nn nn nn




- reviewing data availability in a firm's internal systems
nn nn nn nn nn nn nn nn nn



- reviewing data availability in a firm's external network
nn nn nn nn nn nn nn nn nn



- examine data dictionaries and other contextual data
nn nn nn nn nn nn nn nn



- evaluate and perform ETL processes and assess the time required to complete
nn nn nn nn nn nn nn nn nn nn nn nn nn



- assess data validation and completeness to provide a sense of reliability
nn nn nn nn nn nn nn nn nn nn nn nn



- evaluate and perform data normalization - to reduce data redundancy and improve
nn nn nn nn nn nn nn nn nn nn nn nn



data integrity
nn nn nn



- evaluate and perform data preparation and scrubbing - ANS>>To give some idea
nn nn nn nn nn nn nn nn nn nn nn nn



about the data questions, you may want to consider:
nn nn nn nn nn nn nn nn nn




between 50% and 90% - ANS>>How much time to data analytics professionals
nn nn nn nn nn nn nn nn nn nn nn



estimate they spend cleaning the data so it can be analyzed?
nn nn nn nn nn nn nn nn nn nn nn




- the research question
nn nn nn nn



- the model
nn nn nn



- the data availability
nn nn nn nn



- the expected statistical inference - ANS>>Characeristics that might suggest use of
nn nn nn nn nn nn nn nn nn nn nn



different data approaches are:
nn nn nn nn




Similarity Matching - ANS>>a data approach that attempts to identify similar
nn nn nn nn nn nn nn nn nn nn



individuals based on data known about them
nn nn nn nn nn nn nn




Link Prediction - ANS>>attempts to predict a relationship between 2 items
nn nn nn nn nn nn nn nn nn nn