Time traveling for Power BI

Spoiler alert: Nerd-article

The SMS-Timing software is more and more used as a single tool to run an entire business or family entertainment center.  Also on the area’s that we haven’t foreseen earlier.  Topics like stock management, staff management, data analytics, everything is being handled and is offered as part of one product, with the same quality and ease of use expected from that product.

Data for statistical analysis is very different from data needed for live operations. In live operations, it is fine to know who “is doing it now”.  When we start processing data of years, we need to know “who did it back then”.

In close cooperation with our Power BI team, we have found a way to record all the data required for processing.  With little to no work, our data-analysis team can inform the framework that “time traveling” data should be recorded on certain data.

The software will understand this requirement and from that version on, each change on data will be processed in a Time-Traveling table and can be used for further analysis by Power BI.

Since this blog is also used by internal developers, I’ll explain quickly how to achieve this.

  1. Put the meta-tag <Timetravel=on/> on the table that should record time traveling data.Time traveling Power BI
  2. Run our AAA-Tool.  (Special tool that is used to manage the database structure)
    • A partner-table is created, suffixed “_TT”.
      A UTC Timestamp field is added.
      History is disabled on this new table.
      Synchronization is still happening though.Time traveling Power BI
    • This new table fills up automatically by a set of triggers.  All these triggers are created by the framework and should not be maintained.Time traveling Power BI

 

If you don’t fully understand what is happening here, don’t worry, you are only supposed to understand the end result.  The goal of this article is to announce that we have an easy solution to answer questions like: “Who made that sales on December 26th and to what sales team did he belong back then so we give the right manager his commission!”

Opt-out fields

It is in the latest version also possible to “opt-out” certain fields or domains from being added to the time travel list.  As soon as you mark a table for TimeTraveling, all fields are included, except those that the tag <timetravel=off/> mentioned explicitly inside the description of the field.

SMS-Timing and BMI Leisure are brands of B&MI NV. We offer an all-in-one reliable software suite, covering all aspects of your karting & entertainment business, including strategic advising, and marketing. We help you deliver fun, relaxing, and entertaining experiences to your visitors that will keep them coming back for more!

Our system includes a comprehensive POS system, CRM management, online booking & website shop for family entertainment centers all over the globe.

More information?

Check out our website: BMI Leisure and SMS-Timing

Need more help with this feature? Click here:  24/7 Support service

Check out other updated features here: devblogs 

Remember also to check our Marketing blogs for some inspiration! 

This site uses Akismet to reduce spam. Learn how your comment data is processed.