Soft and hardware for manipulating multi-million record data sets
Use vowpal wabbit for building your regression or classification models. It'll train at the speed at which you can read your data 


Use pandas and dask for plotting graphs etc.
You can use an AWS i2.8xlarge or equivalent machine which will cost you ~ USD 6k for an year