• Replies 19 replies
  • Subscribers 964 subscribers
  • Views 391 views
  • Users 0 members are here
Related

Exporting Your Data - What Are You Doing?

Summer Hirtzel (Past Member)
$organization

Hi folks! I've really enjoyed reading through all the past posts in this forum since I discovered it the other day (Tom Brown you are my new favorite Tessituran), and I have some questions! I'm just starting to get into Power BI (I have training in Mode and Tableau, but the pricepoints there are pretty prohibitive so I'm...pivoting...:D), and while I'm used to running SQL queries in SSMS, I'm not familiar with exporting the query results for analysis outside of the system.

I'd love to know how you all are exporting your data into your analysis tool of choice? Are you connecting from Tessitura, T-Stats, or both? Does being on RAMP make it harder (we're on RAMP)?

Any suggestions and tips would be very much appreciated! 

p.s. a bit off topic: I love this article http://firstround.com/review/im-sorry-but-those-are-vanity-metrics/



[edited by: Summer Hirtzel at 8:25 PM (GMT -6) on 19 Apr 2017]
  • $organization in reply to Arthur Curtis

    Arthur,  let me do some research on the go to meeting idea.  Back to folks when I know more.   

  • $organization
    I really like this idea as well, along with having a standing meeting going forward. I think it sounds like a perfect way to stay in touch more regularly and see what we're all doing througjout the year - digital TUG, perfect description.

    Would it be worth splitting the first meeting into two parts to handle the admin and planning, then the first presentation?

    Also, this only works if weve got enough users, but if we could settle dates a year out what about organizing a meeting leader for each date? So in September, person A will lead/moderate, then in October person B, and so on, with settled dates so that we can all put them on our calendars.
    From: Self-service Business Intelligence <groups-selfservicebi@tessituranetwork.com> on behalf of Tom Brown <bounce-tombrown3568@tessituranetwork.com>
    Sent: Friday, August 18, 2017 2:36:34 AM
    To: Samantha Erenberger
    Subject: RE: [Self-service Business Intelligence] Exporting Your Data - What Are You Doing?
     

    Arthur,

    love this idea.  (In fact I've been thinking about this for some time now.)

    The idea from my point of view is a "virtual TUG" on analytics.  

    I'm working on getting a conference bridge setup, either through BAM or the network.  I'd like to do the first meeting before September 29, because my schedule gets a bit more complicated after that date.  

    I suspect the best way to do this is to start a doodle poll for the dates / times.  I think that the web programmers who have done something like this in the past found noon - 1:00pm eastern time one of the better times to do this.  Let's try a rather large doodle poll for every day the second and third weeks of September. Are you comfortable doing this Arthur?  

    Let's post to this list and the participants of any of the open space sessions that might make sense.  

    Agenda

    1. Conversation What we are hoping from the group.

    2. Invitation / Solicitation of a core leadership team.

    Three leaders of the group overall

    Leaders would just make sure we are on track getting out an event each month and liaison with the network to get the bridge setup.

    Folks to volunteer for setting up content for the next few months.  Folks would plan 1 hour content / activities

    3. We might try an online version of "lean coffee" for the remainder of the first meeting. I can walk folks through this activity.

    For this first meeting we may need 1.5 hours.  To do administrative and content portions.  

    Do we have a marketer on the group that could pull together an invitation email?

    Thoughts? 

    To be successful we need to have this planned by the end of August.  

    We might call the event Analytic Coffee.  

     

    From: Arthur Curtis <bounce-arthurcurtis5363@tessituranetwork.com>
    Sent: 8/17/2017 12:37:20 PM

    Hi Tom, I am wondering if we can setup a monthly "Go To" style meeting where we can all get together and maybe rotate a presentation on what we are working on and discuss any topics. I am thinking that maybe we can just submit topic ideas ahead of time and ask at least one of us to do a quick presentation. I ask you this as I feel that you are leading us as a Business Intelligence group and if you are willing to lead I believe that we are willing to follow. I would be glad to assist and help schedule and put together agenda and if possible ask others to assist with presentations. Please let me know your thoughts. ---Arthur



  • $organization
    That way we won't lose momentum halfway through the year, I figure
    From: Self-service Business Intelligence <groups-selfservicebi@tessituranetwork.com> on behalf of Samantha Erenberger <bounce-samanthaerenberger9862@tessituranetwork.com>
    Sent: Friday, August 18, 2017 4:37:33 AM
    To: Samantha Erenberger
    Subject: RE: [Self-service Business Intelligence] Exporting Your Data - What Are You Doing?
     
    I really like this idea as well, along with having a standing meeting going forward. I think it sounds like a perfect way to stay in touch more regularly and see what we're all doing througjout the year - digital TUG, perfect description.

    Would it be worth splitting the first meeting into two parts to handle the admin and planning, then the first presentation?

    Also, this only works if weve got enough users, but if we could settle dates a year out what about organizing a meeting leader for each date? So in September, person A will lead/moderate, then in October person B, and so on, with settled dates so that we can all put them on our calendars.
    From: Self-service Business Intelligence <groups-selfservicebi@tessituranetwork.com> on behalf of Tom Brown <bounce-tombrown3568@tessituranetwork.com>
    Sent: Friday, August 18, 2017 2:36:34 AM
    To: Samantha Erenberger
    Subject: RE: [Self-service Business Intelligence] Exporting Your Data - What Are You Doing?
     

    Arthur,

    love this idea.  (In fact I've been thinking about this for some time now.)

    The idea from my point of view is a "virtual TUG" on analytics.  

    I'm working on getting a conference bridge setup, either through BAM or the network.  I'd like to do the first meeting before September 29, because my schedule gets a bit more complicated after that date.  

    I suspect the best way to do this is to start a doodle poll for the dates / times.  I think that the web programmers who have done something like this in the past found noon - 1:00pm eastern time one of the better times to do this.  Let's try a rather large doodle poll for every day the second and third weeks of September. Are you comfortable doing this Arthur?  

    Let's post to this list and the participants of any of the open space sessions that might make sense.  

    Agenda

    1. Conversation What we are hoping from the group.

    2. Invitation / Solicitation of a core leadership team.

    Three leaders of the group overall

    Leaders would just make sure we are on track getting out an event each month and liaison with the network to get the bridge setup.

    Folks to volunteer for setting up content for the next few months.  Folks would plan 1 hour content / activities

    3. We might try an online version of "lean coffee" for the remainder of the first meeting. I can walk folks through this activity.

    For this first meeting we may need 1.5 hours.  To do administrative and content portions.  

    Do we have a marketer on the group that could pull together an invitation email?

    Thoughts? 

    To be successful we need to have this planned by the end of August.  

    We might call the event Analytic Coffee.  

     

    From: Arthur Curtis <bounce-arthurcurtis5363@tessituranetwork.com>
    Sent: 8/17/2017 12:37:20 PM

    Hi Tom, I am wondering if we can setup a monthly "Go To" style meeting where we can all get together and maybe rotate a presentation on what we are working on and discuss any topics. I am thinking that maybe we can just submit topic ideas ahead of time and ask at least one of us to do a quick presentation. I ask you this as I feel that you are leading us as a Business Intelligence group and if you are willing to lead I believe that we are willing to follow. I would be glad to assist and help schedule and put together agenda and if possible ask others to assist with presentations. Please let me know your thoughts. ---Arthur






  • $organization in reply to Arthur Curtis

    Arthur,

    love this idea.  (In fact I've been thinking about this for some time now.)

    The idea from my point of view is a "virtual TUG" on analytics.  

    I'm working on getting a conference bridge setup, either through BAM or the network.  I'd like to do the first meeting before September 29, because my schedule gets a bit more complicated after that date.  

    I suspect the best way to do this is to start a doodle poll for the dates / times.  I think that the web programmers who have done something like this in the past found noon - 1:00pm eastern time one of the better times to do this.  Let's try a rather large doodle poll for every day the second and third weeks of September. Are you comfortable doing this Arthur?  

    Let's post to this list and the participants of any of the open space sessions that might make sense.  

    Agenda

    1. Conversation What we are hoping from the group.

    2. Invitation / Solicitation of a core leadership team.

    Three leaders of the group overall

    Leaders would just make sure we are on track getting out an event each month and liaison with the network to get the bridge setup.

    Folks to volunteer for setting up content for the next few months.  Folks would plan 1 hour content / activities

    3. We might try an online version of "lean coffee" for the remainder of the first meeting. I can walk folks through this activity.

    For this first meeting we may need 1.5 hours.  To do administrative and content portions.  

    Do we have a marketer on the group that could pull together an invitation email?

    Thoughts? 

    To be successful we need to have this planned by the end of August.  

    We might call the event Analytic Coffee.