SQL Server: Completed-BI workshop in Hyderabad September 2011

Hi Friends,

Today, while I write this blog, I am at Microsoft campus in Redmond attending the SQL BareMetal workshop.

Here is something about my BI assignment that I delivered for Microsoft IDC in September 2011. As usual, there is so much that I learnt in this assignment. I met new minds, new personalities, got to know their SQL stories, their issues, remedies, tips, tricks, techniques and bunch of little things! Every assignment makes me a better SQL guy and a better person too 🙂

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

Previous to my BI assignment, I had delivered a T-SQL batch for MS IDC in the same week. I blogged about that here;

After completing the T-SQL workshop, I delivered the BI assignment in the same week . This was my 12th workshop at MS IDC.

This was a 3 day workshop on Microsoft SQL Server Business Intelligence platform and I covered Analysis Services, Integration Services & Reporting Services. Yes, 3 days is too short to cover these subjects but the need of the hour was to cover some important topics in the stipulated period of time. I started off with advanced DW concepts and we had some good discussions around surrogate keys. This was followed by Analysis Services and I tried my best to cover many aspects of SSAS including Dimensions Modeling best practices, KPIs, Reference & Fact Designs, Calculated Members, Aggregations and a little bit on MDX. I then moved on to SSIS and the key focus of my workshop was Fuuzy Grouping, Fuzzy Lookups, SCD & incremental fact & dimensional load design. I was only left with half a day to and covered a few things related to Reporting Services. All in all, it was a hectic 3 day workshop on BI (only from SQL Server prespective).


The audience at Microsoft was so very professional, many of them knew the subject so well – 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! And I made a few friends 🙂 – as always!

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 batch was a T-SQL batch in Gurgaon for the IT arm of one of the largest insurance company in US. 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




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: http://sqlmaestros.com/amit-bansal/ He is on Twitter: https://www.twitter.com/A_Bansal

View all posts by Amit Bansal →

Leave a Reply

Your email address will not be published.