Date Analytics for Subscription and Contracted Services

UPDATE: PLEASE DON'T COME EARLY AS MICROSOFT IS HOSTING AN EVENT THAT IS SET TO FINISH AT 5:30 PM. LET'S BE RESPECT OF OUR HOST AS THEY KINDLY ALLOW US TO USE THE SPACE!

SESSION OUTLINE:

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. Let's explore some models that handle this concept, and try to extend it to other non-subscription business problems too.

SPEAKER PROFILE:

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: https://www.linkedin.com/in/toddmcdermid/

PRE-REGISTRATION IS MANDATORY:

Our room size is limited, so we need you to register in advance at our meetup site: http://www.meetup.com/Vancouver-Power-BI-User-Group/

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