OKEH DONO EFASA

A Microsoft MVP in Data Platform and Certified Power BI Data Analyst Associate, with expertise in Power BI, Data Visualization, MS SQL, Database Development, and Excel. I specialize as a Data and Logistics Analyst, leveraging data engineering and analytics to design scalable models, create insightful visual reports, optimize operations, and drive data-informed business decisions.

Expertise

• Data Platforms: Skilled in gathering, cleaning, and analyzing complex datasets using SQL, Power Query, and visualization tools to uncover actionable insights that drive decision-making.
• Business Intelligence: Proficient in developing KPI dashboards, interactive reports, and storytelling visuals that clearly communicate data narratives to diverse stakeholders.
• Research and Documentation: Conduct research and properly document findings
• Tools:Microsoft Excel | Microsoft Power BI | Microsot SQL | MS Fabric | Python | MS PPT.
• Decision Support: Talented at contextualizing data insights, assessing alternatives and providing data-backed recommendations to influence strategy.
• Communication: I am able to communicate and work synergistically with teams to deliver required business outcomes

BI Projects

End-To-End National Health Report with Power BI

This project analyzed hospital demographics, patient admissions, and medical conditions to enhance visibility into healthcare performance and efficiency. An interactive Power BI dashboard was developed with dynamic filters, trend visuals, and key metrics for year-over-year comparisons across hospitals and conditions. The solution empowered data-driven decisions, improved hospital benchmarking, and boosted operational efficiency through actionable healthcare insights.

Explore Report

Bank Transactions and Financial Health Analysis

Aurora Bank used this report to gain deep insights into loan performance, customer demographics, and financial risk. It revealed key patterns across age, income, and spending behavior while assessing debt ratios to identify high-risk customers. The insights guided data-driven strategies for improved risk management and customer engagement.

Explore Report

End-To-End Microsoft Fabric Project: Exploring Fabric Medallion Architecture Using Pillsbay Reward Dataset

Pillsbay Pharma utilizes the Quickbooks application for daily transactions. In an effort to enhance sales and customer retention, the Quickbooks reward program ensures that customers receive a 2% discount for every 10,000 Naira purchase, which they can redeem on their next purchase. The program was initiated in 2015, and the analysis provides a historical summary to date and a daily summary of reward activity

Explore Report README

Comprehenive Supplychain Management Report

This report provides a concise analysis of supply chain processes: Supply: Assesses efficiency and cost across product categories. Manufacturing: Evaluates capacity, target achievement rates, defect rates, and improvement areas. Logistics & Inventory: Reviews stock health, inventory practices, and cost-effective delivery options. Sales & Profit: Identifies sales and profit drivers by product, region, and customer segment.

Explore Report

E- Commerce KPI - A Quick Analysis

In this project, I analyzed sales volumes, profitability, and key performance indicators (KPIs) for a global skincare and beauty e-store. The analysis focused on achieving a 15% average annual profit margin, 20% annual sales growth, with a target of 30% for the corporate segment, and ensuring each market reached at least $400K in annual sales. The Power BI report provides dynamic visualizations and actionable insights to support strategic decision-making, driving the e-store's continued growth in a highly competitive market.

Explore Report

Marketing Campaign Analysis

Using key performance and traffic KPIs, we effectively track campaign success across various channels and locations. Conversion Rate, Engagement Rate, and Return on Advertising Spend help measure user actions and revenue, while Impressions, Clicks, and Click-Through Rate gauge campaign visibility and engagement. Despite a positive cost-to-profit ratio of 0.10 and an ROI of 10.41%, continuous optimization is crucial for sustained growth and profitability..

Explore Report README

Technical Support Analysis

In today’s world, businesses of all sizes rely heavily on technology for their daily operations. Technical support plays a crucial role in maintaining these systems efficiently. This analysis provides an overview of the performance of the Technical Support Centre.

Explore Report

Electronic Products Ratings and Reviews Analysis

The dataset included ratings and reviews for electronic products from various brands across different stores. Reviews and ratings significantly influence product sales and popularity. I found analyzing diverse product and brand reviews intriguing. My objective was to meticulously analyze and visualize the data, identifying top-performing and highly recommended products and brands. I was the runner-up winner of the Onyx DataDNA Electronics Product Rating Challenge for February. Tools utilized: Power Query and Power BI.

Explore Report

Udemy Course Analysis

This project involves analyzing Udemy course data from 2011-2017, focusing on course distribution across segments and learning levels. The key metrics include subscribers and revenue generated from paid courses.

Explore Report README

North America Retail Sales Optimization

The project involves a comprehensive analysis of key performance indicators within the retail logistics domain. The primary focus is on dissecting metrics such as loss revenue transactions, extended delivery timelines, and return rates to derive valuable insights.

Explore Report README

Xmas Sales Analysis

The dataset under consideration spans Christmas sales data from November to December across the years 2018 to 2023. The primary objective of the analysis is to scrutinize trends in Christmas sales, with a particular emphasis on assessing the impact of events and promotions on sales performance.

Explore Report README

YouTube Data Analysis

The project, initiated by OnyxData on LinkedIn, presented a challenge that required a meticulous analysis of a YouTube dataset within a specific timeframe. The primary objective was to extract valuable insights from the data and formulate actionable recommendations.

Explore Report README

London Crimes Analysis

The project focuses on analyzing a dataset containing information about crimes that occurred in London from 2021 to 2023. The dataset categorizes individuals into five major roles: Accomplice, Informant, Witness, Victim, and Offender.

Explore Report README

SQL Projects

Phone Sales Analysis with SQL

Analysis of Phone Sales. The dataset comprises of sales details for different phone brands across several regions by different distributors.

View

Danny's Dinner Sql Analysis

In early 2021, Danny, a passionate lover of Japanese cuisine, took a bold step and opened a small restaurant named "Danny’s Diner." Specializing in his top three favorites – sushi, curry, and ramen – the diner needs assistance in leveraging the basic operational data collected during the initial months to enhance business management.

View

FIFA Dataset Analysis

The football dataset I studied provides extensive information on players, clubs, countries, ratings, and wages. Analyzing trends in player salaries across leagues and countries, I explored the relationships between a player's performance, age, and wages. This comprehensive dataset informs decisions on player recruitment, team management, and salary negotiations in the football industry.

View

Contact Me and Connect