Ask HN: From Spreadsheets to Data Warehouse
At work I have build a spreadsheet based system where we download csv files from a few systems and with a series of spreadsheet, we enrich the data, and compile business reports.
But the entire system is now taxed by the size of the data files and the complexity of the reports that keep piling up.
I want to migrate to a small Data Warehouse; but I need to educate myself.
From the research that I have done I need to learn SQL and Python. I am willing to put on the time.
So, these are my 2 questions for HN:
1. What's the best and inexpensive way to learn SQL and Python online. Low cost is fine since the company will pay for it, but the budget is limited.
2. Is there an online class that is hands-on, so that I can actually build my data warehouse as I am studying?
Thanks in Advance.