Digital Learning Resources

Data Analysis Handbooks & Guides

In-depth digital handbooks authored for practitioners, analysts, and students. Explore free interactive chapters online or reference the full guides.

All companion code runs 100% in your browser memory with zero setup required.

HANDBOOK

140 Pages

Python for Tabular Data Analysis

From Raw Spreadsheets to Automated Insights with Pandas

A practitioner-oriented handbook covering Pandas Series, DataFrames, multi-metric GroupBy patterns, outlier imputation, and Matplotlib chart generation.

Core Curriculum Modules:

•1. Tabular Ingestion (CSV, XLSX, Parquet)
•2. High-Performance Boolean Indexing
•3. Split-Apply-Combine GroupBy Patterns
•4. Imputing Nulls & Deduplication Strategies
•5. Presentation-Ready Matplotlib Figures

Read Free Interactive Python Modules

HANDBOOK

120 Pages

SQL for Everyday Business Intelligence

Transforming Relational Tables into Actionable KPIs

Master practical analytical SQL. Learn how to write aggregations, window functions, conditional CASE bucketing, and CTEs over business datasets.

Core Curriculum Modules:

•1. Essential SELECT & Arithmetic Expressions
•2. Filtering & Logical Operators in Practice
•3. Aggregations, GROUP BY & HAVING Logic
•4. Segmenting Tiers with CASE WHEN
•5. Performance Optimization for Large Tables

Read Free Interactive SQL Modules

MIGRATION GUIDE

95 Pages

From Excel to Python: Migration Playbook

Translating VLOOKUP, PivotTables, and Formulas into Code

For Excel analysts ready to automate spreadsheets. Translates VLOOKUP to merges, Pivot Tables to GroupBy, and nested IFs to vectorized Python operations.

Core Curriculum Modules:

•1. The Spreadsheet Mental Model vs. Vectorized Arrays
•2. VLOOKUP & XLOOKUP to Pandas Merges
•3. PivotTables & Pivot Charts in Python
•4. Automating Repetitive Monthly Report Exports
•5. Handling 1M+ Row Scale Limits

Read Free Excel Cleaning Guide

DESIGN GUIDE

110 Pages

The Dashboard Design & Visual Storytelling Playbook

Cognitive Hierarchy, KPI Selection, and Layout Theory

Learn how to build executive dashboards that drive action. Covers cognitive load reduction, color psychology, and multi-metric visual layout grids.

Core Curriculum Modules:

•1. Visual Perception & Z-Pattern Scanning
•2. Choosing the Right Chart Archetype
•3. Executive vs. Operational KPI Hierarchy
•4. Color Palettes for High-Contrast Accessibility
•5. Designing for Mobile & PDF Export

Read Free Chart Selection Guide