Acc 430 - Milestone One
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
430
Subject
Accounting
Date
Feb 20, 2024
Type
docx
Pages
6
Uploaded by EpsylonGere
ACC 430: Data Analytics for Financial Professionals
Milestone One
Southern New Hampshire University
Bryan Levin
11/12/23
Data analytics solutions such as Microsoft Excel Power Query/Power BI and Tableau are flexible and can be used to solve data related issues. These solutions can be used in analyzing ethical issues, explaining techniques, explaining why clean data is being used, identifying problems, and justifying why identifying anomalies is important when working with data.
The accounting department has data that is frequently inconsistent in format, missing numbers, and outliers. There can be an overabundance of data when one starts to look at the data for the company. The data needs to be broken down and cleaned up to be able to be analyzed properly to see the exact information that one is looking for. The technologies aid in the creation of models that forecast cost variations. The models are also able to help the management department discover the problem areas, by measuring key performance indicators with industry data and real-time industry data. Microsoft Excel Power Query/Power BI and Tableau are two examples of analytical technologies that can help the accounting department in its daily operations. Power Query with Microsoft Excel Power BI can be utilized to clean and manipulate data. To be able to make the data usable, one may eliminate duplicates, fill in the missing information, and pivot data. The company analysts can use data preparation with Tableau to clean and restructure the data. As an example, one can aggregate data, combine various tables, and construct computed columns. Once the data has been cleaned and compiled, we can apply this data to do predictive analysis, such as estimating consumer behavior or sales. One can also use program languages such as R and Python to incorporate machine learning into Power BI and generate predictions. “Both R and
Python are full programming languages with extensive capability for analyzing and manipulating
data which can unlock more insights from your data. While Power BI can connect to many data
sources, there are a few that it lacks. R and Python are open source languages and as a result, have a plethora of packages and libraries which can be used to extend the language’s abilities. Some of these packages include dealing with specific data sources and file types. They are also capable of some useful visuals. Your organization may have existing solutions written in R or Python, and this code could easily be reused in Power BI. Or perhaps you are already an expert at R or Python. Rather than learning the in and outs of Power Query, you could largely by-pass it
with a language you are already familiar with and fast at” (IterationInsights). We can use previous data with these languages to help predict sales. Both analytical approaches can be used to track performance after receiving the prediction analysis. The company will be able to build a real-time dashboard and stream data using Power BI to keep track of KPIs. It can be used to keep
track of sales and website visitors in real time. Tableau allows the ability to employ data refresh schedules to keep dashboards current. An example of a data refresh would be monitoring inventory levels. These data analytics tools are great assets for those that are looking to use data to be able to make well informed decisions as they provide a wide range of features and the ability to address various data related difficulties. Numerous ethical concerns need to be thoroughly examined while dealing with data and analytical tools while trying to uphold ethical and open data practices. Privacy and transparency are two major ethical concerns in setting up an accounting department. Accountants regularly work with private financial information, such as a client or employee’s personal data. Data breaches, or misuse of data are serious violations of one’s privacy. It can ruin the confidence and
reputation of a company if they revealed customer tax documents through the lack of data safeguards. If analytical tools are poorly established and monitored, it can inadvertently reinforce
bias. As an example, an accounting department could implement a system that unjustly favors
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Question #66: Lamar LLC is in the process of updating its revenues and receivables systems with the implementation of new accounting software. James Loden, Inc. is an independent information technology consultant who is assisting Tamar with the project. James has developed the following checklist containing internal control points that the company should consider in this new implementation:
Will all data entry clerks and accounting personnel have their own PCs with log‐in IDs and password protection?
Will different system access levels for different users be incorporated?
Will customer orders be received via the Internet?
Has the company identified an off‐site alternative computer processing location?
Does the project budget include line items for an upgraded, uninterrupted power source and firewall?
Required: In a two (2) page response, describe the control purpose for each point presented in the case.
arrow_forward
Big Data
Big data and data analytics are becoming an important part of an accountant's methods for analyzing the different companies and their performances. The use of these elements enhances organizational performance, improves fraud detection, and increases audit performance and scope.
Use the Internet or Strayer University Library databases to review at least two news articles or publications about current and future trends in the use of big data.
Choose a company that is not publicly traded (a small or medium-sized company).
Review the company, and suggest some of the ways in which big data would benefit this company.
arrow_forward
Performance Task #1. Introduction to PSA 401
Instructions: Provide for the requirements given to you below. Output must be placed in a
Microsoft Word following the formats specified. Your answers must be in paragraphs and must
contain first person point of view. God bless!
1. Explain the sentence "The overall objective and scope of an audit does not change in a CIS
environment. However, the use of a computer changes the processing, storage and
communication of financial information and may affect the accounting and internal
control systems employed by the entity."
2. Explain why the auditor should have sufficient knowledge of the CIS to plan, direct,
supervise and review the work performed.
3. Differentiate the process of planning the audit in a manual system and a computerized
system.
4. Identify the risks of using a computerized system in the process of audit.
5. Explain the sentence "The auditor's specific audit objectives do not change whether
accounting data is processed manually…
arrow_forward
FYI: THIS IS AN ACCOUNTING EXCEL PROBLEM - NOT A COMPUTER SCIENCE PROBLEM!
Please read the instructions carefully in the picture that I posted.
For this accounting practice problem, please create an excel worksheet based off of the information in the picture.
Thank you!!!
arrow_forward
Pemaining: 01:57:28
Accounting
Subject : Management information system
Draw two(2) separate mind maps to describe :
1) The ethical issues brought about by the development amd advancement in information technology
2) The threats towards computerised information system and protective measures to counter them.
Your ancwor
arrow_forward
How can an auditor use the following topic in his future work?
Apply key data wrangling best practices to real-world structured and unstructured data
Employ data wrangling principles using current industry tools and statistical programming languages, to develop and implement data transformation functions and models
Apply data operations processes to develop automated, repeatable solutions that address business goals
Communicate the opportunities for data transformation needs and solutions to address dynamic organizational data challenges
arrow_forward
research data analytics in accounting information systems or emerging technologies in the accounting industry. Your presentation should focus on the impact of the selected topic on accounting information systems, internal controls, and benefits and challenges associated with its implementation.
As a PowerPoint presentation with voiceover.
The presentation should be 6-8 slides, not including the title page and the reference page.
Speaker Notes should be submitted as a Word Document. On the Word document, include a header for each slide followed by your notes.
Use this guide, APA7 Visual Presentations - CSU Global LibraryLinks to an external site., to record your voiceover for your presentation. You can also use Zoom to record your voiceover.
Your presentation should include the following headers:
Introduction – brief overview of the topic and its relevance to accounting information systems and/or emerging technologies
Impact on Accounting Information Systems – how this topic…
arrow_forward
Understanding components of a computerized accounting information system
Ned Timmons, engineer, is considering using a computerized accounting system for his professional engineering business. Ned has asked that you help him understand the components of a computerized accounting information system by answering the following questions:
Requirements
1. What are the two basic components of a computerized accounting information system?
2. Provide examples of each component.
3. If Ned were interested in an entry-level software system, what software might you recommend?
arrow_forward
Industry Tools Research
Your manager has asked you to recommend an industry tool for purchase. Select one of the following tools to research: ACL, IDEA, Microsoft Visio, Oversight, Power BI, Alteryx, and Tableau.
Identify key features of each tool.
Discuss how auditors can incorporate the tool into their audits.
Additional learning opportunities: If you are interested in learning more about data analytics and emerging technologies in accounting, join the Institute of Management Accountants (IMA) for only $25 per year: Students | IMA - The association of accountants and financial professionals working in business.Links to an external site. (Use code Student22). Gain access to Free courses, training, and webinars.
arrow_forward
Case Study:
In today's rapidly evolving technological landscape, accountants are leveraging
various technologies to streamline their everyday tasks, enhance efficiency, and
provide more insightful financial analysis. One such technology is cloud computing,
which allows accountants to access accounting software and data storage services
over the internet, enabling collaboration and remote work flexibility. Additionally,
automation tools like robotic process automation (RPA) and artificial intelligence (AI)
are revolutionizing repetitive tasks such as data entry, transaction processing, and
reconciliation. These technologies not only reduce manual effort but also minimize
errors and free up accountants' time for more value-added activities.
Furthermore, data analytics tools enable accountants to analyze vast amounts of
financial data quickly and derive meaningful insights for decision-making. With
advanced reporting and visualization capabilities, accountants can identify trends,…
arrow_forward
Chapter 10
Accounting Information Systems
Short Problem 10-3, page 394: Using the following table as a guide, describe for each function from Figure 10.1:
A risk (an event or action that will cause the organization to fail to meet its goals/objectives)
A control/process or use of technology that will address the risk.
arrow_forward
Accounting Softwares: Oracle Netsuite and SAP
Compare the pros and cons of each system to show the system's benefits and drawbacks for businesses in the way they handle transaction processing for accounting cycles.
Discuss the way artificial intelligence (AI) or machine learning is utilized in the system and how these tools elevate data processing and data analytics.
arrow_forward
7 out of 15
Modeling Best Practices
There are various best practices when it comes to entering data.
Which of the following is a best practice for financial model inputs?
Data should only be entered once
Use complex calculations to minimize space in the model
Always lock input cells
Document every change to the model
Review Later
arrow_forward
1.
a. Why are documentation, visualization, and business process mapping important to accounting information systems auditors? b. Why should accountants be interested in AIS documentation?
2. How are data analytics tools helping accountants and auditors?
3.
a. Explain why auditors’ communication skills are so important. b. Give examples of where these skills would be necessary in each phase of an audit engagement. c. In this age of high technology and computer-based information systems, why are accountants/auditors concerned about physical (human) controls?
arrow_forward
Question
Please answer all the requirements. Thank you
1. Increasing use of sophisticated EDP systems has produced significant changes in the accounting environment. Some of these changes are the following:
a. documents that are used to enter information into the computer may exist for only a short time or only in computer-readable form. In some computer systems, input documents may not exist at all, because information is entered directly into the system.
b. Computer processing uniformly subjects like transactions to the same processing instructions.
c. Many internal control procedures, once performed by separate individuals in manual systems, may be combined in systems that use computer processing.
d. The potential for individuals to gain unauthorized access to data or assets may be greater in computerized accounting systems than in manual systems.
Required:
For each of the changes, discuss the impact on the internal control system and the independent audit.
2. The CARE Corporation…
arrow_forward
34. Which of the following describes data science?
Ubiquitous, on-demand access to shared servers and applications
Use of computers to learn and to understand language
Collection, preparation, management, analysis, interpretation and visualization of large and complex datasets
Extraction of meaning and new information from data in order to identify strategies for an organization
35. Mangold plc, a large centralized business in the UK, has conducted a strategic review and established that it needs to pursue a strategy of new products in new markets across the world. Its structure needs to change to facilitate this.
Which of the following structures is most appropriate to Mangold plc's new strategy?
An entrepreneurial structure
A functional structure
A divisional structure
A matrix structure
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Accounting Information Systems
Finance
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Related Questions
- Question #66: Lamar LLC is in the process of updating its revenues and receivables systems with the implementation of new accounting software. James Loden, Inc. is an independent information technology consultant who is assisting Tamar with the project. James has developed the following checklist containing internal control points that the company should consider in this new implementation: Will all data entry clerks and accounting personnel have their own PCs with log‐in IDs and password protection? Will different system access levels for different users be incorporated? Will customer orders be received via the Internet? Has the company identified an off‐site alternative computer processing location? Does the project budget include line items for an upgraded, uninterrupted power source and firewall? Required: In a two (2) page response, describe the control purpose for each point presented in the case.arrow_forwardBig Data Big data and data analytics are becoming an important part of an accountant's methods for analyzing the different companies and their performances. The use of these elements enhances organizational performance, improves fraud detection, and increases audit performance and scope. Use the Internet or Strayer University Library databases to review at least two news articles or publications about current and future trends in the use of big data. Choose a company that is not publicly traded (a small or medium-sized company). Review the company, and suggest some of the ways in which big data would benefit this company.arrow_forwardPerformance Task #1. Introduction to PSA 401 Instructions: Provide for the requirements given to you below. Output must be placed in a Microsoft Word following the formats specified. Your answers must be in paragraphs and must contain first person point of view. God bless! 1. Explain the sentence "The overall objective and scope of an audit does not change in a CIS environment. However, the use of a computer changes the processing, storage and communication of financial information and may affect the accounting and internal control systems employed by the entity." 2. Explain why the auditor should have sufficient knowledge of the CIS to plan, direct, supervise and review the work performed. 3. Differentiate the process of planning the audit in a manual system and a computerized system. 4. Identify the risks of using a computerized system in the process of audit. 5. Explain the sentence "The auditor's specific audit objectives do not change whether accounting data is processed manually…arrow_forward
- FYI: THIS IS AN ACCOUNTING EXCEL PROBLEM - NOT A COMPUTER SCIENCE PROBLEM! Please read the instructions carefully in the picture that I posted. For this accounting practice problem, please create an excel worksheet based off of the information in the picture. Thank you!!!arrow_forwardPemaining: 01:57:28 Accounting Subject : Management information system Draw two(2) separate mind maps to describe : 1) The ethical issues brought about by the development amd advancement in information technology 2) The threats towards computerised information system and protective measures to counter them. Your ancworarrow_forwardHow can an auditor use the following topic in his future work? Apply key data wrangling best practices to real-world structured and unstructured data Employ data wrangling principles using current industry tools and statistical programming languages, to develop and implement data transformation functions and models Apply data operations processes to develop automated, repeatable solutions that address business goals Communicate the opportunities for data transformation needs and solutions to address dynamic organizational data challengesarrow_forward
- research data analytics in accounting information systems or emerging technologies in the accounting industry. Your presentation should focus on the impact of the selected topic on accounting information systems, internal controls, and benefits and challenges associated with its implementation. As a PowerPoint presentation with voiceover. The presentation should be 6-8 slides, not including the title page and the reference page. Speaker Notes should be submitted as a Word Document. On the Word document, include a header for each slide followed by your notes. Use this guide, APA7 Visual Presentations - CSU Global LibraryLinks to an external site., to record your voiceover for your presentation. You can also use Zoom to record your voiceover. Your presentation should include the following headers: Introduction – brief overview of the topic and its relevance to accounting information systems and/or emerging technologies Impact on Accounting Information Systems – how this topic…arrow_forwardUnderstanding components of a computerized accounting information system Ned Timmons, engineer, is considering using a computerized accounting system for his professional engineering business. Ned has asked that you help him understand the components of a computerized accounting information system by answering the following questions: Requirements 1. What are the two basic components of a computerized accounting information system? 2. Provide examples of each component. 3. If Ned were interested in an entry-level software system, what software might you recommend?arrow_forwardIndustry Tools Research Your manager has asked you to recommend an industry tool for purchase. Select one of the following tools to research: ACL, IDEA, Microsoft Visio, Oversight, Power BI, Alteryx, and Tableau. Identify key features of each tool. Discuss how auditors can incorporate the tool into their audits. Additional learning opportunities: If you are interested in learning more about data analytics and emerging technologies in accounting, join the Institute of Management Accountants (IMA) for only $25 per year: Students | IMA - The association of accountants and financial professionals working in business.Links to an external site. (Use code Student22). Gain access to Free courses, training, and webinars.arrow_forward
- Case Study: In today's rapidly evolving technological landscape, accountants are leveraging various technologies to streamline their everyday tasks, enhance efficiency, and provide more insightful financial analysis. One such technology is cloud computing, which allows accountants to access accounting software and data storage services over the internet, enabling collaboration and remote work flexibility. Additionally, automation tools like robotic process automation (RPA) and artificial intelligence (AI) are revolutionizing repetitive tasks such as data entry, transaction processing, and reconciliation. These technologies not only reduce manual effort but also minimize errors and free up accountants' time for more value-added activities. Furthermore, data analytics tools enable accountants to analyze vast amounts of financial data quickly and derive meaningful insights for decision-making. With advanced reporting and visualization capabilities, accountants can identify trends,…arrow_forwardChapter 10 Accounting Information Systems Short Problem 10-3, page 394: Using the following table as a guide, describe for each function from Figure 10.1: A risk (an event or action that will cause the organization to fail to meet its goals/objectives) A control/process or use of technology that will address the risk.arrow_forwardAccounting Softwares: Oracle Netsuite and SAP Compare the pros and cons of each system to show the system's benefits and drawbacks for businesses in the way they handle transaction processing for accounting cycles. Discuss the way artificial intelligence (AI) or machine learning is utilized in the system and how these tools elevate data processing and data analytics.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningAccounting Information SystemsFinanceISBN:9781337552127Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan HillPublisher:Cengage Learning
- Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Accounting Information Systems
Finance
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L