• Replies 5 replies
  • Subscribers 963 subscribers
  • Views 32 views
  • Users 0 members are here
Related

Welcome

Tom Brown (Past Member)
$organization

Hi All,

Welcome to the Self Service BI group here on Tessitura Network.com

So we are all about self service so take a moment to make sure that you are subscribed to the group's email feed.

Please also take a moment to answer these two questions.

1. What self service BI tools are rocking your world right now?

2. What data analysis question would be most helpful for you to solve?

  • $organization

    So here is my response.

    My name is Tom Brown, I'm the Tessitura Business Manager here at BAM (the Brooklyn Academy of Music).

    I'm having some interesting results with Microsoft Power Query and Power Pivot.  The harvesting of additional data through REST services.

    I'd love to have a Transaction Model that was both straight forward to use and powerful.

  • $organization

    My name is Brian Ramos, and I am the Development Operations Manager for Seattle Opera.

    I am currently exploring Microsoft's Power Query and Power Pivot to create excel based dashboards and analysis tools directly out of Tessitura. To aid in that, I am trying to develop standard SQL views from Tessitura, which can then be pulled in and manipulated if need be. The tables themselves are great, but it is often easier to have names and descriptions in the various tables instead of reference numbers.

    I'm also exploring what can be done with some statistical software such as SPSS (or PSPP for a free alternative) to help determine the drivers, and how much they drive, of various levers of contributed revenue. With these in place, I'm hoping to build some predictive and prescriptive analytic tools that tie directly to live data out of Tessitura.

  • $organization in reply to Brian Ramos

    Brian, It's great to have you on the Self-Service BI group here on TessituraNetwork.com.

    We are also looking at some of the same things you are considering.

    You might find this Video from Marco Russo of interest.  It describes from a IT professionals point of view the use of database views for publishing data for internal self service BI initutives.

    What data views have you created so far?

     

  • $organization

    Hi, I am Flavia Barros and I am the senior Director for Finance, Institutional Advancement at the American Museum of Natural History. The museum is in the final stages of implementing Tessitura, and I look forward to using many of the tools and data that will be available to us then.

    I am currently playing around with Power Pivot and Power Query. When Tessitura is implemented here, I look forward to creating a donor behavior model that can be useful in predictive analysis.

    Looking forward to many discussions here in the group!

     

     

  • $organization in reply to Flavia Barros

    This is interesting to me as well.

    As you are planning your implementation what opportunities are you taking to collect standard Tessitura and custom variables to support your model?