Minnesota Microsoft BI User Group 2012 Q2 Meeting–June 5
Posted by denglishbi on May 10, 2012
The next MN Microsoft Business Intelligence User Group has been scheduled and the agenda is set. This meeting we will have two sessions starting out with an adventure into MDX with the Star Trek experience and then a presentation about agile business intelligence with SQL Server 2012. Just a reminder that the location for this event has now moved to the Microsoft Technology Center location in Edina.
MN Microsoft BI User Group 2012 Q2 Meeting
Date: Tuesday, June 5, 2012
Check In: 2:30 PM Event Time: 3:00 PM – 6:00 PM
Location: Microsoft Technology Center – 3601 76th St W, Suite 600 Edina MN 55435 (in LOW 1, 2, and 3)
To join via Live Meeting: Click Here
- 2:30-3:00 : Registration
- 3:00-3:15 : Microsoft BI User Group Updates & Announcements
- 3:15-4:30 : MDX Trek: First Contact
- 4:30-4:45 : Break
- 4:45-5:30 : Agile BI with SQL Server 2012
- 5:30-6:00 : Social and Networking
MDX Trek: First Contact (by Mark Vaillancourt, Digineer) – Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment.
Agile BI with SQL Server 2012 (by Neelesh Raheja, GNet Group and Terry McDonald, Pentair) – There is always pressure from business users to deliver flexible, fast, self-service and cost effective BI/Data Warehouse solutions. Going into a BI project, we expect that business requirements will evolve and change; one business question will lead to another, creating challenges in managing scope, iterations, timelines and costs. With a traditional waterfall BI project execution approach it can take several months to incorporate new functionality in a data warehouse and update reports, creating a backlog and falling short of users’ expectations.
In this session we will show how agile BI project execution can be implemented using Microsoft SQL Server 2012. We will explore how PowerPivot and Analysis Services 2012 enable additional flexibility; accelerating the time it takes to deliver value with BI projects. Agile techniques along with self-service tools offer an opportunity to transform traditional BI project development methods to fit dynamic user requirements and accelerate development, testing and deployment. We will also present a strategy, process and key considerations for using Agile techniques to promote ad-hoc self service reports to a corporate BI solution.
Hope to see you there!