Data Analytics Training Program

The School of Accountancy, in collaboration with the UH Manoa Department of Information Technology Management, offers its Data Analytics Training Program in February and March 2018. The four-day training is open to both professionals and students.

American Accounting Association, American Institute of Certified Public Accountants (AICPA), and the Big Four accounting firms have all emphasized the importance of utilizing data analytics and have provided input and guidance regarding Shidler's data analytics programs.

Shidler students who take the class for credit (BUS 699 for graduate students and ACC 399 for undergraduate students), must pay the relevant university tuition and fees and are not required to pay the registration fee. To receive credit, students are required to attend all sessions and must obtain a score of at least 75% in the test conducted at the end of the class. Students who fail the test or do not attend all sessions, will be assigned "no credit" grade.

Data Analytics Session

February 24 – 25 and March 3 - 4, 2018
1:00 – 4:30 p.m.
Instructor: Dr. Roger Debreceny

Participants will gain an overview of data analytics techniques and an introduction to data visualization. This is a “hands on” class which will incorporate examples drawn from Data Science. Fifteen-hour program.

Required Course Materials

  • Data Smart: Using Data Science to Transform Information into Insight by John W. Foreman published by Wiley in 2013
  • Participants must bring their own laptops

This course is entirely based on MS Excel. Previous experience working with MS Excel is required. Suggested tutorials include: Videos by Snarr Institute (Chapters 1 – 3, 14). A Certificate of Completion (for those who will attend all sessions) and Continuing Professional Education (CPEs) will be issued to participants.  

Detailed Schedule

Session Time (minutes) Content
30 An Overview of Data Analytics in Accounting and Auditing
  20 A Refresher on Data Types
  70 Exploring your Data Visually

Exploring your Data Statistically

  40 Cluster Analysis I
40 Cluster Analysis I Cont.
  70 Bayes Law
  80 Optimization
80 Cluster Analysis II: Network Graphs
  70 Regression Analysis
  40 Ensemble Modeling
50 Ensemble Modeling Cont.
  120 Revisiting Visualization
  20 Wrap up

About the Instructors

Dr. Roger Debreceny
PhD, FCPA, CGEIT | Shidler College of Business

Roger Debreceny is a Shidler College Distinguished Professor of Accounting. Dr Debreceny has many years of experience teaching auditing, accounting information systems and data analytics. He has published academic papers and teaching cases on data mining, email mining and data analytics.


Past Data Analytics Sessions

Business Intelligent & Visual Analytics
Instructor: Dr. Kaven Abhari
Part 1: Tableau, September 17 – 18, 1:00 – 5:00 p.m.
Part 2: Power BI, September 24 – 25, 1:00 – 5:00 p.m.
Read news story >>