Dan English's BI Blog

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

Posts Tagged ‘training’

PASS Business Analtyics VC August Meeting – Maximize your Microsoft Investment with BI Office

Posted by denglishbi on August 17, 2016

The next PASS Business Analytics Virtual Chapter meeting is coming up next week on Thursday, August 25.  This month we welcome Pyramid Analytics and they will go over their BI Office product and show the Power BI on-premise solution.  If you are not familiar with Pyramid Analytics, they are one of the PASS national as well as local SQLSaturday sponsors.  If you attend a local SQLSaturday event or go to one of the major PASS Conferences (Summit or Business Analytics) make sure you stop by their location and check them out.

–> REGISTER NOW <–PASS_BAVC_Logo_New_201502

Aug 25 – Maximizing your Microsoft investment with Pyramid Analytics BI Office

Abstract

Pyramid Analytics BI Office is the top analytics platform for the Microsoft BI Platform. BI Office provides a complete on-premise or private cloud solution with unparalleled governance, security, and integration with Microsoft, including Power BI Desktop content. This session will provide an overview discussion and demo of the BI Office application, including advanced analytics with complex topics made easy (such as reusable R models). Target audiences include business analysts, data scientists and Power BI users.image

Bios –

Peter Sprague is VP of Product Marketing at Pyramid Analytics. A veteran of ProClarity, Capstone and Microsoft; Peter Sprague has been developing analytic tools, and designing and deploying enterprise BI solutions for over 15 years.

John Hormaechea is Director of Product Marketing at Pyramid Analytics. John has previously worked at Microsoft as part of the SharePoint and Business Intelligence product marketing teams. and ProClarity in various sales, consulting, and training roles.

image

–> REGISTER NOW <–

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

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

MN PASS Microsoft BI User Group Meeting – Aug 22

Posted by denglishbi on August 16, 2016

The next MN Microsoft BI User Group meeting is coming up on Monday, August 22. We will have two presentations, the first one is a case study from Lifetouch "Exceeding Six Sigma Email Address Quality" and the other will be by me (Dan English) on "Power BI: Dashboard in an Hour Walk-Through".

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

MN Microsoft BI User Group August 2016 Meeting

Sponsored by:

image[12]MSFT_logo_Page

Date: Monday, August 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:45 : Pizza Lunch
  • 1:45-2:00 : Microsoft BI User Group Updates and Announcements
  • 2:00-3:00 : Exceeding Six Sigma Email Address Quality
  • 3:00-3:15 : Break
  • 3:15-4:15 : Power BI: Dashboard in an Hour Walk-Through
  • 4:15-5:00 : Networking

Presentations:

Session 1: Exceeding Six Sigma Email Address Quality

While efforts around data quality and CRM have been around for quite a while, it seems that getting customer data clean and consistent remains a challenge for many organizations. While the causes for this are numerous, there are solutions available to improve the outcome of customer data cleansing efforts at a reasonable cost and without needing to spend several months of effort.

This presentation focuses on how through using software provided by Melissa Data, Pragmatic Works, and native functionality within the SQL Server platform an organization was able to achieve in excess of six sigma quality for email addresses and build a foundation for future customer data integration efforts. Email is a channel used by Marketing to inform and engage customers. Failure to have accurate data for email addresses can result in an email sender being identified as a spammer, or black listed as a result of sending too many incorrectly addressed emails to a given email domain (i.e. gmail, Hotmail, etc.). Using Selligent as the ESP (Email Service Provider) results of the data cleansing process were able to be validated at the receiving inbox. We will discuss what to look for in cleansing email addresses and how codes provided through Melissa Data software helped ensure spam traps were avoided, and erroneous email addresses were recovered (i.e. gmaill.com). While the project focus was email, the cleansing process also included name, address, and some limited demographics (using Census data); these will be covered as time allows.

What’s not covered? How to keep the data clean; keeping it clean varies with all the sources that produce and consume customer data and is often unique to each organization or situation.

Speaker: Chad Burdette, Data Management Team Lead

Chad currently leads the Data Management team for three Lifetouch divisions. He has over 25 years IT experience, holds certification from IBM as a DB2 DBA and Business Intelligence Expert, and from Microsoft as a Data Platform Sales Specialist. He started with the Microsoft BI stack when it wasn’t a stack using Microsoft EIS (Executive Information System) pack for Excel 3.0 back in the early 1990’s. Chad has served in multiple roles: ETL developer, Reports and Dashboard developer, Data Architect, Infrastructure Architect, DBA, Project Manager, and Leader. He is passionate about increasing customer relationships through the use of information to provide relevant points of engagement and interactions, and helping business better use the data they collect achieve superior results.

