Systems | Development | Analytics | API | Testing

May 2020

A guide to the Enterprise Data Warehouse (EDW)

Companies use predictive and business analytics to gain an advantage over their competitors and claim a bigger share of the market. But with the accelerated proliferation of data volume, speed and variety, establishing a system to make sense of this data is posing ever-increasing challenges. Several data solutions - from databases to data lakes - have emerged to empower companies of all sizes to take over their data and use it to accelerate growth.

PostgreSQL vs MySQL: Which one should you choose?

Bonus Material: PostgreSQL vs MySQL complete comparison table ‍ PostgreSQL (or Postgres) and MySQL are both relational database management systems (RDBMS for short). They are complex technological inventions designed to simplify your data operations across a wide variety of business use cases. The “relational” part of the name refers to the way in which they structure data as relations between rows and columns.

The Ultimate Guide to Data Cleaning

While digging through data, Anna spots an interesting trend - some customers buy 3 times more than others. A segment of super-high spenders? This could make it rain for the company! She rushes to her boss, to show them the data, only to hear: “Yeah, I know. We have a bug, which inserts every order three times in the database. Were you not paying attention during our daily meeting?” Aw-kward.