AIA Certification Program

Scheduled Dates for Modules

Summer 2019

Application Deadline for Summer 2019 is May 24, 2018


Excel and modelling basics June 1, 2019

  • Gathering and Organizing Data
  • Lookups, Match, Index
  • Various Charts
  • Pivot Tables and Pivot Charts
  • Modelling Best Practices
Database Fundamentals June 8, 2019

  • Structure
  • Data
  • Tables
  • Relationships
  • Queries
  • Reports
  • SQL Language

Statistical Analysis June 15, 2019

  • Statistics Review
  • PowerPivot
  • Excel Solver
  • Regression Analysis
  • Data Analysis Tool Pack
  • Advanced Formulas
Financial Analysis June 22, 2019
  • Building a financial model
    • Evaluating net cash flows and components
    • Discounting cash flows by WACC
  • Evaluating Metrics

Business Analysis June 29, 2019

  • Cost Analysis
  • Marketing and Sales Analytics
  • Competitive Analysis
  • Process Automation
Operations,  Supply Chain & Logistics July 13, 2019

  • Modes of transportation
  • Trade flows
  • Tariffs
  • Terminals and Ports
  • Shipping
Process Economics  July 20, 2019
  • Estimating capital costs
  • Cash Costs
    • Margins
    • Cost curves



    Market Analysis and Forecasting – July 27, 2019

    • Market Analysis
      • Supply/Demand Fundamentals
        • Production
        • Domestic Demand
        • Trade Flows
        • Inventories
    • Forecasting

      • Ratios
      • Regression
      • Differentials
      • Cost plus Margin
      • Cost Curves
    Risk Analysis August 3, 2019
    • Identifying risk factors
    • Qualitative Risk Analysis
      • Probability
      • Impact
    • Quantitative Risk Analysis
    • Monte Carlo Analysis
    • Risk Management
      Advanced Statistical Analysis August 10, 2019

      • Multivariate Analysis
      • Macros

        Alternative Analytics (Alteryx) - August 17, 2019

        • Building a workflow
        • Expressions
        • Apps
        • Spatial Objects
        • Macros

        Data Visualization August 24, 2019

        • Uploading data to data visualization platform
        • Building connections within the platform
        • Setting up dashboards
        • Using data visualization to make decisions


        The instruction will be delivered via webinar on Saturday mornings beginning at 9 am. 

        Quick Links

        Program Details

        Register Now

        Information Flyer


        For questions regarding the program, email admin@aia-global.org.

        The Association of Industry Analytics is a 501(c)3 non-profit organization. 

        Powered by Wild Apricot Membership Software