Accounting Analytics An Integrated Approach

This open educational resource textbook teaches accounting and business students to extract, prepare, analyze, and visualize financial and operational data using Microsoft Excel, SQL, and Microsoft Power BI, three tools widely adopted in professional practice. Every technique is taught through accou...

Full description

Saved in:
Bibliographic Details
Main Author: Codesso, Mauricio (Author)
Format: Electronic eBook
Language:English
Published: [Place of publication not identified] Accounting Analytics Hub [2027]
Series:Open textbook library.
Subjects:
Online Access:Access online version
Tags: Add Tag
No Tags, Be the first to tag this record!

MARC

LEADER 00000nam a2200000 i 4500
001 OTLid0002139
003 MnU
005 20261022095705.0
006 m o d s
007 cr
008 261022s2027 mnu o 0 0 eng d
040 |a MnU  |b eng  |c MnU 
050 4 |a HF5625 
050 4 |a HF5001 
050 4 |a QA76 
100 1 |a Codesso, Mauricio  |e author 
245 0 0 |a Accounting Analytics  |b An Integrated Approach  |c Mauricio Codesso 
264 2 |a Minneapolis, MN  |b Open Textbook Library 
264 1 |a [Place of publication not identified]  |b Accounting Analytics Hub  |c [2027] 
264 4 |c ©2027. 
300 |a 1 online resource 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
341 0 |a textual  |b alternativeText  |b displayTransformability  |b readingOrder  |b structuralNavigation  |b tableOfContents  |b taggedPDF  |2 sapdv 
490 0 |a Open textbook library. 
505 0 |a Preface -- Downloads -- Foundations of Accounting Analytics -- 1 The Role of Analytics in Accounting -- 2 Understanding Data in Accounting -- 3 The Accounting Data Environment -- Comprehensive Case: Getting the Data Ready for the Furniture Margin Question -- Accounting Analytics with Excel -- 4 Excel Essentials for Accounting Analytics -- 5 Data Preparation and Cleaning in Excel -- 6 Descriptive and Diagnostic Analytics in Excel -- 7 Forecasting, Budgeting, and What-If Analysis in Excel -- 8 Audit Analytics in Excel -- Comprehensive Case: Deciding on the 2027 Promotion Calendar -- Accounting Analytics with SQL -- 9 SQL Essentials for Accounting Analytics -- 10 Joining and Summarizing Data in SQL -- 11 Analytical Queries in SQL -- 12 Audit Analytics in SQL -- Comprehensive Case: Planning the Plant’s Hours for 2027 -- Data Visualization and Power BI -- 13 Power BI Essentials for Accounting Analytics -- 14 Data Models and DAX Measures -- 15 Reports for Management Decisions -- 16 Audit Monitoring and Report Assurance -- Comprehensive Case: Finding the Cash Behind the Profit -- Capstone Cases -- 17 Financial Statements for a Lender -- 18 Make, Buy, or Reprice -- 19 Auditing the Customer Credits Cycle -- Closing Thoughts -- Appendices -- A Quick Reference: Excel, SQL, and DAX -- B Publishing, Securing, and Sharing Reports -- C Power BI in the Browser -- D The Exercises and Professional Competencies 
520 0 |a This open educational resource textbook teaches accounting and business students to extract, prepare, analyze, and visualize financial and operational data using Microsoft Excel, SQL, and Microsoft Power BI, three tools widely adopted in professional practice. Every technique is taught through accounting questions, and every example draws on the data of a single company, so students see how analytics supports financial reporting, management decisions, and audit work.The book is designed for undergraduate and graduate accounting and business students with no prior analytics or programming experience. Applied exercises in the chapters of Parts I to IV look at each technique from the perspectives of financial accounting, managerial accounting, and auditing. Throughout the book, the Charles River Accounting Dataset provides a common setting for learning across all three tools. 
532 1 |a The textbook is available in online HTML, PDF, and EPUB formats to support different reading preferences and accessibility needs. The HTML edition provides a structured table of contents, chapter navigation, hierarchical headings, and descriptive text accompanying selected figures. The EPUB format offers an additional reading option for compatible ebook readers and assistive technologies. The textbook incorporates text-based explanations, tables, diagrams, and practical tutorials. Some instructional figures and software screenshots may require additional descriptions for readers using assistive technologies. A comprehensive accessibility audit of all publication formats has not yet been completed. In particular, PDF tagging, reading order, and the completeness of alternative text across all figures require further verification. Accessibility improvements will be incorporated into subsequent revisions. 
542 1 |f Attribution-ShareAlike 
546 |a In English. 
588 0 |a Description based on print resource 
650 0 |a Business  |v Textbooks 
650 0 |a Accounting  |v Textbooks 
650 0 |a Computer Science  |v Textbooks 
710 2 |a Open Textbook Library  |e distributor 
856 4 0 |u https://open.umn.edu/opentextbooks/textbooks/2139  |z Access online version