Fox Valley Microsoft Data Platform

Next Meeting




FoxPASS January 2013 Meeting

Join us for networking, a discussion on the future of business intelligence, dinner, and a presentation from Dave DuVarney! Live Meeting link:

Featured Presentation:

It’s About Time – Adding Date Comparison Logic to Your Data Warehouse and Analysis Services Cubes

Dave DuVarney, Consultant Talavant

Analytical problems very often require some time element to make them relevant. There are many scenarios where end users need to compare one time period to another: year to date, this period vs. the same period last year, etc. There are a few techniques that can provide an incredible amount of insight into existing data by adding common date calculations. In this presentation we’ll look at three areas: 1. Common attributes used in a date dimension to facilitate time based analysis 2. Building a Date Utility dimension in Analysis Services to aggregate and compare data over time 3. Leveraging the Date Utility dimension and other attributes in front end reporting tools

About Dave:
Dave DuVarney is an independent business intelligence consultant and trainer. He has broad technical and functional BI knowledge and has worked with organizations across the full BI life cycle. Dave has helped clients establish their BI program and run Agile development teams. He specializes in SQL Server Analysis Services, Integration Services, and Reporting Services as well as .NET development.

Bronze Sponsors




Other Sponsors






Brent Ozar Unlimited

Back to Top