Hi,

I’m Amarachi Nwoke Ugagbe

Welcome to my Portfolio

A tireless explorer, armed with an array of tools and unbounded curiosity, resides in a world driven by data, where insights hold the key to success. Come meet me - A Data Analyst and Business Intelligence Analyst with skills in SQL, Python, Excel, Power Apps, Power BI, Power Automate, Tableau, and problem-solving techniques.

So, if I take hold of your organization's data, watch my eyes light up as I embark on a mission armed with SQL, Python, Excel, Power Apps, Power BI, Power Automate, and Tableau. Witness my unwavering commitment to extracting the truth from data, my enthusiasm for creating visual tales, and my unshakable commitment to problem-solving. For data becomes more than simply statistics in my hands; it becomes the key to unlocking a future of informed decisions and limitless possibilities.

Embellished with data storytelling ability, excellent communication skills, strong customer relationship, good work ethics, creative/analytical skills and collaborative abilities. I combine both technical and soft skills to achieve great results.

I love hosting community events and public speaking where I inspire young people to pursue personal development and tech.

I know how much you desire to take measures on the actionable insights you will get from data. If you’d like to learn more about my thought process, feel free to message me.

Projects

These were projects carried out as Personal projects, Projects during Internships, Projects during fellowship programs, and Projects at my Work Places to consolidate my learning experience.

Whatsapp Group Analysis and Sentiment Analysis

As a Data Analyst who solves problems with Data, I discovered that there were times people drop questions on Whatsapp group and they were not given immediate responses, Other times, the response rate becomes high. As a member of two communities: Digital Witch Support Communuity and Data Science Nigeria -PH, I had to find a way

In order to:

know the best time to send messages to the group to receive a response
To know the most active people that are usually online to run to in cases of urgency.
To understand the basic tone of the group.

Hence, I thought it wise to carry out a Whatsapp Chat Analysis.

Whatsapp Data comes as a .txt document file from Whatsapp..

Tools used are: Excel, Python and PowerBI.

Github

Article

Cohort Analysis of an Online Retail Store

Cohort Analysis assesses the features of particular consumer groups in comparison to overall impressions and sales figures. When deciding whether to invest in any company, a “Venture capitalist” may request information such as cohort analysis to aid his decision. He wants to know:

If you can keep your subscribers or customers? at what rate? (Customer Retention)
What percentage of clients did you lose each month? (Churn Rate)
your customer’s Lifetime value.

Tools used are: Excel, SQL, Python and Tableau

Github

Article

Tableau Viz

new revenue dashboard

Python Screenshot

Cohort Retention Dashboard

new revenue dashboard

Udemy Course Sales Analysis

What is the need for being in business and having a company when you can’t track your business performance to know where the gold of your business resides? How will you know your customer’s needs in order to serve them appropriately?

This was the situation of the Education tech company-Udemy which wants data-driven insights into their business. The company presented the data on course revenue showing different data on the different courses and topics to understand where opportunities abound and then track the performance of courses.

Link to Report

Customer Segmentation Analytics

Customer Analytics of a KPMG client who specializes in high-quality bikes and accessible cycling accessories to riders. They are looking for ways to boost their business by analyzing their existing customer dataset to determine customer trends and behaviour.

Questions asked include:

What are the trends in the underlying data?

Using existing datasets (Customer demographic, customer address and transactions) I recommended the top 1000 customers that should be targeted to drive the most value for the organization.

Data Exploration; Model Development and Interpretation were done in Excel and PowerBI

Link to Github

Ghana's Milk Import and Export

Exploring Ghana's Milk Import and Export for Jan-May,2019

Since a country's economy depends, sometimes heavily, on its exports and imports. The United Nations Comtrade database provides data on global trade. Data from the website was used to analyse Ghana's imports and exports of milk and cream from January to May 2019: Questions to answer were focused on:

How much does Ghana export and import and is the balance positive (more exports than imports)?
Which are the main trading partners, i.e. from/to which countries does Ghana import/export the most?
Which are the regular customers, i.e. which countries buy milk from Ghana every month?
Which countries does Ghana both import from and export to?
Pandas and Matplotlib were used.

Github

Holiday Weather Determination

Most people like taking holiday after several busy months. So in this project, I used the historic weather data from the Weather Underground for Delhi to try to predict two good weather weeks to take off as holidays. Of course, the weather in the summer of 2016 may be very different to 2014 but it should give some indication of when would be a good time to take a summer break.

