ResagratiaResagratiaResagratia
+234 806 299 1199
contact@resagratia.com

Data Analytics

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

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

VLOOKUP Function in Excel

  Following the previous Excel article on Excel Wildcards, we will be discussing the usage of the commonly used Vlookup function. Vlookup stands for ‘Vertical Lookup’. As the name Implies, Vlookup is a Microsoft Excel function that is usually used to lookup data organized vertically in a table. Vlookup supports approximate and exact matching, and […]
Read More

Excel Wildcards

Excel Wildcards: What are they? Microsoft Excel is a powerful software that uses a spreadsheet to organise data and numbers with functions and formulas. It is well used around the world and can be used by businesses of all sizes. Excel wildcards are simply three characters used for comparison in text filtering, searching and replacing […]
Read More

July 2020 Power BI Update

Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end-users to create their own reports and dashboards. Every month since the release of Power BI in 2014 there are updates to improve its functionalities and features to provide Bussines Intelligence Analysts with the necessary tools and resources […]
Read More