Session 2: Power BI: Dashboard in an Hour Walk-Through

This session will provide a walk-through example showcasing the Power BI tools including the Desktop, Service, and Mobile application. You will see how you can quickly access and explore data and gain insights from any device as well as collaborate and share the content with others. Some of the recent capabilities that have been released since our last meeting will also be demoed.  The content and examples will be provided after the meeting so that you can go through the walk-through examples on your own.

Speaker: 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 Virtual Chapter and on the executive leadership team for the MN Microsoft BI user group.

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 Analtyics VC July Meeting – Incorporating R with SQL Server 2016

Posted by denglishbi on July 7, 2016

The next PASS Business Analytics Virtual Chapter meeting is coming up this week on Thursday, July 14.  This month we welcome Microsoft MVP Ginger Grant (b|t) who will talk to us about using R with SQL Server 2016.

–> REGISTER NOW <–PASS_BAVC_Logo_New_201502

July 14 – Incorporating R with SQL Server 2016

Abstract

Interest in the R language is has grown along with the amount of data being accumulated. As Microsoft is now incorporating the R language into SQL Server 2016, the language is going to be a required skill for all data professionals in the near future. This webinar will provide an explanation the different versions of R, demonstrate writing R code in Visual Studio, and run some R code on SQL Server. To ensure everyone who wants to can run this code on their PCs, all of the setup information needed to make R work on SQL Server and the UI will a be covered. After watching this you will know everything you need to start incorporating SQL Server and R.Ginger Grant

Bio –

Having worked with the Microsoft BI stack for many years, Ginger Grant is exploring new challenges by applying her data expertise to the expanding field of data science and data visualization. Using R and Machine Learning she has been able to use data and algorithms to answer many different business questions for users. When not working, Ginger is studying for the pilot degree program Microsoft created for Data Science, blogging at DesertIsleSQL.com and speaking at numerous technical events, including SQL Saturdays, GDI and Women Who Code. An active member of the Microsoft data community, she was recently awarded a Microsoft MVP in Data Platform.

–> REGISTER NOW <–

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

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

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:

image[12]MSFT_logo_Page

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)

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

Abstract

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

–> REGISTER NOW <–

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 »

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 »

PASS Business Analytics VC April Meeting – Using R Machine Learning Script as a Power BI Desktop Data Source

Posted by denglishbi on April 1, 2016

The next PASS Business Analytics Virtual Chapter meeting is coming up next week on Thursday, April 7.  This month we welcome data scientist Sergei Dumnov who will show us how we can use an R script in Power BI.

–> REGISTER NOW <–PASS_BAVC_Logo_New_201502

April 7 – Using R Machine Learning Script as a Power BI Desktop Data Source

Abstract

You can develop a Power BI Dashboard that uses an R machine learning script as its data source and custom visuals. In this webinar, you will learn how to connect to data sources over the Internet, cleanse, transform and enrich the data through the use analytical datasets returned by the R script, design the dashboard and finally share it.

Bio –Sergei Dumnov

Sergei is a data scientist at Qrious, an Auckland (NZ) based big data analytics company, where he responsible for data wrangling, analysing it and building analytical applications using variety of tools (Greenplum DB, R, PostGIS, QGIS and Tableau). He received his PhD from the Institute of Hydrodymics (Russian Academy of Sciences) developing mathematical models of water flow and transport phenomena in water bodies.

–> 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 Business Analytics VC March Meeting–Building Business Systems to Retain Clients (CHURN) with Azure ML

Posted by denglishbi on March 9, 2016

The next PASS Business Analytics Virtual Chapter meeting is coming up on Tuesday, March 15.  This month we welcome back Professor Giuseppe MascarellaPASS_BAVC_Logo_New_201502 from Florida Atlantic University, College of Business.

–> REGISTER NOW <–

March 15 – Building systems to retain valuable clients (CHURN) with Microsoft Azure Machine Learning

Abstract

If you think that acquiring new clients is costly, try to deal with the cost of lost clients. Telecoms know when you will change your provider before you even make that decision and so do many other leading retailers, banks, etc. Microsoft Machine Learning will help build a cost-effective and cutting-edge system. In this session, you will learn how to build one with Azure Machine Learning.

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 »

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 »

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 »

 
Follow

Get every new post delivered to your Inbox.

Join 2,350 other followers