ResagratiaResagratiaResagratia
+234 806 299 1199
contact@resagratia.com

Business

Creating a Dashboard in Tableau

Tableau is a powerful and fastest-growing data visualization tool used in the Business Intelligence Industry. It helps in simplifying raw data into a very easily understandable format. Data analysis is very fast with Tableau and the visualizations created are in the form of dashboards and worksheets. The data that is created using Tableau can be […]
Read More

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

Introduction To Tableau

Is Tableau the right solution for your data visualization reports and business intelligence needs? This article will attempt to answer the question of how Tableau fits into the realm of data visualization and business intelligence (BI) tools by enumerating some of its characteristics. In the latter part of this article, we will compare Power BI […]
Read More

Trend Analysis with Excel

What is trend analysis and how do you predict the value of a commodity, measure or quantity? In this article, we cover some critical aspects of what is needed to generate trends. Our initial emphasis is on helping you identify and manipulate data that can be visualized as trends. This sometimes involves a bit of […]
Read More

Custom Excel Charts – Part 2

What are custom Excel charts? You can think of them as infographic charts: a visual representation of information, data or knowledge intended to present information quickly and clearly. They can improve cognition by utilizing simplified graphics to enhance the human visual system’s ability to see patterns and trends. Sequel to the article on Customs Charts […]
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

Data Challenge: Excel Wildcard with Multiple Criteria

Hi Tribe, To continue our Data Challenge series, this tutorial will focus on more advanced use cases of Excel wildcard. The goal of our data challenge series is to motivate you, our users and readers, to imbibe an attitude of continuous learning and to solve some common problems encountered in the field of data analytics […]
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

Custom Charts and Infographics in Excel

Do you ever get tired of the mundane Excel charts? Do you feel you can make your Excel charts more intuitive by adding custom infographic charts? There may be times when the default chart formats just aren’t what you need. If you want to make your visuals more user-friendly, I suggest you tag along with […]
Read More