Completed: SQL Server BI workshop in Bangalore 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 mentioned in my last blog that this has been a seasons of multiple batches for the same client. 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! I blogged on the Chennai assignment which you can read here;

This blog post is for the Bangalore batch.

This was again a 5 day BI workshop 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.

Just like the last batch, 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. This time also went deep in to working with Account Dimensions, etc. Feedback said that audience just loved it.

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. We also discussed a few tuning techniques & debugging in SSIS.


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. In fact, people inside the classroom make the training successful and all kudos to them !

Here are is the pic from the class:


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

Next, I travel to Pune. 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.