Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Posts Tagged ‘msbimn’

MN PASS Microsoft BI User Group Meeting – Apr 25

Posted by denglishbi on April 25, 2016

The next MN Microsoft BI User Group meeting is today Monday, April 25.  We will have two topics, one is a case study for Andersen Corporation and the other is on using R in Power BI!

Please Register Now (Please register so that we can have your name badge pre-printed)

MN Microsoft BI User Group April 2016 Meeting

Sponsored by:

image[12]MSFT_logo_Page

Date: Monday, April 25, 2016

Check In: 12:45 PM Event Time: 1:00 PM – 5: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:

  • 12:45-1:00 : Check-In
  • 1:00-1:45 : Pizza Lunch
  • 1:45-2:00 : Microsoft BI User Group Updates and Announcements
  • 2:00-3:00 : Andersen Corp’s Journey with Microsoft BI: A Business Perspective
  • 3:00-3:15 : Break
  • 3:15-4:15 : Introduction to and Using R with Power BI
  • 4:15-5:00 : Networking

Presentations:

Session 1: Andersen Corp’s Journey with Microsoft BI: A Business Perspective

Lessons learned, Roll out approach, Real examples of how our sales team and leadership group use Microsoft BI tools at Andersen Corp

Speaker: Stephanie Smith

Stephanie Smith is the Retail Insight and Sales Support Manager at Andersen Corporation. While in this role she has used Microsoft BI extensively to help expand the team’s analytic and reporting capabilities.

Session 2: Introduction To and Using R with Power BI for Insightful Visualizations with Advanced Analytics

In this presentation we will explain and demonstrate how to use advanced analytics with Power BI and R visualizations to unlock hidden insights. Learn how to get started using R and take Power BI to the next level.

Speaker: Lily Vergara

Lily Vergara is a Business Intelligence Analyst at GNet Group, where she helps customers implement Self Service with Power BI and advanced analytics with R. She has BI and analytics in human resources, manufacturing, and retail.

Planning on attending the PASS Summit?  If so, make sure to associate yourself with our user group and receive a $150 discount on registration!

PASS Summit 2016 – Use the following code to save $150 off registration LC15FML4

Posted in Training | Tagged: , , , | Leave a Comment »

Minnesota Microsoft Power BI User Group Feb 22 Follow Up

Posted by denglishbi on February 23, 2016

Today we kicked off the 2016 year with two presentations, one on SQL Server 2016 and the other on Power BI.  Will Weber (@WilliamWeber) did the first presentation and I did the one covering the majority of the items that have been released for Power BI since I last spoke to our group last June. Wow, that was quite a daunting task, the Microsoft Power BI team has gone crazy and is doing a phenomenal job.

Here is the content I presented and for the demos I covered some of the key new features, but I think I might have glossed over a few as well as skipped a few that I wanted to cover, just not enough time to try and tackle this in an hour:)

 

The slides do include links, so reference those for more additional information and the complete list of updates, just remember this is not everything, just some of the key items that I selected;)

I also showcased a new Power BI report, Power BI Ideas, that I put together that is based on the Power BI Ideas area.  I thought this would be interesting to show people the items that were completed, that are started, and also being planned for.  That way they could get a good feel to how the User Voice really matters and that people need to use this to submit as well as vote on items, it really does make a difference.

image

(apologize, I am using WordPress.com which does not allow for the embedding of iFrames, so the image will send you to a link to run the live report)

This report above took some time and work to put together. The Ideas forum area does not have the data in a table, it is all in a list. Plus it appears on multiple pages, so a bit of screen scraping had to be performed. Then you realize that that completed and declined ones are not include in the normal pages. So it took some time and work to compile the file. I have thought about moving the source file to OneDrive and then updating that file using Power Update, we will see.

Some other areas that I wanted to mention that I forgot were some of the nice showcase areas available that include live examples you can interact with:

Department Solutions

Industry Solutions

Partner Showcase

Best Report Finalists

Power BI Showcase

We had great attendance too today, the even was sold out and standing room only, with approximately 120 people in attendance, outstanding!

