Moving from Data Warehouse to Data Lake

Before you begin reading this article, it is important to clarify which topics will not be covered: This article will not answer the question of which method is better, because the answer is not binary. This article will not recommend which technology you should use, but it will discuss a number of tools and solutions […]

Beginners guide to Athena – Part 1: Getting Started

What is this article about? In this article, we will start exploring AWS Athena, You will learn how to create a query. This article is mainly for BI developers who want to extend their capabilities to handle Big Data. What is Athena? Athena is a full, serverless service that gives you the power to make […]

A Beginners guide to Athena – Part 2: Query CSV & JSON files

What is this article about? In this article, we will start querying CSVs and JSONs in Google Cloud Storage (GCS) and create new tables from existing tables (ETL process). This article is mainly for BI Developers who want to expand their capabilities to handling Big Data and finished successfully part one. Creating tables In this […]

Beginners guide to BQ – Part 1: Getting Started

What is this article about? In this article, we will start exploring Google BigQuery. You will learn how to create a Project, Schema and a query. This article is mainly for BI Developers who want to expand their capabilities to handling Big Data. What is BigQuery? BigQuery is a full serverless service and Data Warehouse that […]

Beginners guide to BQ – Part 2: Query CSV & JSON files

What is this article about? In this article, we will start querying CSVs and JSONs in Google Cloud Storage (GCS) and create new tables from existing tables (ETL process). This article is mainly for BI Developers who want to expand their capabilities to handling Big Data and finished successfully part one. Creating tables In this […]

Dashboard design in a nutshell

This article will discuss a few of guidelines for editing and designing dashboards. It may not always be possible to follow these guidelines, since in some cases you might already have a specific design idea in mind for the dashboard you are designing. I do recommend, however, that before you begin creating your dashboard, you […]