ISE Data Analytics for Accounting

Vernon J. Richardson is Distinguished Professor of Accounting and the G. William Glezen Chair in the Sam M. Walton College of Business at the University of Arkansas and a Visiting Professor at Xian Jiaotong Liverpool University. He received his B.S., Masters of Accountancy, and MBA from Brigham Young University and a Ph.D. in accounting from the University of Illinois at Urbana-Champaign. He has taught students at the University of Arkansas, University of Illinois, Brigham Young University, Aarhus University, University of Kansas, and the China Europe International Business School (Shanghai), Xian Jiaotong Liverpool University and the University of Technology Sydney. Dr. Richardson is a member of the American Accounting Association. He has served as president of the American Accounting Association Information Systems section. He previously served as editor of The Accounting Review and is currently editor at the Accounting Horizons. He has published articles in the Accounting Review, Journal of Information Systems, Journal of Accounting and Economics, Contemporary Accounting Research, MIS Quarterly, International Journal of Accounting Information Systems, Journal of Management Information Systems, Journal of Operations Management, and Journal of Marketing. Chapter 1: Data Analytics for Accounting and Identifying theQuestions Chapter 2: Mastering the Data Chapter 3: Performing the Test Plan and Analyzing theResults 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'sData to Predict Sales Returns Appendix A: Basic Statistics Tutorial Appendix B: Excel (Formatting, Sorting, Filtering, andPivotTables) Appendix C: Accessing the Excel Data Analysis Toolpak Appendix D: SQL Part 1 Appendix E: SQL Part 2 Appendix F: Power Query in Excel and Power BI Appendix G: Power BI Desktop Appendix H: Tableau Prep Builder Appendix I: Tableau Desktop Appendix J: Data Dictionaries