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!
Table of Contents:
  • 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