John Ifiok (@ifioklee)

Sometimes, going forward means going back. Recently, I’ve been revisiting some of the fundamentals of SQL, and one area that caught my attention is data types in MySQL. It is easy to focus primarily on writing queries and getting the expected output as you learn the language of SQL. But the more…

While working on a recent data analysis project, I gained practical experience implementing the concept of fact and dimension tables—an essential component of dimensional data modeling that is often discussed in theory but less frequently built from raw datasets. Using Microsoft Power BI, I worked…

The video below is a walkthrough of the analysis I conducted on a dataset containing customers of an insurance company and their car insurance details. The project was carried out using Excel for data exploration, transformation, and visualization. The project features: → An interactive Excel…

I recently worked on the analysis of a fictitious product sales dataset in Canada. While the analytic process concluded with the creation of a dashboard that visualized key insights gathered throughout the analysis, the work done to reach that point was equally important. The original dataset was…

Today, I am sharing a project I did related to the aviation industry. The video below is a walkthrough of an analysis of historical airplane crashes. In this work, I analyzed over 5,000 Boeing 707 accidents that have occurred since 1948. The analysis process led to the creation of a Historical…

The video here is a walkthrough of a recent project I completed using Power BI. The final result is an interactive Power BI revenue dashboard developed through a combination of processes, ranging from data transformation in Power Query to writing DAX that enables specific visualizations, as well…

The video below is a walkthrough of a project I recently worked on using Excel, which I documented on GitHub. What I found most interesting while working on this project was how, with just one spreadsheet, I was able to answer more than eight relevant business questions. In the process of…

I analyzed a bank customer churn dataset and created an interactive Power BI dashboard that highlights key insights from the study. Working with this dataset helped me better understand the various factors that influence why customers stop using certain products and services, as well as how to…

I worked on a dataset containing the ratings and reviews of over 1,000 Amazon products. The project was carried out using Power Query for data transformation and Power BI for visualizing insights obtained from the dataset analysis. The final result is a three-page interactive dashboard, featuring…

The video below is a walkthrough of the dashboard I created using Power BI. It presents insights derived from the digital marketing spend of a fictitious brand for the month of February 2021. Having worked as a digital marketer for several brands over the past few years, I found the analysis of…

Every tale has a hero, and in the story of Calvary, Christ is our SUPER HERO! The greatest story ever, happened at Calvary. The song "CALVARY'S TALE" is more than a song, it is about the greatest love. It is the Gospel of the Cross preached in a song! The cross was not the end, it was only the…

If you work with data, there is no escaping the use of tables or charts, therefore appropriate care must be taken to ensure the right tables or charts are used when representing the your data. In order to choose the appropriate table or chart type, the first thing you must acertain is whether your…

The image below is a chart called the Pareto Diagram, I came across it while reading a book on Statistics, although I had previously been using it when creating visualizations for my analysis but never really understood how the chart was created and what it means, so I took a dive into finding…

OUT NOW🔥🔥🔥 GOD has anointed you to reach the nations with the Gospel! ANOINTED JESUS is here to remind you of the power that GOD has deposited in you!🔥 Don't miss this heavenly sound. It's now out and streaming on all platforms https://youtu.be/YWxia6WVQHE?si=cchEIVy5Hey9AhmJ…

GLORY TO GOD!!! PENTECOST- THE HARVEST IS NOW OUT!!💃💃 Yes, the sound we have been eagerly anticipating is out and available for your listening pleasure on all streaming platforms🥳🥳. PENTECOST- THE HARVEST is here to remind you to give more energy to your Father's work. It is a call to go out…

EL-DOXA UNVEILED! The moment we’ve all been waiting for has finally arrived. That’s right! EL-DOXA: GOD OF GLORY is officially here, and it’s time to let the world know! With each note, each chorus, it reignites our faith and reminds us of the GOD OF GLORY who can turn any situation around. Are…