Building Apps in Sigma
The first complex app I built in Sigma taught me more about architecture than it taught me about Sigma. It started simply enough: One input table, some additional logic on top, a button that wrote records back to the warehouse. Then complexity crept in: A new user type needed a separate view A logic step […]
Stop Underestimating Excel Before You Migrate to Sigma
I spent years trying to kill Excel. Not literally. But as an analytics architect, I approached every spreadsheet like a building that needed to be condemned. Manual data entry. No source of truth. Formulas nested inside formulas. One wrong change and the whole thing breaks. I was right about most of that. But I was […]
Before You Build a Sigma App, Read This
The most expensive mistake you can make on a Sigma App project isn’t a technical one. It’s starting to build before you’ve clearly defined what you’re building. I’ve seen projects double in scope mid build because the initial conversation used “Sigma App” to mean something different than what the builder heard. I’ve seen “a few […]
SQL in Sigma: You’re Probably Putting it in the Wrong Place
I’m a code first person. Given a choice between clicking through a UI and writing SQL, I’ll write the SQL. It’s faster, clearer and I can read it later. That preference isn’t a problem in Sigma. The challenge I ran into wasn’t that Sigma didn’t support my approach. It was that I was putting my […]
Dynamic Bulk Insert in Sigma: Two Approaches
Why Bulk Insert Is Hard in Sigma Sigma’s writeback is designed for row by row input. A user fills out a form, hits submit, one row gets written. That works well for simple data entry. The problem comes when one user action needs to produce multiple output rows and you don’t know how many at […]
From Chaos to Confidence: What You Really Get When You Partner with InterWorks
In Part 1 and Part 2 of this series, I made the case that data transformation is fundamentally about leadership and people, not just technology. We talked about building the right foundation, getting aligned on shared definitions, mastering data storytelling and managing change with intention. I know, I know. You came here for the […]
How Do I Track Who’s Using My Curator Portal?
It’s one of the most common questions I get after a go-live. Here’s a practical look at your options — from Curator’s built-in tools to web analytics integrations and your BI platform’s own usage data. One of the most common questions I get after a Curator go-live is some version of: “Can we track who’s […]
From Dashboards to AI Apps: Building a School Directory with Sigma and Snowflake
Why a School Directory Needs More Than Dashboards School directories rarely fail because of complexity. They fail because of process. In most environments: The warehouse holds the authoritative staff and student data Dashboards display it Updates happen somewhere else That separation creates delay, duplication and mistrust. Administrators export spreadsheets. Analysts get pulled into “small” fixes. […]
HTML Share: A Story of Solving a Problem with a Simple App
AI is great at creating visually appealing HTML artifacts, whether these are just summaries of some research findings, mock-ups of some proposed solution or just an agenda for an upcoming meeting. The most common thing to do with these artifacts is to share them with others. We have a plethora of tools like Slack, Box […]
Deploying Secure AI Apps at Scale
Low Friction Development As mentioned in the whitepaper on how to leverage AI to become a world-class dev team, AI has upended who is able to create solutions to business problems. Application development no longer needs to be funneled through a specific group within IT. Now, anyone from HR, finance, facilities, legal, and other departments […]
