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
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 SusanFrom: Adria Gunter <bounce-adriagunter1034@tessituranetwork.com>Sent: 4/20/2016 11:59:17 AMHi 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. --View this message online at http://www.tessituranetwork.com/Community/forums/p/14405/48037.aspx#48037 or reply to this message Adria Gunter | Subscriptions and Groups Manager STUDIO THEATRE 1501 14TH ST NW WASHINGTON DC 20005 T 202-232-7267, ext. (365) F 202-588-5262 www.studiotheatre.org Subscriptions are online! Reserve your group of 10+ today and enjoy a discount! 2015-2016 SEASON MAIN SERIES CHIMERICA |THE APPLE FAMILY CYCLE: SORRY & REGULAR SINGING | BETWEEN RIVERSIDE AND CRAZY | MOMENT | HEDDA GABLER 2015-2016 SEASON STUDIO X ANIMAL | CONSTELLATIONS 2015-2016 SPECIAL REMOUNT BAD JEWS
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
From: Adria Gunter <bounce-adriagunter1034@tessituranetwork.com>Sent: 4/20/2016 11:59:17 AM
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.
Adria Gunter | Subscriptions and Groups Manager
STUDIO THEATRE
1501 14TH ST NW
WASHINGTON DC 20005
T 202-232-7267, ext. (365)
F 202-588-5262
www.studiotheatre.org
Subscriptions are online! Reserve your group of 10+ today and enjoy a discount!
2015-2016 SEASON MAIN SERIES CHIMERICA |THE APPLE FAMILY CYCLE: SORRY & REGULAR SINGING | BETWEEN RIVERSIDE AND CRAZY | MOMENT | HEDDA GABLER
2015-2016 SEASON STUDIO X ANIMAL | CONSTELLATIONS
2015-2016 SPECIAL REMOUNT BAD JEWS
Hey Adria,
No, in T-Stats you can pull multiple seasons/fiscal years and report on them in tandem. T-Stats is aggregate data, so it it is great for summarizing. Also, no SQL required. Definitely check out the Power BI - especially if you are looking to prettify a dashboard for C- level folks.