Difference between Data Lake and Data Warehouse for Data Analyst | Data Analysis | SQL #data analyst

If you are planning to move up the career ladder and want to become a senior data analyst, then you may be asked this question.

So here is the answer.

Data Lake is a much larger data storage in its raw form. There are no restrictions on the type of data you can store.
You can store structured data, that is, data that has columns and rows and can be easily understood and analyzed if necessary. Then we have unstructured data, including audio and video files. There is still a long way to go before storing them. the database and analyzed, and finally we have semi-structured data such as HTML code or logs which have specific tags for each information.

Data Warehouse is a lot like a library. Everything is organized, indexed and sorted into different groups of tables; we call these groups data marts, and each data mart contains data for a specific business or purpose.
For example, Finance Data Mart contains financial data, which is very restricted, and only a handful of people have access to it because it is easy to misunderstand the data since it has not been cleaned yet.

When it comes to data warehouses, depending on the role, multiple people may have access and the data is very reliable.

Hope this helps!

data analyst, data analyst job, data analyst career, data analysis, database vs data warehouse, database vs data lake, database vs data warehouse vs data lake, database vs data lake vs data warehouse, database vs data lake vs data warehouse, data warehouse, data lake, what is a database, what is a data warehouse, what is a data lake, what is a data lake vs. a data warehouse, data warehouse vs. a data lake

Please take the opportunity to connect and share this video with your friends and family if you find it useful.