Most of your data will be transferred via stream or batch process into your Data Warehouse or Data Lake. You will choose stable ETL or ELT processes to bring the majority and most relevant data from your legacy systems, CRM, ERP, IOT, etc.

However, in the world of Data Science and Self Service BI your Data Analyst/Scientist and BI users will also need data from external systems, open API’s, data from sheets, websites and so on. Therefore, tools like Google Sheets could be a great solution to implement a data flow easily. This article should give you a first idea how you can combine Google’s powerful BigQuery with easy to use Googles Sheets and its’ endless add-ons.

#data-integration #data-lake #google #bigquery #data-science