Performing and Interpreting Data Analytics
This course will be an overview of: How to perform descriptive, predictive, and prescriptive analyses using tools available in Microsoft Excel. WE RECOMMEND USING GOOGLE CHROME.
...
Course Provided by: Becker Professional Education
IMA Competency: Data Analytics, Data Visualization, Information Systems
Advanced Preparation Required: None
Course Level: Intermediate
Course Prerequisites: Foundations of data and analytics for the accounting profession
Instructor bio
Dr. Ann C. Dzuranin is the KPMG Endowed Professor of Accountancy at Northern Illinois University. She earned her B.S. from Fairleigh Dickinson University, her MBA from New York University and her Ph.D.from the University of South Florida. Ann is a CPA (NJ) with 15 years of experience in both public and corporate accounting.
Ann conducts behavioral research in management accounting decision-making and the ways in which accounting information systems interact with those decisions. Her publications include Issues in Accounting Education, Journal of Information Systems, Journal of Business Ethics, Management Accounting Quarterly, Journal of Corporate Accounting and Finance and the Journal of Accounting Education.
Ann also received the 2018 American Accounting Association’s Innovation in Accounting Education Award for her work in data analytics curriculum development. Ann’s work in data analytics has resulted in invitations to present on Data Analytics and Accounting curriculum at both academic and professional conferences. Her presentations have reached over 1,800 people and her materials have been shared with more than 50 universities.
3 Credits
Blended Learning
Enquire Now
Course Provided by: Becker Professional Education
IMA Competency: Data Analytics, Data Visualization, Information Systems
Advanced Preparation Required: None
Course Level: Intermediate
Course Prerequisites: Foundations of data and analytics for the accounting profession
Instructor bio
Dr. Ann C. Dzuranin is the KPMG Endowed Professor of Accountancy at Northern Illinois University. She earned her B.S. from Fairleigh Dickinson University, her MBA from New York University and her Ph.D.from the University of South Florida. Ann is a CPA (NJ) with 15 years of experience in both public and corporate accounting.
Ann conducts behavioral research in management accounting decision-making and the ways in which accounting information systems interact with those decisions. Her publications include Issues in Accounting Education, Journal of Information Systems, Journal of Business Ethics, Management Accounting Quarterly, Journal of Corporate Accounting and Finance and the Journal of Accounting Education.
Ann also received the 2018 American Accounting Association’s Innovation in Accounting Education Award for her work in data analytics curriculum development. Ann’s work in data analytics has resulted in invitations to present on Data Analytics and Accounting curriculum at both academic and professional conferences. Her presentations have reached over 1,800 people and her materials have been shared with more than 50 universities.
This course will be an overview of:
- How to perform descriptive, predictive, and prescriptive analyses using tools available in Microsoft Excel
- How to interpret the results of descriptive, predictive and prescriptive analyses
- How to identify potential outliers and their potential effect on the analysis results
- How to test and interpret model assumptions.
- How to perform and interpret correlation
- How to interpret correlation
This course is ideal for anyone who is interested to learn data analysis tools using Microsoft Excel.
After completing this course, the learner should be able to:
- Identify common data analysis tools in Microsoft Excel
- Prepare and interpret descriptive analytics
- Prepare and interpret diagnostic analytics
- Prepare and interpret predictive analytics
- Prepare and interpret prescriptive analytics
- Prepare and interpret correlation
- Identify issues related to outliers and model assumptions
YOUR IT LECTURERS
-
Timothy F. Gearty
Faculty for Becker Programme: Technology: Artificial intelligence, blockchain, cybercrime
SHOW DETAILS -
-
Timothy F. Gearty
Faculty for Becker Programme: Technology: Artificial intelligence, blockchain, cybercrime
ACADEMIC FOCUS
Tim is a partner in Gearty & McIntyre, LLP, CPA, a firm which has developed a reputation as a specialist in business advisory services, litigation support and forensic accounting.
EXPERIENCE
Tim Gearty is the National Director and Editor-in-Chief for the world’s largest CPA training program, Becker CPA Review. In addition to his editorial leadership, Tim is also Becker's National Lead Instructor, whose taped lectures are seen in over 325 loca
Dr. Preethi Kesavan
IT
ACADEMIC FOCUS
Dr. Preethi Kesavan has attained her PhD from the University of Canberra.
EXPERIENCE
Preethi has extensive teaching and learning, school administration and executive oversight of strengthening a high-quality student experience, enriching global mobility, enhancing academic quality and professional staff effectiveness. She is a contemporar
Ann Dzuranin
Faculty for Becker Programme: Performing and interpreting data analytics
ACADEMIC FOCUS
Dr. Ann C. Dzuranin is the KPMG Endowed Professor of Accountancy at Northern Illinois University. She earned her B.S. from Fairleigh Dickinson University, her MBA from New York University and her Ph.D.from the University of South Florida.
EXPERIENCE
Ann is a CPA (NJ) with 15 years of experience in both public and corporate accounting.
