I've started a new role which deals with large amount of related data. Our source of all this data is various Excel dumps pulled from databases we do not have access to. The previous person filling this role used a dozen or so Excel files to gather these data files, manipulate them, and create reports.
I have started moving the dumps to an Access database. I have noticed a lot of the Excel data is related and should probably be normalized. What I have currently been doing is creating a table for every data dump, and importing them to Access, and using a number of queries to replicate the dozens of data manipulations and reporting.
Are there still benefits to normalizing data where my only source are Excel dumps out of a warehouse?
How would I normalize data, when I do not have the ability to change the format of how the dumps are sent to me?
Additionally, my plan (budget-depending) is to move from Access to a MS SQL Database.