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.

I should also mention that we don't have any IT staff, so the solution is designed to be very hands off for the organization.

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.

I should also mention that we don't have any IT staff, so the solution is designed to be very hands off for the organization.

This is really exciting Brian. I am wondering if you can share any success stories of staff adoption. The problem that I am having within my Consortia is that the Senior Management wants adoption outside of IT, Finance a few power users. We ran into this issue with T-Stats where we were successful in using within IT, Finance and a few power users but unsuccessful in expanding it out to the larger staff even after applying some of the lessens learning from Nicole Keating in Miami. The fear is that Power BI will be in the hands of the few and not empower all users. Thank you in advance for any thoughts that you can share on this. ---Arthur

Arthur,

This is a real interesting question, point...

In your mind, (or maybe I'm asking in the minds of your execs. [as you see them]) 

What does it look like when we "empower all users" to use data, when it comes to non-it, non-finance, non-power user?  

Do the execs expect, that these folks are able to quote regression coefficients, certainties of 90 day sales forecasts, or be able to create new diagnostic model... (of course I think, I'm being silly here...)

What about yesterday's sales numbers, or the size of the largest subscriptions in the last 90 days.  Or should they know who gave the $100,000 gift last week?  I suspect that Existing tessitura dashboards would likely do some maybe much of this... 

Given that we are trying to do this... Do the folks we are talking about have the needed skills, curiosity to find the data useful?  Do we have an internal culture that hires for staff who can do these things?  If not can we train our existing staff? And can we change the internal culture to value knowing these types of things as consistently as what is playing on our stages...

I'm wondering if we could start another thread on this group about this topic.  What does mass data use success look like in your organization? 

Then we might get clearer about tools and techniques.  

To date at BAM I've been focused on tools, data, training for the types of folks you are listing in your note.  I see value in broadening this focus.