IMG_20160222_1414154_rewind

And “Yes”, that is my work Surface Pro 3 at the bottom right. Are you on team Captain America or team Iron Man?

I can’t wait till May 6!

I also forgot that I had some Power Bars (I thought that was kind of fitting for my Power BI topic…) to give away during my presentation, so I just randomly tossed them out to some attendees afterwards.

IMG_20160222_1424547_rewind

Looking forward to another exciting year of Power BI announcements, the roadmap ahead is looking very good!

Posted in Training | Tagged: , , | Leave a Comment »

MN PASS Microsoft BI User Group Meeting – Feb 22

Posted by denglishbi on February 9, 2016

The next MN Microsoft BI User Group meeting is coming up in a couple of weeks on Monday, February 22.  We will have two topics, one on the upcoming release of SQL Server 2016 (which CTP 3.3 was just released) and the other on Power BI (all of the new content since I last spoke on it last year – which is a lot of content).

Please Register Now (Please register so that we can have your name badge pre-printed)
image

MN Microsoft BI User Group Feb 2016 Meeting

Sponsored by:

image[12]MSFT_logo_Page

Date: Monday, February 22, 2016

Check In: 12:45 PM Event Time: 1:00 PM – 5: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:

  • 12:45-1:00 : Check-In
  • 1:00-1:15 : Microsoft BI User Group Updates and Announcements
  • 1:15-2:15 : SQL Server 2016
  • 2:15-2:30 : Break
  • 2:30-3:30 : Getting the new year started with Microsoft Power BI!
  • 3:30-5:00 : Networking and Pizza

Presentations:

Session 1: SQL Server 2016

Microsoft is continuing to invest heavily in BI and Analytics with SQL Server 2016. Reporting Services and Analysis Services are receiving major enhancements and will deliver modern and mobile reporting as well as powerful modeling capabilities. SQL 2016 also brings new advanced analytic capabilities with R Services and enables hybrid BI scenarios to benefit from existing on-premises investments. In this sessions we’ll go over the new BI features of SQL 2016 and talk about the future of BI in SQL Server.

Speaker: Will Weber

Will Weber is a Data Platform Solution Architect with Microsoft. He’s been an active participant in the SQL community in the Twin Cities for a number of years and looks forward to continuing that work in the future. And if the PowerBall gets back up to $1.5 billion he’ll definitely consider buying a ticket.

Session 2: Getting the new year started with Microsoft Power BI!

In this session we will take a look at the changes that Microsoft has released for the Power BI Service, Power BI Desktop, and Power BI Mobile Apps. Microsoft continues to release updates to Power BI on a weekly and monthly basis. Some of the changes since we last met include items such as Custom Visualizations, Full Screen Mode, Pop-Out for Visualizations, Printing, Export Data, QR Codes, Excel Add-In, Widgets, R Visuals Integration, Improved Image Support, and much, much more. Come and check out all of the latest capabilities of Power BI and be amazed!

Speaker: Dan English

Dan is the Senior Data Warehouse Architect at Constellation, Inc. He is also a Microsoft Data Platform MVP, author, technical editor, and community leader. He has been developing with Microsoft technologies for over 15 years, and over 10 years with Data Warehousing and Business Intelligence. He has been working with SQO Server since version 6.5 through 2014 and is exploring 2016. Dan has videos on Vimeo, is an avid blogger, and tweets. Dan is the chapter leader for the PASS Business Analytics VC and on the executive leadership team for the MN Microsoft BI User Group.

Planning on attending the Data Insights Summit or the PASS BA Conference?  If so, make sure to associate yourself with our user group.

Data Insights Summit – Our 3-digit Power BI User Group (PUG) code is 102.

PASS BA Conference – Use the following code to save $100 off registration USMO03

Posted in Training | Tagged: , , , , | Leave a Comment »

MN PASS Microsoft BI User Group Q4 2015 Meeting – Dec 16

Posted by denglishbi on November 25, 2015

