August Mtg: CrossTabs & Pre-Aggregations: Reporting on Steroids - w/ Jeff Moden

The Albuquerque SQL Server User Group (ABQSQL) will be having its next meeting on Friday, August 9th from 11:30 AM to 1:00 PM online via Microsoft Teams.

This month we are delighted to host Jeff Moden, former Microsoft MVP, Senior DBA at Proctor Financial, and well-known evangelist of the "tally table". Please join us for his presentation “CrossTabs and Pre-Aggregations: Reporting on Steroids". Ask Jeff your data questions, and get to know your peers!

Presentation description:
“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”
  - “Impossible” Reports on 100 Million rows in Milli-Seconds
  - Eliminates ETL
  - Always Up to Date
  - Tiny Footprint

If you’ve ever been to one of Jeff’s presentations before, you’ll also know that there will be a ton of other useful ancillary information included and that donning a water-cooled helmet is strongly recommended.

Attend this FREE data platform training event!

(Microsoft Teams link will be made available the day of the event.)