data preparation

Data quality issue logging

18 Data Quality Issue Attributes You Should Be Logging

If you’ve already started or are planning to start a data governance program to support your data quality improvement goals, you need a structured way of tracking your data quality issues and their status. There are different ways of doing this, of course, with either the help of dedicated data quality…

Read More
Icons on city buildings

5 Advantages of an ETL Tool: Taming Your Data

It’s nearly impossible to talk about the benefits of ETL (Extract, Transform, Load) data processing without first considering the alternatives. So let’s set the stage: you’re a SaaS provider, and you’ve got data in different formats coming in from a variety of sources—SQL Server, MySQL, PostGres—and business users who need…

Read More
Override thumbnail

How to Not Get Overrun by Your Data Overrides

Large-scale enterprises rely heavily on market and consumer data sourced from outside vendors, but that information comes at a cost. In addition to intermittent issues with the data quality itself, consumers of vendor data can face timeliness problems, non-standard formats, coverage gaps, and lags in technical support. Despite these and other…

Read More
ETL primes your data for reporting

Infographic: How ETL Primes Your Data For Reporting

There’s a lot your BI solution can do to make reporting off live data faster and more efficient; but when you’re looking for an even more substantial performance boost, it’s time to bring out the big guns. Any pre-processing you do to your data is work your system can skip when…

Read More