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/
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 Desktop
· MS 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