Caleb Chijindu UgorjiDiscover the Easiest Way to Measure the Effectiveness of Your Programs, Projects, or Training!It is crucial to evaluate the effectiveness of a program, activity, or training to determine its progress and identify areas for…Feb 21Feb 21
Caleb Chijindu UgorjiWriting an SQL query to answer this question took me back to the basics: The Order of SQL Query…In this article, I briefly explained the order in which SQL queries are executed. I encountered this concept during my beginner days as a…Jan 23Jan 23
Caleb Chijindu UgorjiHow To Use Basic Python Methods to Clean Up Difficult Research Data QuicklyThis article is on how I cleaned up research data that was quite tricky to clean and prepared it for analysis with SPSS. The client said…Nov 2, 2023Nov 2, 2023
Caleb Chijindu UgorjiHow I prepared a messy dataset for analysis for a client.A client hit me up to analyse a dataset for a project. This data set is on sanitary pad use and has 1000 observations and 18 variables.Aug 22, 2023Aug 22, 2023
Caleb Chijindu UgorjiExplaining How the Windows Functions Work in SQLI came across the window’s function for the first sometime in 2022. After finishing the Google Data Analytics Professional Course, I…Aug 8, 2023Aug 8, 2023
Caleb Chijindu UgorjiExplaining Recursive Query in SQLIn the last project I did with SQL, I wrote a recursive query to generate a table as part of the challenge questions.Aug 5, 2023Aug 5, 2023
Caleb Chijindu UgorjiDanny Ma’s Week Two Solution — PIZZA RUNNERHey guys, long time no see. I have actually been very busy finishing up school.May 24, 2023May 24, 2023
Caleb Chijindu UgorjiDanny Ma’s 8-week SQL challenge: Case study 2 (Data wrangling)Hey guys, I am still solving Danny Ma’s 8-week SQL challenge, and this case study two is challenging😂. The data provided was messy and…Apr 6, 20233Apr 6, 20233
Caleb Chijindu UgorjiMy solution to Danny Ma 8 Week SQL Challenge: Case Study OneI decided to hop on this challenge to practice my SQL skills and gain more proficiency in it. Here I will present my solutions to the…Mar 11, 2023Mar 11, 2023