We are pleased to announced the next MN Microsoft BI User Group on Wednesday, December 16.  We have two presentations this quarter, one on HDInsight and Power BI and the other on Azure Machine Learning. Please register ahead of time and make sure to bring a photo id to get into the meeting. We are also pleased to announce that we are one of the initial user groups to also be recognized as an official Microsoft Power BI user group!

Please Register Now (Please register so that we can have your name badge pre-printed)
image

MN Microsoft BI User Group 2015 Q4 Meeting

Sponsored by:

image[12]MSFT_logo_Page

Date: Wednesday, December 16, 2015

Check In: 2:45 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:45-3:00 : Check-In
  • 3:00-3:15 : Microsoft BI User Group Updates and Announcements
  • 3:15-4:15 : Powering Up HDInsight with Power BI
  • 4:15-4:30 : Break
  • 4:30-5:30 : Rise of the Machine (Learning)
  • 5:30-6:00 : Networking and Pizza
Presentations:
Session 1: Powering Up HDInsight with Power BI

Join Steve Hughes as he walks through two techniques for working with data in HDInsight. In the first example, he will use Power Query to interact with the files in HDInsight. In the second example, he will use Power BI Desktop and Hive to work with the same data. Throughout the session, he will highlight some of the features within Power BI that can be used to explore data stored using Hadoop on HDInsight.

Speaker: Steve Hughes

Steve is a Principal Consultant at Pragmatic Works. He is currently responsible for guiding the Principal Consultant team and working with other areas in the organization to build out their data and analytics offerings. His area of expertise is in data and business intelligence architecture on the Microsoft SQL Server platform. He was also the data architect for a SaaS company which delivered a transportation management solution for fleets across the United States. Steve has co-authored three books and delivered many presentations on SQL Server and data architecture over the past six years. He also provides insights from the field on his blog at http://www.dataonwheels.com.

Session 2: Rise of the Machine (Learning) – Azure ML in BI, in Apps, and as a product in Azure Marketplace

Machine Learning no longer requires expensive infrastructures and knowledge of specialized statistical coding languages. Azure ML lowers the barriers of entry for predictive analytics using Machine Learning.

In this session, review the similarities and differences of Machine Learning compared to traditional Predictive Analytics, Data Mining, Data Science, and Artificial Intelligence. Learn how to integrate predictive analytics into your existing analytics and reporting strategy and infrastructure. Greg will demonstrate how a BI solution using only Excel with Power Pivot can connect to an Azure ML Model in the cloud for predictions and perform analysis with Power BI.

Learn how Azure ML can be used to add value to Apps. Also, review ways to turn your Azure ML Model into a source of revenue using Azure Marketplace. Machine Learning is now quietly rising all around us as it integrates with technology, improves processes and workflows, and transforms how data drives business. Empower your organization with new competitive advantages using Azure ML.

Speaker: Greg Beaumont

Greg is currently the Data Science Practice Lead at GNet Group, where he provides consulting services using Microsoft technologies. His industry vertical experience includes healthcare, manufacturing, logistics, retail and public/government data. Greg has been working in Analytics since 2007, and enjoys designing and building specialized solutions using tools and methodologies such as Six Sigma, Healthcare Performance Measures, Price Analytics and Predictive Analytics. He frequently writes blogs on use of analytics and visualizations http://blog.gnetgroup.com

Posted in Training | Tagged: , , , | 1 Comment »

MN PASS Microsoft BI User Group Q3 2015 Meeting – Sept 18

Posted by denglishbi on September 8, 2015

We are pleased to announced the next MN Microsoft BI User Group on Friday, September 18.  We are honored to have Kamal Hathi, the Director of Program Management of Business Intelligence at Microsoft, travel to MN to do a keynote presentation on Power BI. Please register ahead of time and make sure to bring a photo id to get into the meeting.

Please Register Now (Please register so that we can have your name badge pre-printed)
image

MN Microsoft BI User Group 2015 Q3 Meeting

Sponsored by:

image[12]MSFT_logo_Page

Date: Friday, September 18, 2015

