Is there a way to extract large amounts of data without locking up Tessitura or getting the "Tessitura not Responding" message? I work in a large arts organization and often need to pull combined data from all of our divisions for large time frames. There has to be an easier way than running many shorter reports, downloading, and then piecing them together so that I can work with the data.
Thanks so much!Mark
Mark,
We are using a method based on Microsoft Power Query & Power Pivot here at BAM.
I have a spreadsheet in front of me at the moment with all 7.25 million seats we have made available over the last 13 years here at BAM.
In just a few moments, I can pull the 225,000 + contributions in our systems. Just did it… It took about 1 minute start to finish. I know that the Seattle Opera is doing the same thing.
I’d be glad to talk with you about our approach.
--Tom
…
718.724.8135
tbrown@BAM.org
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Mark FreySent: Wednesday, September 16, 2015 1:22 PMTo: Thomas Brown <tbrown@bam.org>Subject: [Tessitura Development Forum] extracting large amounts of data
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Hi Tom. First, you're like an IT god to me right now. Whenever I search for something there you are always with the answers. You're a gem. So I have also heard of the presentation of the Excel Power Query and have been looking at a couple of tutorials online. We're lucky enough to have Microsoft Office Professional Plus 2010 which can run Excel Power Query. My purpose for looking into it is that I'd like to have views/reports created for upper management and myself that can assist in budget projections, ticket sales comparisons last year to this year and prior years, compare donations last year to this year. Does this sound like what Power Query is useful for accomplishing? I don't do SQL at all. We are anemic in the custom report area but still need the information a custom report would pull. I think that I'm probably the primary person that would use it since I'm most interested in trying to solve our custom report deficiency. This Power Query is for query only right? No manipulation? I wasn't quite sure of Beth's concern for having people view other department's data. That may be a concern in a larger organization but we're really small. Let me know if you think this is really useful for non-IT, non-SQL people like myself. How would I get started in created views? I'll continue to watch some tutorials but it'd be nice to see what you're doing at BAM since you already have it up and running. We're going to have Laura Scholl present on this at the conference because I think it's valuable to organizations without DBAs like us. Thanks in advance.
Hi Adria,
For year over year comparisons I would use T-stats. Check out the T-Stats Recipe book - there are some examples there, I believe. You can then bring the data into Excel and use Microsoft Power BI to make it really pretty: https://powerbi.microsoft.com/en-us/?getStartedPage=16.15
Susan