Data Audit
Dashboard Filters Are Not Row-Level Access Controls
Dashboard filters change what a report displays, not who can access the source data. Use viewer-email filtering or separate per-rep files, then verify access as the recipient.
Data Analytics · Systems · AI Engineering
Decades of Experience. A Modern, Data-Driven Approach.
Leveraging a career that spans manufacturing, education, and urban mobility, I specialize in solving complex challenges. My focus is on using data to find clarity and drive measurable growth, regardless of the industry.
Grain First
Table & Metric Clarity
4 Pillars
Metrics · Data · Reporting · Ownership
AI + Ops
Production Systems & RAG
analytics-workbench — Live Preview
Interactive01 · Grain FirstVERIFIED
Define What One Row Represents Before Counting
Conflicting totals usually start when spreadsheets mix orders, line items, and payments in the same view. Declaring the table grain first restores trust in every downstream metric.
Grain: 1 row per completed_order_id (net of refunds, UTC close)
Case Studies & Production Systems
Systems built for operational clarity and measurable outcomes.
Selected case studies across business development automation, educational transformation, and AI-assisted career learning.
Next.js · Supabase · AI
CareerTalkLab
An existing English-learning LMS, with a wider data and software career-learning direction planned.
Read case study
Operations · EdTech
Digital Transformation in Crisis
Leading a language school's complete pivot to online learning during COVID-19.
Read case study
Python · AI Pipeline
BD Automation Suite
A modular Python pipeline that automates multi-stream business development, from prospect research to AI-drafted outreach.
Read case study
Operator & Builder Perspective
Real-world operations meet disciplined data and AI systems.
With a unique blend of hands-on manufacturing expertise, educational leadership, and data analytics skills, I bring a comprehensive perspective to every project. My approach combines decades of real-world experience with modern technological solutions to deliver tangible results.
About Me
Focus AreasSMB Analytics · Grain First · AI
MethodologyClear Definitions & Owned Action
Community LabCareerTalkLab (A1–C1 + Data)
Writing & Field Notes
Practical essays on small-business analytics, Grain First, and building CareerTalkLab.
Field notes on turning messy spreadsheets into reliable decisions, alongside essays on AI engineering and language pedagogy.
Business Intelligence
Why the Dashboard Total Differs from the Spreadsheet
When a Data Studio dashboard total differs from your Google Sheet after refreshing, check filter scope across every metric, replace AVG or SUM of row percentages with a guarded SUM/SUM calculated field, and match COUNT_DISTINCT(order_id) versus COUNT(line_id) grain.
Business Intelligence
Why Your Data Studio Report Shows Old Data
Check saved edits, the Google Sheets connector Optional Range, report date filters, and the 15-minute query cache in order, then compare the report total, row count, and latest date against a sheet check block.