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...
Saved in:
| Main 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 |