The workflow before
Durable Capital, an $18B investment firm, had licensed Consumer Edge consumer transaction data but had nowhere to land it. Analysts pulled and blended data by hand in Excel, spending a large share of their week on preparation instead of research, and the feed could not be refreshed or analyzed at scale.
What we built
In 8 weeks we stood up an end-to-end pipeline: Alteryx prepares the raw Consumer Edge feed, it lands on AWS, and it loads into Snowflake on a schedule.
We modeled the Consumer Edge data in Snowflake so it is reporting-ready, with raw, cleaned and analysis-ready layers, then connected Tableau and delivered the first dashboards to the investment team.
Orchestration runs the loads automatically, so the feed refreshes without an analyst rebuilding a spreadsheet.
Before and after
| Measure | Before | After |
|---|---|---|
| Time to usable consumer data | No environment | Live dashboards in 8 weeks |
| Analyst time on data prep | About 40% of the week | About 20% |
| Feed refresh | Manual pulls | Automated scheduled loads |
What's next
With the consumer feed modeled in Snowflake, the next step is L2: an analytics copilot that lets analysts ask questions of the data in plain English and get the chart back.
