One of the interesting features of ThingWorx Analytics Manager is its ability to run distributed models created in Excel (and more of course). Most people having been tasked with understanding data have built models in Excel and have sometimes built quite complex models (or even applications) with it.
The ability to tie these models to real data coming from various systems connected through ThingWorx and operationalise their execution is a really simple way for people to leverage their existing work and I.P. on a connected analytics journey.
To demonstrate this power and ease of implementation, I created a sample data set with historical data, traffic profile, and a simple anomaly detection model to execute with Analytics Manager. (files are attached)
The online help center was quite helpful in explaining the process of Creating the Excel Workbook, however I got stuck at the XML mapping stage. The Analytics and Excel documentation both neglect to mention one important detail -- you must be using the Windows version of Excel in order to get the XML Source functionality (and I use Mac). Once using Windows, it was easy to do - here is a video of the XML mapping part of the process (for the inputs and results).
Hi ,
Could you please explain why did you selected following formulas in excel sheet -->HourlyTravellerStatistics
In Cell Z4:
<<=MonthlyTicketSalesByDate!N18>>
In Cell Z6:
<<=MonthlyTicketSalesByDate!N19>>
Why cell N18 and N19 are specifically chosen here?
Thanks
Tushar
Content Move Notice (Dec. 2018)
ThingWorx Code Examples boards are now merged into IoT Tech Tips under the Code Examples label.
The Service Apps board is now merged into the Manufacturing Apps board.