AIA Certification Program

Scheduled Dates for Modules

Fall 2019 Program

We are now  accepting applications for the Fall 2019 Program!

00 - Excel and Modelling Basics - Sept 7
  • Modelling Best Practices
  • Complex Charts
  • Shortcuts
  • Formulas
  • Data Analysis ToolPak
  • Pivot Tables

01 - Database Fundamentals Sept 14

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

02 - Statistical Analysis Sept 21

  • Basic Stats
  • Probability
  • Bell Curves
  • Correlations and Regressions
  • ANOVA
  • Chi-Square
  • Sensitivity Analysis

    03 - Business Analysis Sept 28

    • Business Unit Analysis
    • Operations
    • Financial Ratios
    • Competitive Analysis
    • Cost Analysis

    04 - Financial Analysis Oct 5

    • Time Value of Money
    • Capital Budgeting
    • Project Analysis
    • Evaluating Metrics

      05 - Supply Chain & Logistics Oct 12

      • Operations
      • Chain Margins
      • Logistics
      • Tariffs
      • Transportation
      • Terminals and Ports

        06 - Process Economics  Oct 19

        • Estimating capital costs
        • Production/Cash Costs
        • Process Unit Analysis
        • Cost curves



            07 - Market Analysis and Forecasting – Oct 26

            • Economics
            • Supply/Demand Balances
            • Forecasting Methods
              08 - Risk Analysis Nov 2
              • Risk Framework
              • Risk Management
              • Risk Measurement
                  09 - Advanced Statistical Analysis Nov 9

                  • Multivariate Analysis
                  • Bayesian Statistics
                  • Python

                    10 - Advanced Excel - Nov 16

                    • Power Query
                    • Power Pivot
                    • VBA

                    11 - Big Data Prep and Cleanse (Alteryx) - Nov 23

                    • Structure
                    • Workflows
                      • Import, join, filter, sort, transform, predict, and visualize

                    12 - Data Visualization Dec 7

                    • Source Data
                    • Charts – Construction, formats, manipulation, and interactivity
                    • Tables and Heat maps
                    • Statistical Analysis and Forecasting
                    • Aggregations and Calculations
                    • Maps and Geospatial Analysis
                    • Interactive dashboards



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

                      Quick Links

                      Program Details

                      Register Now


                      Download the Fall 2019 Schedule


                      Program Managers

                      Ben Gonzalez          Arshad Parvez

                      Ben Gonzalez, MBA             Arshad Parvez, MBA, CFA


                      Ben and Arshad each have over 11 years of experience analyzing various commodity markets and serving as industry analysts and energy economists for the oil and gas sector.


                      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