X
Excel Zero to Hero Interactive Learning Platform
0%
Mental Models & Frameworks

25 Atomic Analytics Concepts

Focused, deeply-explained concept notes answering the core structural questions of data architecture, formulas, and business intelligence.

Concept intermediate

AI for Data Analysts: Master Map of Content (MOC)

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Advanced VBA for Dashboards

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Common Table Expressions (CTEs)

Explore mental model, trade-offs, and analytics applications.
dax advanced

Concept: Calculated Columns vs DAX Measures

Explore mental model, trade-offs, and analytics applications.
visualization intermediate

Concept: Chart Selection Matrix

Explore mental model, trade-offs, and analytics applications.
visualization beginner

Concept: Conditional Formatting

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Dashboard Design & Analytics Engineering MOC

Explore mental model, trade-offs, and analytics applications.
visualization intermediate

Concept: Dashboard Design Principles

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Dashboard UI UX Principles

Explore mental model, trade-offs, and analytics applications.
dax advanced

Concept: Data Analysis Expressions (DAX)

Explore mental model, trade-offs, and analytics applications.
methodology beginner

Concept: Data Analysis Life Cycle

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Concept: Data Cleaning (Data Cleansing)

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Database Grain & Dimensional Modeling

Explore mental model, trade-offs, and analytics applications.
data-modeling advanced

Concept: Dimensional Modeling

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Dynamic Excel Techniques

Explore mental model, trade-offs, and analytics applications.
data-engineering intermediate

Concept: The ETL Process (Extract, Transform, Load)

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Excel Dashboard Architecture

Explore mental model, trade-offs, and analytics applications.
Data Management & Architecture beginner

Excel File Formats: XLSX, XLSM, XLSB & CSV

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Excel Performance Optimization

Explore mental model, trade-offs, and analytics applications.
structure beginner

Concept: Excel Tables (ListObjects)

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Excel Visualization Principles

Explore mental model, trade-offs, and analytics applications.
data-modeling advanced

Concept: Fact vs Dimension Tables

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Human Skill vs AI Assistance

Explore mental model, trade-offs, and analytics applications.
lookup intermediate

Concept: INDEX & MATCH

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Interactive Excel Dashboards

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

KPI Design & Metric Governance

Explore mental model, trade-offs, and analytics applications.
etl advanced

Concept: M Language (Power Query Formula Language)

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Many-to-Many Relationships & Bridge Tables

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

OLTP vs OLAP Architecture

Explore mental model, trade-offs, and analytics applications.
summarization intermediate

Concept: Pivot Tables

Explore mental model, trade-offs, and analytics applications.
etl advanced

Concept: Power Query & Automated ETL

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Primary and Foreign Keys

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Production Analytics Pipeline

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Power Query SQL Query Folding

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Relational Database Concepts

Explore mental model, trade-offs, and analytics applications.
formulas beginner

Concept: Relative vs Absolute References

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

Resource to Skill Map

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

SQL Database Ingestion MOC

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

SQL Joins: Mechanics & Best Practices

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

SQL Project Skill Matrix

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

SQL Server Architecture

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

SQL Views in Analytics Engineering

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

SQL to Excel Ingestion Architectures

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

SQL vs Power Query: Responsibility Matrix

Explore mental model, trade-offs, and analytics applications.
data-engineering intermediate

Concept: The Six Dimensions of Data Quality

Explore mental model, trade-offs, and analytics applications.
visualization intermediate

Concept: Slicers & Timelines

Explore mental model, trade-offs, and analytics applications.
data-modeling advanced

Concept: Star Schema vs Snowflake Schema

Explore mental model, trade-offs, and analytics applications.
formulas intermediate

Concept: Structured References

Explore mental model, trade-offs, and analytics applications.
lookup intermediate

Concept: VLOOKUP vs XLOOKUP

Explore mental model, trade-offs, and analytics applications.
architecture intermediate

Why Not Always Formulas? (Enterprise Analytics Boundaries)

Explore mental model, trade-offs, and analytics applications.
Concept intermediate

SQL Window Functions

Explore mental model, trade-offs, and analytics applications.