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 (198)
- Data Chant (160)
- Excelerator BI (141)
- In2BI (21)
- Power BI (508)
- powerbi (1)
- PowerPivotPro (151)
- SQL Chick (55)
- SQL Girl (50)
Recent Posts
- Move All Columns into a Display Folder with Tabular Editor
- Understanding The “The key didn’t match any rows in the table” Error In Power Query In Power BI Or Excel
- COVID-19 & Time Intelligence in Power BI
- Speed up your Power BI DAX formulas by up to 95% using the new OPTIMIZEDAX() function
- Skillwave – Learn Power BI from Industry Experts
- How Public Agencies Keep Communities Informed on COVID-19 with Power BI
- Join us! March 31, 11:00 am PDT – Power BI Not Just a Visualization Tool
- Analysing Dataset Refresh In Power BI Premium Using SQL Server Profiler
- ‘Better Together’ Contest Finalists Announced!
- New Instructor Led Online Power BI Training Classes