Hi,
I'm getting data request from different areas of the business, and although we have everything in the database, and a complex suite of reports that answer most of the day to day needs; every time we get an adhoc request that requires querying the database directly we have a few challenges.
There is no in house resource that knows sql in the level that is needed.
And we also need to combine different tables to replicate the model's behaviour so that we extract the same numbers.
Is there a way to query the model's dataset inside the service using a graphic interface ? That would be ideal, as it would allow us to maintain the model's measures and calculations while extracting ad hoc requests.
Alternatively, would it be possible to query the database directly using PQ graphic interface ?
I tried using analyse in Excel, but the probably due to the size of the database, the file keeps hanging.
I then tried dataflows but I could only export a json file, without any data.
Finally, I tried datamarts, but the PQ UI keep loading forever.
A few things to note:
We have +5 years of data, most of the request require 2 or less years of data.
We have multiple tables and some considerations embedded into the model's logic - hence the ideal solution would be to query the model's dataset directly.
Is the cruel answer simply that we lack an IT resource that could help us manage ad hoc request as there is no workaround ?
Thanks!
