SQL London User-Group 20th July 2011 with (Neil Hambly, Alex Whittles, Avanade)
Nearest Tube : St. Paul’s
Network, learn, ask a question, meet other folk, get fed - these are all things that happen at user group events. These events are a really great opportunity to socialise in an informal learning experience - if you want your own exposure then come and do a 1 - 5 minute nugget in front of your peers.
Remember to tell your friends and the people you work with; make sure you register as soon as you can.
5.45 – 6:15pm Registration and networking
Meet and greet. (5 minute Nuggets)
6:15 – 7:10pm Neil Hambly -
Further details on session will be posted soon
7:10 – 7:50pm Saurav (Avanade) Using Dynamic Security in SSAS
How to use dynamic SSAS security for roles and access to the cube. Performance consideration for dimensional & cell level security. Lessons learned from customer implementations.
7:50 – 8:10pm Break: Light refreshments
More time to network, ask questions and eat pizza...
8:10 – 9:00pm Alex Whittles - PowerPivot & QlikView 101
How to get started with PowerPivot and QlikView. This session will cover how to combine data sources, common pitfalls, adding some calculation logic and building a basic dashboard.
We’ll walk through the same example on both systems and compare the results, pros and cons of each.