Data Marts: If You Must, Then Do So Responsibly!
One of the biggest changes in data warehousing in recent years concerns attitudes toward data marts. Just a decade ago (circa 2001-2004) the DW community was struggling to consolidate the uncontrolled plague of data marts spawned in the booming years of IT growth in the late 1990s. But things are different today. There’s a new tolerance and respect for data marts, and many organizations depend on them to satisfy critical new requirements in advanced analytics, big data, distributed data warehouse architectures, and departmental business intelligence.
Does the new tolerance of data marts mean you can let down your guard concerning rogue marts? No, not at all. To prepare for the new demand, you need to put responsible control processes and controllable platforms in place, so business users get the datasets they need, but in a manageable and governable environment. Getting to this utopia probably means consolidating some existing data marts, while imposing new controls on others without consolidation. Push hard to get responsible controls in place today, before the ramp up of data marts progresses. Otherwise, your organization will find itself on yet another resource-consuming data mart consolidation project later.
What you will learn:
- New data requirements that have driven organizations to begin deploying data marts again, but within carefully defined guidelines and control
- How data marts have evolved to satisfy new requirements and use cases
- Tips for when to consolidate data marts versus allowing their independence
- New products, platforms, and practices that help you deploy marts responsibly
Philip Russom, Ph.D.