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
Blogroll
- Chris Webb (186)
- Data Chant (152)
- Excelerator BI (131)
- In2BI (21)
- Power BI (464)
- powerbi (1)
- PowerPivotPro (146)
- SQL Chick (55)
- SQL Girl (50)
Recent Posts
- Come to Microsoft Business Applications Summit this May
- Premium Capacity Metrics app – new health center with KPIs to explore relevant metrics and steps to mitigate issues
- Power BI Dataset Refresh Scheduling Using Outlook And Power Automate
- Extracting Data from Complex Web Pages with Power BI
- Power BI Pixel – A new way to track usage on Power BI
- Performance Overhead Of Using Power BI Custom Visuals
- Happy New Year from Power BI Desktop!
- Fifteenth Blog Birthday
- On-premises data gateway December 2019 update is now available
- New “Diagnose Step” Power Query Feature In Power BI