Step (2) involves humans, isn't it? Because for simple cases this scenario is already covered with:
- Google Sheets suggests pivot tables / charts that can be built on your worksheet data
- with our BI tool (https://www.seektable.com) everyone can upload even rather large (up to 500mb) CSV file, then engine suggests dimensions/measures automatically and even suggests some typical reports (suggestions are very simple as for now, just set of heuristics rules based on CSV column names). More than this, for CSV file user can 'ask' data with search-like queries and get an answer in form of pivot table.
- Google Sheets suggests pivot tables / charts that can be built on your worksheet data
- with our BI tool (https://www.seektable.com) everyone can upload even rather large (up to 500mb) CSV file, then engine suggests dimensions/measures automatically and even suggests some typical reports (suggestions are very simple as for now, just set of heuristics rules based on CSV column names). More than this, for CSV file user can 'ask' data with search-like queries and get an answer in form of pivot table.