+234 806 299 1199

Geovanni Ubah

  • Home
  • Author: Geovanni Ubah

Index & Match Simplified

Do you struggle whilst trying to make complex searches in Excel? Do you not understand the rudiments on how to use these powerful functions? This article will demystify the ambiguity surrounding these functions, and hence, make you more confident, and prolific in their usage. INDEX and MATCH is the most popular tool in Excel for […]
Read More

The Importance of Data Visualization

Why data storytelling? Data is useless until we understand what it means and can clearly communicate that meaning to those who need it. We live in the information age where there is so much information available and without proper care and skill, we can easily drown it. Above all else, this article focuses on the […]
Read More

How to Connect MySQL to Power BI

MySQL is one of the most used legacy database management systems while it is the industry standard for storing and querying data, its forte is not in visualizing and aggregating data from multiple sources that is where Power BI comes in. So, what does it mean to connect? To connect is to join, link, unite, […]
Read More

Exploratory Data Analysis in SQL

Data exploration! What does it mean to explore? To explore is to inquire into or discuss in detail. To explore is to travel through an unfamiliar path in order to learn about it, to conquer it and that’s exactly what we intend to achieve in this article. Sequel to the article on “A Data Analyst’s […]
Read More

A Data Analyst’s Introduction to MySQL

Is MySQL a good solution for reporting and data analytics? Is MySQL the right solution for your business intelligence needs? Sequel to the article on “Understanding Relational Database Management Systems.” this article will attempt to answer the question of how MySQL fits into the realm of data analytics by enumerating some of its characteristics. What is […]
Read More