Fox Valley Microsoft Data Platform

Next Meeting: Wed, Aug 05 2015

FoxPASS August 2015 Meeting

Language: English
Event Type: In-Person & Online
Online Meeting URL: https://meet.lync.com/sqlpass365-sqlpass/fox/DG74KTXI
RSVPURL: http://fox-pass-sql.eventbrite.com

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

When

iCal
UTC : Wed, Aug 05 2015 22:30 - 00:00
Event Time : Wed, Aug 05 2015 17:30 - 19:00 Central Daylight Time
Your Local Time: Wed, Aug 05 2015 22:30 - 00:00

Where

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

Direction: None

Featured Presentation

Dealing With Time

Speaker: Ben Taylor, Consultant Omni Resources

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

Attachments

Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 

 

Brent Ozar Unlimited

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids