Here the threads meet: the process thinking from consulting, and everything since in data and machine learning. Before I build an agent, I map the process it will work in and give it a job description first.
Read 1 post →Making data behave.
I'm Eric. I write field notes on Databricks, dbt and Power BI, and lately on putting AI agents to work. Each post is a problem I hit at a client, and the fix that held up.
Field notes. Nine years of them.
- 11 Apr 2026Stop. Understand Your Business Process Before You Build an AI AgentAI Agents
- 17 Aug 2024Ingesting and Flattening XML Files in DatabricksDatabricks
- 02 May 2024Flattening Nested JSON with BigQuery UDF and dbt Macrosdbt
- 06 Feb 2022Databricks Job Orchestration - Reuse Cluster and Multi-Process JobsDatabricks
- 27 Nov 2021ETL Becomes So Easy with Databricks and Delta LakeDatabricks
- 11 Aug 2021Visualize Complex Hierarchy and Slice with Any NodePower BI
- 19 Apr 2021Switch Measure with Different Format in VisualsPower BI
- 02 Dec 2019Dynamic Cohort Analysis in Power BIPower BI
- 21 Nov 2019Build a real-time Dashboard for Survey CollectionPower BI
- 07 Jun 2019How to Visualize FYTD YoY Precisely in Power KPI?Power BI
- 09 May 2019How to Keep Power BI Report Neat?Power BI
- 24 Apr 2019How to Create a Dynamic Rank in Matrix with Hierarchy?Power BI
- 07 Mar 2019How to Design a Pop-up Live Comments Window in Power BI Report by Integrating PowerApp?Power BI
- 06 Feb 2019Is Power BI a "Self Service" Tool?Power BI
- 11 Dec 2018Best Practice and Advanced Usage of Parameters in Power BIPower BI
- 28 Oct 2018How to Make Date Slicers for a Certain Days CyclePower BI
- 16 Sep 2018How to Make Peak Time Analysis based on Records with Start Time and End TimePower BI
- 28 Jul 2018How to Create Custom Function in Power BIPower BI
- 15 Jun 2018How to Write A Conditional Measure Linked with SlicerPower BI
- 13 May 2018How to Setup Your Own Theme of PowerBI ReportsPower BI
- 29 Apr 2018Investment Return Rate Calculation in Power BIPower BI
- 20 Apr 2018How to Calculate Percentage of Total in Matrix in Power BIPower BI
- 12 Nov 2017How to Pass Multiple-Values Parameters to SQL StatementSQL
- 10 Nov 2017How to Draw an Australia Map with Label in Power BIPower BI
Hi, I'm Eric. Named after a guitarist.
My Chinese name is 董经纬 (Dong Jingwei). I picked Eric because of Eric Clapton and Tears in Heaven, though we were born in very different times. My own guitar playing is still at the stage of picking it up, putting it down, and picking it up again.
I moved from mainland China to Brisbane in 2015. Since then I have built reports, pipelines and data models for teams who needed their numbers to add up. This site is where I write down what worked.
Off the clock: LEGO Technic builds and games.
Building Databricks and dbt pipelines for an airline's commercial team, and working out where AI agents genuinely help a data team and where they just add cost.