Accounting Data Analytics with Python

This course is focused on learning Python skills to build business data. This course will cover the same material as Introduction to Accounting Data Analytics and Visualization but in a more general programming environment (Jupyter Notebook to Python) than Excel and the Visual Basic Editor. These concepts will be taught in the context of one or several accounting data domains (e.g. financial statement data from EDGAR and stock data, loan data, and point-of-sale information).

The course's first half continues from Introduction to Accounting Data Analytics & Visualization. It focuses on using an integrated development environment to automate data analysis tasks. We will discuss how to share code within Jupyter Notebook. This is a popular environment for data analysis software such as Python and R. Finally, we will review fundamental programming skills like loops, conditional statements, mathematical operators and functions using Python software. The second part of the course is about assembling data for machine-learning purposes. Students are introduced to Pandas dataframes, and Numpy for manipulating and structuring data. The data is then analyzed using linear regression and visualizations. We then explain how Python can interact with SQL data.