Data Analytics for Accounting – Third Edition (Richardson, Teeter, Terrell) | Complete Textbook with Labs and Case Studies

page i


Data Analytics for Accounting
THIRD EDITION




Ver
non
J.
Ric
har
dso
n
Unive
rsity
of
Arka
nsas,
Baru
ch
Colle
ge

Rya
n

,A.
Tee
ter
Unive
rsity
of
Pittsb
urgh

Kat
ie
L.
Terr
ell
Unive
rsity
of
Arka
nsas

, page xx




Brief Table of Contents
Preface iv
About the Authors vi
Acknowledgments vii
Key Features viii
Main Text Features ix
End-of-Chapter Materials x
Data Analytics for Accounting, 3e Content Updates xii
Connect for Data Analytics for Accounting xv

Chapter 1 Data Analytics for Accounting and Identifying the
Questions 2
Chapter 2 Mastering the Data 52
Chapter 3 Performing the Test Plan and Analyzing the Results 114
Chapter 4 Communicating Results and Visualizations 180
Chapter 5 The Modern Accounting Environment 244
Chapter 6 Audit Data Analytics 282
Chapter 7 Managerial Analytics 334
Chapter 8 Financial Statement Analytics 404
Chapter 9 Tax Analytics 454
Chapter 10 Project Chapter (Basic) 498

, Chapter 11 Project Chapter (Advanced): Analyzing Dillard’s Data to
Predict Sales Returns 512
Appendix A Basic Statistics Tutorial 528
Appendix B Excel (Formatting, Sorting, Filtering, and PivotTables) 534
Appendix C Accessing the Excel Data Analysis Toolpak 544
Appendix D SQL Part 1 546
Appendix E SQL Part 2 560
Appendix F Power Query in Excel and Power BI 564
Appendix G Power BI Desktop 572
Appendix H Tableau Prep Builder 578
Appendix I Tableau Desktop 582
Appendix J Data Dictionaries 586

GLOSSARY 588

INDEX 593