The Data Analytics Modeling Certificate will expand your ability to work with structured and unstructured data to drive a successful analytics practice.

This certificate is Part 3 of the Data Analyst Certificates Bundle--a comprehensive five-part program that provides training and practical guidance on the topic of data analytics.

SYSTEM REQUIREMENTS

AICPA's online CPE courses will operate in a variety of configurations, but only the configuration described below is supported by our technicians.

A stable and continuous internet connection is required.

In order to record your completion of the online learning courses, please ensure you are connected to the internet at all times while taking the course. It is your responsibility to validate that CPE certificate(s) are available within your My Account after successfully completing the course and/or exam. Please contact us at 1.888.777.7077 or service@aicpa.org with any questions or concerns related to your CPE certificate(s).

• Supported Operating Systems: Macintosh OS X 10.10 to present, Windows 7 to present
• Supported Browsers: Apple Safari, Google Chrome, Microsoft Internet Explorer, Mozilla Firefox
• Required Browser Plug-ins: Adobe Flash, Adobe Acrobat Reader

Customer Note: Please Read the Following Before Opening the Package

By opening this package, you are agreeing to be bound by the following agreement.

This software product is protected by copyright and all rights are reserved by the author, John Wiley & Sons, Inc., or their licenses. You are licensed to use this software as described in the software. Copying the software for any other purpose may be a violation of U.S. Copyright Law.

This software products is sold as is without warranty of any kind, either express or implied, including but not limited to the implied warranty of merchantability and fitness for a particular purpose. Neither Wiley not its dealers or distributors assumes any liability for an alleged or actual damages arising from the use of or the inability to use this software. (Some states do not allow the exclusion of implied warranties, so the exclusion may not apply to you.)

PIN Activation Instructions

1. Pull tab above to reveal PIN code

2. Visit efficientlearning.com/pin/activate to activate PIN

3. Login or register

4. You will receive a Welcome Email and can login immediately with the credentials you created

For technical support, please visit efficientlearning.com/contact

The Data Analytics Modeling Certificate (14.0 CPE Credits) will expand your ability to work with structured and unstructured data to drive a successful analytics practice.

To start, you will learn to define clear business outcomes for your analytics practice to ensure your efforts align with your organization's strategic direction and create value. Next, you will learn data profiling and data cleansing techniques to maintain data quality throughout the data life cycle. You'll practice ETL (extract, transform, load) techniques and work with different data models and analytics tools. Finally, you will learn how to institute sophisticated tools for managing an ongoing enterprise data practice, including tools for data warehousing, managing the data life cycle, and working with structured and unstructured data.

This certificate is Part 3 of the Data Analyst Certificates Bundle - a comprehensive five-part program that provides training and practical guidance on the topic of data analytics.

Note: It is recommended that you complete the Application of Data Analysis Essentials Certificate, or ensure you have equivalent knowledge and skills, before starting this certificate course.

Learning Labs*

This is an interactive learning program that includes bonus hands-on learning labs that will expose you to the tools needed to implement an analytics practice in a practical way and equip you to deploy those tools as needed within your organization. You will practice using various technologies for preparing, analyzing and managing datasets in the real world.

*Time spent on learning labs does not award CPE and completing learning labs is not a requirement for earning the certificate.

WHO WILL BENEFIT

• Accounting and finance professionals, especially those interested in learning and applying data analysis techniques to help their organizations make informed, data-driven business decisions.

KEY TOPICS

• Defining value and tying analytics to value-driven business cases
• Understanding the characteristics of data and how they can be leveraged to gather insights from information
• Identifying project constructs for data analytics
• Identifying different types of data with which analysts will be expected to interact
• Profiling data for accurate analysis initiatives
• Understanding tool capabilities for working with data
• Cleansing data with appropriate tools to increases analytics accuracy
• Managing data quality and integrity
• Extracting, transforming, and loading data
• Implementing a data warehouse
• Managing the data life cycle
• Creating and using different types of data models
• Tools for working with both structured and unstructured data

LEARNING OBJECTIVES

• Identify opportunities, processes, and necessary data for solving analytical problems.
• Apply data profiling and data cleansing techniques to available data.
• Use data preparation and enrichment tools.
• Use ETL (extract, transform, load) tools.
• Compare data warehousing techniques.
• Use data warehousing and data management tools.
• Align the outcomes of your data analytics practice with your organization's strategic direction and create value.

Digital Badge: Your Professional Distinction

Set yourself apart as a future-ready financial professional. Upon completion, you will be awarded with a certificate in the form of a digital badge. Digital badges allow you to distinguish yourself in the marketplace and show your commitment to quality. The badge can be posted to your social media profiles and linked to your resume or email signature, providing maximum visibility to your achievement.

Credit Info

• CPE CREDITS: Online: 14.0 (CPE credit info)
• NASBA FIELD OF STUDY: Information Technology
• LEVEL: Intermediate
• PREREQUISITES: Recommended: Complete the Application of Data Analysis Essentials Certificate or ensure you have equivalent knowledge and skills.
• ADVANCE PREPARATION: None
• DELIVERY METHOD: QAS Self-Study
• COURSE ACRONYM: DALP-S3

Online Access Instructions

A personal pin code is enclosed in the physical packaging that may be activated online upon receipt. Once activated, you will gain immediate online access to the product for one full year.

System Requirements

AICPA's online CPE courses will operate in a variety of configurations, but only the configuration described below is supported by AICPA technicians.

A stable and continuous internet connection is required. In order to record your completion of the online learning courses, please ensure you are connected to the internet at all times while taking the course. It is your responsibility to validate that CPE certificate(s) are available within your account after successfully completing the course and/or exam.

Supported Operating Systems:

• Macintosh OS X 10.10 to present
• Windows 7 to present

Supported Browsers:

• Apple Safari
• Google Chrome
• Microsoft Internet Explorer
• Mozilla Firefox

Required Browser Plug-ins:

• Adobe Flash
• Adobe Acrobat Reader

Technical Support: Please contact service@aicpa.org.