BI Concepts | Analytics Advisory
  • Home
  • Services
    • Modern Data Platform
    • Data Services
    • Marketing Analytics
    • Tableau Starter
    • Tableau Licences
    • Tableau Hosting
    • Tech Stack
  • Trainings & Events
    • Tableau Desktop Fundamentals
    • Tableau Desktop Intermediate
    • Tableau Desktop Advanced
    • Tableau Prep
    • Events
  • Meet the Team
  • Get in touch
  • BI Blog

Blog about BI quarrels.

A modern data stack with Snowflake, dbt and Fivetran

5/7/2021

0 Comments

 
Managing the pipeline from raw data ingestion, storage on a data platform to data transformation plays a crucial role in each data-driven company. This pipeline, also called Extract, Load & Transform (ELT) can be heavily outsourced by using a modern data stack. This is where Fivetran, Snowflake, and dbt appear on the stage.

​​Two unicorns and a rising star will make our daily lives in analytics exciting, fast and more reliable. Snowflake is a fantastic offer for a data warehouse service either hosted on AWS or Azure. This service charges for computing and storage only. No usage, no bills. As with Fivetran, this offering is based on credits that depend on the tier and the location of your cloud offering your Snowflake instance is running on. We are currently working on the maintenance of our Snowflake data warehouse automated by Terraform - exciting times I would say.

To feed the Snowflake Data Warehouse we use Fivetran, of whom we are the first official partner in Switzerland. Amazing people in Munich to say the least. We are looking forward to visit them as soon as these not fun times are over. Fivetran essentially is a data pipeline service that takes over the heavy lifting for us - experts say the ingestion and maintenance can take up about 80% of an analytics platform, before any benefits in the form of actual analytics can be presented to the customer. If you are interested in their offering, let us know and we can support you on that journey.

dbt (data build tool) takes over the last part in ELT - Extract, Load & Transform. This application is a gem, a rising star in the analytics community and getting a lot of attention from Fivetran. The best is, this is open source and available to use for anyone. The community is highly active and very helpful in your modelling journey. On our own journey, we aim to build a product, based on these tools and other, to provide a comprehensive analytics suite to our customers.

We are currently working in a proof of concept mode working together with innovative companies that implement future-proof technology while applying fundamentally robust pattern to build upon. Very exciting times ahead, of course also for our Swiss market since Azure has since 2020 data centres in Switzerland which takes off concerns holding certain industries back from moving towards cloud solutions. Have you got experience with dbt or any kind of dbt offering in Switzerland?

0 Comments

    Categories

    All
    Automation
    Data Analytics
    Data Culture
    Data Sharing
    Data Visualisation
    Digital Transformation
    Google Analytics 4
    Master Data Management
    Technology Stack

    Archives

    December 2022
    September 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    September 2021
    July 2021
    October 2019

    RSS Feed


    Subscribe to our newsletter

BI Concepts GmbH
Deuberrainweg 6
8807 Freienbach
Switzerland

Swiss Commercial Register Entry
VAT No (UID): CHE-434.247.552
(founded in 2020)
  • Home
  • Services
    • Modern Data Platform
    • Data Services
    • Marketing Analytics
    • Tableau Starter
    • Tableau Licences
    • Tableau Hosting
    • Tech Stack
  • Trainings & Events
    • Tableau Desktop Fundamentals
    • Tableau Desktop Intermediate
    • Tableau Desktop Advanced
    • Tableau Prep
    • Events
  • Meet the Team
  • Get in touch
  • BI Blog