Check In: 8:30 AM Event Time: 9:00 AM – 11:30 AM

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:

  • 8:30-9:00 : Registration and Welcome Reception
  • 9:00-10:30 : Power BI Keynote Presentation
  • 10:30-11:00 : Q & A
  • 11:00-11:30 : Prize drawing and Networking

Presentation:

Session: Power BI Keynote Presentation

With Microsoft Power BI generally available, we are excited to bring it to you. It doesn’t matter if you’re already familiar or new with Power BI. Kamal will share how powerful and simple it is to connect to and visualize your data.

Connect to fellow data professionals, hear first-hand from Power BI product team about what you can do with Power BI and where it’s headed. It doesn’t matter if your data is in the cloud or on-premises: Power BI can help you make sense of it.

Speaker: Kamal Hathi

Kamal is the Director of Program Management, Business Intelligence at Microsoft. Kamal manages the overall strategy, design and delivery of Microsoft business intelligence technologies. Microsoft delivers an innovative set of tools and services for data visualization and analytics that help organizations worldwide gain insights on data at all scales.

Since joining Microsoft in 1996, Hathi has served in engineering management roles in various product groups. He has 20 years of experience in data analysis and visualization and was one of the founding members of Microsoft’s business intelligence efforts. Before working with Microsoft, Hathi’s diverse work history included experience in research and consulting. He has a graduate degree in engineering from Case Western Reserve University.

PASS Summit Conference 2015 Discount Code – save $150 – LC15FML4

Members of the PASS Chapter, Minnesota Microsoft BI User Group can save $150 off their

PASS Summit 2015 registration by using the unique Chapter discount code: LC15FML4

http://sqlpass.org/summit/2015/RegisterNow.aspx

Posted in Training | Tagged: , , , | Leave a Comment »

MN Microsoft BI User Group Special Edition Meeting–June 10

Posted by denglishbi on June 9, 2015

We are pleased to announce that there will be a Special Edition meeting tomorrow on June 10.  Devin Knight from Pragmatic Works is in town and he will be presenting on SSIS tomorrow night for our user group. Please register ahead of time and make sure to bring a photo id to get into the meeting.

Please Register Now (Please register so that we can have your name badge pre-printed)
image

MN Microsoft BI User Group 2015 Special Edition Meeting

Sponsored by:

image

Date: Wednesday, June 10, 2015

Check In: 5:00 PM Event Time: 5:30 PM – 7: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:

  • 5:00-5:30 : Registration, Announcements, Hospitality and Networking
  • 5:30-6:45 : Adapting your SSIS Solutions to use the Project Deployment Model
  • 6:45-7:00 : Prize giveaways sponsored by Pragmatic Works

Presentations:

Session: Adapting your SSIS Solutions to use the Project Deployment Model

SSIS in SQL Server 2012 had a significant overhaul to its architecture and it is important to understand how these changes can make your development life easier. These changes impact how you deploy, configure and manage SSIS packages. This session will guide you through how to integrate the features that come with the Project Deployment Model in SSIS into your solution as well as how you can upgrade existing solutions to use the new model.

Speaker: Devin Knight

Devin is the Training Director for Pragmatic Works. He is a Microsoft SQL Server MVP, an author of five SQL Server books and leads his local user group in Jacksonville (JSSUG).

PASS Summit Conference 2015 Discount Code – save $150 – LC15FML4

Members of the PASS Chapter, Minnesota Microsoft BI User Group can save $150 off their

PASS Summit 2015 registration by using the unique Chapter discount code: LC15FML4

http://sqlpass.org/summit/2015/RegisterNow.aspx

Posted in Training | Tagged: , , | 1 Comment »

MN PASS BI User Group Q2 2015 Meeting – June 2

Posted by denglishbi on May 29, 2015

The next meeting for the Minnesota Microsoft BI User Group is next Tuesday, June 2.  This meeting will have two presentations, the first one is on the new Power BI Preview and the second one is on Datazen.  Please register so that we can have your name badge pre-printed.

*There will be a HP Stream 7 tablet given away during the networking session!
image

