Category Archives: Analytics

Windowed Functions empowering analytics [#TSQL2sday]

This blog entry is participating in the T-SQL Tuesday #16 for the month of February, hosted by Jes Schultz Borland (Blog|Twitter). Back in 2001 I was involved in a project migrating an e-commerce site to a new platform. We were mapping and moving data from an Oracle 8.1.5 to an… Read more »

MediaWhiz’s BI Solution Goes Live [Analytics]

      3 Comments on MediaWhiz’s BI Solution Goes Live [Analytics]

We presented the solution to the business owners, with multiple sample reports generated by SSMS, Regular Pivot Tables and PowerPivot for Excel. We sliced and diced at the client level, server level and the results were coming back pretty fast. They were extremely happy as they just found a way to slice “everything by everything”. I even heard the statement ‎”This will be the company’s biggest asset”.