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
- What’s new with ArcGIS for Power BI
- Power BI February 2021 Feature Summary
- Power BI Developer community February 2021 update
- Query Folding On SQL Queries In Power Query Using Value.NativeQuery() and EnableFolding=true
- Implementing Data (As Well As Metadata) Translations In Power BI
- Microsoft named a Leader in the 2021 Gartner Magic Quadrant for Analytics and BI Platforms
- Data insights without limit, security without compromise
- .NET Core support for Analysis Services client libraries is GA
- Optimise The Performance Of Reading Data From ADLSgen2 In Power BI With The HierarchicalNavigation Option
- Join us! Power BI Instructor Led Training! 24th & 25th of February, 2021 from 5:00 AM – 9:00 AM PST
Blogroll
- Chris Webb (250)
- Data Chant (182)
- Excelerator BI (162)
- In2BI (21)
- Power BI (676)
- powerbi (1)
- PowerPivotPro (163)
- SQL Chick (55)
- SQL Girl (50)
Recent Posts
- What’s new with ArcGIS for Power BI
- Power BI February 2021 Feature Summary
- Power BI Developer community February 2021 update
- Query Folding On SQL Queries In Power Query Using Value.NativeQuery() and EnableFolding=true
- Implementing Data (As Well As Metadata) Translations In Power BI
- Microsoft named a Leader in the 2021 Gartner Magic Quadrant for Analytics and BI Platforms
- Data insights without limit, security without compromise
- .NET Core support for Analysis Services client libraries is GA
- Optimise The Performance Of Reading Data From ADLSgen2 In Power BI With The HierarchicalNavigation Option
- Join us! Power BI Instructor Led Training! 24th & 25th of February, 2021 from 5:00 AM – 9:00 AM PST