Course Introduction to Data
Explore learning materials, applied case studies, and hands-on labs designed to build robust data analysis, modeling, and automation skills.
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 Analytics
Linear Regression modeling and Data Analysis Toolpak execution.
Launch Module
5.2 Statistics
Generating precise descriptive statistics and variance overviews.
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.
Fundamentals & Lookups
Conditionals and exact matching.
LockedPivot Table Logic
Complex aggregation mapping.
LockedDescriptive & Regression
Housing Data architectural analysis.
LockedSolver Optimization
Scenario modeling frameworks.
LockedData Relational Models
Database structure architecture.
LockedAlteryx Foundations
Initial process automation mapping.
LockedAlteryx Cleansing
Data sanitization workflows.
LockedAlteryx Joins
Combining large dataset networks.
LockedAssessment Guide II
Advanced review framework covering Predictive Analytics, Solvers, and complex scenario forecasting models.
Chicago Case Architecture
Deploy cumulative analytic frameworks to dissect, process, and map a comprehensive, real-world data infrastructure based on the Chicago model.
© 2026 ACCT311 Data Architecture. Gonzaga University.