I am currently analyzing the best approach to accomplish the following:
Consolidate up to four data sources into one area or database to be able to pull reports, perform analyses, create dashboards, etc.
All four sources exist as Excel files that are posted monthly to an internal SharePoint site
Would need the following capabilities (at the least)
Eliminate Categories and/or subcategories I don't need
Create a top 20-30 list of the major items based on their count totals
Consolidate source data into a digestable report with predetermined KPIs
My preliminary questions include (but are not limited to):
What is the best approach that can be a repeatable process?
How match up the data from all the various and disparate sources
Text analytics would be amazing to have but where do I start with that?