SQL2012 Windowing Functions In The Data Warehouse–2. Reporting
This is the second post of a diptych on the magical windowing functions in data warehouse scenarios. With these functions you can greatly simplify the TSQL you write. Many complex queries with CTE’s, temp tables and sub queries can be rewritten to simpler, better...Hansen BI brings you the latest insights from the most popular Microsoft Business Intelligence bloggers around the world
Top Posts & Pages
- Power Query: From No-code to Low-code Enterprise ETL
- Priority Access sign-up for Power BI Premium per user public preview now available
- The enhanced compute engine is now enabled by default
- Why I’m Excited About Dynamic M Parameters In Power BI
- Updates to Power BI Publish to web for better public reporting
- Join us! Thursday October 22 Power Platform Community Conference
- Heads up: The ‘new look’ of the Power BI service begins rolling out soon
- Announcing Personalize Visuals General Availability (GA)
- Power BI October 2020 Feature Summary
- Build Scalable BI Solutions Using Power BI and Snowflake
Blogroll
- Chris Webb (231)
- Data Chant (176)
- Excelerator BI (162)
- In2BI (21)
- Power BI (622)
- powerbi (1)
- PowerPivotPro (159)
- SQL Chick (55)
- SQL Girl (50)
Recent Posts
- Power Query: From No-code to Low-code Enterprise ETL
- Priority Access sign-up for Power BI Premium per user public preview now available
- The enhanced compute engine is now enabled by default
- Why I’m Excited About Dynamic M Parameters In Power BI
- Updates to Power BI Publish to web for better public reporting
- Join us! Thursday October 22 Power Platform Community Conference
- Heads up: The ‘new look’ of the Power BI service begins rolling out soon
- Announcing Personalize Visuals General Availability (GA)
- Power BI October 2020 Feature Summary
- Build Scalable BI Solutions Using Power BI and Snowflake