January 2018 Summaries

In a data-driven world where advanced business analytics play a crucial role, Fivetran recommends storing data in a column-oriented warehouse for efficient and speedy results. Columnar warehouses offer significant benefits over row-based alternatives, including dramatic data compression due to the repetition of values within columns and faster query processing times. This is because columnar databases only need to read the values of columns required for processing a given query, avoiding unnecessary memory usage. Fivetran provides secure data pipelines for businesses to sync and replicate data into central data warehouses, enabling deep insights through SQL queries and business intelligence (BI) software tools.

Fivetran, a secure pipeline for replicating important company data into a central data warehouse, has partnered with Help Scout, an email-based help desk software company with over 7,000 customers. The partnership allows Help Scout to utilize the Fivetran pipeline for advanced business analytics. Data from Help Scout runs through the Fivetran pipeline and is stored in Google BigQuery data warehouse, a technology partner of Fivetran. Additionally, Help Scout uses Looker, a BI tool and Fivetran partner, to create dashboards displaying key business metrics. This partnership enables companies to gain deep insights into sales trends and metrics by running SQL queries and employing Business Intelligence (BI) software tools.