Ok this is hard to explain and im not sure if this is the right place to ask it but.
Im 2 weeks in on my new work and I feel like our work can be a lot more easier if we dont rely on just Excel for our tasks. We deal with a lot of excel files. And these excel files are a lot. Per day we have 2000+ entries. So when we do monthly data, that excel file would be 2000x30 days. Imagine that.
Basically we just do matching with these excel files. All these excel files have different formats but they all have this unique mobile number (i work at a telco company) so we bash data with the excel files we have. Currently, we just use Access to bash data. But its not efficient. Access is REALLY SLOW.
So its like data mining. Lets say we are given this mobile number they want to investigate (we are in the fraud analysis team) so its my job to backtrack and check that phone number's usage. But our company has an inefficient way of handling their data. Like theres various excel files that arent centralized.
Anyway, any suggestions on how to deal with this? Are there alternative tools? etc. Since you guys know about database and i know its a rule that Excel shouldnt be used for database management. I do have some background with mysql and mssql but thats just basic commands.. Im not sure if it can be incorporated with my job.
(also, is there a word for what i do exactly? they call it data mining. We just match a mobile number and look for its corresponding data across different sources)