As a followup to my blog Power View for Multidimensional Models – Preview Available, the final version is now available via SQL Server 2012 Service Pack 1 Cumulative Update 4. So you can now create Power View reports against multidimensional models … Continue reading →
If you are involved in Business Intelligence, then the books by Ralph Kimball are required reading: The Data Warehouse Lifecycle Toolkit: Practical Techniques for Building Data Warehouse and Business Intelligence Systems, Second Edition, 2008, 636 pages (Amazon). Subject: Implementation guide. Primary … Continue reading →
There are three fundamental steps in building a data warehouse for a BI solution (see Why you need Business Intelligence): Identify the data the users interact with, or would like to interact with, via interviews. Make sure to determine the … Continue reading →
I am fortunate enough to have been selected to give a presentation at the PASS Summit 2013 in Charlotte, NC on October 14-18. It’s amazing to think that, although I have been in IT for 25 years, I first started to build … Continue reading →
One of my pet peeves is seeing a top-notch BI architect/developer working as a salaried/perm employee of a consulting company where they are making a good salary but are being billed out to the client at a rate that is … Continue reading →
This is something I just heard about recently, but then experienced it for myself. This story was told to me: A client is looking for a contractor and contacts a staffing firm to find candidates. The staffing firms sends a … Continue reading →
To expand on what I talked about in Should a placement firm tell you what they are billing the client?: If you are a consultant working through a placement firm, should the markup percentage (client bill rate divided by consultant … Continue reading →
Data cleansing can be done via SSIS as well as Data Quality Services (DQS) and Master Data Services (MDS). The lines are a bit blurred when talking about data cleansing using SSIS, DQS and MDS. In what product should data … Continue reading →
Here is another response to my blog “Should a placement firm tell you what they are billing the client?” (the first response was Billing rates – other side of the fence). My purpose of these blogs is to give more understanding … Continue reading →
I greatly enjoy doing presentations on a variety of topics, such as Business Intelligence, SQL Server, and personal development. If you would like me to do a presentation, just ask! For descriptions of presentations I have done before, along with other … Continue reading →