Applying Data Analytics in Accounting

This course explores how modern technologies are transforming accounting practice. We begin with a survey of accounting fundamentals and emerging analytics topics, including process mining, text analysis, cloud computing, and cybersecurity. Next, we move into visualization, summarization, and filtering techniques for control testing and auditing, using tools like Python and Pandas to analyze and interpret accounting data. We then explore automation in accounting—from generating invoices programmatically to building dashboards from SQL databases—while introducing the spectrum of automation from basic scripts to intelligent agents. Finally, we focus on data governance, covering core principles, lifecycle management, and frameworks like COSO and COBIT, paired with hands-on exercises using SQL and Git to enforce data quality and maintain an audit trail.