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

****
This will be a remote teams meeting.
I will start the teems meeting at 4:45 PM, for any Pittsburgh locals who want to join and catch up with each other.
The main presentation and speaker will begin at 5:30 PM
****

“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