Date Analytics for Subscription and Contracted Services


Details
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/
https://secure.meetupstatic.com/photos/event/4/c/e/5/600_459739685.jpeg
PRE-REGISTRATION IS MANDATORY:
Our room size is limited, so we need you to register in advance at our meetup site: https://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

Date Analytics for Subscription and Contracted Services