• Replies 10 replies
  • Subscribers 414 subscribers
  • Views 89 views
  • Users 0 members are here
Related

extracting large amounts of data

Former Member
Former Member $organization

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

  • $organization in reply to Former Member

    Hi Mark,

    I used Power Query at Seattle Opera to do exactly this type of data analysis - it's a huge time saver and an amazing tool. That said, if your organization is a RAMP organization, then you cannot directly connect Excel to Tessitura using Power Query. There are database and privacy issues. I checked with Tess at TLCC and there is no possible way to make the connection. 

    Here at Seattle Symphony, we are a RAMP organization and I have been exploring how you work with data and Power Query when you can't access the live data from Tess. Basically, I have pulled data out using a combination of reports and output set elements (heavily leaning on custom elements) and then used Power Query and Power Pivot tables to turn that data into something I can combine and produce analysis on. Its not as fluid as before but it's still better than anything else I have been able to do.

    Nicholas  

  • $organization

    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 Frey
    Sent: Wednesday, September 16, 2015 1:22 PM
    To: Thomas Brown <tbrown@bam.org>
    Subject: [Tessitura Development Forum] extracting large amounts of data

     

    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




    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!

  • Former Member
    Former Member $organization

    Thanks Tom!  That sounds amazing!  I’m going to investigate further to see if I can get that here.  I appreciate your offer to talk.  I’ll email you if I have any questions.

     

    Mark Frey  |  Woodruff Arts Center  |   P: 404.733.4277

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Tom Brown
    Sent: Wednesday, September 16, 2015 2:05 PM
    To: Mark Frey
    Subject: RE: [Tessitura Development Forum] extracting large amounts of data

     

    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 Frey
    Sent: Wednesday, September 16, 2015 1:22 PM
    To: Thomas Brown <tbrown@bam.org>
    Subject: [Tessitura Development Forum] extracting large amounts of data

     

    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




    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!




    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!

  • Former Member
    Former Member $organization

    Thanks so much Nicholas!  This is all good information. 

     

    Mark Frey  |  Woodruff Arts Center  |   P: 404.733.4277

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Nicholas Walls
    Sent: Wednesday, September 16, 2015 3:44 PM
    To: Mark Frey
    Subject: RE: [Tessitura Development Forum] extracting large amounts of data

     

    Hi Mark,

    I used Power Query at Seattle Opera to do exactly this type of data analysis - it's a huge time saver and an amazing tool. That said, if your organization is a RAMP organization, then you cannot directly connect Excel to Tessitura using Power Query. There are database and privacy issues. I checked with Tess at TLCC and there is no possible way to make the connection. 

    Here at Seattle Symphony, we are a RAMP organization and I have been exploring how you work with data and Power Query when you can't access the live data from Tess. Basically, I have pulled data out using a combination of reports and output set elements (heavily leaning on custom elements) and then used Power Query and Power Pivot tables to turn that data into something I can combine and produce analysis on. Its not as fluid as before but it's still better than anything else I have been able to do.

    Nicholas  

    From: Mark Frey <bounce-markfrey7157@tessituranetwork.com>
    Sent: 9/16/2015 6:20:35 PM

    Thanks Tom!  That sounds amazing!  I’m going to investigate further to see if I can get that here.  I appreciate your offer to talk.  I’ll email you if I have any questions.

     

    Mark Frey  |  Woodruff Arts Center  |   P: 404.733.4277

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Tom Brown
    Sent: Wednesday, September 16, 2015 2:05 PM
    To: Mark Frey
    Subject: RE: [Tessitura Development Forum] extracting large amounts of data

     

    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 Frey
    Sent: Wednesday, September 16, 2015 1:22 PM
    To: Thomas Brown <tbrown@bam.org>
    Subject: [Tessitura Development Forum] extracting large amounts of data

     

    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




    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!




    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!




    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!

  • $organization in reply to Tom Brown (Past Member)

    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. 

  • $organization in reply to Adria Gunter

    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

  • $organization in reply to Adria Gunter

    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.

    Susan

  • $organization
    Thanks Susan. Don't I have to pull each season's data separately and Grid to Excel each time? I will check on this Microsoft BI. Thanks for the link. I'm looking at videos for Power Query as well now. 

    On Wed, Apr 20, 2016 at 2:03 PM, Susan Farma <bounce-susanfarma5540@tessituranetwork.com> wrote:

    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. 



    --
    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

  • $organization


    On Wed, Apr 20, 2016 at 3:44 PM, Susan Farma <bounce-susanfarma5540@tessituranetwork.com> wrote:

    For some bizarre reason every time I try to pull more than one season it never shows when I have the two seasons as the Filter/Slicer. Isn't it supposed to show the two seasons vertically?

    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.

    Susan

    From: Adria Gunter <bounce-adriagunter1034@tessituranetwork.com>
    Sent: 4/20/2016 6:20:52 PM

    Thanks Susan. Don't I have to pull each season's data separately and Grid to Excel each time? I will check on this Microsoft BI. Thanks for the link. I'm looking at videos for Power Query as well now. 

    On Wed, Apr 20, 2016 at 2:03 PM, Susan Farma <bounce-susanfarma5540@tessituranetwork.com> wrote:

    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. 



    --
    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



    --
    View this message online at http://www.tessituranetwork.com/Community/forums/p/14405/48053.aspx#48053 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

  • Former Member
    Former Member $organization

    Hey Adria,

     

    It’ll show vertically if you put it in the Series section instead of the Filter/Slicer.

     

    Mark

     

    Mark Frey  |  Woodruff Arts Center  |   P: 404.733.4277

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Adria Gunter
    Sent: Wednesday, April 20, 2016 6:38 PM
    To: Mark Frey
    Subject: Re: [Tessitura Development Forum] extracting large amounts of data

     

     

     

    On Wed, Apr 20, 2016 at 3:44 PM, Susan Farma <bounce-susanfarma5540@tessituranetwork.com> wrote:

     

    For some bizarre reason every time I try to pull more than one season it never shows when I have the two seasons as the Filter/Slicer. Isn't it supposed to show the two seasons vertically?

    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.

    Susan

    From: Adria Gunter <bounce-adriagunter1034@tessituranetwork.com>
    Sent: 4/20/2016 6:20:52 PM

    Thanks Susan. Don't I have to pull each season's data separately and Grid to Excel each time? I will check on this Microsoft BI. Thanks for the link. I'm looking at videos for Power Query as well now. 

     

    On Wed, Apr 20, 2016 at 2:03 PM, Susan Farma <bounce-susanfarma5540@tessituranetwork.com> wrote:

    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. 



    --
    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



    --
    View this message online at http://www.tessituranetwork.com/Community/forums/p/14405/48053.aspx#48053 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




    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!