Laboratory & Data Analytics Projects
Embedded Files
LABORATORY PROJECTS:
Title: ISO/IEC 17025 Accreditation & Renewal — Geochem West Africa
Tools used: ISO/IEC 17025:2017 | Internal Audit | NCR Management
Description: Core contributor to both the initial ISO/IEC 17025:2017 accreditation and subsequent renewal at Geochem West Africa — covering multiple petroleum testing scopes including gasoline, diesel, jet fuel, and marine fuel. Zero major findings across both audit cycles. Outcomes included a 15% reduction in nonconformities and 20% improvement in operational efficiency through risk-based QA framework design.
Title: Laboratory Nonconformity Reduction Programme
Tools used: ISO 17025 Clause 7.10 | Clause 8.7 | RCA | CAPA | IQC Trending
Description: Designed and implemented a risk-based nonconformance management system — NCR writing, root cause analysis, and corrective action closure. Achieved 15% reduction in laboratory nonconformities through structured CAPA cycles and tightened IQC controls.
Title: Petroleum Laboratory IQC & Measurement Uncertainty Dashboard
Tools used: Excel | Power BI | GUM Methodology | Shewhart Control Charts Description: Built an internal quality control tracking system to monitor test result trends, flag out-of-control conditions, and maintain uncertainty budgets across accredited petroleum testing scopes — D445, D4294, D86, D4052, D93, D5580.
Title: Custody Transfer & Marine Terminal Inspection Operations
Tools used: ASTM D445 · D4052 · D86 · D93 · IP Methods · ISO 8217
Description: Provided custody transfer support at refinery and marine terminal operations across West Africa — conducting witness testing, quantity verification, sampling, and compliance reporting for major oil company clients. Ensured measurement traceability and result defensibility at point of transfer.
Title: Marine Fuel Testing & ISO 8217 Compliance
Tools used: ASTM D445 · D4294 · D93 · D4052 · ISO 8217 · IP Methods
Description: Conducted marine fuel oil testing against ISO 8217 specifications for fuel oil grades including RMG and RMK. Applied viscosity, density, flash point, sulfur content, and pour point testing to verify product compliance before and during vessel bunkering operations.
Title: Measurement Uncertainty Evaluation — Accredited Test Methods
Tools used: GUM Methodology · Excel · ASTM Methods · ISO/IEC 17025
Description: Evaluated and documented measurement uncertainty budgets across multiple accredited petroleum test methods at Geochem West Africa. Identified dominant uncertainty contributors per method, maintained uncertainty records for ISO/IEC 17025 audit readiness, and reviewed budgets as part of the accreditation renewal cycle.
DATA ANALYTICS PROJECTS
METROCITY REVENUE AND PERFORMANCE REPORT DASHBOARD
The dashboard highlights solid revenue performance, with buses as the primary revenue driver and select routes delivering the highest utilization and returns. Strategic opportunities exist in optimizing route efficiency and diversifying revenue streams across transport modes.
METROCITY PASSENGER AND USAGE ANALYTICS
The dashboard reveals opportunities to streamline route performance, strengthen tram and train services, tailor offerings to gender-specific commuter needs, and sustain revenue growth through smarter, data-driven transport strategies.
COSMO-MART INC SALES DASHBOARD
This dashboard highlights Cosmo-mart’s steady and resilient sales trajectory, driven by a broad customer mix, well-distributed demographics, and strong national footprint. These advantages provide a solid foundation for future growth. To advance further, the company should prioritize strengthening loyalty among repeat buyers, expanding core revenue drivers such as Books and Beauty, and preserving profitability while tapping into untapped potential within younger and middle-income customer segments.
COSMO-MART INC SALES DASHBOARD
COSMO-MART INC SALES DASHBOARD
The dashboard underscores its ability to sustain strong and consistent sales growth through a diverse customer base, balanced demographics, and extensive regional presence. These strengths position the company well for continued expansion. However, to unlock further growth, Cosmo-mart can focus on deepening relationships with high-value returning customers, scaling top-performing categories like Books and Beauty, and sustaining margins while capturing more share among younger and middle-income consumers.
US REAL ESTATE SALES RATIO ANALYSIS DASHBOARD
This dashboard reveals that the market is largely driven by single-family homes, making them both the core growth engine and the main source of risk. Sales activity follows strong seasonal patterns, peaking in late summer and early fall. Undervaluation in property assessments, particularly for three-family homes, points to potential reassessment opportunities, while high-priced four-family properties represent a niche investment segment despite low sales volume. Regional differences remain pronounced, with premium towns like New Fairfield contrasting sharply against more affordable markets such as Hartford, creating room for targeted investment strategies.
EXCELPRO CONSULT TRAINING PERFORMANCE DASHBOARD
The dashboard reveals that the training program engaged 160 trainees and generating $1.95M in revenue. The IT department and the East region lead in training investments, reflecting strategic focus areas. Notably, 69% of participants benefited from discounts, driving higher enrollment. While overall satisfaction stands at 3.0/5, this presents an opportunity for continuous quality improvement. Participation spans across all education levels, underscoring the program’s inclusive reach and relevance across the workforce.
HR EMPLOYEE ATTRITION DASHBOARD
The HR attrition analysis revealed an overall turnover rate of ~16%, with the highest losses concentrated in Sales, HR, and among employees under 25%, where attrition reached nearly 40%. Sales Representatives and Lab Technicians were particularly at risk, while senior roles showed strong stability. Work-life balance proved to be a key driver, with poor ratings linked to double the attrition rate of those reporting healthier balance. Recommendations included stronger onboarding and mentorship for younger staff, redesigning sales incentives, improving work-life balance policies, and leveraging senior leaders as mentors. Together, these strategies could reduce attrition to a sustainable 10–12 % and build a more engaged workforce.
Employee Demographic Analysis Summary
Developed a dynamic HR dashboard to visualize workforce composition, hiring trends, diversity metrics, and attrition patterns. Key insights include a mid-career-dominant workforce (avg. age 41), peak exits in 2021, balanced gender distribution, and engineering as the largest department.
Recommendations: Focus on succession planning for aging employees, strengthen retention programs, enhance diversity hiring, invest in early-career talent, and use data to predict attrition and guide workforce planning.
🚗 METROSAFE ACCIDENT ANALYSIS
Analyzed 144K+ accidents, 195K+ casualties, and 265K+ vehicles involved. Fridays emerge as the riskiest day, with single carriageways (120K+ cases) posing the highest danger. 65% of crashes occur in urban areas, while Sept–Oct peaks reflect festive travel and weather changes. Strikingly, 1 in 7 accidents is serious or fatal—underlining the urgent need for safer road designs, driver awareness, and faster emergency response.
FRAUD MONITORING ANALYSIS
⚠️ Imagine this: every 5th transaction is fraudulent. The Fraud Monitoring Dashboard (Tableau) revealed a 21.3% fraud rate worth $489K, with hotspots across POS, bank transfers, and ATMs. Fraudsters systematically target clothing, luxury, and travel merchants, while risk varies by customer group — from students on mobile to retirees in crypto. The insight is clear: fraud follows patterns, and detecting them early protects both money and trust.
EXECUTIVE SALES ANALYSIS
💡 The Executive Sales Dashboard reveals more than just numbers — it shows where profit truly comes from. In-Store leads with $30.1M revenue, but Wholesale delivers the highest margin (30.3%) despite being the smallest channel. Seasonal surges drive in-store & online growth, while everyday products like platters and glassware outperform niche items. 👉 Revenue tells the story, but profit writes the ending.
🏨 Hotel Booking Analysis Project
🏨 Hotel Booking Analysis Project
Tools Used: Microsoft Excel (Power Query), SQL, Power BI
Data Size: 225,000+ guest records | 114,000+ bookings
Project Type: Data Cleaning | Exploratory Analysis | Dashboard Design | Insight Generation
🔧 Project Overview
🔧 Project Overview
This end-to-end analysis project focused on uncovering trends in hotel booking behavior, revenue performance, customer segmentation, and occupancy patterns. The objective was to deliver actionable insights to inform strategic decisions across revenue management, marketing, and operations.
🔗 Explore the Dashboard:
Curious to see the full interactive visuals behind these insights?
🏥 Medical Analytics Dashboard (Power BI)
🏥 Medical Analytics Dashboard (Power BI)
Overview:
In hospitals, inefficiencies don’t just cost money — they can cost lives. This Medical Analytics Dashboard transforms complex hospital data into clear, actionable insights that empower decision-makers to improve patient care, optimize resources, and enhance financial performance.
Designed from real hospital use cases, this interactive Power BI solution helps clinical, financial, and administrative leaders make data-driven decisions with confidence.
🔗 Explore the Dashboard:
Curious to see the full interactive visuals behind these insights?
Page updated
Google Sites
Report abuse