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
Business Intelligence Careers SearchSQLServer.com Interview
I had a very interesting conversation recently with a good friend of mine. She's at the top of her game as a first class enterprise DBA in a major medical institution. She was interested in my career advice because she'd recently received an unsolicited invitation for a higher paying job in the business intelligence (BI) field. While I won't talk much more about the specifics of that conversation, it's not a unique conversation. In fact, I gave an interview to SearchSQLServer.com a while back about how DBA career paths are more and more leading into an even better paying career in business … [Read more...]
Filed Under: Administration, Databases, Opinion, Professional Development, SQLMag, SQLServerPedia Syndication Tagged With: Business Intelligence, Career, DBA, Developer, SQL Server 2008 R2, SSAS