/ 1 min read / Using Holistics

How to Create Data Models from External Data Sources in Holistics

by Cedric Chin

How to Create Data Models from External Data Sources in Holistics

Let's say that you're running a marketplace company, and you'd like to investigate your merchant product listings. The only problem: your merchant names are in a spreadsheet, your merchant data is in MongoDB, and your product listings are stored in an SQL database.

In the past, you would have to find a way to combine these three data sources within your data warehouse, before you begin creating reports. With Holistics, however, you can create data models directly from external data sources.

This allows you to skip the tedious work of creating a new pipeline and testing the data and writing code to combine everything — you know, the boring plumbing work that usually happens in order to do such things. In Holistics, you create a data model from your external sources once ... and then reuse this model whenever you need information about your merchants's product listings!

(If you would like to learn more about Holistics data models, read this! Data models are a foundational part of the new Holistics platform, and are powerful abstractions over your data. They allow data teams to become extraordinarily productive).

In this three minute video, we show you how to create a data model from a MongoDB datastore and a PostgreSQL relational database:

Enjoy!

Cedric Chin

Cedric Chin

Staff writer at Holistics. Enjoys Python, coffee, green tea, and cats. I'd love to talk to you about the future of business intelligence!

Read More

From SQL Queries To Beautiful Charts

Connect to your database and build beautiful charts with Holistics BI

Learn More
Grab Logo

"Holistics is the solution to the increasingly many and complex data requests from the operational teams"


Tang Yee Jie - Senior Data Analyst, Grab

Tang Yee Jie

Senior Data Analyst, Grab