Data Analytics in Accounting and Finance (4 Credits)

Learning Outcomes:

Define data analytics in business and accounting;
Identify data used in the data analytics process;
Explain the test plan and analyze the result;
Demonstrate the result and illustrate data visualization;
Perform financial statements and tax analytics.

Topics:

• Data Analytics for Accounting
• Data Analytics Using IMPACT Cycle
• Data Used and Stored
• Tutorial 1 – Extract, Transform, and Load (ETL) the Data
• Performing The Test Plan
• Standardizing Data for Comparison (Z-Score)
• Modern Data Environment
• Automating Data Analytics
• Audit Data Analytics
• Tutorial 2 – Advanced Predictive and Prescriptive Analytics in Auditing
• Tax Analysis
• Tutorial 3 – Financial Statement Analysis
• Financial Statement Analytics