Dealing with Multiple Sources of Information

In certain cases, our database is being connected to different data sources - eg: cloud, local files, CRM systems, etc. Usually, the number of data sources isn't a problem for designing the database. However, there are certain cases where the data we receive from the different sources isn't coherent and can lead to some issues regarding data integrity.

Kimball vs Inman

Data warehouse architecture is a broad and important concept that shapes the data structure of one’s organization. It has a large effect on an organization’s data-related aspects such as data flow process, development, and maintenance costs, reporting ability, etc. In this article, we are going to discuss two of the most common approaches for data warehouse architecture - the Kimball and Inman methods.

Are you more of a Report or Dashboard Manager?

Are you a "Report Manager" or a "Dashboard Manager"? Everyone knows the difference between a report and a dashboard. Imagine looking at an extensive report with many columns, records, and much information. And in contrast - a dashboard with a few KPIs and a few graphs from which you can directly derive insights. Which will you choose when it comes to analyzing data? Does this indicate the type of manager you are?

Enter your details