SharePoint Webcasts: Reporting Services for the Really Really Good Looking

Send to Kindle

imageLast year, Peter Serzo and I presented at the SharePoint Best Practices Conference in DC. We did an extremely serious talk called “SharePoint and SQL Reporting Services 2008 for the really really good looking” which rated rather well. As part of this, we recorded a bunch of screencasts that have never seen the light of day, so I thought that some would benefit from this being released to a wider audience.

Note: This post and content is really going make utterly no sense unless you have watched Zoolander. Even if you have seen the movie, before you launch into the webcasts, some scene setting is required.

The business need

Some time ago, Peter and I were contracted by the Derek Zoolander School for the Really, Really Good Looking after Derek saw Microsoft’s new SharePoint diagram when he accidentally picked up a “Computerworld” magazine. Apart from matching Derek’s suit colour rather nicely, the diagram captivated his imagination with the notion of “Insights”.

Zoolander thought that “Insight”, sounded like the perfect look to follow up from the highly successful “Magnum”, which he used to save the Malaysian prime ministers life. He took the diagram to his wife, and demanded that he must have “Insights” at all costs.

image

Zoolander’s wife saw the business problem that “Insights” would help to address. You see, the Derek Zoolander School for the Really, Really Good Looking, at great expense, custom developed an ERP system to manage everything you needed to know about male models. The system was called the “Computerised Records for Attractive People”…

image

The CRAP system stored all sorts of interesting information about male models, such as tracking their “hotness”, as well as important detail such as stated age versus actual age, and any cosmetic procedures that they have undertaken. After a long and expensive consultation, Peter and I concluded that SharePoint 2007, integrated with SQL Reporting Services, was the perfect solution to create the all important “Insights” that Zoolander so desperately needed.

As a result, we conducted a project kickoff meeting with Hansel and Peter tried to explain the architecture of reporting services using a nice diagram.

image

… but we worked out pretty quickly that this was not the way to explain how it all worked to poor old Hansel…

image

So instead, we went the live demo route. Being male models, custom development was totally out of the question. This solution had to be done using all out of the box methods in a quick and easy manner. Below are the four live demos that were recorded and now you can use them as inspiration for your own male modelling school.

  • Our first webcast illustrates how we were able to create a meaningful report from the CRAP system within five minutes.
  • The second webcast expanded on this idea, by illustrating how reports can be parameterised and linked together for drilldown reporting.
  • The third demo modifies the user profile store to allow for recording of each users unique ID in the CRAP system
  • The last webcast strings this all together for the final demonstration where we pimp the report to make it dynamic with no custom code.

 

image  image

The 5 minute report

Drilling down with Derek
image image

User Profiles for the really really good looking

Pimp my report

 

We hope you find some value from these webcasts and we look forward to hearing about your hot new look as a result!

Thanks for reading

 

 

Paul Culmsee

www.sevensigma.com.au

 Digg  Facebook  StumbleUpon  Technorati  Deli.cio.us  Slashdot  Twitter  Sphinn  Mixx  Google  DZone 

No Tags

Send to Kindle

A roving we will go…

Send to Kindle

Hi all

I am finding it increasingly difficult to find the time to post at the moment. Too many projects, too many initiatives and too many evil plans coming to fruition. It’s like every seed I planted last year suddenly sprouted this year and I can barely keep up. Whilst this is a good thing for a growing business, it is not a good thing when it comes to writing blog posts.

In April I’ll be jumping on a very long flight to London, to attend and speak at the SharePoint Evolutions conference, held at the Queen Elizabeth II Conference Centre.

SP2010EvoBanner_Large (2)

This conference represents the evolution of the Best Practice conferences held over the last three years or so. It is one of the most unique and important SharePoint conferences of the year. SharePoint 2010 will be a key focus, yet unlike say a Tech-Ed, many of the topics have a heavy focus on the strategic side of the SharePoint challenge, in areas like Information Architecture, User Engagement and Planning and Deployment. There are five tracks in all, and over seventy speakers from all over the world.

  • For the techie geeks who like to hang in datacenters and like to get paged late at night to fix things that have died, the IT Pro track (ITP) will push their buttons. ITP sessions will focus on topics such as Document Management, Database Sizing, SharePoint and SQL optimization or server farm deployments scenarios.
  • For the developers and designers of the world, the DEV track is for you. DEV sessions will focus on topics in the areas of customization, development, and deployment best practices.
  • For all of the cool people, we have the information worker track where I speak (IW). In fact the IW track is so damn cool that there are two IW tracks! Sessions here will focus around business strategy and adoption, information architecture, training your organization or developing a culture of collaboration.
  • For the tech geeks who can code, who are therefore more elite than regular tech geeks and devs (looking at you Spence), there is a deep dive track to make you happy called level 400. In this track there will be IT Pro and Developer sessions that will be deep diving into the product and code. There will be very few slides, lots of source code and demonstrations.
  • Finally, there is a community track. This track has sessions for all verticals and will include speakers from all types of companies who have implemented SharePoint and what they learnt by doing so. All speakers are actively engaged in the SharePoint community and user group and have a wealth of knowledge to share.

