Data Warehouse

www.ciceksepeti.com is an e-commercial website which has various data layers. These individual data structures are stored in independent micro databases. Hence, the necessity of analyzing data located in different databases gives the Business Intelligence team an important responsibility. …

with Databricks — I recently joined Databricks, a company founded by the creators of Apache Spark. At the time that I am joining the company they have moved far beyond just “Spark in the Cloud” and I believe they are leading the next revolution in Data Warehousing and Analytics. This blog article starts…

Welcome to the part 2 of this series. In case, if you have missed part 1, then please check the link below. Preparing for Data Warehouse Interview Part #1 If you are here, then definitely you are looking for something that will get you prepared for your upcoming interviews…medium.com So, let’s start with part 2… What is OLAP? OLAP (stands for Online Analytical Processing) is software for performing multidimensional analysis at high speeds on large volumes of…

Intro Many of you who have seen my LinkedIn profile must be wondering what my profile headline means. For the longest time, a Data Warehouse has been the gold standard for integrating data from disparate systems into a single database to analyze and derive business insights. After having worked in the…

In this article, I hope to paint a picture of the modern data world and when done you should have a decent understanding of the roles of Data Engineers, Data Analysts and Data Scientists and the technologies that empower them. The Transactional World (OLTP) Imagine we are creating the newest social media startup. Our…

If you are here, then definitely you are looking for something that will get you prepared for your upcoming interviews with respect to Data Warehousing. So, yes mate, you are at the right place. In this series of articles, I will be sharing questions that I prepared for my interviews…

Imagine you accidentally touch a hot plate for a second. What happens?

我們都知道巴菲特選股票的原則是，不投IPO、不投沒穩定盈利的公司、不投科技股，而這間公司成功的讓巴菲特放棄了他的3大選股原則。這間公司還同時是2020年美股最大的IPO公司，他就是Snowflake。這片雪花怎麼就入了滾雪球的賽道中呢？ Snowflake 這家公司其實是一家雲端計算服務的公司，從這邊就可以看出這也是一家Saas公司，那為什麼巴爺爺願意投資一間還沒穩定盈利的科技公司呢？我們一起來看看吧。 Snowflake的業務？ 一間好公司，他的特點通常是能夠解決一個行業裡面的痛點，那Snowflake他正好就是解決了數據庫的痛點，像是無法支應龐大的數據量，無法同時支持龐大的用戶量，使用體驗不佳，或是數據庫之間無法互相兼容，數據無法共享，不然就是管理成本較高等等等….的問題，光是上面這些問題，我不是工程師但我都能想像工程師們的口吐芬芳了:joy:。 所以Snowflake用一個創新的方式建立了數據服務的新模式，Snowflake是基於雲端計算的一個「數據倉庫」平台，就是數據倉庫服務[Deta-warehouse-as-a-service(DWAAS)]看起來有沒有跟我們之前講過Adobe那篇的Saas商業模式長得有點像，沒錯～他也是一種服務型商品，但他的商業模式比起Saas單純的軟體售賣更上一層樓。

Companies have access to more data than ever in today’s digital economy. This data serves as a foundation for making critical business decisions. At Agoda, it is important for us to be able to analyze enormous amounts of data in real-time and extract significant value from it. …