Next Meeting: Wed, Aug 05 2015
FoxPASS August 2015 Meeting
Event Type: In-Person & Online
Online Meeting URL: https://meet.lync.com/sqlpass365-sqlpass/fox/DG74KTXI
In August, we have local speaker Ben Taylor talking about...time!
Event Time : Wed, Aug 05 2015 17:30 - 19:00 Central Daylight Time
Your Local Time: Wed, Aug 05 2015 22:30 - 00:00
4351 W College Ave
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 :