data preparation

Search
Generic filters
Filter by Categories
Business Intelligence
Company News
Devs & Admins
Exago BI
The Business of SaaS
automatic data models

Data Models That Build Themselves

Self-service BI is about bridging the knowledge gap that has historically separated business professionals from their data. It’s about doing away with intimate knowledge of information systems as a prerequisite for finding out last quarter’s growth margin. And when it comes to replacing SQL statements with friendly drag-and-drop graphical elements,…

Read More
business intelligence rollout

Recommendations for a Phased BI Rollout

One of the top challenges enterprises face in deploying business intelligence solutions is lack of resources. With other high-priority projects going on, it can be hard for teams to bring their ideal BI implementations to fruition on deadline. Something’s got to give, and sometimes that something is the deadline, but…

Read More
Exago No-Code ETL

Decision Tree: Is Exago ETL Right For You?

Figuring out how to prepare your data for analytics can be tricky. Should you do it all in programmatic data objects like views and stored procedures? Should you hire someone to hand-code your data warehouse or rely on a consultant? What about all the ETL solutions out there? We’re big…

Read More
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