Category: Data Analysis

  • What is Reverse ETL?

    What is Reverse ETL?

    The data engineering industry has evolved from Extract, Transform, Load (ETL) to ELT, where raw data is copied from the source system loaded into a data warehouse or data lake and then transformed. The current trend is to adopt a new approach, called “reverse ETL,” the process of moving data from a data warehouse into third-party…

  • How to build a centralized and secured Data Catalog on Google Cloud Platform

    How to build a centralized and secured Data Catalog on Google Cloud Platform

    Time is money, to organize your data in a Data Catalog is one of the first steps to give visibility to organizations’ data and to save time by employees to find data in the organization.

  • #datapipeline: Deploy Serverless Data pipeline to GCP with Terraform

    #datapipeline: Deploy Serverless Data pipeline to GCP with Terraform

    I recently built a data pipeline which I wrote up in an article data pipeline the hourly electricity rate, what I did not explain was how I deployed it to the Google Cloud Platform. In this article, I will show you how I used Terraform to deploy it to the Google Cloud Platform. The biggest…

  • #Datapipeline: The T in ETL with SQL

    #Datapipeline: The T in ETL with SQL

    If you read this I assume you are familiar with Extract Transform and Load (ETL), this is just a short article to show how you can do ETL and especially T, the transform using a SQL statement.

  • Tips To Supercharge Your Marketing Strategy

    Tips To Supercharge Your Marketing Strategy

    Marketing strategies have the potential to send sales soaring and raise brand awareness but not every campaign is effective. If you are looking to put your business on the map, or you have ambitions to attract new customers or boost profits, it’s beneficial to ensure that your marketing campaigns are on point. Here are some…

  • List of datasets for all your data science work

    List of datasets for all your data science work

    Data science is a hot topic just now, more and more people are talking about it and planning to include data science in their organizations. The data science practice is to extract knowledge and insights from data and information generated through various tools and applications.

  • List of modern data stack technologies for your modern data stack

    List of modern data stack technologies for your modern data stack

    We have created a list of modern data stack technologies. The Modern Data Stack technologies are mostly SaaS-based technologies that comprise runs on a cloud-native data platform, generally leveraged to reduce the complexity in running a traditional data platform. The goal with the Modern Data Stack is to make data actionable by reducing the time…

  • The Swedish Electricity Pricing Explained

    The Swedish Electricity Pricing Explained

    I recently started digging into electricity prices and how electricity price is in Sweden, I wrote an article on how I built a data pipeline to get an email report sent to me daily with the latest hourly electricity price. The article #datapipeline the hourly electricity rate shows you how the data pipeline was built.

  • #datapipeline the hourly electricity rate

    #datapipeline the hourly electricity rate

    I spent my Christmas holiday in the southern part of Sweden, the weather was cold with several days of temperatures down under -10 celsius. In the news were stories about new price records for a KwH of electricity. I started to get worried that our electricity bill for December or for the whole winter period…

  • Do you know how much CO2 your computer use?

    Do you know how much CO2 your computer use?

    Have you ever wondered how much Co2 your computer use and what impact computers have on climate change? I set out to investigate and came to the conclusion that it is now easy to figure, accordingly to Worldometer there has been shipped over 2 billion computers as of 2007, the number is high. This year…