This conference is organised by Steve Smith of Combined Knowledge, who is renowned for putting together something special for all participants. The speaker list is pretty much a who’s-who of the SharePoint world, and I am very much looking forward to catching up with (Paul takes deep breath) Andrew Woodward, Ben Curry, Brett Lonsdale, Chandima Kulathilake, Dux Sy, Joel Oleson, Laura Rogers, Michel Noel, Mike Watson and Zlatan Dzinic to name a few.

Bob Fox will also be there, so we finally have that beer that apparently I am supposed to buy – according to Bob anyway :-).

So if you are going to attend a SharePoint conference this year, then my strong suggestion is to make it this one.

 

Thanks for reading

Paul Culmsee

www.sevensigma.com.au

 Digg  Facebook  StumbleUpon  Technorati  Deli.cio.us  Slashdot  Twitter  Sphinn  Mixx  Google  DZone 

No Tags

Send to Kindle

SharePoint Saturday Perth Wrap and SP2010 BOOTCAMPS!

Send to Kindle

Well, the event that I never thought would ever happen in Perth happened, and not only did it happen, it had more interest than expected and some people unfortunately missed out. Jeremy, as a result, had to take many upset phone calls. It seems that for Perth, once a few people got wind of SharePoint Saturday, everyone wanted in.

There were great sessions, great giveaways and I think overall, tremendous value for this free event. Seven Sigma sponsored the showbags, which we managed to fill with some awesome goodies, thanks to the generosity of Brett Lonsdale at Lightningtools, Michael Sampson, Bjoern Furuknap, Dux Sy, Combined Knowledge and the good folks at Colligo. If you attended the event, please show your support to these guys – they really went above and beyond. Mrs Cleverworkarounds, on the other hand, never wants to see or hear the word “showbag” ever again! 

For me personally, I enjoyed meeting Michael Noel. I think he and I were the only non devs at SharePint (okay well maybe Joshua Haebets too 🙂 ). Speaking of which, Joshua and Milan Goss were also great to meet too, and I’m sure that there might be projects in the future we will see each other on.

Seven Sigma also donated a seat on the first SharePoint 2010 week-long bootcamp to be held in Perth. As a background: I met Steve Smith in New Zealand last year and we got on very well. Recently, we asked him if he would consider Perth to run his 2010 bootcamps and he has agreed! This is a great outcome for Perth, having beat out Sydney and Melbourne for being the first to run them as this will be the first time the courses have been offered to the general public in Australia.

Steve Smith and Gary Yeoman will be flying in from the UK especially for this event, so it is not to be missed. Both Steve and Gary are internationally renowned for the quality of their training and the courseware itself is the very same material that Microsoft itself uses to train their own staff on SharePoint 2010. All you eastern states people reading this?  It’s about time you went west anyway, so come and check out Perth’s beer while you are here!

SharePoint 2010 Beta Developer Track     4 days

  • Delivered by Gary Yeoman
  • Date:  27th April  -  30th April 2010
  • Cost: $3000 (+GST)

This course guides you through essential 2010 elements, from pre-requisites to system integration, giving you the skills to work confidently and leverage full value from new technology.

Please note: Due to our ANZAC public holiday this course is a 4 day course from 08:30 – 6:00pm. One additional session is added per day to make up for the Monday public holiday.

SharePoint 2010 Beta Administrator Track    5 days

  • Delivered by Steve Smith – MVP
  • Date: 10th May – 14th May 2010
  • Cost: $3000 (+GST)

Step-by -step understanding is the key to successful implementation and deployment of SharePoint 2010. This 15-module course will guide you through each critical stage, giving you exactly the skills you need to leverage full value from the latest SharePoint technology.

Book now at Seven Sigma’s website:

http://www.sevensigma.com.au/2010/02/07/first-ever-sharepoint-2010-training-courses-2/

For more info visit: www.combined-knowledge.com.au

or contact: training@sevensigma.com.au

 Digg  Facebook  StumbleUpon  Technorati  Deli.cio.us  Slashdot  Twitter  Sphinn  Mixx  Google  DZone 

No Tags

Send to Kindle