Snowflake cloud database with ELT(Airflow+Python+Talend)

A data lake is a store that keeps data in its original form, files of any shape in cheap object storage, loaded before anyone has decided what questions will be asked of it, so that the structure is applied when the data is read rather than when it is written.

Business intelligence is the practice and the tooling for turning an organisation's data into reports and dashboards that people use to run it: connecting to the sources, modelling the data into measures everyone agrees on, and presenting it so that a manager sees the state of the business without asking an analyst.

Data governance is the set of decisions and responsibilities an organisation puts in place over its data: who owns each dataset, what each field means, who may read or change it, how long it is kept and how its quality is measured, recorded so that the answers do not depend on who is asked.