Completed - SQL Server Business Intelligence assignment- Bangalore, March 2012

Hi Friends,

In March, I delivered an interesting assignment, not in terms of content, but in terms of schedule. I was asked by my client to deliver two workshops, one on DBA, which was delivered in the morning schedule and the other on Business Intelligence, delivered in evening. This was so very different and uncommon but I took up the challenge without realizing that it’s not going to be easy task. But why? What’s the big deal in it? Here is the big deal, at least for me.

I started off my first day at 9 am. The first module was SQL Server Architecture. And I talked/demoed SQLOS, Memory, CPU, Disk stuff, SQL internals, etc, amongst many other sub-topics. I finished at 1 pm and we took a break for lunch. At 2 pm I was required to start SQL Server Business Intelligence and the first module was Why BI? And the fun begins! After delivering 4 hours of SQL Server DB engine architecture, it was getting so difficult to switch to BI instantly; I mean mentally, it was not easy. It looked like a paradigm shift. It took me while to get over the hang of DBA stuff and get into the BI shoes – probably because I do not get into these arrangements too often. The second day was more taxing, since it was full of demos. First half, DBA demos & second half, Analysis Services demos – and I was so drained out at the end of the day. And it was a fun-moment when a friend of mine called me up and asked what assignment was I delivering? :)

So in this blog post, I want to talk about SQL Server Business Intelligence workshop which I delivered in the second half :).

This SQL Server training assignment in India was organized by Peopleware India – www.PeoplewareIndia.com

Prior to this assignment, I completed advanced Transact-SQL assignment in Hyderabad for Microsoft IDC– you can find that blog here: http://www.sqlservergeeks.com/blogs/AmitBansal/sql-server-bi/629/completed-advanced-transact-sql-workshop-hyderabad-january-2012

This delivery on SQL Server Business Intelligence was not a very advanced one. I was required to discuss only up to Level 200/300. And I included most of it: Analysis Services, Integration Services & Reporting Services. Time did not permit us to talk about SharePoint which I would have loved to do. Analysis Services is my favorite and I get a bit partial in spending more time with this tool. And I made it a point to get into a bit of MDX – demoing ParallelPeriod and PreviousPeriod functions !

The audience was very interactive and they matched my speed of executing labs, and I was glad to make new friends, as always.

Here are is the Pic from the class:

More pics can be seen from my FaceBook page at: http://www.facebook.com/#!/media/albums/?id=165298110161387

The gallery page on Peopleware India site is updated as well: http://www.peoplewareindia.com/gallery.htm

In my next blog post, I shall write about the first half, the DBA part!

If you are looking for SQL Server training / consulting for your company / people, you can write to enquiry<at>peoplewareindia<dot>com or visit www.PeoplewareIndia.com

Have a SQL Server question? Join the fastest growing SQL Server facebook group at: http://www.facebook.com/groups/458103987564477/

Regards
Amit Bansal

www.FaceBook.com/AmitRSBansal
www.twitter.com/A_Bansal
www.twitter.com/SQLServerGeeks
www.amitbansal.net