6 ms·
I do this all the time. Excel is a fantastic data GUI for ad-hoc reporting. My typical quick turn-around process is: type SQL in text editor, test sql in data
by cupofpython 4y ago
I do this all the time. Excel is a fantastic data GUI for ad-hoc reporting.
My typical quick turn-around process is: type SQL in text editor, test sql in database, create a view, connect to the view from excel, use native excel features to display whats needed.
Usually I create a summary page as well which uses sum-ifs and such on the query result for the high level detail rather than go through the SQL process for it separately