Welcome to Xplenty's Blog

All things data

Today’s BI Professions OR ‘Who does what’ in Analytics?

Today’s BI Professions OR ‘Who does what’ in Analytics?

A chart that clearly specifies what are the differences between each and every profession in the field of BI, including titles, skills, roles and salaries.

Introduction to Data Integration OR What is ETL?

Introduction to Data Integration OR What is ETL?

Xplenty explains the basics of Data Integration: What is ETL (Extract Transform Load), what are its main functions and when you would need them.

ETL vs ELT or Data Warehouse vs Data Lake

ETL vs ELT or Data Warehouse vs Data Lake

Which BI architecture is better for your organization, ETL or ELT? This article explains the considerations and also how they relate to Data Warehouses and Data Lakes.

How to succeed in Hiring your ‘Head of BI’?

How to succeed in Hiring your ‘Head of BI’?

Matt Mueller, President of a BI and analytics recruitment firm, shares his tips and best practices on how to hire a ‘Head of BI’.

Xplenty has made it to StartUp Big 50 list! Thank you, StartUp50.com for including us

Xplenty has made it to StartUp Big 50 list! Thank you, StartUp50.com for including us

Today, we have great news to share - Xplenty was included in StartUp50.com’s Annual StartUp Big 50 List. To earn our well-deserved spot in the Big 50 we had to battle our way through three rounds of tough competition with over 200 applicants vying for 50 spots..

Cloud vs. On-Prem Data Warehouse

Cloud vs. On-Prem Data Warehouse

Data warehouses (DWHs) are widely recognized as essential components of business intelligence and analytics operations. But the question of whether the optimal deployment route is in the cloud or on-premise remains hotly debated.

Like so many things, the truth is that there is no one-size-fits-all solution. Every business is different, and there are advantages and disadvantages in both approaches. On the one hand the cloud offers scalability and low entry cost advantages. On the other, there’s the security and flexibility that only an on-prem solution can offer.

Confessions of a Data Scientist

Confessions of a Data Scientist

Igor Elbert, Principal Data Scientist at Gilt.com, shares with Xplenty his thoughts on recent data projects, challenges and his approach to ETL.

5 Reasons to Use an ETL Tool rather than “Script Your Own”

5 Reasons to Use an ETL Tool rather than “Script Your Own”

Why you need a Data Integration Layer (ETL), reasons to use a SaaS based tool for ETL rather than coding it through scripts.

Xplenty Asana Integration

Xplenty Asana Integration

Xplenty, swoops in as a superhero in the world of ETL, to save you time (which means money) getting all that data into your company’s analytic data store. Grab data from Asana, as well as your other data sources, and transform and manipulate the data before it gets into your data warehouse.

Xplenty HipChat Integration

Xplenty HipChat Integration

Xplenty integration with HipChat is super fast and incredibly easy using Xplenty’s HipChat hooks. Xplenty’s HipChat hooks allow you to get real-time updates about your account activity into your HipChat rooms.

Xplenty Salesforce Integration

Xplenty Salesforce Integration

Xplenty's integration with Salesforce is the easiest way to read and process your data from Salesforce and move it to an analytic data stores such as Amazon Redshift or Google BigQuery.

Xplenty PagerDuty Integration

Xplenty PagerDuty Integration

We already integrate with many tools to reduce the bulk of time you likely spend on cleaning your data and preparing it for analytics. We want to continue to make ETL easy no matter what tools and platforms you use so we are constantly integrating with all the latest and greatest.

Our latest integration... is PagerDuty. And we are hooked!

Xplenty Slack Integration

Xplenty Slack Integration

At Xplenty, we aim to make moving and processing data as quick and seamless as possible.
We integrate with a ton of tools your teams already uses to make the process even easier, like Intercom, Hubspot and tons of others.

And today we wanted to share our latest integration. Slack!

Using An ETL Platform VS Writing Your Own Code

Using An ETL Platform VS Writing Your Own Code

Writing your own ETL code is not trivial. What starts out as a simple ETL process gets more complex over time. So does the coding, which becomes less manageable. A short story that morphs into a convoluted volume that rivals Tolstoy’s War & Peace.

Recap: Xplenty Data Panel → Big Data's 'Janitor' Problem - Is it Killing ROI?

Recap: Xplenty Data Panel → Big Data's 'Janitor' Problem - Is it Killing ROI?

May was a crazy month here at Xplenty. We started our event tour at Collision in Las Vegas. Then we headed over to NYC for the Data Summit where CEO, Yaniv Mor, had 2 speaking slots, both packed to capacity!