Data Marts: Your Department's Slice of the Data Warehouse
Think of a data mart as a department's personal slice of the main data warehouse, containing only relevant data. This allows teams like Sales or Marketing to run faster, focused queries. The footgun is letting each team define shared terms differently.
The mental model
Think of a company's data warehouse as a massive central library. A data mart is a small, curated bookshelf in the Sales department's office, containing only the books on sales strategy and performance, all pulled from the main library. It's a subject-specific subset of the larger data warehouse, designed for a single business unit.
How it works
Data is extracted from the main data warehouse and loaded into a separate, smaller database—the data mart. This new structure is optimized for the specific analytical needs of one department. In some deployments, that department owns its data mart completely, including the hardware, software, and data. This autonomy allows them to manipulate data and develop reports without waiting for a central IT team, using a model that best suits their function.
When to use it
Use a data mart when a specific department needs faster, easier access to data for its unique analytical needs. It's ideal for business units with well-defined subject areas, like Finance or HR, that want to perform analysis without the complexity or query latency of an enterprise-wide warehouse. For example, a Marketing team can build a mart focused solely on campaign performance and customer segmentation.
When not to use it
Avoid creating data marts without a central governance strategy for shared data. If each department builds its mart in total isolation, you create conflicting data silos. For instance, Sales might define an "active customer" differently than Marketing, making a coherent view of the business impossible. This is solved by using "conformed dimensions," where master data like customer or product lists are managed centrally and shared across marts.
One canonical example
A retail company's central data warehouse contains all sales, inventory, and supply chain data. The Marketing department needs to run frequent queries on customer lifetime value. To speed this up, they create a Marketing data mart that pulls only customer demographics and purchase history from the main warehouse. They can now run analyses quickly without slowing down other departments. The definition of "customer" is a conformed dimension, managed centrally to ensure it's consistent with the Sales and Finance data marts.
Interview question
What is the main challenge that arises when departments create data marts without central oversight, and what is the recommended solution?
- a.Data definitions become inconsistent across departments; solved by implementing conformed dimensions.Correct
- b.The central data warehouse experiences slower performance; solved by upgrading its hardware.
- c.Data security becomes difficult to manage; solved by encrypting all data within each mart.
- d.Departments face increased data storage costs; solved by using more efficient compression algorithms.
Why? this is the answer
The card highlights that the primary risk of ungoverned data marts is creating conflicting data silos due to departments defining shared terms differently. This issue is mitigated by using "conformed dimensions," which ensure master data is managed centrally and consistently across all marts.
Just read this? Test yourself on what you have been reading.
Read the original → en.wikipedia.org
- #data warehouse
- #analytics
- #data architecture
- #business intelligence
You just looked this up. Could you explain it out loud?
That is the part interviews actually test. Tezvyn takes questions like this one and gives you what the interviewer is really checking, the answer that lands, and the mistake that ends the conversation, in the four minutes before your next meeting.
The iPhone app is on the way
We are building it. Until it lands, nothing here is held back from you: every interview card, your saved cards, streaks and the job board all work in Safari, plus hundreds of free practice quizzes of thirty questions each. Sign in and it all carries over to the app the day it arrives.
Want it as an icon? Tap Share at the bottom of Safari, then Add to Home Screen. It opens full screen and the cards you have read stay available offline.
We are hiring for this. Open roles that interview on data warehouse — each one lists the topics its interview covers.
See open roles