ACCOUNTING INFORMATION SYSTEMS SPRING 2024 TERM PROJECT USING DATA ANALYSIS
PART ONE
UNDERSTAND the QUESTION
DETERMINE the SCOPE of the QUESTION (Single Company OR Economy as a Whole) – BRIEF ONE PARAGRAPH DESCRIPTION
BASED ON #2, Identify and ListWHAT DATA is NEEDED and AVAILABLE. D
IDENTIFY and LIST WHERE THE DATA IS LOCATED
What are Advantages/Disadvantages? (Descriptive Analytics)
What are the root causes of the results? (Diagnostic Analytics)
What should you do, based on what you expect will happen? How do you optimize our performance based on potential constraints?” (Prescriptive Analytics)
PART TWO
List areas of concern. Identify the Relevant Accounting Question and the appropriate tools that were used in your analysis
We will be using the second part of the textbook for the rest of the course. There is valuable guidance provided in the textbook.
REQUIRED – The AMPS model, Document work steps, Detailed Data Analysis:
AMPS:Ask the Question – Match one of the accounting questions and appropriate procedures with the question being asked above.
AMPS:Master the Data –
What data (financial & non financial) do you need to answer/address the question?
Identify data sources and analytical tools that will be used
AMPS:Perform the Analysis-
Predictive analytics are procedures used to generate a model that can be used to determine what is likely to happen in the future.
Prescriptive analytics are procedures that model data to enable recommendations for what should be done in the future.
Spreadsheets – Basic Formula and functions
References – how to connect other data in the spreadsheet
Macros – how to automate processes that are repetitive
Pivot
Tables
– often a very functional tool for many types of summarizations and also serves as a way to help organize the data
Query – Used to access the data needed for analysis
Using VLOOKUP in Excel to retrieve data from different databases
Understand how SQL might be used to access specific data from large datasets
State your conclusion. What is the best way to communicate what you have found in your data analysis?
Static Visualizations
Reports
Graphs
Tables
Diagrams/Flowcarts
PART FIVE
AMPS: Share the Story–
ACCOUNTING INFORMATION SYSTEMS SPRING 2024 TERM PROJECT USING
DATA ANALYSIS
PART ONE
1- UNDERSTAND the QUESTION
2- DETERMINE the SCOPE of the QUESTION (Single Company OR Economy as a Whole)
– BRIEF ONE PARAGRAPH DESCRIPTION
3- BASED ON #2, Identify and List WHAT DATA is NEEDED and AVAILABLE. D
4- IDENTIFY and LIST WHERE THE DATA IS LOCATED
5- DETERMINE and LIST HOW TO EXTRACT DATA
PART TWO
QUESTION- Should we outsource Customer Servive Whatever your conclusion it must be
substantiated be specific, detailed data analysis….financial data AND non-financial.
List areas of concern. Identify the Relevant Accounting Question and the appropriate tools that
were used in your analysis
We will be using the second part of the textbook for the rest of the course. There is valuable
guidance provided in the textbook.
- PART THREE
REQUIRED – The AMPS model, Document work steps, Detailed Data Analysis:
AMPS: Ask the Question – Match one of the accounting questions and appropriate procedures
with the question being asked above.
- Four Types/Themes of Accounting Questions:
What are Advantages/Disadvantages? (Descriptive Analytics)
What are the root causes of the results? (Diagnostic Analytics)
What will be the result? What is the probability, is it forecastable? (Predictive
Analytics)
What should you do, based on what you expect will happen? How do you
optimize our performance based on potential constraints?” (Prescriptive
Analytics)
AMPS: Master the Data –
What data (financial & non financial) do you need to answer/address the question?
Identify data sources and analytical tools that will be used
PART FOUR
AMPS: Perform the AnalysisDescriptive analytics are procedures that summarize existing data to determine what has
happened in the past.
Diagnostic analytics are procedures that explore the current data to determine why something
has happened the way it has, typically comparing the data to a benchmark.
Predictive analytics are procedures used to generate a model that can be used to determine
what is likely to happen in the future.
Prescriptive analytics are procedures that model data to enable recommendations for what
should be done in the future.
Spreadsheets – Basic Formula and functions
References – how to connect other data in the spreadsheet
Macros – how to automate processes that are repetitive
Pivot Tables – often a very functional tool for many types of summarizations and
also serves as a way to help organize the data
Query – Used to access the data needed for analysis
Using VLOOKUP in Excel to retrieve data from different databases
Understand how SQL might be used to access specific data from large datasets
PART FIVE
AMPS: Share the StoryState your conclusion. What is the best way to communicate what you have found in your
data analysis?
Static Visualizations
Reports
Graphs
Tables
Diagrams/Flowcarts
Identify your Data Sources
Aprox. 4 – 5 pages.
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
