Please note: our site will be undergoing scheduled maintenance on April 21, 2019, starting at 07:00 UTC and ending at April 22, 2019 04:00 UTC. During this period, you will not be able to log in to your PASS account. To register for PASS Summit, select the Register as Guest option. If you require assistance, please email Thank you for your patience.

Fox Valley Microsoft Data Platform

Next Meeting




FoxPASS August 2015 Meeting

In August, we have local speaker Ben Taylor talking about...time! 

Featured Presentation:

Dealing With Time

Ben Taylor, Consultant Omni Resources

Tomorrow, today will be yesterday. The point is, time is constantly moving. Mining data based on time is a common problem. In a data warehouse it is so significant, most designs include a TIME dimension. There are lots of issues with time, such as reporting across time zones. A specific second is a part of a minute, hour, day, week, quarter, and year. Throw in fiscal years, and time becomes even more complicated. This presentation addresses the need to calculate aggregates of time across multiple decision points in an easy to understand implementation, utilizing standard transact SQL commands you can take home and use tomorrow. Watch how a single SSRS report presents pivoted time across multiple levels of aggregation of hours, days, weeks, months, quarters and years, including fiscal periods if we have time. Get a handle on time, before it runs out.

About Ben :

Bronze Sponsors




Other Sponsors






Brent Ozar Unlimited

Back to Top