Event link at our Meetup page.

Creating CrossTab Queries and Pivot Tables in SQL
a.k.a. Reporting on Steroids

“Data” is useless. It tells you nothing until it’s converted to “Information”.

Knowing how to convert “Data” to “Information” is an absolutely critical skill in the multiple worlds of Data Analytics, Predictive Analysis, and related disciplines.

One of the most common and extremely useful methods of converting “Data” into “Information” is to transform the data into a “Cross Tabulation” or “Contingency Table” or, as it is more commonly known, a “Pivot” or “CrossTab” table. The conversion process is also commonly referred to as a “Pivot” or “CrossTab”.

This session is for newbies and highly experienced folks alike. Here’s a short synopsis and the killer end result:

· Purpose and Basics of CrossTabs (a.k.a. Pivots)
· Create a “Single Column” CrossTab
· Create a “Multi Column” CrossTab
· Why the PIVOT Operator is NOT Your Friend
· Intro to Creating Voluminous Test Data and “Minimal Logging”
· 3 Pre-Aggregation Methods for Serious Increases in Performance
· The “Ultimate Pre-Aggregation”
o “Impossible” Reports on 100 Million rows in Milli-Seconds
o Eliminates ETL
o Always Up to Date
o Tiny Footprint

Jeff Moden

Jeff Moden is an “Accidental DBA” with more than 26 years of SQL Server experience. Jeff helped make the advanced technique known as the “Tally” or “Numbers” Table a household word and coined the term “RBAR”, which stands for “Row By Agonizing Row”. He’s written 44 mostly five star articles for SQLServerCentral.com and, having more than 58,000 posts, is one of the leading contributors on that site. Jeff is renowned for being able to teach extremely complex concepts and techniques in such a manner that even beginners can understand without boring the experts. He’s also a 9 year SQL Server MVP veteran, won the Red Gate exceptional DBA award in 2011, has spoken at the PASS Summit, many SQL Saturdays, and many local PASS chapter meetings on many different SQL Server subjects.

His mantra is “Performance is in the code”.

---