Exporting Your Data - What Are You Doing?

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.

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.

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?

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,

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.

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.

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.

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?

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,

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.