The fourth quarter and final meeting of the year is coming up next week for the MN Microsoft BI User Group. This meeting will have two presentations, the first one on Azure Machine Learning and the second one 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 Q4 Meeting
Sponsored by:
Date: Tuesday, December 2, 2014
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)
Agenda:
- 2:30-3:00 : Registration
- 3:00-3:15 : Microsoft BI User Group Updates & Announcements
- 3:15-4:15 : Predictive Analytics for the Masses: Azure ML
- 4:15-4:30 : Break
- 4:30-5:30 : Case Study: Monitoring SSAS Usage with Extended Events
- 5:30-6:00 : Happy Hour at Pinstripes – Meeting will adjourn with a special networking opportunity hosted by Slalom Consulting. Join everyone at Pinstripes Edina at 3849 Gallagher Drive for refreshments, fun and networking.
Presentations:
Session 1: Predictive Analytics for the Masses: Azure ML
Predictive Analytics generally has the strongest ROI attached to it, but is unfortunately usually one of the last analytical capabilities on the modern enterprise’s Analytical Roadmap. Part of this is due to the fact that predicting the future generally requires some foundational data pieces and tools to be in place. The advent of the Cloud has disrupted many commonly held historical approaches as it can greatly reduce the time to market for the foundational pieces.
The Machine Learning product will be reviewed and a demonstration of the ML set-up and “how to” model 1-3 scenarios will also be covered.
Speaker: Joe Berg and Matthew Lawrence
Joe Berg is a Managing Director with Slalom Consulting and is responsible for the National Information Management & Analytics (IM&A). Joe has spent over 8 years working on business intelligence and data warehouse platforms as a consultant for Microsoft. In addition to his implementation and leadership roles on these projects, Joe has led a variety of successful engagements helping some of the worlds largest organizations develop a world-class Business Intelligence and Analytics capability.
Matthew Lawrence is an accomplished analytics professional with vast experience across many Fortune 500 companies using predictive and descriptive modeling skills in a variety of technical environments to solve a host of business problems. He has led successful analytics engagements from vision to implementation across technology platforms in a variety of data environments. He is skilled at asking the questions to get to the heart of the matter to uncover relationships that lead to actionable insight.
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.
PASS Summit 2014 Follow Up & Pictures
Posted by denglishbi on November 19, 2014
This month I headed out to the PASS Summit 2014 Conference which is the largest gathering of SQL Server and BI Professionals. I was fortunate enough to be able to attend this year because the Microsoft MVP Summit was also held that same week. So it had been a few years since I had attended the PASS Summit and I was excited to go back. I really appreciated the coordination of the two events and the fact that Microsoft was able to adjust the schedule for the SQL Server MVPs up one day to be able to attend, it was quite remarkable to partake in both events. I also have to thank my company, Superior Consulting Services, for providing me the opportunity to attend as well.
The first major event that I participated in at the conference was the #sqllongrun. Adam Machanic (b|t) organized an 11 or 14 mile run event this year in Seattle. It has been a goal of mine to run a 1/2 marathon, so I decided that this was going to be it! Unfortunately with my schedule I didn’t get to train as much as I probably should have, but I pushed myself the week prior to the event and I was quite impressed with my results. It turns out that not only did I run a 1/2 marathon, but I went a couple of miles more because apparently I didn’t start my watch at the start, sorry Reeves Smith (b|t), but I greatly appreciate your support and running the extra mile at the end with me when I thought I had only ran 12 miles!
What a great event and looking forward to my next 1/2 marathon now that I have a benchmark, thanks to Adam for organizing, SQL Sentry for sponsoring, and everyone that participate for your support and encouragement!
Now on to the main event, but not until we do a few more runs, right? I ended up running each morning with some of the other #SQLFamily members such as Ted Krueger (b|t) and Tim Radney (b|t). Each day I ran a 5k with the exception of Thursday (took one day off for rest). I also took part in the #sqlrun organized by Jes Borland (b|t) and thanks SQL Sentry for sponsoring.
So the main event, the PASS Summit.
Day 1
On Wednesday we found out from the PASS President Thomas LaRock (b|t) that there were 50 countries, 2000 companies, and around 5900 attendees at the conference, simply amazing! Currently there are 285 PASS Chapters, 27 Virtual Chapters, and there were 86 SQLSaturday events this year, over 1.3 million hours of training provided by the community, awesome!!! I was really looking forward to the Day 1 keynote to hear each of the three core leaders of the Microsoft Data Platform talk – T.K. “Ranga” Rengarajan, James Phillips, and Joseph Sirosh.
The day did not stop there, I checked out the community zone, some great sessions, and got special seating up front because of my PASS Outstanding Volunteer recognition. I even attended the PASS Virtual Chapter meeting and met my Paras Doshi (b|t) who is the other chapter leader for the PASS Business Analytics VC with me! Paras is awesome to have on the team, simply amazing, can’t say enough, great asset to have and really looking forward to next year to see what we can do next!
Day 2
My friend Adam Jorgensen (b|t) the PASS Executive Vice President of Finance kicked off the keynote on day 2 and discussed plans and revenue, incredible that the PASS Summit brings in $5.9M. Denise McInerney (b|t) the PASS VP of Marketing also talked and went her personal growth story going from attending a local event up to where she is today, amazing! They announced the PASSion Award winner, Andrey Korshikov (b|t), congrats! Then Rimma Nehme gave the big talk on Cloud Databases 101 (21:55). Her humor and slides were outstanding and made the content easy to relate to and enjoyable, thanks! Who can’t understand the cloud services when you compare it to PIZZA (see image below)! Now DBAs that are learning and using the cloud based services can update their titles to Cloud DBA, time to soak it in and make the most out of this opportunity while it is really kicking in high gear now with the hybrid solutions.
While I was out there I also noticed a couple of great books in the bookstore that I was able to contribute to
I wish I could have stayed around for Day 3, lots of more great sessions that I had to miss out on, I had to get home to my family, it had been a long and exciting week with the MVP and PASS Summit events.
Let the countdown begin, PASS Summit 2015 will be October 27-30 next year! Register now and the rate is only $1195 (over 1/2 off until January 11)!
CONNECT + SHARE + LEARN = PASS SUMMIT!!!
Posted in Personal Comments, Training | Tagged: sqlpass, training | 1 Comment »