Okafor Sopuluchukwu.T

Data Analyst | SQL, PowerBI, Excel

About Me

Your Name

I am a data professional, proficient in transforming complex datasets into actionable insights. My workflow focuses on SQL and Excel to collect, clean and transform raw datasets to uncover trends, patterns, and KPIs across sales, customer behavior, and operational performance. I build interactive PowerBI dashboards that visualize key metrics and applying analytical techniques like RFM segmentation to support data-driven stories that help organizations make informed decisions.

With experience in Power BI, SQL, and data modeling, I transform complex data into a clear, comprehensive report that reveal critical areas. This portfolio showcases my projects across various sectors.

My Projects

project one preview

General Ledger & Financial Report

A financial reporting system in Excel using a raw general ledger dataset. Organized accounts, automated aggregations with formulas and PivotTables, and created a structured financial statement to track Profit & loss.

Documentation View Dashboard
Project two preview

Customer Segmentation SQL Analysis

Designed an end-to-end retail sales project using SQL and Power BI. Conducted data cleaning, created RFM customer segmentation, and developed an interactive dashboard to track KPIs.

Documentation View Dashboard
Project Three Preview

Patients Record Analysis

Using Power Query for data transformation and Power BI for visualization, the analysis uncovers insights into: Patient admissions and readmission, hospital stay patterns, Medical costs, medical encounters, insurance coverage and Trends.

Documentation View Dashboard
Project Four Preview

Retail SQL Analysis Project

Performed end-to-end analysis on a retail dataset (customers, products, stores, employees, sales, payments) using SQL Server and Power BI. Applied advanced SQL techniques (joins, aggregations, group and filtering) to clean and analyze data, generating insights into sales performance, customer behavior, and payment trends. Built a Power BI dashboard to visualize KPIs and support business decision-making.

Documentation View Dashboard
Project five Preview

Finance Tracker & Project Tracker

Developed an Excel based Personal Finance Tracker that enables users to record income and expenses with guided data validation. Automated running balance calculations and built a PivotTable powered dashboard with charts to visualize and slicers to interact with net balance, trends, spending by category, and income vs expenses.

Documentation View Dashboard
Project Four Preview

Human Resources Data Analysis

provided actionable insights into workforce dynamics, helping identify strengths like effective recruitment channels and areas of concern like pay inequities, using Excel (PivotTables, Charts, Conditional Formatting, Statistical Functions and comparative analysis)

Documentation View Dashboard

Technical Skillset

Data Visualization

  • Power BI
  • PowerPoint
  • Looker Studio
  • Excel Dashboards

Data Analysis

  • SQL
  • Microsoft Excel
  • Google Sheets
  • PowerQuery
  • Beginner Python (Pandas)

Data Modeling

  • Power Query
  • DAX
  • Excel Power Pivot
  • Schema Design

Send me a message

Interested in collaborating or have questions about my work? I'd love to hear from you!