SQL Saturday – Wausau 2017

Recently, I learned that I'll be speaking at the SQL Saturday Wausau 2017 conference on Sep 16th. I'm excited about this event because it's the first time that I've been slotted for more than one session at a SQL Saturday event. For those attending, return here after the event to

SQLSaturday #588 – New York City 2017

Session Description: Developing Business-Driven Self-Service BI Speaker(s): Wylie Blanchard Duration: 70 minutes Track: BI Platform Architecture, Development & Administration In this session we'll develop a Tabular Data Model in MS SSAS and review our options for deploying, sharing and visualizing it.  Well also discuss how senior leaders will see the business value of SSAS and

University of Wisconsin – Madison 2017 – SQLSaturday #604

Session Description: SSAS Tabular in 60 mins: Developing Business-Driven Self-Service BI Speaker(s): Wylie Blanchard Duration: 60 minutes Track: BI Platform Architecture, Development & Administration In this session we’ll develop a Tabular Data Model in MS SSAS and review our options for deploying, sharing and visualizing it. Well also discuss how senior leaders will see the

SQL Saturday 595 – Cleveland Ohio 2017

Session Description: Analyzing SQL Server Data using PowerPivot in MS Excel Speaker(s):  Wylie Blanchard Duration: 60 minutes Track: BI Information Delivery Your end users want to analyze data in your data warehouse. They could deal with the learning curve of SSAS but they'd prefer to utilize a familiar application like MS Excel. Welcome PowerPivot, a

Chicago .NET Users Group – Microsoft Corporation 2016

SESSION DESCRIPTION: Technology Enhancements for SQL Server 2014/2016 Developers Speaker(s):  Wylie Blanchard Duration: 75 minutes Your team is planning to upgrade from an early version of SQL Server environment. Learn what's new and which features and enhancements are really important to the work life of a SQL Server Developer. In this presentation we’ll explore

Lightning Talk – SQL Saturday #572 – Oregon 2016 – Washington State University Vancouver

Session Description: Become a SQL Pro who's in High Demand Speaker(s):  Wylie Blanchard Track: Lightning Talk Expertise in SQL is an in demand IT skill. As demand continues to grow, so does the increase of sql professionals entering your specific industry. Learn what's needed to ensure that you become a stronger technology authority in your

SQL Saturday #572 – Washington State University Vancouver – Oregon 2016

Session Description: SQL Server 2014/2016 Technology Enhancements for Developers Speaker(s):  Wylie Blanchard Duration: 75 minutes Track: Application & Database Development Your team is planning to upgrade from an early version of SQL Server environment. Learn what’s new and which features and enhancements are really important to the work life of a SQL Server Developer. In

SQL PASS SUMMIT 2016 – I’m Attending: @SQLPASS

SQL PASS Summit - 2016 Conference - Professional Associaion for SQL Server - Wylie Blanchard

PASS Summit 2016 will be held at the Washington State Convention & Trade Center in Seattle, with two days of Pre-Conference Sessions beginning Oct. 24, 2016.   About PASS Summit   Don’t miss one of the industry’s best events.   What is PASS Summit? Whether you’re a data novice or a pro, PASS Summit is the place

Rockhurst University – Kansas City 2016 – SQL Saturday #548

Session Description: Analyze & Visualize SQL Server Data w/ PowerPivot, PowerView & Excel Speaker(s):  Wylie Blanchard Duration: 75 minutes Track: Analytics and Visualization Your end users want to analyze data in your data warehouse. They could deal with the learning curve of SSAS but they'd prefer to utilize a familiar application like MS Excel. Welcome PowerPivot,

SQL Saturday #542 – Saint Louis 2016 – Saint Louis University

sqlsaturday 542 - st louis 2016 - saint louis university

Session Description: SQL Server 2014/2016 Technology Enhancements for Developers Speaker(s):  Wylie Blanchard Duration: 60 minutes Track: Application & Database Development Your team is planning to upgrade from an early version of SQL Server environment. Learn what's new and which features and enhancements are really important to the work life of a SQL Server Developer. In

Indiana Wesleyan University – Indianapolis 2016 – SQL Saturday #530

Session Description: Using PowerPivot in MS Excel to analyze SQL Server Data Speaker(s):  Wylie Blanchard Duration: 60 minutes Track: BI Information Delivery Your end users want to analyze data in your data warehouse. They could deal with the learning curve of SSAS but they'd prefer to utilize a familiar application like MS Excel. Welcome PowerPivot,

Analyze & Visualize SQL Server Data w/ Power Pivot & Power View in Excel

Last updated 05-13-2017 In this tutorial we'll use Microsoft Excel to retrieve data from our SQL Server database. We'll then model, analyze and visualize the data using Excel's Power Pivot and Power View features. Activate the Power Pivot & Power View add-ins          Open MS Excel 2013\2016          Go to File > Options > Add-Ins          In the Manage box,

SQLSaturday #523 & University of Iowa – Iowa City 2016

  Session Description: Capture Changes with SQL Server's Change Data Capture Speaker(s):  Wylie Blanchard Duration: 75 minutes Track: Application & Database Development Learn how to easily capture information about data changes – inserts, deletes and updates using SQL Server's Change Data Capture feature. Change Data Capture tracks INSERTs, UPDATEs, and DELETEs applied to your SQL Server tables,

PCP Member Eligibility Secure Email

Automated, Hippa Compliant, system to email member eligibility lists to Primary Care Physicians. Trizetto's QNXT™ Enterprise Core Administration System & ASM's MD-Staff - Credentialing. Created an automated, HIPAA compliant, process to securely batch and distribute member eligibility lists to PMG/non-Presence PCP's on a monthly basis via individual PCP email addresses.Utilizing SQL,