What are some strategies for automating data collection in a constantly changing manufacturing process?

Our controls and monitoring software is separate from Ignition. Ignition can only read from the PLCs, it collects and aggregates data for reports, typically excel or CSV files. Excel is used for analytics.

Would you mind elaborating on this?

I'll have to look into this, I'm not familiar with them. Would these be for reporting data or for analytics?