M365Con 2027 – 無料オンラインカンファレンス · 11–22 Jan 2027 · 120 sessions m365con.net

Spreadmart

Concept

A pejorative term for a spreadsheet- or desktop-based reporting setup that individuals or teams build on their own instead of a governed data mart or warehouse. In BI it stands for duplicated datasets and inconsistent metric logic.

✦ CONCEPTSpreadmartM365.FM
Title graphic: Spreadmart (Concept)

あわせて取り上げられたテーマ

Spreadmartに関するエピソードでは、Calculation groups、DAX time intelligence、Self-service BI、Semantic layer、DAX、Microsoft Fabricも取り上げられています。

Description

Spreadmart, short for "spreadsheet data mart", is a pejorative term from business intelligence. It describes a reporting and analysis setup built on spreadsheets or other desktop databases that individuals or small groups maintain themselves, doing work that a governed data mart or data warehouse could do in a more structured way. Wayne Eckerson of TDWI coined the term in 2002 as a criticism of this pattern.

A spreadmart usually appears when standard BI reporting feels too slow or too inflexible. A typical sequence is that an analyst exports a table into Excel and builds a private report. Copies of that file are then emailed around, edited, and re-saved. Once exported, the data is disconnected from its source, so it cannot be verified against the original system and cannot be refreshed automatically. Because different people build their own versions at different times, with different data sources and different definitions of the same metric, the organization ends up with a fragmented, decentralized view of the business. The core risk named in the sources is that undefined, disconnected data can support false conclusions and costly wrong decisions.

The term is a label for a symptom rather than a product or feature. In practice, discussions around spreadmarts focus on duplicated datasets, conflicting calculations and a lack of trust: two reports can show different numbers for what appears to be the same measure, and nobody can easily say which one is correct. The main alternatives are the structured approaches the term is defined against, namely data marts and data warehouses, where data is modeled once, sourced from governed pipelines, and shared.

The concept is not without counterarguments. Stephen Samild argues that spreadmarts fill roles that warehouses cover poorly. He names handling unstructured data, read-write analysis, avoiding long lead times when a new data source is needed, and free-form presentation. This view frames spreadmarts as a response to real gaps in formal BI rather than only as a governance failure, which is why the decision is often about balancing agility against consistency rather than eliminating spreadsheets outright.

In the Microsoft ecosystem, the term comes up in discussions about Power BI sprawl. The M365.FM episode "Build Reusable Semantic Models in Microsoft Fabric" (2025-08-12) describes environments that start fast and then stall under copy-paste sprawl: duplicated PBIX files, conflicting measures and "spreadmart" dashboards that nobody fully trusts. The episode says the fix is not another naming convention but a model-first architecture. In that approach, Microsoft Fabric treats the semantic model as an enterprise asset, one definitional layer reused across reports, workspaces and teams. The episode also points to calculation groups as a way to avoid endless YTD, QTD and TTM variants, keeping time intelligence, KPIs and business rules centralized and auditable.

Taken together, the sources present the spreadmart as both a historical BI criticism and a recurring modern pattern. The practical question for teams is where metric definitions live and who owns them. When definitions are scattered across individual files, the spreadmart pattern emerges; when they are centralized in a shared, governed model, reports can be built on a single consistent layer while still allowing self-service analysis on top of it.

Overview compiled with AI from M365.FM episodes and the facts on this page. You can improve it with the edit button below.

TypeConcept
WikipediaSpreadmart – Wikipedia en.wikipedia.org

Glossary

Community wiki

Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.

Experts and companies for this topic

Nobody has listed this topic yet. Add it to your profile.

Sources

Maintained by Mirko Peters (Microsoft MVP) · Last updated: