Dan English's BI Blog

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

Archive for August, 2017

MN SQLSaturday #682–Oct 7

Posted by denglishbi on August 31, 2017

The schedule has been posted for this year’s Minnesota SQLSaturday event which will be held on October 7 at Saint Paul College.SQLSaturday #682 - Minnesota 2017

I will be speaking in the afternoon on Analyzing Healthcare Open Data with Power BI.

In this session we will explore and evaluate Healthcare data that is freely available to the public. You will see how easily we can consume and integrate the data to analyze and investigate. In the demos you will see some of the latest enhancements and features that have been included with Power BI such as ArcGIS (Esri) maps, forecasting, Top N filtering, grouping / binning, clustering, custom R visuals, and maybe a few more along the way. If you are interested in Open Data, Healthcare, or have to perform a lot of data manipulation in Excel or other tools to provide analysis for your job then this is the session for you. Leverage the free capabilities of Power BI, advanced analytics, and help simplify your everyday workload and wow your boss!


Hope to see you there!

Posted in Training | Tagged: , , , | 2 Comments »

MN PASS Microsoft BI User Group Meeting–Aug 28

Posted by denglishbi on August 25, 2017

The next MN Microsoft BI User Group meeting is next week on Monday, August 28. There will be two presentations, the first one is an introduction to Machine Learning and the other is using maps in Power BI.

Please Register Now (Please register so that your name badge is pre-printed)

MN Microsoft BI User Group August 2017 Meeting

Date: Monday, August 28, 2017

Check In: 1:00 PM Event Time: 1:15 PM – 4:00 PM

Location: Microsoft Technology Center – 3601 76th St W, Suite 600 Edina MN 55435

Please Register Now (Please register so that your name badge is pre-printed)


  • 1:00-1:15 : Check-In
  • 1:15-1:30 : Microsoft BI User Group Updates and Announcements
  • 1:30-2:15 : Intro to Machine Learning (Jared)
  • 2:15-3:00 : Pizza & Networking
  • 3:00-3:45 : How to become a data surveyor: Maps in Power BI (Alex)
  • 3:45-4:00 : Closing & Giveaways


Session 1: Intro to Machine Learning

Come to this session to get your toes wet with machine learning. What types of questions it can answer? What types of models it can produce? What are some techniques used? There will be practical demos using Azure Machine Learning as well. Enough info to get you started, or enough to quit while you’re ahead, either way, you’ll come out with some concrete ideas of what ML is all about.

Speaker: Jared Zagelbaum

Jared Zagelbaum is a highly experienced IT professional, specializing in the Microsoft Data Platform suite of technologies since 2007. He expertly leads projects and teams through enterprise solution design and implementation for data management, analytics, and information delivery.

Jared regularly speaks at user groups and events across the Midwest, as well as blogging and providing technical review for SQL Server publications. He is a Microsoft Certified Solutions Expert (MCSE) in Data Management and Analytics, and a graduate of the University of Florida with a BS in Finance, Accounting and Economics. https://jaredzagelbaum.wordpress.com/about/

Session 2: How to become a data surveyor: Maps in Power BI

Have you been using maps in Power BI to present your geographic data? Do you want to map your data to see what cities have the best sales, but don’t know where to begin? Join us in this session to learn the practical steps to mapping your data, what you need to get started, and how to make beautiful maps to see your data in a whole new light. We will also discuss when you may not want to map your data, and some of the roadblocks you might encounter.

Speaker: Alex Barbeau

Alex Barbeau is a BI Consultant with Nihilent Technologies, focusing on SSAS, data modeling, and EDW design. Alex has extensive experience in designing and developing analytics and reporting solutions in Sales, Manufacturing, Inventory Management, Healthcare, and Commodities verticals across the span of the Microsoft BI platform.

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

PASS Business Analytics Virtual Group August 17 “R-Ternatives in Power BI”

Posted by denglishbi on August 16, 2017

The next PASS Business Analytics Virtual Group meeting will be tomorrow on Thursday, August 17.  We welcome Ryan Wade who will be showing us the different options for utilizing R code in Power BI.PASSBA_Logo


August 17 – R-Ternatives in Power BI

Session Abstract

R is a very powerful statistical programming language that has been gaining a lot of traction in recent years. In early 2015 Microsoft acquired Revolution Analytics, a major provider of software and services for R. Microsoft have since incorporated R in Azure ML, SQL Server 2016, and Power BI. There are 3 ways you can leverage R in Power BI. You can use it as a data source, you can leverage it in Power Query, or you can use it to create custom visualizations. In this session I present easy to follow examples of those 3 scenarios. I will also provide resources that will enable you to take what you learned to the next level.

Speaker Bio –

Ryan Wade is a data analytic professional with close to 20 years of experience. My education and work experience enables me to understand things from a technical, analytical, and business viewpoint. I have the ability to present complex data in an intuitive way using sound analytical and visualization methods. I have an advanced analytical and technical skill-set. My technical background includes the following tools and programming languages: Power BI, T-SQL, Excel, DAX, M, R, SQL Server R Services, Python, VBA, Office 365, SSIS, SSRS, & SSAS Tabular. I also have an elementary understanding of Azure ML and Octave.


Also, we will be doing a random drawing after the webinar and giving away eight $25 Amazon gift cards to anyone that attends and fills out the survey!

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