Automating Reports that include 3rd Party Sales Data

We have started to play with microsoft's Power Query to "automatically" pull together data from multiple data sources into a single MS Excel spreadsheet. You do not describe much about the sources of data you are trying to aggregate. However, Power Query has all sorts of options. Tessitura is fairly easy. Build a SQL server database view that exposes the data to authorized staff. Or pull from t-Stats tickets or seats cube. There are lots of other sources that Power Query can access, text files, other databases, rest services, the list goes on.

This would then be loaded into a PowerPivot "tabular" data model. In which you could do the calculations you need to do in order graph you sales curves.

If intrested let's setup a call.

--Tom

On Fri, Sep 12, 2014 at 3:46 AM, Tessitura Marketing Forum wrote:

I'm curious to know if others have found ways to completely automate composite reports that include Tessitura sales data and sales from 3rd parties (i.e. ticket agencies or outlets)? 'Completely' being the key word. Specifically, reports that include sales by transaction date that could produce a year-to-year sales curve comparison.

Thanks for the feedback.

Best,

Chuck



Senior Data Analyst

T 02 9250 7618

Sydney Opera House Bennelong Point

GPO Box 4274 Sydney NSW 2001 AUSTRALIA



This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing 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!

We have started to play with microsoft's Power Query to "automatically" pull together data from multiple data sources into a single MS Excel spreadsheet. You do not describe much about the sources of data you are trying to aggregate. However, Power Query has all sorts of options. Tessitura is fairly easy. Build a SQL server database view that exposes the data to authorized staff. Or pull from t-Stats tickets or seats cube. There are lots of other sources that Power Query can access, text files, other databases, rest services, the list goes on.

This would then be loaded into a PowerPivot "tabular" data model. In which you could do the calculations you need to do in order graph you sales curves.

If intrested let's setup a call.

--Tom

On Fri, Sep 12, 2014 at 3:46 AM, Tessitura Marketing Forum wrote:

I'm curious to know if others have found ways to completely automate composite reports that include Tessitura sales data and sales from 3rd parties (i.e. ticket agencies or outlets)? 'Completely' being the key word. Specifically, reports that include sales by transaction date that could produce a year-to-year sales curve comparison.

Thanks for the feedback.

Best,

Chuck



Senior Data Analyst

T 02 9250 7618

Sydney Opera House Bennelong Point

GPO Box 4274 Sydney NSW 2001 AUSTRALIA



This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing 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!