AIA Workshops - request a workshop using the form below
Charts and Data Visualization Tools
Advanced Functions, Features, and Charting
12
- Formatting Data
- Conditional Formatting
- Conditional Statements
- Match/Index/Lookup Formulas
- Advanced Charts
- Goal Seek, Solver, and Data Analysis Toolpak
- Pivot Tables/Pivot Charts/Dashboards
Tableau Fundamentals
15
- Tableau Terminology
- Importing and combining data
- Filtering and sorting
- Building visuals (charts and tables)
- Dashboards
- Best practices
Power BI Fundamentals
22
- Basic visualization and interactive reports
- Importing and combining data
- Power Query (Data Transformation)
- Data Modeling
- Basic calculations
- Dashboards/Reports
- Best practices
Applications of Analytics
Tableau Analytics
12
- Review of Tableau Fundamentals
- Time Series Forecasts
- Reference Lines
- Distribution bands
- Scatter Plots
- Box Plots and Histograms
- Calculations
- Dynamic Dashboards
Intro to Predictive Analytics
15
- Python Basics
- Exploring Data
- Correlation Matrix
- Training Model
- Testing Model
- Evaluating Results
Industry Modeling and Forecasting
22
- Demand forecasting
- Supply/demand balances
- Process economics and cost models
- Cost curves
- Supply chain
- Seasonality
- Technical Analysis
Pulling, Prepping and Storing Data
Database Fundamentals and SQL Statements
12
- Database Terms and Concepts
- SQL Introduction
- Retrieving Data
- Sorting and Filtering
- Summarizing and Grouping
- Calculations
- Joining Tables
Alteryx Core and Predictive Analytics
15
- Alteryx Layout
- Alteryx Core Tools
- Workflows
- Linear Regression
- Logistic Regression
Pulling FRED and EIA Data with APIs
22
- API concepts
- Python Basics
- Python FRED code
- Practice using FRED data
- Python EIA code
- Practice using EIA data
Add a footnote if this applies to your business