Dan English's BI Blog

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

Posts Tagged ‘training’

PASS Business Analytics VC Feb Meeting–Building Business Recommenders with Azure ML

Posted by denglishbi on February 5, 2016

The next PASS Business Analytics Virtual Chapter meeting is coming up on Thursday, February 11.  This month we welcome Professor Giuseppe MascarellaPASS_BAVC_Logo_New_201502 from Florida Atlantic University, College of Business.

–> REGISTER NOW <–

February 11 – Building Business Recommenders with Microsoft Azure Machine Learning

Abstract

Netflix knows if you are going to like a movie before you watch it, so do many other leading companies in what they sell. How do you build capabilities like this for your business? A cost effective way is by using a Matchbox (Large Scale Bayesian) Recommendations algorithm in Microsoft Azure Machine Learning. In this session we will go step-by-step in what is required to build one for any opportunity you might have.

Bio –

Prof. Giuseppe Mascarella is a former Microsoft consulting manager and has won WW awards on leading cloud and business intelligence programs at a global level. He works as an Adjunct Prof. of Social Media Analytics and Data security at FAU and is a Principal at Value Amplify where he works on Machine Learning and IoT solutions.

–> REGISTER NOW <–

If you are planning on attending the PASS Business Analytics Conference use the following discount code and save $100

Save $100 right now using discount code BAVCBA

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 at PASSBAVC@SQLPASS.ORG

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

PASS BA Webinar Marathon–Dec 10

Posted by denglishbi on December 4, 2015

Don’t miss out on the upcoming PASS BA Webinar Marathon coming up next week on Dec 10. There are 7 sessions to attend:)

This is to get you excited and ready for the upcoming PASS Business Analytics Conference!

image

And it was just announced that if you register by Dec 23 that you will be entered into a drawing for an XBox.

 

PASS BA Webinar Marathon Register Now!

 

Here are the sessions that are set for next week and I will be hosting the 2nd and 4th sessions:

Chris Webb

Create Amazing 3D Topographic Maps In Excel With Power Query, Power Pivot, and Power Map

Chris Webb | Director, Crossjoin Consulting Limited

15:00 GMT, 07:00 PST

Mark Wilcock

Tools For Exploratory Data Analysis

Mark Wilcock | Business Analytics Consultant, Zomalex Ltd.

16:00 GMT, 08:00 PST

Jordan Goldmeier

Creating Outstanding Spreadsheet Models

Jordan Goldmeier | Dashboards and Data Visualization Expert, Cambia Factor

17:00 GMT, 09:00 PST

Ginger Grant

Implementing Data-Based Decision Making

Ginger Grant | Business Intelligence Consultant, Pragmatic Works

18:00 GMT, 10:00 PST

Ken Raetz

Modular Data Extraction and Integration Patterns

Ken Raetz | Principal, Think Data Insights, LLC

19:00 GMT, 11:00 PST

Matt Allington

Moving From Excel to PowerBI.com, A Business Analyst’s Perspective

Matt Allington | BI Professional , Excelerator BI

20:00 GMT, 12:00 PST

Rick Grantham

Making Informed Decisions: Guidelines for Creating an Effective Dashboard

Rick Grantham | Analytics Expert, EPI-USE America / Excel.TV

21:00 GMT, 13:00 PST

PASS BA Webinar Marathon Register Now!

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: , , , | Leave a Comment »

PASS Business Analytics VC October Meeting–Spatial Data Looking Outside the Map

Posted by denglishbi on September 30, 2015

The next PASS Business Analytics Virtual Chapter meeting is coming up next week on Thursday, October 8.  We welcome Microsoft SQL Server MVP Hope Foley (b|t).PASS_BAVC_Logo_New_201502

–> REGISTER NOW <–

October 8 – Spatial Data – Looking Outside the Map

Abstract

I’ve said it before and I’ll say it again, spatial data doesn’t get much love in SQL Server. It is a feature worthy of much appreciation and will become more vital as more location data is collected. In this session we will explore spatial data and discover many ways it can be used for incredible analytics. You will learn some new ways to visualize your data outside of the typical plots on a Bing map layer. Come and learn how powerful spatial data can be even though it lacks a snazzy "power" title.

