Completed: SQL Server BI workshop in Chennai August 2011

Hi Friends,

I like writing about my trainings – there is so much to learn in every training assignment. I get to meet new minds, new personalities, get to know their SQL stories, their issues, remedies, tips, tricks, techniques and bunch of little things !

This SQL Server training assignment in India was organized by Peopleware India

I last blogged about my performance tuning training for a leading global bank. The blog is here

My next assignment brought me back to Chennai. And before I talk technical, let me tell you that my stay in Chennai on previous occasion was not good 🙁 – and this time I desperately needed a change. I landed up staying in Hotel Savera and I must say – it was a welcome change !

Back to SQL – this was a BI workshop for 5 days and I was required to cover SSAS, SSIS & SSRS. Yes, it is indeed very difficult to cover all the three components in 5 days, but justifiably, even the client cannot let their people sit in classroom for 9 working days, assuming 3 days on each component. This training was for one of the leading global giants in IT services space.

I took up the challenge to deliver this. There was a special thrust on SSAS & MDX and I just loved that. I spend 3 days on SSAS with approximately 4 hours on MDX and talked about everything I could including UDM, SCDs, Many-to-Many Dimension, Semi-Additive Measures, etc. Feedback said that audience just loved it. I went on to spend 4 hours on MDX and loved talking about the difference between .members & .children function 🙂


Followed by SSAS, I covered some specific topics in SSIS & SSRS including Fuzzy Lookup, Fuzzy Grouping, Map Layer controls, etc. We spent a good deal of time in building an SSIS package for incrementally loading FACT & Dimension tables.

The audience was very patient, cooperative and active – they matched my speed of doing the labs and it was a real pleasure knowing & interacting with them. Thanks to all the folks.

This has been a seasons of multiple batches for the same client. Yes, last time it was 2 batches for the Bank, one in Gurgaon & another in Chennai. And this time I repeat the same batch in Bangalore after Chennai – back to back!

Here are is the pic from the class:


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

I shall write about the next batch shortly.

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.