Using Data Analytics to Evaluate Policy Implications of Migration Patterns: Application for Analytics, AIS, and Tax Classes

Abstract

ABSTRACT This case uses IRS SOI migration data to help students understand the power of data analysis to identify potential policy issues faced by state governments. The data skills covered in this case are used by entry level accounting professionals in all fields: the Extract, Transform, and Load (ETL) process using Alteryx and creating data visualizations using Tableau. The case learning objectives are: (1) develop students' ETL skills; (2) develop students' data visualization skills; (3) develop students' critical-thinking skills, and (4) enhance students' effective oral and written communications skills. Pre- and post-learning assessment surveys and open-ended responses indicate that the case meets these learning objectives. Students easily related to policy questions surrounding migration as future employees considering their career options. As such, this case is appropriate for stand-alone data analytics courses in business or accounting, accounting information systems courses, undergraduate- and graduate-level tax classes, and M.B.A. courses.