What you want to do is a very good idea. In many cases, it's the key to success.

Data can get out of hand very quickly, then you lose control over your business. I see this happening to a lot of companies.

There are many ways to set up data architectures. One thing I do recommend is to try automate the process from the beginning. Otherwise, when you start growing, you wont be able to keep up with the data.

I collect, process, analyze and visualize data every day, but this is what I do. This is my job. We do all our data engineering, creating custom software for each project. I can't recommend any existing software, but I am sure there are many out there.