The next MN Microsoft BI user group meeting is coming up next Tuesday on September 9 from 3 to 6. This meeting will have two presentations, the first one on forward looking dashboards & KPIs and the second on is a case study on monitoring Analysis Services usage. Please register so that we can have your name badge pre-printed.
MN Microsoft BI User Group 2014 Q2 Meeting
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)
Please Register Now (Please register so that we can have your name badge pre-printed)
- 2:30-3:00 : Registration
- 3:00-3:15 : Microsoft BI User Group Updates & Announcements
- 3:15-4:15 : Looking Through the Windshield: Creating Forward-Looking Dashboards and KPIs
- 4:15-4:30 : Break
- 4:30-5:30 : Case Study: Monitoring SSAS Usage with Extended Events
- 5:30-6:00 : Social and Networking
Session 1: Looking Through the Windshield: Creating Forward-Looking Dashboards and KPIs
It is dangerous to drive forward while looking through the rear window. The same is true about guiding our organizations forward while looking only at the past. Yet, much of our business intelligence shows only the past. This session explores simple techniques to make our dashboards and KPIs visualize what is likely in the future. No fancy predictive algorithms are necessary–just an appreciation of what we know about our organization’s future and a recognition of past trends that are likely to continue.
Speaker: Brian Larson
Brian Larson is the Chief Technology Officer at Superior Consulting Services and has presented at SQL Server Connections, the PASS Summit and the Microsoft BI Conference. As a consultant to Microsoft, Brian contributed to the original code base of Reporting Services. Brian is the author of “Microsoft SQL Server 2012 Reporting Service: 4th Edition” and “Delivering Business Intelligence with SQL Server 2012: 3rd Edition” as well as co-author of “Visualizing Data with Microsoft Power View.”
Session 2: Case Study: Monitoring SSAS Usage with Extended Events
How do you measure the success of a Self Service Business Intelligence initiative? While the answer to that question has several components, a vital one is Adoption. Are people using the assets created for that initiative? Since Business Intelligence is using data to make better decisions, why not use data to help answer this question? At Capella University, we did just that.
This case study will describe how we used Analysis Services Extended Events to track the usage of Tabular Models that Capella built for Self Service BI users. We will demonstrate the following:
- The business case for capturing asset usage
- The particular goals Capella had in this case
- How easy it is to get started with SSAS Extended Events (far easier than it looks)
- The end-to-end solution created: from the event trace itself thru to the Power Pivot model created for analysis
- Lessons learned (some learned the hard way)
We hope you will come away from this presentation with less trepidation around SSAS Extended Events as well as a foundation you can use for your own solution.
Speakers: Prashant Tolia and Mark Vaillancourt
Prashant Tolia is the Senior Technical Architect for the Information Delivery department at Capella University. He has over 16 years of experience in IT and a passion for Business Intelligence and Data Warehousing. Prashant earned his MBA form Capella and holds certifications as an Oracle DBA and in Cognos BI suite. In his current role, Prashant ensures that all technical solutions are cost effective, appropriate, and adhere to Capella standards and best practices.
Mark Vaillancourt is a SQL Server MVP and a Business Intelligence Enterprise Consultant for Digineer, a Microsoft partner based in Plymouth, MN. He has been working with SQL Server since 2007 and holds the MCITP – Business Intelligence Developer 2008 certification. With a background in Theater and Improvised Comedy, Mark makes sure that his presentations are both informative and fun.