BLOG

The drill-through solution from Power BI to Priority

Authors:  Eran Sherf - BI project Manager and Power BI expert & Assaf Mazal-Tov - BI developer and characterization specialist. Overview: Our solution allows the user to explore an issue that appears in the Power BI dashboard by going directly to the specific screen in the Priority system. The Drill-through solution is beneficial for companies that would like to take their BI to the next level: A data-driven solution. We implement such solutions to deal with issues efficiently and create an impact...

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 SQL-like queries on top of structured and semi-structured files in S3. It is important to note that Data is not stored in Athena. Athena only query the data nut doesn’t...

Dashboard design in a nutshell

This article will discuss a number of guidelines for editing and designing dashboards. A good dashboard conveys information in the most effective way possible, while still remaining attractive. To achieve the best balance, dashboard designers must be consistent, meticulously detail-oriented, and choose the best design to effectively convey the information.

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 that could be helpful for you. What will be covered in this article are the following: This article will focus on the most important topics...

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 case, I needed to create 2 tables that holds you tube data from Google Storage. I will present two examples - one over CSV Files and another over JSON...

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 can run extremely fast interactive and ad-hoc queries. Data can be saved in Google Storage and be queried by BiqQuery, or alternatively, data can be imported to BigQuery and be queried...

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 case, I needed to create 2 tables that holds you tube data from Google Storage. I will present two examples - one over CSV Files and another over JSON...

Enter your details