HI all,
Does anyone have any experience of hooking Microsoft Power BI up to Tessitura for some sweet data visualisations?!
I love analytics but there are a few things I seem to be unable to currently achieve in analytics (happy to be told otherwise!) that I'd like to investigate in Power BI.
Would love to chat with some Power BI users out there if there are any?
Cheers!
James
Hi James, here at the Science Museum Group we have some initial explorations of exporting Tessitura data in Power BI for visualisation. This was before the days (at least our days) of Analytics, so having Analytics has mostly - though not entirely - obviated the requirement. We still in fact export a small amount of data from Tessitura into Power BI, via an Azure SQL database. This is daily site attendance numbers, which feed into a Retail Sales report I've built in Power BI (which is mainly drawing data from our retail POS system, which is entirely separate to Tessitura).
As RAMP users we're constrained in our options for exporting data from Tessitura. Other than running SQL in SQL Server Management Studio and copying the query results into a CSV, the option we had was pretty much using the REST API and using Custom/Execute calls to invoke custom Stored Procedures on impresario database. However, this method not suitable to extracting data at a very granular level (eg individual tickets) since it places a big load on the API (something Tessitura Network asks users to avoid). In any case, the data output can either be put in CSVs or into another database (eg Azure SQL) which Power BI can get to.
Happy to talk about this in more detail. I am a big fan of both Sisence (which drives Analytics) and Power BI but each is better at certain things and less good at others.
John