Accounting Analytics: An Integrated Approach, offers a comprehensive, practice-oriented introduction to accounting analytics, integrating financial accounting, managerial accounting, and auditing with Microsoft Excel, SQL, and Microsoft Power BI. Designed to bridge accounting knowledge and analytical technology, the textbook helps students develop the skills needed to transform accounting data into meaningful information for business decisions.
At the center of the book is the Charles River Accounting Dataset, a comprehensive synthetic accounting database representing the operations of a fictional company. Rather than relying on disconnected examples, the textbook uses a consistent business environment throughout its chapters. This integrated approach enables readers to explore how business processes generate accounting data, trace transactions from operational systems to the general ledger, and apply analytical techniques to realistic accounting problems.
Organized into five progressive parts, the textbook begins with the foundations of accounting analytics before introducing data preparation, analysis, and automation in Excel, relational database management and querying with SQL, and data modeling, visualization, and reporting with Power BI. The final part brings these competencies together through comprehensive accounting cases that require readers to integrate technical skills, accounting knowledge, and professional judgment.
Each chapter combines conceptual foundations with guided tutorials, practical exercises, and applied accounting examples. The emphasis on reproducible workflows and realistic business scenarios prepares readers to extract, clean, transform, analyze, visualize, and interpret accounting data while developing a deeper understanding of financial reporting, management decision-making, and auditing.
Developed for undergraduate and graduate accounting education, the book also serves instructors, researchers, and accounting professionals seeking to strengthen their analytical capabilities. Its integrated structure supports classroom instruction, independent study, and professional development.
Open Educational Resource
Accounting Analytics: An Integrated Approach is published as an open educational resource under the Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license, except where otherwise noted. The complete digital textbook is freely accessible, supporting the development and dissemination of high-quality, affordable accounting education.
Readers can access the free online textbook, download digital editions, obtain the Charles River Accounting Dataset, and explore supplementary learning resources, including tutorials, exercises, case studies, and teaching materials.
Official Book Website
AccountingAnalyticsHub.com