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: http://www.peoplewareindia.com/gallery.htm

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 www.PeoplewareIndia.com