Data Audit
Why Merging Tables Inflates Your Sales Total
Repeated lookup keys can multiply orders and overstate sales. Test key uniqueness, choose a business-rule filter or aggregation, then reconcile totals and each order.
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.
Data Audit
Append vs Merge: How Should You Combine Tables?
Append stacks the same kind of row; merge adds details through a key. Choose the right method and check rows, columns, numeric sales counts and totals afterward.
Data Audit
Combine Monthly CSV Files with Power Query
Combine monthly CSV exports with Power Query, preserve leading-zero codes, and check each file’s row count and sales total after every refresh.