Portolio
With over 6 years of experience in data analytics, I have successfully delivered 60+ analytical projects for clients across multiple industries, leveraging tools such as Microsoft Excel, Power BI, and SQL, among other analytical technologies.
Due to data privacy policies and contractual agreements with my clients, the original datasets cannot be publicly shared. However, this page provides a concise summary of the business problems addressed, analytical tasks performed, and data skills applied across selected projects.
MICROSOFT EXCEL PROJECTS
Sales Performance Analysis Using Microsoft Excel
Project Overview
Analyzed sales data to evaluate revenue performance across products, regions, and time periods using Excel.
Problem Statement
Management lacked clear visibility into sales trends and top-performing products.
Data Description
Sales dataset containing order date, product category, region, quantity sold, and revenue.
Key Tasks Performed
Cleaned and structured raw data
Built Pivot Tables and charts
Applied SUMIFS, IF, and percentage calculations
Key Insights
Top 20% of products generated over 60% of total revenue
Certain regions consistently underperformed
Deliverables
Excel sales analysis workbook
Pivot-based summary dashboard
Customer Purchase Trend Analysis
Project Overview
Studied customer purchasing behavior to identify trends and buying patterns.
Problem Statement
Marketing efforts were ineffective due to lack of insight into customer behavior.
Data Description
Customer transaction data including customer ID, purchase date, product type, and order value.
Key Tasks Performed
Data cleansing and standardization
Used XLOOKUP, TEXT, and DATE functions
Created trend charts and summaries
Key Insights
Repeat customers accounted for a majority of revenue
Clear seasonal purchase patterns identified
Deliverables
Customer trend analysis workbook
Summary charts for decision-making
Budget vs Actual Financial Analysis
Project Overview
Compared budgeted figures against actual expenses and revenue to assess financial performance.
Problem Statement
Finance teams needed a structured way to monitor overspending.
Data Description
Monthly budget and actual data categorized by department.
Key Tasks Performed
Calculated variances and percentages
Applied conditional formatting for exceptions
Built financial summary tables
Key Insights
Some departments consistently exceeded budgets
Seasonal cost spikes identified
Deliverables
Budget vs actual Excel model
Variance analysis report
HR Attrition & Workforce Analysis
Project Overview
Analyzed workforce data to understand employee attrition and distribution.
Problem Statement
High staff turnover without clear insight into causes.
Data Description
HR dataset including employee age, department, tenure, salary, and exit status.
Key Tasks Performed
Data cleaning and categorization
Built attrition metrics using formulas
Created HR summary tables and charts
Key Insights
Attrition highest within first two years
Specific departments showed higher exit rates
Deliverables
HR analytics Excel workbook
Attrition summary report
Inventory Management & Stock Optimization
Project Overview
Optimized inventory levels to reduce stockouts and overstock situations.
Problem Statement
Manual inventory tracking led to inefficiencies.
Data Description
Inventory data containing product ID, stock level, reorder point, and sales volume.
Key Tasks Performed
Calculated reorder levels
Applied forecasting tools
Built inventory performance charts
Key Insights
Overstock issues in slow-moving items
Improved reorder timing recommendations
Deliverables
Inventory management Excel model
Stock optimization report
POWER BI PROJECTS
Interactive Sales Performance Dashboard
Project Overview
Designed an interactive Power BI dashboard for sales performance monitoring.
Problem Statement
Executives needed real-time visibility into sales KPIs.
Data Description
Sales data sourced from Excel and SQL databases.
Key Tasks Performed
Data transformation using Power Query
Created DAX measures (Total Sales, YoY Growth)
Built interactive visuals and slicers
Key Insights
Seasonal sales peaks identified
Clear product and regional performance gaps
Deliverables
Power BI Sales Dashboard
DAX measure documentation
HR Analytics & Attrition Dashboard
Project Overview
Developed an HR dashboard to track workforce and attrition metrics.
Problem Statement
HR reports were manual and time-consuming.
Data Description
Employee data including demographics, department, performance, and exit status.
Key Tasks Performed
Data modeling and relationship setup
DAX calculations for attrition rates
Designed HR visuals and filters
Key Insights
Early-stage attrition was most common
Certain job roles required retention strategies
Deliverables
HR Analytics Power BI Dashboard
Automated HR metrics
Financial Performance Monitoring Dashboard
Project Overview
Built a dashboard to track financial KPIs and variances.
Problem Statement
Finance leadership lacked timely financial insights.
Data Description
Budget, actuals, and revenue data across departments.
Key Tasks Performed
Data integration and modeling
Created variance and trend DAX measures
Designed financial performance visuals
Key Insights
Expense overruns highlighted early
Revenue volatility patterns detected
Deliverables
Financial Performance Power BI Dashboard
KPI tracking model
Customer Segmentation & Behavior Analysis
Project Overview
Segmented customers based on purchasing behavior.
Problem Statement
Marketing campaigns lacked personalization.
Data Description
Customer transaction and demographic data.
Key Tasks Performed
RFM analysis using DAX
Built segmentation visuals
Applied interactive filtering
Key Insights
High-value customers formed a small percentage
Dormant customers identified for reactivation
Deliverables
Customer Segmentation Dashboard
Marketing insight summary
Operational KPI & Performance Dashboard
Project Overview
Monitored operational efficiency through KPI tracking.
Problem Statement
Operational KPIs were tracked manually.
Data Description
Operational data including output volume, turnaround time, and error rates.
Key Tasks Performed
Defined KPIs and thresholds
Built DAX measures
Designed performance visuals
Key Insights
Bottlenecks impacting turnaround time
Process improvements identified
Deliverables
Operational KPI Dashboard
Performance monitoring report
SQL PROJECTS
Sales Database Analysis Using SQL
Project Overview
Analyzed sales data stored in relational databases.
Problem Statement
Sales metrics were difficult to extract manually.
Data Description
Sales, customers, and products tables.
Key Tasks Performed
Wrote JOIN, GROUP BY, and CTE queries
Calculated revenue and growth metrics
Created summary views
Key Insights
Top products and regions identified
Monthly revenue trends extracted
Deliverables
SQL scripts and queries
Sales performance reports
Customer Retention & Churn Analysis
Project Overview
Investigated customer churn patterns using SQL.
Problem Statement
Customer churn rates were increasing.
Data Description
Customer profile, transaction, and activity tables.
Key Tasks Performed
Built churn logic using SQL
Created retention cohorts
Calculated churn percentages
Key Insights
High churn among low-engagement users
Retention drops after initial purchase period
Deliverables
Churn analysis SQL scripts
Retention insights report
HR Database Reporting & Analytics
Project Overview
Generated HR reports from structured databases.
Problem Statement
HR reports required manual compilation.
Data Description
Employee, department, and payroll tables.
Key Tasks Performed
Wrote analytical SQL queries
Built views for HR KPIs
Automated report generation
Key Insights
Attrition trends by department
Salary distribution patterns
Deliverables
HR analytics SQL queries
Automated HR reports
Financial Transactions & Fraud Pattern Analysis
Project Overview
Analyzed financial transactions to detect unusual patterns.
Problem Statement
Potential fraudulent activities needed identification.
Data Description
Transaction tables with timestamps, amounts, and account details.
Key Tasks Performed
Used window functions and subqueries
Identified anomalies and duplicates
Flagged high-risk transactions
Key Insights
Repeated transactions above thresholds detected
Time-based anomaly patterns identified
Deliverables
Fraud detection SQL scripts
Risk analysis report
Operational Data Analysis & KPI Automation
Project Overview
Automated KPI reporting using SQL queries.
Problem Statement
Manual KPI reporting caused delays.
Data Description
Operational logs and performance tables.
Key Tasks Performed
Built KPI calculation queries
Created scheduled views
Optimized query performance
Key Insights
Significant reduction in reporting time
Improved KPI consistency
Deliverables
KPI automation SQL scripts
Operational KPI reports
Corporate & Multinational Training Programs
Sales Data Analysis & Business Intelligence
Executive-level training on Sales Data Analytics and Business Intelligence
Organization: SalesRuby, Lagos, Nigeria
Powered by: AQskill Technology Systems
Data Analysis & Visualization in Engineering
Senior Engineers from Prototype Engineering
Organization: Data Analysis & Visualization in Engineering
Powered by: AQskill Technology Systems
Data Analysis & Visualization
Tech Skills Acquisition Training
Organization: RCCG Oko-Oba Provincial Headquarters Lagos State
Powered by: Teck Skills Technology Systems
Data Analysis & Visualization
Tech Skills Acquisition TrainingÂ
Organization: NYSC – SAED Ogun State
Powered by: Teck Skills Technology Systems
Data Analysis & Automation
Data Analytics & Automation for Interns and Regional Executives (Africa)
Organization: GE Vernova
Powered by: Teck Skills Technology Systems
Upcoming Training
Business Performance Management (BPM): Control Frameworks & Dashboards Approach:
Beneficiaries: Nigeria National Petroleum Commission (NNPC) Regional Executives
Powered by: Stowpoint Services Limited – United Kingdom
Training Facilitator: Teck Skills Technology Systems – Awesome Emmanuel
Location: Ghana
Date: Day 1 – Day 5, Month, 2026