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
Blogroll
- Chris Webb (215)
- Data Chant (165)
- Excelerator BI (151)
- In2BI (21)
- Power BI (560)
- powerbi (1)
- PowerPivotPro (157)
- SQL Chick (55)
- SQL Girl (50)
Recent Posts
- Migration From Analysis Services Multidimensional – Your Feedback Needed!
- Announcing: New contact list for Power BI apps and the option to allow contributors to update apps
- Join us! Thursday July 9, 2020 at 11:00 AM – 12:00 noon PDT with Reza Rad!
- Why Is Power BI Running My SQL Query Twice?
- Join us! Wednesday July 8, 2020 at 11:00 AM – 12:00 noon PDT with Reid Havens!
- Calculating Elapses Business Hours Using DAX Part 2
- Ideas.PowerBI.com – Azure Active Directory Single Sign On is Here!
- Announcing General Availability (GA) of enhanced connectivity for Snowflake
- Naming Tables, Columns And Measures In Power BI
- Calculating Business Hours Using DAX