Fox Valley Microsoft Data Platform

Next Meeting: Wed, Jan 16 2013

FoxPASS January 2013 Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None

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


UTC : Wed, Jan 16 2013 23:30 - 01:30
Event Time : Wed, Jan 16 2013 17:30 - 19:30 (UTC-06:00) Central Time (US & Canada)
Your Local Time: Wed, Jan 16 2013 23:30 - 01:30


100 W Lawrence St, Suite 100 Appleton Center
Appleton, Wisconsin

Direction: None

Featured Presentation

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

Speaker: Dave DuVarney, Consultant Talavant

Summary: 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.








Brent Ozar Unlimited

Back to Top