Experiences and Tabular Tips

project I worked on for some time went live months ago. My role as "tech lead" had a foot in many camps: solution architecture, business analysis, scrum master, data modeling, BI evangelism and BI development. We built a data warehouse of over half a terabyte with a handful of tables edging half a billion rows. It is a major component of the data-services layer for the organization. Thousands of applications/reports (primarily Excel/Access apps on network shares) that were tightly-coupled with systems of record were either replaced by a corporate BI & reporting solution, or rebuilt to consume data from reusable data services. We retired other competing "data layers" (legacy DW and a data-service + BI layer with a mix of technologies including multidimensional cubes) and migrated their consumers to the new architecture. We also enhanced limited MDM capabilities resulting in greater business ownership of master data, rather than the MDM repository being an unnecessary duplication of data. A data governance model has been established to ensure growth and longevity of the solution.