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/
Summer,
As a RAMP user I'm still working out the best way to get more detailed data to use - not being able to connect PowerBI or PowerQuery presents some challenges. If aggrgated data is what you are looking for, I find T-Stats is usually the easiest way and can export into Excel. The problem is when you need disaggregated data. My usual process for getting data to analyze is to write a query that compiles as much as possible in one go. If the dataset ends up not being too large I can copy and paste the grid into excel directly from SSMS. This is kind of a low-tech solution but works reasonably well.
As a long term project that I work on when there is nothing else pressing, I am trying to build a data model in PowerBI that I can use for tackling all sorts of projects. I think I can get it to encompass most things I would reasonably need with around 30-40 standard tables and views. The next step is to come up with a good way of simplifying the process of updating the data that I use on site - this is what I haven't quite figured out. I want to avoid just copying tables or views after taking any information that can be used to identify people out of it. I think there might a way to drop each section into a csv that I can use to update the reference files.
I would love to hear from anyone that has successfully integrated PowerBI using RAMP. I was hoping the new analytics portion of Tessitura would be out soon enough that I could just use that, but I guess I have to wait a bit longer. At least once I also teach myself R, PowerBI can handle that as well.
-Andrew