Category: Projects
-
SQL Server 2014/2016 Technology Enhancements for Developers – 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…
-
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, a…
-
SQL Saturday #572 – Washington State University Vancouver – Oregon 2016
Session 1. 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…
-
MCSE: Data Management and Analytics was issued by Microsoft to Wylie Blanchard
View my verified achievement from Microsoft. MCSE: Data Management and Analytics was issued by Microsoft to Wylie Blanchard on September 26, 2016. Earners of the MCSE: Data Management and Analytics certification have demonstrated the skills required to build enterprise-scale data solutions, and leverage business intelligence data—both on-premises and in cloud environments. Earning this certification qualifies an individual for…
-
SQL Saturday #542 – Saint 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, a…
-
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, click COM Add-ins> Go…
-
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, and…
-
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, SSIS, & C#,: Trizetto’s…
