Data Analyst

WOFAI EYONG

A detail oriented, reliable and proactive data analyst, who is an ardent lover of big data and the possibilities that come with it.EXCEL| SQL| PYTHON| POWER BI| TABLEAU| DBT

DATA CLEANING WITH SQL

Danny is the owner of a pizza business. He has collected data for his business but he requires further assistance to clean his data.This project focused on the pre-cleaning process, identification of issues and the data cleaning process using SQL.

• view code

EXPLORATORY ANALYSIS OF LOAN DATA FROM PROSPER Inc. WITH PYTHON

Prosper Marketplace, Inc. is a San Francisco, California-based company in the peer-to-peer lending industry, operating . Prosper provides unsecure loans and has facilitated over 21 billion dollars in loans to over 1.3M people.The prosper loan dataset contains information on 81 variables, representing about 113,937 loans collected from the company. I analysed 14 variables, focusing on the Lender yield as a tool for investors to select the best loan types for investment.

• view report

• view code

WE-RATE-DOGS PROJECT
Scraping, Wrangling and Analysing Twitter Data

The we rate dogs project is focused at wrangling data from the twitter account 'WeRateDogs' with the aim of creating analysis, trustworthy insights and visualisations. Results from these analysis will have the potential to trigger needed business growth and development for the twitter account.The Twitter archive holds very basic tweet information, creating the need for data scrapping from twitter for more information. I gathered, assessed, cleaned and generated insights from the Twitter data.

• view report

• view code

BIKESHARE DATA ANALYSIS WITH EXCEL

This is a bike-share outfit, offering a fleet of bikes which can be unlocked at one station, used and returned to any other station in its ecosystem within 24-48 hours. Two customer types exist; Subscribers who purchase membership plans and non-subscribers who purchase single use passes.A clear goal of strategic business decision making has been set and to achieve this, historical bike trip data was used to identify significant trends.

• view report

• view code

QUERYING DATA WITH SQL

Mr Danny, a restaurant owner is interested in having information about his customers, especially about their visiting patterns, how much money they’ve spent and also, which menu items are their favourite.I analysed 3 key datasets to help him deliver a better and more personalised experience for his loyal customers, and decide whether he should expand the existing customer loyalty program or not.

• view code

• Tableau Profile

EDUCATIONData Analyst Nanodegree, Udacity 2022Data Analysis pro, HerTechTrail Academy 2022Data Analysis, HerTechTrail Academy 2022PGD, Customer Relationship Management,
Chartered Institute of Customer Relationship Management 2017-2018University of Calabar, BMLS, Clinical Laboratory Science 2009 - 2015