# Jonathan Dufault > it's usually a data problem ## Posts - [Limiting the worst-case bill from a Fabric F2 capacity](https://mediumslateblue-hippopotamus-675104.hostingersite.com/limiting-the-worst-case-bill-from-a-fabric-f2-capacity/): I passed DP-600. Below is a setup I had for making a Fabric F2 Capacity for personal testing with a limited blast radius. Headers so you can skip sections that aren’t relevant. Background A lot of companies only use part of Fabric, so getting experience with the whole ecosystem can be tough. I’m more familiar […] - [Tell It Who You Are](https://mediumslateblue-hippopotamus-675104.hostingersite.com/tell-it-who-you-are/): This is a post about food. I arrived in France two months ago. My husband had his usual grocery routine. People vary in their tastes but core products remain the same. It’s how we choose who we are. In Tennessee I bought California olive oil and Huy Fong sriracha as a way to keep a […] - [We Were Developing Great Data Engineers](https://mediumslateblue-hippopotamus-675104.hostingersite.com/we-were-developing-great-data-engineers/): A supply chain analytics team designed around credibility, a bridge between operations, technology and data science, and the day it turned out we were training data engineers. - [How do you count a million milk crates?](https://mediumslateblue-hippopotamus-675104.hostingersite.com/how-do-you-count-a-million-milk-crates/): We were losing hundreds of thousands of milk crates a year. At $4 a piece, it was half a million dollars. Conventional wisdom was that the majority of the loss was stores using them for storage, or people taking them home for furniture or their garage, but the volume we were seeing had nothing to […] - [In-Spec Isn't Good Enough](https://mediumslateblue-hippopotamus-675104.hostingersite.com/when-in-spec-isnt-good-enough/): Note: the numbers have been changed for privacy. Every quality check was passing. Customers were calling in about a chemical taste in the water anyway. Both of those things were true at the same time. I was a continuous improvement leader at a manufacturing plant that produced spring water and drinking water alongside dairy products. […] - [Making Tempeh: An Unreasonably Thorough Approach](https://mediumslateblue-hippopotamus-675104.hostingersite.com/making-tempeh-an-unreasonably-thorough-approach/): Challenging Tempeh making community advice with an Arduino and a sewing machine. - [Strategy is a Story](https://mediumslateblue-hippopotamus-675104.hostingersite.com/strategy-is-a-story/): In 2016, during my MBA at Cal State Long Beach, I competed in a semester-long business simulation competition. Five teams running fictional companies, making quarterly decisions on pricing, production, marketing, and R&D. I was the CIO for ours. When I downloaded the year 3 quarter 4 reports, I found the first of two questions that […] - [The Price of a Hidden Column](https://mediumslateblue-hippopotamus-675104.hostingersite.com/the-price-of-a-hidden-column/): In March I spent a weekend running test queries through Power BI Copilot on a Fabric F2 capacity, reviewing the diagnostic JSON to understand how to improve my reports. One of those diagnostics is the reason for this post. When I asked a question about product growth trends, the answer had taken 107 seconds to […] - [Is It Okay?](https://mediumslateblue-hippopotamus-675104.hostingersite.com/is-it-okay/): I built an MCP (Model Context Protocol) that gives an LLM five tools for working with a data lake: list tables, describe schema, sample data, row count, run query. I use it every day. Different data sets, different questions. It supports different workflows. You can paste a screenshot, tell the agent “replicate this data and […] - [How to Keep Power BI Copilot in Its Fast Lane](https://mediumslateblue-hippopotamus-675104.hostingersite.com/how-to-keep-power-bi-copilot-in-its-fast-lane/): This is a companion piece to Looking under the hood for Power BI Copilot. In the main post I traced the full pipeline from question to answer, but one of the more practical findings was about the two paths Copilot can take to resolve a data question. One is fast and reliable. The other is […] - [Fabric Costing](https://mediumslateblue-hippopotamus-675104.hostingersite.com/fabric-costing/): The Bill Power BI is part of the Fabric ecosystem. Fabric is an end-to-end data platform, including ingestion, warehousing, outflows, and dashboarding, including Copilot for Power BI. The costing for Fabric involves you purchasing capacity units (CU), from F2 for 2, to F2048. Capacity units are measured in seconds. If you have 2 capacity units […] - [The Telephone Game](https://mediumslateblue-hippopotamus-675104.hostingersite.com/the-telephone-game/): I spent last weekend testing out Copilot for Power BI. I’ve been using it extensively as a developer, trying to make something that’s useful for people. I’ve been growing more skeptical of all my technical skills. I went into the Azure calculator, pulled up the resource usage, all told would be no more than $5.00. […] - [Hands-Free French Dictionary](https://mediumslateblue-hippopotamus-675104.hostingersite.com/i-built-a-hands-free-french-dictionary-so-i-could-stop-putting-my-book-down/): I have my concerns about AI coding. There’s an aphorism, the confidence about replacing a job with automation is highest when you are least familiar with it. For AI, in my domain, that’s been my experience. It can write SQL queries that run, but miss the context. It can scaffold out a Pytorch model, but […] - [Looking under the hood for Power BI Copilot](https://mediumslateblue-hippopotamus-675104.hostingersite.com/looking-under-the-hood-for-power-bi-copilot/): Power BI Copilot doesn’t document how it processes questions internally. The closest that I’ve found is in Microsoft Learn (below). I’m writing what I’ve found using Copilot’s diagnostic JSON across three environments, Desktop, Power BI Service (not edit mode), and the sidebar Copilot in Power BI. I spent a weekend setting up a Fabric F2 […] - [When the Model Isn't the Answer](https://mediumslateblue-hippopotamus-675104.hostingersite.com/when-the-model-isnt-the-answer/): If you stare at any two datasets long enough, you can convince yourself there’s a connection between them. Not because there is, but because there is an important enough question that the data “should” be connected. It’s a dangerous place from which to start a modeling project. This is one such story. Enter multi-instance-learning, and […] - [The Boring Part of Machine Learning Nobody Wants to Talk About](https://mediumslateblue-hippopotamus-675104.hostingersite.com/the-boring-part-of-machine-learning-nobody-wants-to-talk-about/): I’ve been getting more into vision analytics, private, professional, everywhere. My usual approach for solving problems is to learn a tool, understand conceptually what it does, check my back catalog of problems I couldn’t solve and see if that tool or approach helps. Vision analytics is no different. I’ve also applied this to document classification […] - [Training a Neural Net to Find Puss in Boots](https://mediumslateblue-hippopotamus-675104.hostingersite.com/training-a-neural-net-to-find-puss-in-boots/): I want to fine-tune an image generation model on Puss in Boots. That means I need 50 to 100 good stills of the character. The movie is 98 minutes long. I am not going to sit there and screenshot by hand. So I trained a binary classifier to do it for me, wired it up […] ## Pages - [Contact](https://mediumslateblue-hippopotamus-675104.hostingersite.com/contact/) - [About](https://mediumslateblue-hippopotamus-675104.hostingersite.com/about/): For over five years I worked in data science and analytics, embedded on a supply chain operations team at a national grocery company. “Embedded.” I sat between the business, data software engineers, and statistics PhDs, and spoke all of their languages. I designed and built the things those people needed, from prediction models across dozens […] - [Home](https://mediumslateblue-hippopotamus-675104.hostingersite.com/): Jonathan Dufault it’s usually a data problem Analytics engineer, turning questions into projects. Operations and supply chain: the reporting people run the business on, and the checking that happens before anyone acts on a number. Code is maybe 40% of figuring something out. The rest is just staring at it until it makes sense. Selected […] - [Projects](https://mediumslateblue-hippopotamus-675104.hostingersite.com/projects/) ## Optional - [Agent (MCP protocol)](websites-agents.hostinger.com/mediumslateblue-hippopotamus-675104.hostingersite.com/mcp) [comment]: # (Generated by Hostinger Tools Plugin)