I had the good fortune to overhear some of my good friends and fellow MVPs discussing the process of data modeling for business intelligence systems. So what are the industry standard approaches for modeling dimensional data modelling? The short answer is that Kimball's dimensional modeling is the most widely adopted standard for any sort of data warehouse. Inmon is also well respected. But the consensus is to stick with Kimball, especially if you're looking for something an enterprise standards team is going to recognize as "standard". The book on my shelf and which I most … [Read more...]
What’s the Data Modeling Standard for Business Intelligence Systems?
Filed Under: Architecture, Business Analytics, Business Intelligence, Databases, On-Line Resources, SQL Server, SQLMag, SQLServerPedia Syndication Tagged With: Architecture, Best Practices, BI, Business Intelligence, Data Modeling, Data Warehouse, MVP, SQL Server 2012, SSAS
Video: Data Modeling in the SQL Server Space
Join SQL Server MVP and President of PASS, Kevin Kline as he: * Identifies the issues that can arise from relying only on modeling tools * Discusses the 10 most common modeling issues you will face when transforming data models from logical (conceptual) to physical * Describes how to correctly identify and resolve serious problems * Provides best practices to resolve issues Posted June 14, 2007. … [Read more...]
Filed Under: Challenges, Databases, Presentations, SQLServerPedia Syndication, Tool Time, Video Tagged With: Data Modeling, Database Architect, Database Design, DBA, Normalization, Tools, Video
