Dan English's BI Blog

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

Archive for June, 2015

PASS Business Analytics VC June Meeting–Tools for Initial Exploratory Data Analysis

Posted by denglishbi on June 9, 2015

The next PASS Business Analytics Virtual Chapter meeting is coming up on Thursday, June 11.  This month we welcome Mark Wilcock and we are teaming up with the Data Science Virtual Chapter for this webcast.PASS_BAVC_Logo_New_201502

June 11 – Tools for Initial Exploratory Data Analysis


We do exploratory data analysis (EDA) when we take a first look at the source data we will use in our analytics project. EDA helps us to get a good idea of the usefulness, relevance, completeness and quality of the data for our purposes and to explore patterns in the data to give us some insight. With this session we’ll explore a public dataset – the Titanic passenger list. Most people know the of the tragic events. The RMS Titanic sailed from Southampton on 10th April 1912, hit an iceberg in the Atlantic 4 days later and sank. Of the 2000 people on board, only 700 survived.

We’ll build some rough and ready visualisations and crunch some basic statistics on this dataset using 4 different tools

• Excel and Power Query as our benchmark,

• R with the ggplot2 graphics and dplyr data manipulation packages,

• Azure Machine Learning and

• the free starter edition of RapidMiner

The purpose of the session is to introduce you to some tools that you may not be familiar with so that you can decide which tools you prefer for exploring and analysis data. Or you may decide to use all these tools at different times for different tasks.

Bio – Mark Wilcock Mark Wilcock is an independent consultant specialising in the analysis, reporting and visualisation of financial data. Over the last 20 years, he has worked on many systems to measure and monitor financial performance and manage market risks that arise from banking and trading activities. He is the organiser of the London Business Analytics Group (http://www.meetup.com/London-Business-Analytics-Group/), a popular community group that holds monthly talks on topics ranging from Predictive Analytics to Power Query to Personalised Medicine. He blogs intermittently at http://zomalex.co.uk.

–> REGISTER NOW <–image

This month we will also be giving away a $25 Amazon gift card as well!  You need to not only register for the event, but also attend in order to qualify for the give away.

If you are interested in speaking we are always looking for speakers, please leave a comment or send me an email at denglishbi@gmail.com

Posted in Training | Tagged: , , | 1 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)

MN Microsoft BI User Group 2015 Special Edition Meeting

Sponsored by:


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)


  • 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


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


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