MN Microsoft BI User Group 2015 Q2 Meeting

Sponsored by:

image[12]MSFT_logo_Page

Date: Tuesday, June 2, 2015

Check In: 2:45 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:45-3:00 : Registration
  • 3:00-3:15 : Microsoft BI User Group Updates & Announcements
  • 3:15-4:15 : The “New” Power BI Service Walkthrough
  • 4:15-4:30 : Break
  • 4:30-5:30 : Achieving Enlightenment with Datazen. Anywhere!
  • 5:30-6:00 : Eval Collection, Prizes, Networking, and Pizza

*There will be a HP Stream 7 tablet given away during the networking session!

Presentations:
Session 1: The “New” Power BI Service Walkthrough

In this session, we will discuss the changes that are coming to Power BI and the new features that are provided with the Power BI Designer as Microsoft continues its roadmap with self-service BI. If you haven’t seen this yet, Power BI features are now available in a standalone application outside of Excel! You will see with the new designer that you will be able to easily integrate data, create stunning and interactive visualizations, and even create cloud based Power BI dashboards to share and it is even Free!! In this session we will also cover the mobile side of Power BI looking at the new Power BI apps for both Windows and iOS.

Speaker: Dan English

Dan English is the BI Practice Manager at Superior Consulting Service and is a SQL Server MVP, co-author, and technical editor. He has been developing with Microsoft technologies for over 15 years, and over 8 years with Data Warehousing and Business Intelligence. He has been working with SQL Server since version 6.5 through 2014 and is getting ready to explore 2016. Dan has screencasts and videos on Vimeo, is an avid blogger, and tweets. Dan is on the executive leadership team for the MN Microsoft BI user group and the chapter leader for the PASS Business Analytics Virtual Chapter.

Session 2: Achieving Enlightenment with Datazen. Anywhere!

In this session we will examine the capabilities offered by Datazen, one of Microsoft’s latest acquisitions. Datazen allows you to present a highly customizable unified view of data across the enterprise. We will look at the authoring experience and integration with data sources ranging from ad hoc Excel reports to SQL Server and SSAS cubes.

The best part of it all? You can take everything with you. With native apps on Android, iOS, and Windows 8 and HTML5 rendering, your data is available anywhere, anytime.

Speaker: Greg Baldini

Greg Baldini is a BI Analyst with GNet Group. He is an experienced BI professional who has executed multiple projects delivering Enterprise BI and data warehouse solutions using the Microsoft BI Stack, which includes SSIS, SQL Server, Analysis Services, Power Pivot, Reporting Services, SharePoint, Power BI and Datazen. An expert in creating Agile BI solutions using PowerPivot/Tabular/ DAX. His experience spans verticals such as – manufacturing, healthcare, fraud analysis, marketing pipelines, and sales performance.

PASS Summit Conference 2015 Discount Code – save $150 – LC15FML4

Members of the PASS Chapter, Minnesota Microsoft BI User Group can save $150 off their

PASS Summit 2015 registration by using the unique Chapter discount code: LC15FML4

http://sqlpass.org/summit/2015/RegisterNow.aspx

Analytics with Power BI Workshop – 6/9,10 (Discount Code)

Pragmatic Works has created a discount code that will give users 25% off their workshop purchase. This code is valid until May 31, 2015
Discount Code: WSDISCOUNT

http://pragmaticworks.com/Training/Workshops/Business-Analytics/Schedule/6-9-2015_MinneapolisAnalyticswithPowerBIWorkshop

Posted in Training | Tagged: , , | 1 Comment »

MN PASS BI User Group Q1 2015 Meeting – March 3

Posted by denglishbi on February 12, 2015

The first meeting of the 2015 year is coming up in a couple of weeks on Tuesday, March 3 for the MN Microsoft BI User Group.  This meeting will have two presentations, the first one is a healthcare case study and the second one is on Power Query.  Please register so that we can have your name badge pre-printed.


image

MN Microsoft BI User Group 2015 Q1 Meeting

Sponsored by:

