When you come to use PowerPivot in a real project, you'll need to know how to write calculations in DAX, PowerPivot's own calculation language. This session covers the basic DAX concepts and then describes how to implement common business calculations such as year-to-dates, previous period growths, and distinct counts.

19:30 - 20:00 Break

20:00 - 21:00 Case StudyAndrew Sadler, Hitachi consulting

Case Study: Come see how Square Enix have used SQL server to deliver player leaderboards and gamer stats for their recent game release JustCause2 - http://www.justcause2.com . JustCause2 is a very popular game (currently approx 700,000 unique players) which incorprates some significant internal metrics. Hear about the challenges of aggregating 7 billion rows of data, and how this was achieved cost effectivrly.