CrossTabs & Pre-Aggregations: Reporting on Steroids - Friday, 09 Aug 2024
-
Howdy folks.
The Albuquerque SQL Server User Group (ABQSQL) will be having its next meeting on Friday, August 9th, 2024 and I'll be the speaker that day.
This is a remake of the older CrossTabs & Pivots": Reporting on Steroid presentation of done in the past. It doesn't cover the PIVOT operator much at all... why teach something I recommended to NOT use? 😀 As I allude to in the abstract, the end goal is to produce some "Impossible" reports on a 100 million row, 52.3 GB table that's always up to date and does 2 year reporting in 18 MILLI-seconds and the full 10 year reporting in something less that 250 ms. This is the same one I gave a month or two ago. If you missed it and want to see it, here's a second chance during an earlier time of day.
Here's the link to register for this free meeting. The user group does ask that you register and understand the meet link won't be revealed until Friday to help protect against what they called "Zoom Attacks" that they've previously experienced. It's funny that they call it that because this will be a Teams meeting according to the site.
https://www.meetup.com/albuquerque-sql-server-user-group/events/302336274/
Also, they say the meeting is from 11:30 AM 'til 1:00PM. THAT'S MOUNTAIN TIME IN THE USA!
Here's the short introduction and abstract... if you know me, there will also be a ton of ancillary information as a part of the presentation.
Presentation Description and Short Agenda:
“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.
- 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
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Awww man!! Keep coming west Jeff! Would love to see you make it to Orange County, CA one of these days.
- SoCal_DBD wrote:
Awww man!! Keep coming west Jeff! Would love to see you make it to Orange County, CA one of these days.
Thank you kindly for the encouraging words but the presentation was remote.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Preaggregation sounds familiar 🙂
N 56°04'39.16"
E 12°55'05.25" - SwePeso wrote:
Preaggregation sounds familiar 🙂
Heh... it sure does. Here's page 44 from that presentation.
Every time I use the term, I try to remember to credit you with the explanation of what it is because it made such a great change way back in the cross tab articles.. 😉
I say "try" only because I'm human and may have forgotten it in a place or two but, hopefully, no more than that. It happens to everyone.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply