Dan English's BI Blog

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

Archive for June, 2016

MN PASS Microsoft BI User Group Meeting – Jun 27

Posted by denglishbi on June 21, 2016

The next MN Microsoft BI User Group meeting is next week on Monday, June 27.  We will have two topics, one is a case study for Pyramid Analytics / Constellation, Inc. and the other is on using Streaming Analytics and Power BI!

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

MN Microsoft BI User Group June 2016 Meeting

Sponsored by:


Date: Monday, June 27, 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)

  • 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 : Constellation, Inc. Case Study and Pyramid Analytics
  • 3:00-3:15 : Break
  • 3:15-4:15 : Getting beyond hype and buzz words to understand how Power BI, Steaming Data, and Advanced Analytics can work together to solve business problems
  • 4:15-5:00 : Networking
Session 1: Constellation, Inc. Case Study and Pyramid Analytics

In this presentation Pyramid Analytics will talk about their Microsoft Strategic Alliance, PASS global alliance partnership, and provide a high level overview of the BI Office suite.  Constellation, Inc. will discuss their Data Warehouse and Business Intelligence story and use of Microsoft and Pyramid Analytics solutions.  We will also touch base on the new on-premise Power BI capabilities provided with the latest release of Power BI Desktop and v6.1 of BI Office!

Speakers: Andrew Mauch and Dan English

Andrew Mauch, Sales Director-Midwest and North Central

Results oriented sales and management professional striving to help companies unlock the power of their data.  Andrew has spent several years managing a consulting organization that built custom BI solutions from the Microsoft platform.  Seeing how companies struggled with BI and complex builds, led him to join Pyramid Analytics where BI is made simple, putting the power of BI in the end users hands with the governance of IT.

Dan English, Senior Data Warehouse Architect

Dan is the Senior Data Warehouse Architect at Constellation, Inc. and is a Microsoft Data Platform MVP, author, technical editor, and community leader. He has been developing with Microsoft technologies for over 15 years, and over 12 years with Data Warehousing and Business Intelligence. He has been working with SQL Server since version 6.5 through 2016. Dan has videos on Vimeo, blogs (https://denglishbi.wordpress.com), and tweets (@denglishbi). Dan is the chapter leader for the PASS Business Analytics VC and on the executive leadership team for the MN Microsoft BI user group.

Session 2: Getting beyond hype and buzz words to understand how Power BI, Steaming Data, and Advanced Analytics can work together to solve business problems

Devices are becoming smarter and more connected, and the expectation of what can be done with the data generated and collected from these devices continues to evolve both in the commercial and consumer spaces. Whether you are doing health monitoring, building or home automation, social media analytics, application monitoring, energy management, manufacturing, etc., there are millions of events or messages being generated from devices from which you need to gain real-time insights. In this presentation we will explain and demonstrate how Microsoft Cortana Intelligent Suite is used to get real-time insights by creating a scalable stream processing solution to analyze the content of these events, identify anomalies, trigger alerts, and power real-time dashboards. Come learn how to use the power of Stream Analytics & Power BI to create your real-time Internet of Things (IoT) solution.

Speakers: Paul Doyle and Johan Johnson

Paul Doyle, Director of BI Services, GNet Group

Paul is currently the Director of BI Services at GNet Group where he has helped customers in manufacturing, retail and insurance industries successfully implement enterprise data warehouse solutions and self-service BI. He has 15+ years of development experience with SQL Server, Power BI and advanced analytics. He was a contributing author of the Microsoft white paper, "Empowering Enterprise Solutions with SQL Server 2005 Enterprise Edition" and AppDev courseware "Microsoft SQL Server 2005 Integration Services". Paul holds a BA in Quantitative Methods & Computer Science from the University of St. Thomas, St Paul, MN.

Jonah Johnson, Solution Architect, GNet Group

Jonah is a Solution Architect for the GNet Group focusing on the Azure Platform and Big Data Analytics. He has nearly two decades of leadership experience building and evolving the technological infrastructure of enterprise corporations. In the most recent ten years Jonah has specialized designing business intelligence platforms and data warehousing solutions.

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 »

PASS Business Analytics VC June Meeting – What’s New in SQL Server Reporting Services 2016

Posted by denglishbi on June 14, 2016

The next PASS Business Analytics Virtual Chapter meeting is coming up this week on Thursday, June 16.  This month we welcome Dustin Ryan (b|t) who will talk to us about what’s new in Reporting Services 2016.

–> REGISTER NOW <–PASS_BAVC_Logo_New_201502

June 16 – What’s New in SQL Server Reporting Services 2016


SQL Server Reporting Services is getting a makeover with the release of SQL Server 2016. In this session, we’ll cover the new features of SSRS and how you can even take advantage of some of the new features in SQL Server. By the end of this session you’ll have a better understanding of the new capabilities of Reporting Services, how to create mobile reports, the new features of the Reporting Services portal, and more.

Bio –

Dustin is a Data Platform Solution Architect with Microsoft and has been working in the business intelligence field for the past eight years. Dustin is also a blogger, author, and speaker. You can find Dustin speaking at SQL Saturday events or spending time with his beautiful wife and three children in Jacksonville, Florida.Dustin Ryan


If you are planning on attending the PASS Summit 2016 use the following discount code and save $150

Save $150 right now using discount code VC15BKR3

If you are interested in speaking at an upcoming PASS BA Virtual Chapter meeting we are always looking for speakers, please leave a comment or send us an email atPASSBAVC@SQLPASS.ORG

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