#1
I am starting a Business Analytics consulting company and would like to bring the power of data mining and predictive analytics to small and medium sized companies. They won't be willing to pay the prices that are required to bring analytics and data mining to the large enterprise. I can cut costs by writing my own web applications and hosting all analysis results in the cloud (Azure). But all analysis will still depend on the ETL required to bring together all source data into a unified data warehouse.

What would be the best way to ETL business data in a cost-effective manner? Should I outsource the ETL to an ETL consultant? Can this be done effectively if the ETL consultant does not live in my home town? Is it worth using an open-source ETL tool and learn to do the process myself?

Any advice would be greatly appreciated.

Thank you,