4 ms·
You're probably asking for something impossible. It's common for the raw data to not fit in excel. You have to do some sort of aggregation or filtering, which m
by nitwit005 3y ago
You're probably asking for something impossible. It's common for the raw data to not fit in excel. You have to do some sort of aggregation or filtering, which means having that app where you aggregate and filter.
Almost all these tools support exporting to Excel or CSV, so they can do whatever they want in Excel after that.
- Sylamore 3y agoIn multiple orgs now I've had raw access to data warehouses (DB2 and SQL Server based) that had aggregates of petabytes of data from ETL that I was free to access via Excel PowerQuery, direct SQL tools, Python or R, or even PowerBI.
- nitwit005 3y agoIf you're getting aggregates, it's not the raw data by definition. Someone set up aggregation for you to use, much like I described.
- Sylamore 3y agoI didn't mean aggregate as in summarized data, but aggregate as in a common repository of multiple different data sources as a single massive data warehouse. If I needed to group or summarize the data, I had to do it in my own queries.
- nitwit005 3y agoMy point wasn't that you should never give people access to raw data, but that the raw data won't fit in excel rows. You have to do aggregation or filtering somewhere to get the data within the row limit.