Startup Idea: Intelligent Data Analysis Software

Startup idea to develop a smarter data analysis and reporting tool that can adapt to changes in the data structure, specifically columns, within reports. This software will record actions as macros and understand why these steps were made, ensuring they remain functional even when new data columns are introduced.

I am a Data Coordinator for a large marketing firm. I've been with the company for over 4 years. I do a lot of data cleanup for our reporting on a daily basis.

Excel is the main software that we use for our reporting. We have pre-setup macros that do the data cleanup for us. However, whenever there's a next column added into a report, the macro would bug out and return an error because the new column pushed the existing column to the left and it doesn't recognize the new column.

It would be very helpful if there was a smarter software that records your steps as a macro and know why those steps were made. That way, whenever there's a minor change to a report, it will know what to do instead of making us record the macro again.