Joseph Ajogwu's
Data Analyst Portfolio

A Data Analyst skilled in Excel, SQL, Tableau and PowerBI @joseph-ajogwu-05691399
.

Data Cleaning and Analysis in SQL

Education for all, a charity organization that provides funds to the less privilege for education purposes in the USA. Donations to the organization comes from individuals across the country. Information on how to donate to the organization is incorporated into the programs and schools they patronize. So, Alumni of the programs can share the information. .

As the Data Analyst working for the charity, Education for All. I have been asked by the Head of Fundraising to present the data on donor insights and donation rates. Within the Fundraising team, my objectives are to:

  • ✓ Increase the number of donors in your database
  • ✓ Increase the donation frequency of your donors.
  • ✓ Increase the value of donations in your database.
  • DATA Exploration
    on Udemy's Data

    Udemy has a number of courses in the subject areas of Business Finance, Graphic Design, Musical Instruments and Web Development. Each course could be at a particular level – All, Beginner, Intermediate, Expert. The courses are rated by the subscribers between 0 to 1. These courses could be either free or paid. The Udemy course dataset contains all these details in addition to the course title, URL, price, number of subscribers, number of reviews, number of lectures, content duration, and published date. The problem statement is to understand the revenue generated from the courses and find courses whose cost could be increased to generate more revenue for Udemy. The performance of the courses is also analyzed as part of this. .

    Data Analysis Geographical-distribution-of-Covid-19-in-various-regions-around-the-world
    using Excel

    The background of this project was derived from a dataset from https://www.kaggle.com/datasets where an analysis was done on the Geographical distribution of Covid-19 in various regions around the world. This analysis was done to find out the regions of the world with most Covid=19 cases and related deaths in the year 2020, as to proffer solutions in the prevention vaccination and treatment of covid-19 patients globally This analysis so basically this analysis is been done to have a cursory gaze on the prevalence of the pandemic in various parts of the globe.