Subscribe to DSC Newsletter

All Blog Posts Tagged 'etl' (4)

What Makes a Suitable Integration Tool

When a systems integrator selects a data integration tool, it needs to consider a number of selection criteria.

A key criterion for vendor selection is systems compatibility.

The selected tool must foremost be able to interact with the specific systems that the customer's company uses in the project under…

Continue

Added by Gopi Mattel on May 4, 2018 at 12:30am — 1 Comment

ETL vs ELT: Considering the Advancement of Data Warehouses

ETL stands for Extract, Transform, Load. It has been a traditional way to manage analytics pipelines for decades. With the advent of modern cloud-based data warehouses, such as BigQuery or Redshift, the traditional concept of ETL is changing towards ELT – when you’re running transformations right in the data warehouse. Let’s see why it’s happening, what it means to have ETL vs ELT, and what we can expect in the future.

ETL is hard and outdated

ETL arose to solve a problem of…

Continue

Added by Luba Belokon on April 6, 2018 at 7:30am — No Comments

Data Collection Tools for Events Analytics

One of the first things we do after launching a website nowadays is connect to Google Analytics. A little bit down the road we’ll connect more “out-of-box” analytics tools to calculate funnels, retention, A/B tests, and more.

These tools are great and work fine until a company gets bigger and analytics requirements get more sophisticated. It’s time to set up a data infrastructure, which means selecting a data collection tool, ETL tool, data warehouse, and BI tool on top of…

Continue

Added by Luba Belokon on March 30, 2018 at 3:30am — No Comments

The Analytics Pyramid of Needs

In this day and age, you can’t go a day without hearing terms such as “data science,” “big data,” or “analytics.” These terms have been thrown around to apply to so many situations that the original meaning of these words is lost.

So, what does it take for any organization to be successfully data-driven? Although analytics may seem complicated, the solution comes from simplicity.

I believe it comes down to four things, as I’ve illustrated below: business need, clean data…

Continue

Added by Divya Parmar on August 29, 2016 at 7:30pm — 1 Comment

Monthly Archives

2019

2018

2017

2016

2015

2014

2013

2012

2011

1999

Videos

  • Add Videos
  • View All

© 2019   Data Science Central ®   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service