Premier Sponsors
 
http://www.sqlpass.org 
 
http://www.crescentsolutions.net 
 
http://reduxio.com/ 
 
http://kubisys.com/ 
 
http://www.infragistics.com/ 
 
http://oreilly.com/ 
 
http://pyramidanalytics.com/ 
 
http://www.sqlpower.com/ 
 
http://www.idera.com/ 
 
http://www.telerik.com/ 
 
http://pluralsight.com/training 
 
SQL PASS Community News: View
Download the latest ebook from Microsoft Press: Data Science with Microsoft SQL Server 2016
Download Charlie Glover's Presentation and Code Samples: SQL Server 2012 Window Functions
Los Angeles SQL Server Professionals Group Presents ...
Thursday, January 19, 2017
Introduction to SQL Server 2012 Window Functions
In this presentation, Charlie presents an introduction to T-SQL window functions. These functions are often used to interpret, communicate and summarize meaningful data patterns in business reports displayed in tabular or graphical format. Since statistics and algebraic functions are cornerstones of data analytics, Window functions in SQL server 2012 are a great addition.

Prior to this development, SQL Server 2005 was probably the first milestone in supporting window functions; it introduced window ranking functions (ROW_NUMBER, RANK, DENSE_RANK, and NTILE) with limited extended development in SQL Server 2008 R2. Microsoft SQL Server 2012 enhances support for window aggregate functions by introducing support for offset functions (LAG, LEAD, FIRST_VALUE, and LAST_VALUE), and support for window distribution functions (PERCENT_RANK, CUME_DIST, PERCENTILE_DISC, and PERCENTILE_CONT).

The intended audience is for those who want an introductory presentation on the subject, but have some background in writing reports using TSQL or/and reporting tools such as SSRS, OBIEE, Crystal Reports, Tableau, Excel, R, SAS etc.
Speaker: Charlie Glover
Charlie is a data analytical professional with education and experience in converting raw data into actionable information to support decision-making. Throughout his career, he has been successful in projects involving creating predictive models, computer networking , dashboards/reports and teaching various levels of math including statistics, advanced algebra, geometry, and math analysis.
He obtained his bachelors in Information Science from Jacobs School of Engineering at U.C. San Diego and Masters from University of Southern California (Cum Laude) in Education. Charlie is a Microsoft certified professional (SQL Server 2012/2016) with experience utilizing a wide range of reporting and information technology tools such as Crystal Reports, OBIEE, SSRS, Tableau, Excel, R and SAS. Charlie also holds two teaching credentials (Mathematics and Technology).
In addition to his successful career, Charlie’s technical interests include machine learning (unsupervised and supervised), 3D printing, Hadoop, NOSQL (unstructured data) and the use of these tools in real world applications. He is a strong supporter on the use of technology to address global problems (alternative transportation, sustainable unorthodox housing, healing the environment etc).
As a result of his strong technical curiosity to learn new and emerging technologies from peers and other resources, Charlie is an admirer of legendary inventors Buckminster Fuller and Granville T Woods.
6:30 PM, Registration and Refreshments
7:00 PM to 9:00 PM, Presentations
Our Meeting Location:
Crescent Solutions
6420 Wilshire Blvd. #200
Los Angeles, CA 90048
FREE Parking: Please park anywhere on the lot or on the first floor (valet) area of the structure.
If you park in the parking structure, please take the elevator up to the lobby then to the 2nd floor.

FREE Admission