Log in

AIA Certification Program

Scheduled Dates for Modules

Spring 2020 Program

Analytics, Systems, Mining & Warehouses - Jan 18

  • Introduction to Data Analytics
  • Data Systems
  • Data Mining
  • Data Warehousing

Advanced Excel and Modelling Basics Jan 25

  • Formulas
  • Non-traditional Charts
  • Pivot Tables, Pivot Charts
  • Modelling Best Practices

Database Fundamentals Feb 1

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

    Statistical Analysis Feb 8

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

    *Data Visualization Workshop (Tableau)Feb 15

    • Import Data
    • Charts
    • Tables and Heat Maps
    • Statistical Analysis and Forecasting
    • Aggregations and Calculations
    • Maps
    • Dashboards

      Process Economics and Cost Modelling Feb 22

      • Capital Costs
      • Cash Costs
      • Processes
      • Cost Curves
      • Other Cost Models

        Market Analysis Feb 29

        • Supply/Demand Fundamentals
        • Supply Chain Analysis
        • Forecasting

        Project Analysis – Mar 21

        • Financial Analysis
        • Capital Budgeting
        • Risk Analysis
          Intro to Python Workshop Mar 28
              Machine Learning and Predictive Analytics Rescheduled

                Data Visualization Workshop (Power BI)- Apr 11

                Data Prep,  Cleansing, and Automation - Apr 18

                • Macros
                • Power Query
                • Alteryx

                Advanced Statistical Analysis Apr 25

                • Multivariate Analysis
                • Bayesian Statistics

                Machine Learning and Predictive Analytics  May 2

                ***Final Project Due May 9

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

                  Quick Links

                  Program Details

                  Register Now

                  Program Managers

                  Ben Gonzalez          Arshad Parvez

                  Ben Gonzalez, MBA             Arshad Parvez, MBA, CFA

                  Ben and Arshad each have over 12 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.

                  Follow Us

                  About us

                  AIA Global is dedicated to building a community of professionals, engaged in analytics in various industries globally.

                  Become a member

                  Join a group of leaders, experts, analysts, and economists making a difference in industry analytics.

                  Contact us

                  Powered by Wild Apricot Membership Software