MN Microsoft BI User Group 2011 Q1 Follow up
Posted by denglishbi on March 30, 2011
Last week was the first meeting of the year for our Minnesota Microsoft BI User Group. The topic for the whole evening was Analysis Services including talks at getting started with SSAS (UDM) project, some tips & tricks, and then my PowerPivot presentation.
We also tried using LiveMeeting for the first time with recording the presentations and hopefully in the next week or so we will be able to share that content as well. We will see because it was the first time and I haven’t had a chance to check out the recordings yet.
In general I think the presentations went well and we had around 70 people all together and another dozen or so on the LiveMeeting. The one thing that didn’t go so well for me was when I had to share my desktop to do my presentation. For some reason LiveMeeting was forcing me to switch to a 800×600 resolution (haven’t ran into this before, but usually only have to switch to a 1024×768). Well needless to say when it came time to do my PowerPivot demo it pretty much tanked. Trying to work with PowerPivot with this resolution is pretty much impossible, especially went it comes time to create the PivotTables and PivotCharts along with slicers in Excel.
If you are curious to what I was experiencing here is what PowerPivot looks like at 800×600:
When I initially loaded the data into the PowerPivot window for some reason I was unable to see the tabs on the bottom of the window, so I couldn’t figure out how to switch between the tables. Once I closed the windows and reloaded it I was able to see the tabs though (nothing like being put on the spot – I felt like an id10t). Now that I have ran into this issue I figured out a few workarounds for in the future like in Excel I can minimize the Ribbon and utilize the zooming capabilities in the lower-right hand corner. Once you do this you can get a little more working room (this doesn’t work in the PowerPivot window though). After you do these modifications you can at least see what you are doing to a certain degree:
There were quite a few spots where I couldn’t even position the dialog boxes in a position where I could even click the buttons in them, so I was just hoping that if I clicked ‘Enter’ that the dialog box would close and accept my changes I made (and they did, thankfully). It is also hard to find items in the Ribbon when it gets squished down, so you just have to be pretty much prepared for anything when it comes to doing a live demo. I tried to salvage the demo as best as I could, but eventually I had to give up and toss in the towel. I was extremely disappointed and felt awful for the attendees. I am hoping that what I was able to show along with the content that people found it useful. I am planning on creating a video of my PowerPivot demo to share as well. Once I have this available I will post an additional follow up posting with that as well.
For now I will simply provide some of my blog postings as references for some of the items I mentioned in my presentation and share my presentation as well. Here are the blog posting references to some items I covered:
- New PowerPivot & Azure DataMarket Experience
- Round 2: Calculating Previous Year Marketing Calendar Values with DAX
- Sorting PowerPivot Labels Continued
- PowerPivot Memory Error – Not Enough Storage
I do have more postings as well, you can simply check out the items through the PowerPivot tag.
Here is my presentation deck (available from my SkyDrive account) and stay tuned for the video; I will have it available soon and post on Vimeo with my other videos and post a follow up here on my blog. Until then, enjoy the presentation content.