Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Archive for June, 2010

5 Seconds of Fame at Microsoft BI Conference

Posted by denglishbi on June 8, 2010

Day 2 of the conference and Donald Farmer presented during Ted Kummert’s keynote to talk about the Alpha Geek Challenge winners starting at about 1hr 6min into the keynote.  I got a brief mention as one of the finalist winners at about 1hr 7min 50sec into the video.  Donald stated that my entry was based on the firstKeynote Slide - Dan English BI Conference, but I actually put it together to do analysis based on information for this year’s conference displaying data for Minneapolis and New Orleans.  They also stated that the first winner was Dan, but his name was actually Derek.

You can check out the entire Day 2 keynote video here – http://www.msteched.com/2010/NorthAmerica/Keynote02.

You can also check out my previous postings on this challenge/contest here:

I hope everyone is enjoying the conference, I wish I could have been out there.  Maybe I will see you out at the national PASS 2010 Summit in November.  I submitted four sessions and will find out next month if any of them get accepted.

Posted in Personal Comments | Leave a Comment »

PASSMN June 15, 2010 Monthly Meeting

Posted by denglishbi on June 7, 2010

The next Minnesota SQL Server User Group meeting is coming up in a couple of weeks on Tuesday, June 15.  This month Lara Rubbelke will be presenting on the new features in SQL Server Reporting Services 2008 R2 – Report Builder 3.0, new visualizations (map report item, sparklines, data bars, indicators), new shared features (report parts and datasets), new data sources, new rendering enhancements, and more.  If you have any questions related to SSRS that you would like to have discussed and covered in the discussion please send them in advance to support@mnssug.org.


In order to RSVP for the event you will need to login to the national PASS site and click on the RSVP link.  This month our sponsor for the event is Magenic again.  Last month there was a mix-up with the food and beverage order the Papa John’s actually got sent to Davannis.


PASSMN June 2010 Meeting – New Features in SQL Server Reporting Services 2008 R2

Agenda: sql 2008 r2 logo

3:00 –3:15 : Announcements
3:15 –3:25 : Sponsor
3:25 –4:45 : SSRS 2008 R2 (Lara) 
4:45 –5:00 : Survey Collection and Giveaways
5:00 –5:30 : Networking


What’s New in SQL Server 2008 R2 Reporting Services (presented by Lara Rubbelke) – Amp up your Reporting Services with the many great enhancements in SQL Server 2008 R2. Lara will take you on a tour of all that is new in R2 including collaboration features, new visualizations, rendering enhancements, and new data sources. After this session you will wonder why they call R2 an "interim" release!

Hope to see you there! 

Also, last month we were finally able to get our first successful Live Meeting recording – PASSMN May 2010 Follow-up.  And this week the Microsoft BI Conference and TechEd is going on down in New Orleans, so there should be a lot of content and information being posted this week through Twitter (#msbic and #teched – Twitter handles) and Blogs.

Posted in Training | Leave a Comment »

PASSMN May 2010 Follow-up

Posted by denglishbi on June 2, 2010

This past month I presented at our local Minnesota SQL Server User Group.  I was a tad bit exhausted from presenting at TechFuse 2010 and the SQL Server 2008 R2 launch event here in Minneapolis earlier in the month.  It was tough when each presentation was on a different topic and I filled in for the launch event and had less than a week to absorb the content.  I didn’t plan for all of these to occur one week after the other either, just kind of happened.  Needless to say I was a little burnt out, so hopefully my PASSMN_Logocontent was good even though I probably sounded a bit less than enthused, which I apologize for.  I also want to apologize for the food.  The Papa Johns pizza was mistaken delivered to Davannis….I wish I could have been there to see that one.

For the evaluations I received the following scores (on a five point scale):

  • Effectiveness of the demonstrations – 3.7
  • Usefulness of the material presented – 4.0
  • Speaker’s presentation skills – 3.5
  • Correct blend of presentations and demonstrations – 4.0
  • Overall Presentation Rating – 3.8

I have been holding out on posting the content because this was the first month we got an actual recording of the meeting.  I have been working on converting it and making it available to view.  My talk was on SSAS Design Best Practices and Incremental Processing.  I highlighted some of the built-in items in BIDS along with BIDS Helper, did a few demos, and wrapped it up with a little PowerPivot comparison.

PASSMN May 2010 – SSAS Design & Incremental Processing from Dan English on Vimeo.

I wanted to provide some follow-up reference links that goes over some of my content or highlights items that I discussed:

I think I misspoke a couple of times.  One time I stated that I don’t usually have the security information for SSAS ahead of time.  That isn’t necessarily the case, usually it is a requirement up front.  Sometimes though we add it in after the fact and it doesn’t take a lot of work to accommodate that either using SSAS roles.  I believe I also mentioned that PowerPivot was row based compression and it is column.  It was kind of funny, because the day after my presentation I ran into a blog posting about hierarchies in PowerPivot which I was talking about at the end of my presentation and did a posting in regards to it – Hierarchies in PowerPivot.  You still don’t get the drill path like you would in SSAS, but you can get a similar look-and-feel.

The other big thing was the incremental processing setup I had posted about previously – Analysis Services (SSAS) Processing and Aggregations.  I had originally set that package up to handle yearly incremental processing and before I published it I changed it to monthly.  Well needless to say I forgot to take into account the yearly partitions that might be included and these were getting included in the full processing group instead of being ignored.  I have made the change and have created a new version of the packages and replaced the old ones.

Downloads from my SkyDrive (presentation and SSIS package download):

presentation download

ssis download  

Feel free to leave me any comments if you have any questions or ask me questions at one of the PASSMN monthly meetings.

Posted in SQL Server | Tagged: | 3 Comments »