What’s the Data Modeling Standard for Business Intelligence Systems?

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...]

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...]