|
|
|
|
|
|
by sskates
1553 days ago
|
|
|
Glad to hear you’ve been happy with Amplitude. We’ve been doing a lot RE helping customers federate data to data lakes/warehouses. If I can ask- what data lake you using and what data from Amplitude are you looking to get into it? (Raw dump of analytics data or something else?) |
|
|
We're actually not currently using a data lake. We were initially on the startup plan which was fantastic (the ability to do templated reports etc is a big one for us) but currently we couldn't justify the cost of a full subscription at that point (and now we are just making do until we can complete our next round at which point we will re-look at the whole situation)
We love that you have an API and used fivetran to ETL to (for want of something cheap + low BI tool costs) BigQuery where we were hoping to be able to attach Data Studio to it to achieve our objectives.
This may not have been the right approach.
We couldn't spare anyone from our dev team to take the time to work out the transforms/queries required to make it useful in Data Studio so we spent some time contracting the work out, but that fell over because they were on lend from a mate's startup and I think just never moved out of the blocks. Also maybe we were using the incorrect tools.
Essentially we were looking to get a fair proportion of our data out, in order to create data views for our clients on their usage (... platform in bio, but hospital analytics stuff - no patient info, all operational efficiency). This was fulfilled really nicely by Templates but in the reports we now generate (... a bit laborious but using a offshore contractor who takes all the pain out of it) we are also able to put benchmarking averages against their peer hospitals etc in which wasn't something it was immediately obvious we could achieve with Templates. Ultimately we want those individual dashboards available for the Hospitals to view, as well as be able to return things like views per period for their content on our dashboard, which we know we can also achieve through the API