Skip to main content
Under the kover of business intelligence
  • Home
  • Copyright
  • About

Tag: nested aggregates

Nesting Aggregates with Window Functions

August 18, 2015September 10, 2020 Koen Verbeeck Leave a comment

Recenty I was writing an article for MSSQLTips where I had to create a treemap (it will be published soon). As sample data, I used the different folders containing the drafts for all the tips I ever wrote. As measures, I have the number of kilobytes and the number of items per folder. An example: […]

Read More

Feed

RSS

Social

  • Twitter
  • LinkedIn

Former MVP

Former Microsoft Data Platform MVP (2017-2025)

star schema all the things
Get your star schema merchandise

Author of the Year 2014/2020/2023

Support this blog and buy me a beer

Recent Posts

  • dataMinds Connect 2025 – Slides & Scripts
  • Cloud Data Driven User Group 2025 – Slides & Scripts
  • Retro Data 2025 – Slidedeck
  • Secure Logic Apps with OAuth Authorization
  • Free Online Sessions – Building the €100 DWH and Indexing for Dummies

Categories

  • Azure (28)
  • Azure Data Factory (27)
  • Azure Devops (5)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (61)
  • Fabric (19)
  • Power BI (42)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (114)
    • MDS (8)
    • SSAS (12)
    • SSIS (46)
    • SSRS (13)
    • TSQL (9)
  • Varia (37)
  • Twitter
  • LinkedIn
  • Home
  • Copyright
  • About
Under the kover of business intelligence All rights reserved. Theme by Colorlib Powered by WordPress