I am working on a year long
Data Analysis project for a moderately sized client, the aim of which is to analyse transactional data and identify for the client its customer profiles, transaction patterns, and assist the business management in making factual business decisions. It has > 1M customers though how many are active, we don't know since we don't have access to their database.
The tools we requested were
SQL Server for data storage/extraction, and
R for analyses.
However, the client has come back with
Excel as the only tools they are willing to provide.
Question: If you were to persuade the IT team that the proposed tools are insufficient for what we have been asked to do, how would you go about doing so?
Following is how I am outlining my arguments:
- Briefly explain the Data Analysis project deliverables - what amount of data we hope to analyse (we don't know how much space it will take), what sort of data, what will be the outcome, how much will be ad-hoc analyses, etc.
- Explain how Access will not suit this - primarily due to size limitation for database of 2GB
- Explain how Excel would slow down significantly if > million rows are added to it for simple manipulation
Although I am planning as per the above, but I feel the IT team may refer me to ways of dealing with Access size limitations, and prevent us from solving this issue reasonably...