Chimaobi-Ogbonna-Portfolio
This repository contains my data analyst projects, both completed and on-going.
PROJECT 1: DEBT ANALYSIS
TOOLS:
TYPE OF PROJECT: Data Cleaning, Data Analysis and Visualization
Project Status: Completed
Overview: A new executive was elected in an association. Part of their first assignment was to recover the debt owed by members of the association since its inception. My job as a data analyst was to conduct a debt analysis and present my findings using meaningful visualizations to help the executive understand the debt burden of members of the association.
Skills Used in the Project
- Data cleaning skill with EXCEL
- Data analysis skill with Tableau
- Data visualization (dashboard) skill with Tableau
Findings and Recommendations: My analysis revealed that 23 individuals out of the 121 members of the association owed over 34% of the total debt. Therefore, to save resources and ensure quick recovery of debts, it was suggested that a debt recovery committee be instituted and they should start the debt recovery process with the 23 individuals that are most indebted to the association.
PROJECT 2: REAL ESTATE IN ENUGU STATE
TOOLS:
TYPE OF PROJECT: Data gathering, Data cleaning, Data Analysis and Visualization
Project Status: Completed
Overview: This is a personal project where I intended to practise and showcase my webscraping skills. I scrapped a real estate website and presented a descriptive summary of properties advertised in the website.
Skills Used in the Project
- Webscraping skill with PYTHON (Beautiful Soup library)
- Data cleaning skill with EXCEL
- Data analysis skill with EXCEL Pivot table
- Data visualization (dashboard) skill with EXCEL Pivot Charts
Findings and Recommendations: The descriptive summary obtained at the end of this project could guide real estate businesses on the choice of summary statistics that could be included in their websites to make them user-friendly and increase customers’ satisfaction.
See Webscraping code file here
PROJECT 3: Know The Appropriate Skills For You: IT Professionals’ Use Of Technology
A capstone project for the IBM Data Analyst Professional Certificate
TOOLS:
TYPE OF PROJECT: Data gathering, Data cleaning, Data Analysis and Visualization
Project Status: Completed
Overview: This is a project I completed as one the requirements for the award of the IBM Data Analyst Professional Certificate. The aim of the project was to help job seekers, especially in the information technology field, have information on relevant technological skills required to land a job and thrive in the field. This was achieved by researching and evaluating the technology use trend of current IT professionals.
Skills Used in the Project
- Webscraping skill with PYTHON (Beautiful Soup library)
- Data gathering skill through API
- Data cleaning skill with PYTHON
- Data analysis skill with PYTHON
- Data visualization (dashboard) skill with IBM COGNOS ANALYTICS
Findings and Recommendations: The field of information technology has continued to become popular since many industries tend to rely more on technology-driven processes. However, to successfully gain a job in the IT field, one is expected to possess some relevant technological skillsets. Recommended skillset:
- Languages: JavaScript, HTML/CSS, SQL
- Database: MySQL, Microsoft SQL server, PostgreSQL.
- Platforms: Windows, Linux, AWS, Docker.
- Web Frame: JQuery, Angular/Angular.js, ASP.NET, React.js
PROJECT 4: SENTIMENT ANALYSIS: An analysis of Peter Obi’s Speech after 2023 Presidential Election in Nigeria
TOOLS:
TYPE OF PROJECT: Data Cleaning, Data Analysis, Natural language processing and Visualization
Project Status: Completed
Overview: The 2023 election was a big deal in Nigeria, especially the presidential election. Among the contestants in the presidential election was Mr. Peter Obi of Labour Party. Polls and opinions before the election suggest that Mr Peter enjoys the greatest acceptance especially among the youths, and has been predicted to win the election. Unfortunately, Mr Peter lost in the presidential polls held on 25th February 2023. Following his loss, he presented a speech to his teeming followers, popularly known as the “Obidients”, on the 2nd March, 2023. The speech contained his position on the outcome of the election and the way forward.
This project is meant to analyse this speech to determine the exent it possesses the characteristics of hope and positive directions.
Skills Used in the Project
- Data extraction skill from news sites with python
- Natural language processing with Python
- Data visualization skill with Python
Findings and Recommendations:
Interpretations
Polarity
- Overall, the polarity of the speech is
polarity = 0.218.Hence, the speech is fairly positive. - The most positive statement in the speech was: “It is my belief that if you must answer “His Excellency”, the process through which you arrive to office must be excellent.” It has a polarity score of 1. This statement was however, very subjective (subjectivity = 1).
- There were 49 sentences analysed. For indvidual sentences, 49% were positive (polarity > 0), 45% were neutral (polarity = 0) while only 6% were negative (polarity < 0).
- Wordcloud suggests that 10 most popular positive words include, election, Nigeria, Nigerian, people, new, will, committed, country, Datti, possible.
- These popular words may be interpreted as reflecting Obi’s and Datti’s commitment toward giving the Nigerian people a new Nigeria through the election.
Objectivity
- Overall, the subjectivity of the speech is
subjectivity = 0.558.Hence, the speech is moderately objective. - 18 sentences where perfectly objective with a subjectivity value of 0. These statements were also neutral (polarity = 0)
- There were 49 sentences analysed. For indvidual sentences, 67% were objective (subjectivity < .5), while only 33% were subjective (subjectivity > .5).
- Wordcloud suggests that 10 most popular objective words include, Nigeria, election, people, gratitude, new, media, God, will, thank, Datti.
- These popular words may be interpreted as reflecting Obi’s and Datti’s gratitude to God, the people of Nigeria and the media for their support in the election.
Conclusion
- 10 sentences (20.4%) were found to be both positive and objective.
- popular words among these sentences include, New, Nigeria, people, Datti, will, assure, thank, remain, committed.
- These popular words suggest that Obi’s and Datti are thankful to the people of Nigeria and assures the people of their committment towards achieveing a new Nigeria.
- In all, the speech was fairly objective and positive, and appears to offer hope and positive direction to the people of Nigeria.
Download Full Project file here
PROJECT 5: BUILDING A SCHOOL-DROPOUT PROFILE
TOOLS:
TYPE OF PROJECT: Data gathering, Data cleaning, Data Analysis and Visualization
Project Status: On-going
Overview: School dropout has been on the increase among teenagers especially in the Sub-Saharan Africa. Available evidences suggest that the process of identifying potential dropouts is vague with no empirical back-up. This project will gather and analyse data related to school dropout across the world. The intention is to identify the characteritics of school drop-outs. With this information it would be possible to build a profile for a potential dropout. Such information could assist present and future interventions aimed at reducing school dropout rate across the world.
Skills Used in the Project
- Data collection skill
- Data cleaning skill with R
- Data analysis skill with R
- Data visualization (dashboard) skill with Tableau
Findings and Recommendations:
[Will be added on the completion of the project]