Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
Data Analytics Team Leadership
·
Module 3
Advanced Analytical SQL
1
Multi-Dimensional Aggregation with GROUP BY
Write aggregation queries using GROUP BY across multiple dimensions.
2
CASE Statements for Categorization
Use CASE statements to create calculated categories within queries.
3
Mastering CTEs for Analytical Queries
Write Common Table Expressions (CTEs) to structure complex analytical queries.
4
Advanced Window Functions: Ranking and Offsetting
Apply ranking and offset window functions (e.g., ROW_NUMBER, LAG) to analyze rows within a result set.
5
Window Functions for Running Totals and Moving Averages
Calculate running totals and moving averages using window functions.
Next module isn't ready yet,
Back to course
Previous module
Hands-On Analysis with Metabase
Next module