Speaker Bio –

Hope Foley, a SQL Server MVP with over 16 years of experience in the IT world, has worked across many industries including insurance, health organization, and federal government. She now works for the team at BlueGranite as a Business Intelligence consultant. She has been a consultant in SQL Server technologies for over 9 years focusing on database administration and architecture, more recently in business intelligence. Hope is an active member in the SQL Server and PASS communities speaking at events and organizes the SQLSaturday event in Indianapolis.

–> REGISTER NOW <–

If you are planning on attending the PASS Summit 2015 Conference 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 me an email at denglishbi@gmail.com

Posted in Training | Tagged: , , | Leave a 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 »

PASS Business Analytics VC August Meeting–Power BI, Mission Possible!

Posted by denglishbi on August 24, 2015

The next PASS Business Analytics Virtual Chapter meeting is coming up on Wednesday, August 26.  This month we welcome Microsoft SQL Server MVP, author, and trainer Reza Rad (b|t).PASS_BAVC_Logo_New_201502

–> REGISTER NOW <–

August 26 – Power BI, Mission Possible!

Abstract

Power Query, Power View, and Power Pivot has been in the BI market for a while. Microsoft combined these three products into a single product and service with a new designer called Power BI Desktop (Power BI Designer). Power BI gathered features of these three products all in one, so building dashboards and effective visualization items with this tool is much easier nowadays.

In this session you will learn all new and great features of Power BI. You will learn how to work with different data source, and apply Power Query transformation on them. You will learn tricks and tips of modelling with Power BI Desktop, and then how to visualize effectively with this tool. You will also learn how to build dashboards on Power BI website.

At the end of this session you will be able to use Power BI for your everyday data analysis as well as organizational data mash up and visualization. So expect lots of demos in this session.

Bio – Reza Rad is an Author, Trainer, Speaker and DW/BI Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in SQL Server for five continues years (from 2011 till now) for his dedication in Microsoft BI. His articles on different aspects of technologies, especially on MS BI, can be found on his blog: http://www.radacad.com/blog (previously was http://www.rad.pasfu.com) . He wrote some books on MS SQL BI and also is writing some others, He is also an active member on online technical forums such as MSDN and Experts-Exchange, and is a moderator of MSDN SQL Server forums, and is a MCP, MCSE and MCITP of BI. He is the leader of New Zealand Business Intelligence users group. He is a International Speaker in SQL Saturday and SQL users groups and Conferences like TechEd and PASS Summit. He is a Microsoft Certified Trainer.

–> REGISTER NOW <–

If you are planning on attending the PASS Summit 2015 Conference 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 me an email at denglishbi@gmail.com

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

PASS Business Analytics VC July Meeting–How to calculate ROI of analytics

Posted by denglishbi on July 21, 2015

The next PASS Business Analytics Virtual Chapter meeting is coming up on Thursday, July 23.  This month we welcome Othniel Denis and will learn about ROI calculations.PASS_BAVC_Logo_New_201502

–> REGISTER NOW <–

July 23 – How to calculate ROI of analytics

Abstract

Whether you’re performing business analytics with small data or big data every project needs to deliver ROI (Return on Investment). This session will focus on teaching participants the fundamentals of ROI calculations. We will include case studies, best practices and common pitfalls to avoid.

Bio – Othniel is currently Principal of Excellent Ones Consulting LLC. His firm provides training on finance, Microsoft Excel and creates financial models for businesses. He brings with him a background in finance, training, and information management systems. Prior to opening his own firm, Othniel spent his 13 years in finance at various organizations. His responsibilities included: building financial models, forecasting revenue, developing budgets and analyzing data to support strategic decisions.

–> REGISTER NOW <–

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: , , | Leave a Comment »

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

Abstract

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)
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 »

 
Follow

Get every new post delivered to your Inbox.

Join 2,117 other followers