Category: Topic

The primary purpose of a data warehouse is to serve as a centralized repository for historical data that can be quickly queried for BI reporting and analysis. Data modeling—which defines the database schema—is the heart of your data warehouse. Learn…

Salesforce announced its strategic partnership with Amazon Web Services in 2016. It wasn’t long before the “#1 CRM provider “went ahead and partnered with Microsoft Azure in 2019 and then soon made a deal with Alibaba Cloud to extend its…

Modern IT infrastructures often become a tangled web of multiple environments. As businesses transition to the cloud and let go of their on-premises infrastructure, enterprise data gets divided between on-premises and cloud platforms, both public and private. Businesses bound by…

To begin our exploration of automated dimensional modeling, it’s essential to first gain an understanding of dimensional modeling. Dimensional modeling is among the most preferred design approaches for building a data warehouse. First introduced in 1996, Kimball’s dimensional data models…

APIs have been around for a while now. They gained prominence in the 2000s with the rise of web-based applications. The exponential increase today cloud-based applications has propelled their production and consumption even further—so much so that the global API…