Name: August Mtg: CrossTabs & Pre-Aggregations: Reporting on Steroids - w/ Jeff Moden
Start: 2024-08-09T11:30:00-06:00
End: 2024-08-09T13:00:00-06:00

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.)

Chris Hyde

Keith Tate

Albuquerque SQL Server User Group

Azure Data Tech Groups

Provides lunch for each of our monthly meetings (when in-person).

Robert Half Technology

Technology

SQL Server

Database Development

Database Professionals

Data Analytics

Advanced SQL Server

Microsoft Azure

SQL Azure

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

Data Integration

Online event

Share

Albuquerque SQL Server User Group

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

Albuquerque SQL Server User Group

Details

Sponsors

Members are also interested in