Data Analytics Modeling Certificate - NY - Live Event
Oct. 31–Nov. 1, 2019
Micro Tek, New York, NY
| Live online
Conference details

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.

The Data Analytics Modeling Certificate 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.

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.

Digital Badge: On completion of this certificate you will receive a digital badge to share with your online professional network, which is available as a downloadable PDF certificate suitable for printing and framing.

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.

Free Self-Study Course
A benefit of this live event purchase is access to the self-study material of the Data Analytics Modeling Certificate at no additional cost. If you decide to cancel the live event, access to the self-study material will be removed from your AICPA Store account and your refund will be prorated for any portion of self-study material completed prior to your cancellation. You can access the self-study material and learning labs by logging in to your AICPA Store account and going to My Purchases > My Online Learning.

Attendance options
Data Analytics Modeling Certificate - NY - Live Event
Oct 31-Nov 01, 2019
Step away from your desk, and join us in New York, NY. You’ll interact directly with thought leaders and have the advantage of dedicated networking time with your professional community. (16 CPE credits).
Early Bird rate ends 09/16
AICPA member: $1,295.00
Nonmember: $1,695.00

Day 1
8:30 AM - 9:00 AM

Registration & Breakfast

9:00 AM - 10:30 AM

Module 1: Understanding your Business

10:20 AM - 10:30 AM

Break (10 min)

10:30 AM - 12:00 PM

Module 2: Data Profiling
Lab 1: Data Profiling with Excel *

12:00 PM - 12:15 PM

Lab 2: Data Profiling with Talend Data Preparation 

12:15 PM - 1:00 PM

Lunch (45 min)

1:00 PM - 2:00 PM

Module 3: Data Cleansing 

2:00 PM - 2:15 PM

Lab 3: Data Cleansing with Talend Data Preparation 

2:15 PM - 3:15 PM

Module 4: Data Quality and MDM 

3:15 PM - 3:45PM

Lab 4: Master Data Management Process Using Talend

3:45 PM - 4:00 PM

Break (15 min)

4:00 PM - 5:30 PM

Module 5: ETL Tools
Lab 5: ETL with Talend Open Studio *
Lab 6: Multistage ETL With Talend *

Day 2
8:30 AM - 9:00 AM

Registration & Breakfast

9:00 AM - 10:00 AM

Module 6: Data Warehousing
Lab 7: Data Mart with Talend *
Lab 8: OLAP with Talend *

10:00 AM - 11:00 AM

Module 7: Data Warehousing Tools

11:00 AM - 11:15 AM

Break (10 min)

11:15 AM - 12:15 PM

Module 8: Understanding Data - Overview 

12:15 PM - 1:00 PM

Lunch (45 min)

1:00 PM - 2:00 PM

Module 9: Understanding Data — Data Modeling  

2:00 PM - 3:20 PM

Module 10: Understanding Data — Structured Data Tools
Lab 9: SQL DDL and DML with SQL Server Management Studio *
Lab 10: Proprietary TSQL with SQL Server Management Studio *

3:20 PM - 3:30 PM

Break (10 min)

3:30 PM - 5:00 PM

Module 11: Understanding Data — Unstructured Data Tools
Lab 11: Querying Star Schemas with SQL Server Management Studio *

* Only certain labs are factored into the length of the course and all other labs should be completed by attendees outside of the training as homework UNLESS you choose to weave the extra labs into the training day. Alternatively, you may simply walk through the lab exercise, using the solution provided in the lab environment, in order to demonstrate application of the material.

More details

Does your organization qualify for group registration?

If 10 or more individuals register for a single conference (or fewer people attend multiple conferences to total 10 or more registrations), you qualify for our group conference program. Benefits include:

  • Significant savings
  • Invoicing before or after event
  • Guidance through the registration process

Please reach out to the person in your firm that coordinates conference registrations to ensure you qualify for the best group discount. If you don’t have a firm contact or don’t know who that is, you can get more information or register your group by contacting conference group sales at: groupconference@aicpa-cima.com.

If you would like to register 2-9 individuals for a conference or to learn more about group registrations, please contact the AICPA customer service team at 888.777.7077 or conference group sales at groupconference@aicpa-cima.com.

On-Site/Flex Pass Conference: You may cancel without penalty if cancellation request is received up to and including 45 days prior to the start of the conference. Due to financial obligations incurred by the AICPA, a credit less 50% of the registration fee will be issued for requests received up to and including 21 days prior to the start of the conference. No refunds or credits will be issued on cancellation requests received less than 21 days prior to the start of the event.

For more information about AICPA's conference cancellation policy, contact the AICPA Service Center at 1-888-777-7077 or service@aicpa.org.

Resolution of Disputes

Transactions at this site are covered by binding arbitration. Any controversy or claim arising out of or relating to the use of this Web site that cannot be settled to your satisfaction by our member satisfaction team shall be settled by arbitration in New York, New York. Such disputes will be administered by the American Arbitration Association (https://www.adr.org/), 335 Madison Avenue, 10th floor, New York, New York 10017-4605, (800) 778-7879, in accordance with its Arbitration Rules, and judgment upon the award rendered by the arbitrator(s) may be entered in any court having jurisdiction thereof.

Should you feel that there has been a breach to the integrity or security of this site, please contact the service center immediately at 888.777.7077.

Ratings and reviews
Early bird saving through 09/16
Data Analytics Modeling Certificate - NY - Live Event (In person)
CPE credits
: 16.0
NASBA Field of Study
Information Technology
Recommended: Complete the Application of Data Analysis Essentials Certificate or ensure you have equivalent knowledge and skills.
Delivery Method
Group Live
Course acronym

Location & Accommodations


180 Maiden Lane Suite 1102
New York, NY 10038

Suggested Hotels

320 Pearl Street
New York, NY 10038

Hotel phone:

Room rate:

MicroTek Rate code: 560005254

52 William Street
New York, NY 10005

Hotel phone:

Room rate:

ask for Microtek Rate

161 Front Street
New York, NY 10038

Hotel phone:

Room rate:

Dress code:

Back to Top