Regular Visitor
Posts: 24
Registered: ‎05-17-2016

Date Analytics for Subscription and Contracted Services


Subscription or contracted services businesses have some unique analytic demands around dates.  They still have standard forms of analysis that may involve filtering and grouping facts on multiple role-playing date dimensions.  But they also need analytics where the same facts are shown multiple times, in different time periods; such as showing subscription starts as a positive in one month, and subscription expirations as a negative in another month in order to see the net change in contract values.  Lets explore some models that handle this concept, and try to extend it to other non-subscription business problems too.



Todd McDermid is a BI Solution Architect at Absolute Software, with a deep background in data warehousing, primarily in data modeling and ETL.  He’s built and extended BI systems in manufacturing, distribution, aerospace, and software industries, spoken at a few conferences, posted some articles, built some open-source extensions, and received a few awards. Learn more about Todd McDermid here:



Our room size is limited, so we need you to register in advance at our meetup site:


TENTATIVE AGENDA (subject to change)

  • 5:30pm-6:00pm Networking, Dinner & Soft Drinks
  • 6:00pm-6:05pm Welcome & Introductions
  • 6:05pm-6:55pm Feature Presentation
  • 6:55pm-7:00pm Closing