Okereafor's Data Analytics
Portfolio

Discover a collection of real-world business analysis projects focused on solving practical business problems through data. Each project outlines the challenges faced, the analytical approach taken, the tools used, and the measurable values delivered through insights, dashboards, and strategic recommendations.

Anchor-Hold Retail Group

Anchor-Hold Retail Group is a multinational consumer goods company operating across diverse markets including North America, Europe, and Asia. With a broad product portfolio and customer base spanning government, enterprise, midmarket, and small business segments, the company has experienced rapid expansion over the past two years.
This analysis was performed using MS Excel

Montana Express
Analysis using MS Excel

Welcome to Montana Express, a new and exciting virtual café chain! The café specializes in offering a variety of drinks, snacks, and light meals to customers. In the past years, Montana Express has seen impressive growth but are facing the challenge to meet customer demand.

Phillip-Hill Solution Distribution Analysis
using Power BI

Phillip-Hill Solution is a leading pharmaceutical distributor, facing challenges in optimizing sales performance, managing inventory efficiently, and identifying key market opportunities. The company serves a diverse healthcare sector, ensuring the availability of essential medications in North America, Europe, United Kingdom and Australia.

Mo'Bridget Fashion Store
Dashboard using Power BI

Mo'Bridget is a high-end fashion boutique specializing in designer clothing, shoes, and accessories. Known for its unique collection and personalized shopping experience, the boutique aims to stay ahead in the competitive retail market by leveraging data-driven strategies.They have multiple branches across different cities and cater to a fashion-conscious clients.

FutureSpace Corp
Analytics using PostgreSQL

FutureSpace Corp is a growing technology company focused on developing innovative solutions in software and hardware spaces. The company prides itsel on attracting top talent and maintaing high employee satisfaction to drive growth.

Thompson-Tech
Analytics using Power BI

Thompson-Tech is a multinational consumer electronic company that operates across various sales channels, including online, in-store, reseller & third-party vendors. The company offers a broad range of electronic products including smartphones, monitors & external hard drive.

Rite-Kisk
Analytics using Tableau

Rite-Kiosk operates in a competitive retail market, offering diverse products. The company targets individual and corporate customers across multiple geographies. As it expands its reach, understanding sales performance, customer segments, and operational efficiency is critical, so there is a need for actionable insights.

El Choco Bite
Analytics using Tableau

El Choco Bite is a premium artisanal chocolate brand headquartered in Belgium with operation across the world. Despite strong product quality and market presence, El Choco Bite lacks unified database on its products, saleperson performance and delivery status of every transaction made.

Continental Gross Performance
Analytics using Tableau

County Plc is a data intelligence firm dedicated to h elping government, corporations, and development agencies measure, monitor and acelerate progress towards the United Nations Sustainable Development Goals. Despite steady global GDP per capita growth over the past decade, the relationship between economic expansion, employment creation, and overall well-being remains inconsistent across all regions.

FusionPoint Industries
Analytics using Power BI

FusionPoint Industries is a dynamic consumer electronics retailer serving customers across multiple U.S. states through a well established omnichannel network. Inspite of their strong sales across diverse product categories, FusionPoint Industries faces challenges in understanding the drivers of profitability and regional sales performance within its consumer electronics division.

Sprint legacy Laboratory
Analytics using Tableau

Sprint Legacy Lab. are a leader in talent optimization, the company takes pride in fostering an environment that enables employees to thrive. However, recent challenges with employee retention and workforce engagement have highlighted the need for actionable insights.

Cyclin'Gear Store
Analytics using MS Excel

Cyclin'Gear Store is a multinational retailer in cycling accessories across the United States, Australia, United Kingdom, Canada etc. They face strategic blind spots in understanding its regional revenue performance, demographic appeal, product demand, and seasonal trends. The Leadership is looking to your data analysis to drive smarter decisions around marketing, product focus, and inventory planning.

MavTech Electronics
Analytics using PostgreSQL

MavTech Electronics Ltd is a leading player in the global consumer electronics industry, widely recognized for its innovation in smartphones, tablets, and wearable technology. Despite that, the Brand has been facing a growing challenge related to its reputation. In recent years, the company has faced several issues, including negative customer reviews, product recalls, and public relations crisis.

Streamline Logistics Solution
Analytics using MS Excel

Streamline Logistics Soluions is recognized as a pillar of reliability within the logistics sector, offering tailored solutions that optimize transportation processes, reduce operational costs, and enhance delivery performance. Over time, the Brand continues to experience growing order backlogs, delayed deliveries, and increasing operational costs.

BrightCart Online Retail
Analytics using Tableau

BrightCart Online Retail is a fast-growing e-commerce company specializing in consumer electronics, home goods, and lifestyle products. BrightCart experiences significant fluctuations in website traffic depending on the time of day, day of the week, and marketing campaign timing. The company also lacks comprehensive insights into the sources of this traffic.

SQL Syntax
Analytics using PostgreSQL

This contain different ranges of syntax & Queries written to generate insights & recommendations which answer Business Challenges.