Pandas and Matplotlib (Pythion Libraries) were used.

Github

Holiday 1.jpg

Holiday2.jpg

Holiday 1.jpg

Data Analysis for Supermarket

The data under review consist of Product Total Sales Value of N 30,456,565.62 (N30.46million) from the supermarket with 13 locations, 16 unique products, average sales of 6,104 and total purchases of 4990. The analysis is centred around sales with respect to recommendations on profits, cost reductions and business expansion. Other valuable insights are also considered as well.

Excel and PowerBI were used.

Link to Viz

Data Analysis for supermarket.jpg

DATA ANALYSIS 2.jpg

Data Analysis for supermarket.jpg

HR Analysis of a Company

It was needful to analyse the Workforce of the Company. to show its gender composition, age-range performance, department strength, job satisfaction per age range, Highest paid set of workers and even the location with the highest workforce.

Excel and PowerBI were used for data cleaning and visualization.

Link to Viz

Link to Certifications

Work Experience

What I’ve Done

I have had the opportunity to work on a variety of projects, some traditional and others outside the box. I know how to take on new challenges and contribute to companies in a way that is smart, meaningful and valuable.

December 2021 - March 2022

DATA ANALYST / SCIENTIST - BRAINIACS STEM AND ROBOTICS

Key Deliverables: Projects on Machine Learning Using Scratch, Teachable Machine and Tkinter library.

Created 3 STEM curricula on Data Science that led to a 60% increase in course curriculum.
Planned and developed 3 lesson content for stand-alone modules and curriculum.
Delivered lectures with excellent classroom management and 90% attentiveness.
·Wrote SEO articles/blog posts with content on Data Science and Machine learning that led to 50% of web visits.

April, 2021 - March, 2022

WOMEN TECHSTERS DATA SCIENCE FELLOW - TECH4DEV NIGERIA.

Key modules include: Excel and VBA, Statistical Models, Python (API, Numpy, Pandas, Beautiful Soup, matplotlib and JSON), SQL, Tableau, PowerBi, and Machine Learning.

Used digital classroom tools to learn, explore and communicate the Data Science and Artificial Intelligence modules: Excel and VBA, Statistical Models, Python (API, Numpy, Pandas, Beautiful Soup, matplotlib and JSON), SQL, Tableau, PowerBI, Machine Learning.
Had practical understanding and demonstrated academic/technical skills expected in the taught models and passed the 80% grade

July -August, 2021

VIRTUAL DATA ANALYST INTERN - ENTRYLEVEL

· Framed 1 Business Problem and determined the right data set to collect

· Collected, Cleaned, Normalized and Visualized data of 4000 student’s records using Excel and Tableau

· Gave data-driven solutions based on finding from the data set, showing the top 20 subscribers

· Wrote a Data Analytic Report with 5 data-driven recommendations for company adoption.

· Designed Data Analytic Portfolio from a Capstone project.

July 2021 - August 2021

VIRTUAL DATA ANALYST INTERN - KPMG

· Carried out data quality assessment on 4000 customer’s data provided by Sprocket Central

· Explored data, developed model and interpreted the dataset to show the top 1000 customers.

· Made PowerPoint slides showing 14 charts and 4 tables to show the analysis.

· Developed a dashboard showing 6 different charts of the analysis and names of the 1000 customers.

Academic Experience

My Studies

A good education is a well-rounded one. When it comes to learning, I have had the opportunity to learn from all kinds of sources, including mentors, colleagues and even from those who are not in my field at all. All of this has helped me become the person I am today.

November 2013 - December 2014

Master of Science - PETROLEUM ECONOMICS, MANAGEMENT & POLICY, University of Port Harcourt

Key Modules: Econometrics, Petroleum Economics, Economic Analysis of Oil and Gas Field Development, Linear programming and Optimization Techniques, Petroleum and Energy Market, Model and Analysis

November 2005 - July 2010

Bachelor of Engineering - PETROLEUM ENGINEERING, Federal University of Technology Owerri,

Key Modules: Reservoir Engineering, Production Engineering, Drilling Engineering, Production Engineering, Petroleum Economics, Alternate Energy to Oil and Gas.

SKILLSET

I always look for new and useful skills that will make me better. Whether working on a new collaboration or doing something on my own, there is always room for improvement and new things to learn. Have a look at my skillset and let me know if you need additional information.