image[12]MSFT_logo_Page

Date: Tuesday, March 3, 2015

Check In: 2:45 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:45-3:00 : Registration
  • 3:00-3:15 : Microsoft BI User Group Updates & Announcements
  • 3:15-4:15 : Healthcare Case Study: DW and BI
  • 4:15-4:30 : Break
  • 4:30-5:30 : Power Query: Data Chemistry for the Masses
  • 5:30-6:00 : Eval Collection, Prizes, Networking, and Pizza

Presentations:

Session 1: Healthcare Case Study: DW and BI

Implementing and enhancing a vendor supplied Data Warehouse and Business Intelligence solution in Healthcare is a significant undertaking. Join Ann Warner and Ross McNeely as they discuss the benefits of launching a vendor supplied solution, and the challenges in expanding the data model to meet the needs at HealthEast Care System. As an Accountable Care Organization (ACO) HealthEast required a new platform to support new analytics across current and legacy systems. We will breakdown how dashboards were developed to help drive down duplicate patient records using Microsoft’s MDS and Power BI. Analyzing health systems and payers will give hospitals and clinics insight into care quality, cost accountability, and patient loyalty.

Speaker: Ann Warner and Ross McNeely

Ann Warner is the Data Engineering and Application Manager at HealthEast Care System.  As the Manager of the Data Engineering team, Ann is responsible for building and managing the team for Data Governance, Operational Data Store, and Epic’s Cogito Data Warehouse.  Ann has experience creating and staffing data warehouse development efforts for higher education, finance, banking, credit card risk, manufacturing, logistics, sales, and marketing.

Ross McNeely is a Principle Consultant and the BI Practice Manager at Tail Wind. Ross has presented at DAMA-MN, SQLSaturday, PASSMN, Microsoft BI User Group MN, and ERworld 2012. Ross adds real-world examples from various industries in his presentations. Regardless if you have a beginner, intermediate, or advanced skill set, Ross will provide a solid foundation for each topic he presents.

Session 2: Power Query: Data Chemistry for the Masses

ETL Developers have being doing chemistry with data for years in tools like SQL Server Integration Services. These tools require training, experience, and time that few business users have. But in the age of self-service BI, those business users need a way to shape data to support their analysis.
This session will show how Power Query can be easily used to take advantage of data’s properties to drive the change we need to support our goals.
We will discuss/demonstrate:

  • The simple process of accessing a wide variety of data sources
  • The ease with which simple transformations can be achieved using the Power Query Ribbon
  • Power Query’s fantastic ability to travel through time to see every step taken with the data
  • The foundations of the Power Query Formula Language, informally known as "M"
  • Using "M" to take Power Query WAY beyond what the Ribbon has to offer.

Come learn about what may well be the most exciting member of the Power BI family.

Speaker: Mark Vaillancourt

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 Business Analytics Conference 2015 Discount Code – save $150 – USMO03

Save $150 on your registration to PASS Business Analytics Conference, April 21-22 in Santa Clara, CA, using our chapter’s discount code: USMO03. Feel free to share this discount code with friends or colleagues!
http://passbaconference.com/2015/Home.aspx

Posted in Training | Tagged: , , | Leave a Comment »

Minnesota Microsoft BI User Group 2014 Q4 Meeting–Dec 2

Posted by denglishbi on November 25, 2014

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.


image

MN Microsoft BI User Group 2014 Q4 Meeting

Sponsored by:

MSFT_logo_Page

Date: Tuesday, December 2, 2014image

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.

Posted in Training | Tagged: , , | Leave a Comment »

Minnesota Microsoft BI User Group 2014 Q3 Meeting–Sept 9

Posted by denglishbi on September 3, 2014

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.image

MN Microsoft BI User Group 2014 Q3 Meeting

Sponsored by:

MSFT_logo_Page

Date: Tuesday, September 9, 2014image

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 : 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

Presentations:

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.

Posted in Training | Tagged: , , | Leave a Comment »

 
Follow

Get every new post delivered to your Inbox.

Join 2,215 other followers