Data Analytics for Accounting
2nd Edition
9390219663
·
9789390219667
© 2021 | Published: November 23, 2020
OVERVIEWData Analytics for Accounting, 2e is designed to provide the readers with the necessary tools and skills to successfully perform data analytics. Using Isson's data analytics model, the IMPACT Cycle, the text provides a conceptual framework to…
Read More
Chapter 1 Data Analytics for Accounting and Identifying the Questions
Chapter 2 Mastering the Data
Chapter 3 Performing the Test Plan and Analyzing the Results
Chapter 4 Communicating Results and Visualizations
Chapter 5 The Modern Accounting Environment
Chapter 6 Audit Data Analytics
Chapter 7 Managerial Analytics
Chapter 8 Financial Statement Analytics
Chapter 9 Tax Analytics
Chapter 10 Project Chapter (Basic)
Chapter 11 Project Chapter (Advanced): Analyzing Dillard’s Data to Predict Sales Returns
Chapter 12 Accounting Analytics in India
Appendix A Basic Statistics Tutorial
Appendix B Accessing the Excel Data Analysis Toolpak
Appendix C Excel (Formatting, Sorting, Filtering, and PivotTables)
Appendix D SQL Part 1
Appendix E SQLite
Appendix F Power Query
Appendix G Tableau
Appendix H SQL Part 2
Appendix I Power BI
Appendix J Dillard’s ER Diagram
Appendix K Data Dictionaries
Chapter 2 Mastering the Data
Chapter 3 Performing the Test Plan and Analyzing the Results
Chapter 4 Communicating Results and Visualizations
Chapter 5 The Modern Accounting Environment
Chapter 6 Audit Data Analytics
Chapter 7 Managerial Analytics
Chapter 8 Financial Statement Analytics
Chapter 9 Tax Analytics
Chapter 10 Project Chapter (Basic)
Chapter 11 Project Chapter (Advanced): Analyzing Dillard’s Data to Predict Sales Returns
Chapter 12 Accounting Analytics in India
Appendix A Basic Statistics Tutorial
Appendix B Accessing the Excel Data Analysis Toolpak
Appendix C Excel (Formatting, Sorting, Filtering, and PivotTables)
Appendix D SQL Part 1
Appendix E SQLite
Appendix F Power Query
Appendix G Tableau
Appendix H SQL Part 2
Appendix I Power BI
Appendix J Dillard’s ER Diagram
Appendix K Data Dictionaries
OVERVIEW
Data Analytics for Accounting, 2e is designed to provide the readers with the necessary tools and skills to successfully perform data analytics. Using Isson's data analytics model, the IMPACT Cycle, the text provides a conceptual framework to help readers think through the steps needed to provide data-driven insights and recommendations. Each chapter integrates lab exercises that provide multiple datasets and tutorials to give students hands-on experience working with different types of data. The book also emphasizes on the application and usability of different tools for data analysis, such as Microsoft Excel, Microsoft Access (including SQL) Tableau, IDEA, XBRL, and Weka.
KEY POINTS
• Emphasis on Hands-on Practice: Get hands-on learning on datasets using click-by-click instructions, screenshots, etc.
• Emphasis on Skills: Working through the IMPACT Cycle framework, learn problem assessment, data preparation, data analysis, data visualization, controls testing and more
• Emphasis on Datasets: Use of multiple practice datasets (audit, financial, and managerial data) in every chapter with click-by-click instructions
• Emphasis on Tools: Learn how to conduct data analysis using Excel, Access (including SQL), Tableau, IDEA and Weka
• Emphasis on Accounting Analytics in Indian Context: A dedicated chapter on importance of data analytics in Indian accounting industry and forensic audits done in India
Data Analytics for Accounting, 2e is designed to provide the readers with the necessary tools and skills to successfully perform data analytics. Using Isson's data analytics model, the IMPACT Cycle, the text provides a conceptual framework to help readers think through the steps needed to provide data-driven insights and recommendations. Each chapter integrates lab exercises that provide multiple datasets and tutorials to give students hands-on experience working with different types of data. The book also emphasizes on the application and usability of different tools for data analysis, such as Microsoft Excel, Microsoft Access (including SQL) Tableau, IDEA, XBRL, and Weka.
KEY POINTS
• Emphasis on Hands-on Practice: Get hands-on learning on datasets using click-by-click instructions, screenshots, etc.
• Emphasis on Skills: Working through the IMPACT Cycle framework, learn problem assessment, data preparation, data analysis, data visualization, controls testing and more
• Emphasis on Datasets: Use of multiple practice datasets (audit, financial, and managerial data) in every chapter with click-by-click instructions
• Emphasis on Tools: Learn how to conduct data analysis using Excel, Access (including SQL), Tableau, IDEA and Weka
• Emphasis on Accounting Analytics in Indian Context: A dedicated chapter on importance of data analytics in Indian accounting industry and forensic audits done in India
