Brewing Better Decisions for a Dunkin Donuts Franchisee with Microsoft Fabric
Description
Learn how Bluemont Group transformed Data & AI across 100 Dunkin' locations by replacing a vendor-controlled data warehouse with a modern, fully owned Microsoft Fabric platform. Learn how Collectiv helped them eliminate multi-day data delays, unlock historical insights, and empower managers with real-time, location-level visibility.
Key Takeaways
- Reports generated Thursday through Sunday — leadership waiting days for insights that should
- business was always catching up — never getting ahead.
- brand name, it was chosen because it
- the inability to scale analytics across
- 4-day reporting delay (Thu–Sun cycle)
- Same-day data refresh across all systems
- Vendor-controlled data warehouse
My Notes
Action Items
- [ ]
Resources & Links
Slides
##FABCONSQLCON2026
F A B C O N S Q L C O N 20 26
Úfl# ‰Ú# " » # Á @q "�� "�"�� �"�� ��
Connect With Us On LinkedIn!
S can to C onnect
S can to C onnect
' ¸ w‰"Úq O
@¸ ‰ü OÁ Ê # Úw̧ ‰
F A B C O N S Q L C O N 26
Brewing Better
Decisions for a Dunkin
Donuts Franchisee
with Microsoft Fabric
' ¸ w‰"Úq O
@¸ ‰ü OÁ Ê # Úw̧ ‰
F A B C O N S Q L C O N 26
Brewing Better Decisions with
Microsoft Fabric
Transforming Data & AI for 100 Dunkin' Locations — A real transformation story from
Bluemont Group
100 Locations
Hundreds of Users
Across 7 U.S. states
Employees & managers relying on
data daily
One Opportunity
Turn fragmented ops data into real-time intelligence
' ¸ w‰"Úq O
@¸ ‰ü OÁ Ê # Úw̧ ‰
F A B C O N S Q L C O N 26
THE CHALLENGE
When Data Moves Slower
Than the Business
Bluemont Group was operating 100 locations across 7 states — but
their data infrastructure couldn't keep pace. The result: leadership
was making decisions on information that was already days old.
Vendor-Controlled Data Warehouse
No ownership, no flexibility. Bluemont couldn't extend, customize, or access their own data on
demand.
Operational Bottlenecks
Disconnected systems, recurring Sage Intacct refresh failures, and a growing data backlog
compounded daily.
4-Day Reporting Delays
Reports generated Thursday through Sunday — leadership waiting days for insights that should
have been instant.
Untapped Historical Data
Years of valuable operational data existed but couldn't be queried, analyzed, or acted upon
effectively.
' ¸ w‰"Úq O
@¸ ‰ü OÁ Ê # Úw̧ ‰
F A B C O N S Q L C O N 26
BUSINESS IMPACT
The Cost of Slow Data Across 100 Locations
The cumulative effect of disconnected systems and delayed reporting created real operational friction — not just a technical inconvenience, but a
strategic liability affecting every level of the franchise.
Days of Delay
Locations Affected
States Impacted
Average wait time for weekly financial reports
Every store operating with incomplete or stale
Fragmented visibility across a multi-state
to reach leadership
performance data
franchise footprint
Growing Frustration
Slower Decision Making
Data reliability issues eroded trust in reporting — managers and
Without timely data, decisions were reactive rather than proactive. The
leaders questioned numbers instead of acting on them.
business was always catching up — never getting ahead.
Úfl# ‰Ú# ��
' ¸ w‰"Úq O
@¸ ‰ü OÁ Ê # Úw̧ ‰
THE TURNING POINT
From Vendor Dependency to Data Ownership
At MURTEC, Bluemont leadership connected
with Collectiv and discovered a fundamentally
different approach to franchise data.
Instead of patching the existing vendor
warehouse, the path forward was clear: build a
fully owned, modern data platform on Microsoft
Fabric.
Faster Reporting
Same-day data availability replacing
multi-day delays at every level of the org.
Unified Data Platform
All financial and operational data flowing
into a single, centralized architecture.
Personalized Insights
Custom dashboards tailored to each
individual location's performance metrics.
AI-Ready Foundation
A scalable platform built to support
advanced analytics and future AI capabilities.
Úfl# ‰Ú# ��
C O N V E R S A TIO N
F A B C O N S Q L C O N 26
WHY MICROSOFT FABRIC
The Right Platform for Franchise-Scale Analytics
Microsoft Fabric wasn't chosen for its
brand name — it was chosen because
it solved Bluemont's specific problems:
fragmented data, limited ownership,
and the inability to scale analytics
across a growing franchise footprint.
At the core of the architecture is OneLake — a single, unified data lake that eliminates silos and gives Bluemont
complete ownership and control over every data asset across all 100 locations.
Úfl# ‰Ú# ��
C O N V E R S A TIO N
� h# ? @¸ ‰Ê © fl@¸ ‰� �
THE TRANSFORMATION JOURNEY
Building a Modern Data Platform, Step by Step
Microsoft Fabric wasn't chosen for its
brand name, it was chosen because it
solved Bluemont's specific problems:
• fragmented data
• limited ownership
• the inability to scale analytics across
a growing franchise footprint.
Foundation
Partnership
Enablement
Each phase was designed to deliver immediate value while laying the groundwork for long-term franchise
intelligence — from raw data ingestion all the way to confident, self-service analytics.
"There was no point where I felt like our project was insignificant."
— Bluemont Group Leadership
Úfl# ‰Ú# ��
C O N V E R S A TIO N
� h# ? @¸ ‰Ê © fl@¸ ‰� �
The Fabric Architecture Behind the Transformation
J O IN TH E
C O N V E R S A TIO N
F A B C O N S Q L C O N 26
THE IMPACT
Measuring the Transformation
The results weren't incremental, they were transformational.
Bluemont moved from a reporting model measured in days
to one measured in hours, giving every level of the franchise
access to the data they need, when they need it.
Before
After
• 4-day reporting delay (Thu–Sun cycle)
• Same-day data refresh across all systems
• Vendor-controlled data warehouse
• Fully owned Microsoft Fabric platform
• Disconnected financial and ops systems
• Unified Sage Intacct + store data pipeline
• Limited historical data access
• Full trend visibility across years of data
• Low confidence in data reliability
• High-confidence, actionable reporting
J O IN TH E
C O N V E R S A TIO N
F A B C O N S Q L C O N 26
CASE STUDY
Visit our booth #318 to see the full Fabric architecture, live
Power BI dashboards, and learn how to modernize your own
data estate.
Hear It Directly From Bluemont
' ¸ w‰"Úq O
@¸ ‰ü OÁ Ê # Úw̧ ‰
F A B C O N S Q L C O N 26
Scan to Get Started:
Free POV
Start your Planning journey today.
Collectiv will guide your team through
the process.
' ¸ w‰"Úq O
@¸ ‰ü OÁ Ê # Úw̧ ‰