+234 806 299 1199

data analytics

  • Home
  • Tag: data analytics

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

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

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