Monthly Archives: May 2013

Power View for Multidimensional Models Released

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

Posted in Power View/Project Crescent, SQLServerPedia Syndication | Leave a comment

Ralph Kimball Books

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

Posted in Business Intelligence, SQLServerPedia Syndication | 6 Comments

Business Intelligence Requirements Gathering

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

Posted in Business Intelligence, SQLServerPedia Syndication | 2 Comments

I’m presenting at the PASS Summit!

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

Posted in PASS, SQLServerPedia Syndication | Leave a comment

Consulting company: Perm/Salaried vs 1099/W2

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

Posted in Career, Consulting, SQLServerPedia Syndication | Leave a comment

When the person you hire is not the person you hire

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

Posted in Consulting, SQLServerPedia Syndication | 2 Comments

Should placement companies use a markup %?

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

Posted in Career, Consulting, SQLServerPedia Syndication | Leave a comment

Data cleansing in SSIS, DQS, and MDS

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

Posted in DQS, MDS/MDM, SQLServerPedia Syndication, SSIS | 1 Comment

Billing rates – other side of the fence, part 2

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

Posted in Career, Consulting, SQLServerPedia Syndication | Leave a comment

Want me to do a presentation?

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

Posted in SQLServerPedia Syndication | Leave a comment