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
Hello James,
At the Royal Albert Hall we currently use Power BI alongside Sql Server Reporting services for a large amount of our data visualisations and reporting. We find the flexibility is the biggest selling point as it means we can combine our data with other sources outside of tessitura. We've only recently got analytics but see that in the future we'll have a hybrid system of analytics and power bi for visualisations on a case by case basis as both have their pros and cons.
Happy to chat through and potentially share some of our projects, would also be interested in hearing what problems you're trying to solve with Power BI
Yasmin