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/
Now that we have all met at conference, wondering if there is interested in standardizing some of the models like someone suggested so we can maybe share some code, ideas, models, etc? Also, for those of us on RAMP, it might make life easier for RAMP if we all were asking for the same thing and followed the same architecture patterns. Could we setup a github/gitlab repository to share scripts, etc? Thoughts? From: Tom Brown <bounce-tombrown3568@tessituranetwork.com> Sent: 5/12/2017 9:43:19 PM One of the great places at TLCC 2017 for this type of conversation will be at the Larger than ever open space discussions sessions. I would love see you or someone host a Tessitura in A Power BI session. Particularly considering that you have solved this for the RAMP world. Please consider offering such a discussion. And anyone else on the group. This will be a great place for discussions for advanced and niche BI conversations. Would love to hear about ideas folks might have for other types of conversations. --Tom … 718.724.8135 tbrown@BAM.org From: Self-service Business Intelligence [mailto:groups-selfservicebi@tessituranetwork.com] On Behalf Of Brian Ramos Sent: Friday, May 12, 2017 2:52 PM To: Thomas Brown <tbrown@bam.org> Subject: RE: [Self-service Business Intelligence] Exporting Your Data - What Are You Doing? I am presenting in the BI Faceoff session, so I’m sure you’ll see some of this in action there. I’m also more than willing to get a group together at conference or elsewhere to go through our setup and how everything fits together. Brian Ramos Controller Opera Philadelphia Direct 215.893.5940 Main 215.893.3600 Guest Services 215.732.8400 operaphila.org Connect From: Self-service Business Intelligence [mailto:groups-selfservicebi@tessituranetwork.com] On Behalf Of Tom Brown Sent: Friday, May 12, 2017 2:37 PM To: Brian Ramos <ramos@operaphila.org> Subject: RE: [Self-service Business Intelligence] Exporting Your Data - What Are You Doing? Excellent. Will you be showing some of this at conference this year? Are there other opportunities when I can see this in some more detail? --Tom … 718.724.8135 tbrown@BAM.org From: Self-service Business Intelligence [mailto:groups-selfservicebi@tessituranetwork.com] On Behalf Of Brian Ramos Sent: Friday, May 12, 2017 2:24 PM To: Thomas Brown <tbrown@bam.org> Subject: RE: [Self-service Business Intelligence] Exporting Your Data - What Are You Doing? We are using all three aspects of Power BI. I’ve created a pretty robust data model in PowerBI Desktop, which I publish to PowerBI.com for Report/Dashboard development and consumption by the organization. The Azure database is accessible to anyone in the organization to connect to in Excel as well provided they have the db username and password. That way, they can create Excel based stuff separate from the PowerBI Data Model. They can also connect to the Data Model in Excel via the Analyze in Excel functionality on PowerBI.com. Brian Ramos Controller Opera Philadelphia Direct 215.893.5940 Main 215.893.3600 Guest Services 215.732.8400 operaphila.org Connect From: Self-service Business Intelligence [mailto:groups-selfservicebi@tessituranetwork.com] On Behalf Of Tom Brown Sent: Thursday, May 11, 2017 5:01 PM To: Brian Ramos <ramos@operaphila.org> Subject: RE: [Self-service Business Intelligence] Exporting Your Data - What Are You Doing? Brian, I’m so glad to hear that you have worked this out. I know that going from “On Premises” to RAMP hosted Tessitura meant a bunch of changes for you. When you say Power BI what parts of Power BI are you using. MS Excel (Power Query, Power Pivot)Power BI DesktopMS Power BI web site Would love to hear more about some of your successes… --Tom … 718.724.8135 tbrown@BAM.org From: Self-service Business Intelligence [mailto:groups-selfservicebi@tessituranetwork.com] On Behalf Of Brian Ramos Sent: Thursday, May 11, 2017 4:34 PM To: Thomas Brown <tbrown@bam.org> Subject: Re: [Self-service Business Intelligence] Exporting Your Data - What Are You Doing? We at Opera Philadelphia have started using PowerBI with great success! We are also on RAMP, and it took us many month to finally work out a way with the RAMP Team to push sql view data to an Azure Database that we connect to PowerBI. So we have just under 40 views that are scheduled to be pushed to Azure every morning. We are still working with Tessitura to figure out the best method to easily update the views if we want to add views or additional fields, but they are actively working on a solution for us to do that. Currently, if we need to make any of these changes, it requires us working with the consulting team and the RAMP team to update scripts and files. I'm more than willing to share our views if you are interested in them. From: Summer Hirtzel <bounce-summerhirtzel1505@tessituranetwork.com> Sent: 4/19/2017 8:20:47 PM 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/
Now that we have all met at conference, wondering if there is interested in standardizing some of the models like someone suggested so we can maybe share some code, ideas, models, etc? Also, for those of us on RAMP, it might make life easier for RAMP if we all were asking for the same thing and followed the same architecture patterns. Could we setup a github/gitlab repository to share scripts, etc? Thoughts?
From: Tom Brown <bounce-tombrown3568@tessituranetwork.com> Sent: 5/12/2017 9:43:19 PM
One of the great places at TLCC 2017 for this type of conversation will be at the Larger than ever open space discussions sessions. I would love see you or someone host a Tessitura in A Power BI session. Particularly considering that you have solved this for the RAMP world. Please consider offering such a discussion. And anyone else on the group. This will be a great place for discussions for advanced and niche BI conversations. Would love to hear about ideas folks might have for other types of conversations.
--Tom
…
718.724.8135
tbrown@BAM.org
From: Self-service Business Intelligence [mailto:groups-selfservicebi@tessituranetwork.com] On Behalf Of Brian Ramos Sent: Friday, May 12, 2017 2:52 PM To: Thomas Brown <tbrown@bam.org> Subject: RE: [Self-service Business Intelligence] Exporting Your Data - What Are You Doing?
I am presenting in the BI Faceoff session, so I’m sure you’ll see some of this in action there.
I’m also more than willing to get a group together at conference or elsewhere to go through our setup and how everything fits together.
Brian Ramos
Controller
Opera Philadelphia
Direct 215.893.5940
Main 215.893.3600
Guest Services 215.732.8400
operaphila.org
Connect
From: Self-service Business Intelligence [mailto:groups-selfservicebi@tessituranetwork.com] On Behalf Of Tom Brown Sent: Friday, May 12, 2017 2:37 PM To: Brian Ramos <ramos@operaphila.org> Subject: RE: [Self-service Business Intelligence] Exporting Your Data - What Are You Doing?
Excellent.
Will you be showing some of this at conference this year?
Are there other opportunities when I can see this in some more detail?
From: Self-service Business Intelligence [mailto:groups-selfservicebi@tessituranetwork.com] On Behalf Of Brian Ramos Sent: Friday, May 12, 2017 2:24 PM To: Thomas Brown <tbrown@bam.org> Subject: RE: [Self-service Business Intelligence] Exporting Your Data - What Are You Doing?
We are using all three aspects of Power BI. I’ve created a pretty robust data model in PowerBI Desktop, which I publish to PowerBI.com for Report/Dashboard development and consumption by the organization. The Azure database is accessible to anyone in the organization to connect to in Excel as well provided they have the db username and password. That way, they can create Excel based stuff separate from the PowerBI Data Model. They can also connect to the Data Model in Excel via the Analyze in Excel functionality on PowerBI.com.
From: Self-service Business Intelligence [mailto:groups-selfservicebi@tessituranetwork.com] On Behalf Of Tom Brown Sent: Thursday, May 11, 2017 5:01 PM To: Brian Ramos <ramos@operaphila.org> Subject: RE: [Self-service Business Intelligence] Exporting Your Data - What Are You Doing?
Brian,
I’m so glad to hear that you have worked this out. I know that going from “On Premises” to RAMP hosted Tessitura meant a bunch of changes for you.
When you say Power BI what parts of Power BI are you using.
Would love to hear more about some of your successes…
From: Self-service Business Intelligence [mailto:groups-selfservicebi@tessituranetwork.com] On Behalf Of Brian Ramos Sent: Thursday, May 11, 2017 4:34 PM To: Thomas Brown <tbrown@bam.org> Subject: Re: [Self-service Business Intelligence] Exporting Your Data - What Are You Doing?
We at Opera Philadelphia have started using PowerBI with great success! We are also on RAMP, and it took us many month to finally work out a way with the RAMP Team to push sql view data to an Azure Database that we connect to PowerBI. So we have just under 40 views that are scheduled to be pushed to Azure every morning. We are still working with Tessitura to figure out the best method to easily update the views if we want to add views or additional fields, but they are actively working on a solution for us to do that. Currently, if we need to make any of these changes, it requires us working with the consulting team and the RAMP team to update scripts and files.
I'm more than willing to share our views if you are interested in them.
From: Summer Hirtzel <bounce-summerhirtzel1505@tessituranetwork.com> Sent: 4/19/2017 8:20:47 PM
Awesome, thanks for looking into it. I would love to know what you find out, and how to / if we can honor all the NDA's while also being able to work together as a community to do some great things with our data.
I reached out to Nick Reilingh over at Bard College nreiling@bard.edu. He has been active with the bitbucket Tessitura Network repository.
I asked if he thought we should consider using a similar approach as the web programmers. Here is what he had to offer. See below dashed lines...
What do folks think? Has anyone else joined TN_webshare? I think I have. (But I'm at 35,000 feet right now which make this a bit hard to share.) If someone else is able to access TN_Webshare. I would like to work with you to see if we can get a repo going. I'd share my chunk of Rnotebook code for accessing SQL data directly. I will also work to share my code from my advanced analytics presentation at TLCC2017.
----------------------------------------------------------
On Thu, Aug 17, 2017 at 7:19 AM, Nick Reilingh <nreiling@bard.edu> wrote:Absolutely! Bitbucket has all of the same collaboration features as any other git hosting service, and there's already a bunch of projects hosted there under the TN_WebShare team.
All you've got to do is get a username from bitbucket.org and then send an email to webmaster@tessituranetwork.com to have them add your user to the team. (Can't hurt to also request access to Slack and Confluence at the same time.)
-Nick