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