Author Archives: MikeDavisSQL

Per Member Per Month Per 1000 Calculations in MDX

Posted on May 20, 2013 by MikeDavisSQL

In a lot of industries there is a popular calculation called “Per Member Per Month Per 1000” calculation or the “Per Customer Per Month Per 1000” calculation. This is used to determine the level at which the company is rendering … Continue reading →

Posted in mdx, SSAS, Syndication | Tagged , | 4 Comments

SQL Saturday Jacksonville FL 2013

Posted on April 29, 2013 by MikeDavisSQL

This weekend at SQL Saturday JAX I had a great time and got to meet some great people. I had three sessions and the reviews were great. I did an MDX session in the morning. My attendees were trying to … Continue reading →

Posted in Community, SQL Saturday | Tagged | 4 Comments

Adventures in Interviewing

Posted on April 24, 2013 by MikeDavisSQL

I have done over 140 interviews for potential employees at Pragmatic Works. In that time we have only hired a very small percentage of those people. Now a lot of that has to do with lacking skills. I cover that … Continue reading →

Posted in Pragmatic Works, Training | Tagged | Leave a comment

JAX SQL User Group – Speaker Idol 4/17/13

Posted on April 18, 2013 by MikeDavisSQL

Last nights Speaker Idol at the Jacksonville SQL User Group was awesome. Had 4 great speakers. the winners took home some great prizes. But my favorite part of the night was a slide by Mitch (@SqlLittleFriend) . He paid tribute … Continue reading →

Posted in Uncategorized | Leave a comment

SSRS Map Label Overlap Fixed

Posted on April 10, 2013 by MikeDavisSQL

In Reporting Services 2008 r2 and above there is a great tool called the Map tool. It is great for visualizing data across a map. One of the issues I have run into is overlapping labels. For example I am … Continue reading →

Posted in Syndication, Uncategorized | Leave a comment

Studying and Learning Business Intelligence

Posted on October 2, 2012 by MikeDavisSQL

I have been doing interviews for Pragmatic works for the past few years and I have come across quite a few people who wanted to be hired as a senior BI consultant and their skills were just not up to … Continue reading →

Posted in Business Intelligence, PASS, Pragmatic Works, SSAS, SSIS, SSRS, Syndication, Training | Tagged , , | 2 Comments

Crystal Reports DataDate in SSRS

Posted on July 16, 2012 by MikeDavisSQL

Crystal Reports has a special field name “DataDate”. This date shows the last time the data on the report has been executed. A recent client asked for the similar functionality in SSRS when a snapshot is run. They wanted to … Continue reading →

Posted in SSRS, Syndication | Tagged | Leave a comment

IT Pro Camp Jacksonville 2012

Posted on June 20, 2012 by MikeDavisSQL

I spoke last weekend (6/16/2012) at the first ever IT Pro Camp in Jacksonville Florida. It was a great event with over 100 people attending. Breakfast and Lunch was provided with a great after event at Tilted Kilt. One of … Continue reading →

Posted in SSIS, T-SQL, Training | Tagged | Leave a comment

Using PowerPivot to Monitor Reporting Services

Posted on June 12, 2012 by MikeDavisSQL

PowerPivot is a powerful new tool from Microsoft that has been improved even more in the 2012 release, which you can download for free here. In this blog I will give you a PowerPivot workbook that I created to connect … Continue reading →

Posted in powerpivot, Syndication | Tagged , , | 2 Comments

Oracle Date issues with PowerPivot

Posted on May 29, 2012 by MikeDavisSQL

This week I was building power pivot models for a client pulling data from Oracle. One table kept giving the below error when trying to import: OLE DB or ODBC error: Accessor is not a parameter accessor.. Out of line … Continue reading →

Posted in powerpivot, Syndication | Tagged , | Leave a comment