Build it. Ship it. Get hired.
Real projects on the cloud stack behind the 62% AI wage premium.
Three ways to move up
Analytics Engineering with dbt
Own the models, tests, and documentation your whole team depends on.
View projectApplied AI and Automation
Build a RAG pipeline that writes and delivers stakeholder reports automatically.
View projectAI Agents and Presentation Toolkit
The exact AI agents and slide decks a Director of Data and AI uses daily.
View stackAnalytics Engineering with dbt
The role that replaced “senior analyst.” Here is what it takes.
Data modelling
Star schemas, dimensions
Testing
Catch bad data first
Documentation
Every column defined
Version control
Git workflows on SQL
CI/CD
Nothing merges untested
Incremental loads
Millions of rows, minutes
Change tracking
Full history, nothing lost
Orchestration
Runs without you
Applied AI and Automation
Not prompts. A production pipeline that delivers real reports.
Sales Data Pull
13 weeks from BigQuery. Revenue, margin, volume.
Audience Context Retrieval
RAG matches each recipient’s preferences.
AI Commentary Generation
What happened, why, what to do next.
Report Builder
Fully formatted report with tables, charts and week-over-week highlights.
Secure Cloud Upload
Archives by recipient and date.
Automated Delivery
Emailed to the right inbox, tailored per person.
Learns and Repeats Weekly
Spots trends. Runs again automatically.
AI Agents and Presentation Toolkit
The tools I use daily. Clone them into your workflow.
Code review agent
Reviews dbt PRs for anti-patterns and missing tests
Test generator
Reads a model, writes the .yml tests
SQL migrator
Legacy query to staged dbt models
Documentation agent
Generates descriptions from SQL logic
SQL optimizer
Rewrites slow queries, fewer scans
Stakeholder Q&A bot
Answers data questions from Slack
Meeting prep agent
Pulls numbers before recurring meetings
The Consultant’s Playbook
100-slide deck on executive presentation
Data presentation in Excel
How to format and present data that lands
Video walkthroughs
Watch each deck being built and delivered
One upgrade a week.
What to build, what to say in the room, what the market wants.
Free. Weekly. No spam.
