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 –

Prior to this assignment, I completed advanced Transact-SQL assignment in Hyderabad for Microsoft IDC– you can find that blog here:


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:


The gallery page on Peopleware India site is updated as well:

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




About Amit Bansal

Amit Bansal is always brainstorming around SQL Server. Despite working with SQL since 1997, he is amazed that he keeps learning new things every single day. SQL Server is AB's first love, and his wife does not mind that. He tries to share as much and spreads the SQL goodness. Internals and Performance Tuning excites him, and also gives him sleepless nights at times, simply because he is not a genius, but quite a hard worker and does not give up. It has been a long and exciting journey since 1997, you can read here: He is on Twitter:

View all posts by Amit Bansal →

Leave a Reply

Your email address will not be published.