ACCT 311 Data Analysis for Accountants
Build practical accounting analytics skills through interactive Excel, Power Query, Power BI, Alteryx, statistics, modeling, and applied case work.
0. Setup
Course overview, syllabus expectations, and environment architecture.
1. Fundamentals
Foundational spreadsheet structuring, navigation, and core syntax.
Launch Module
2. Conditionals
Advanced Conditional Statements, IF logic, and error handling architecture.
Launch Module
3. Lookup Models
Advanced relational search utilizing XLOOKUP and INDEX-MATCH.
Launch Module
4. Pivot Aggregation
Summarizing and manipulating large complex data structures.
Launch Module
5.1 Statistics
Statistical concepts, regression analysis, and interpretation for accounting data.
Launch Module
5.2 Excel Practice with Statistical Functions
Practice statistical analysis in Excel using histograms, box plots, and linear regression.
Launch Module
5.3 Forecasting
Optimization modeling utilizing Solver and Scenario mapping techniques.
Launch Module
6. Power Query
Automated ETL pipelines, data cleaning, and systematic transformations.
7. Power BI
Interactive dashboard infrastructure, table relationships, and DAX coding.
8. Alteryx
Designing reliable, scalable workflow logic and process automation.
9. AI for Accounting Analysis
Use the RCCO prompting framework to structure AI-assisted analysis, evaluate AI decisions, and communicate useful outputs.
Launch ModuleConditional Lookup
Pivot Bulldog
Pivot Crypto
Stat Game
STAT LAB · Descriptive
MODEL LAB · Predictive
Macro Architecture
PQ Practice
IMDB Data Cleansing
Data Modeling
Channel Stuffing
Visualization UX
Cybersecurity Data
Study Guide & Tests
Choose a study guide to practice for your test.
Chicago Case Architecture
Deploy cumulative analytic frameworks to dissect, process, and map a comprehensive, real-world data infrastructure based on the Chicago model.
© 2026 ACCT 311 Data Analysis for Accountants · Gonzaga University.