My Expertise

Excel

I am highly proficient in Microsoft Excel, using it as a core tool for data cleaning, transformation, analysis, and reporting. My Excel capability includes advanced formulas, logical functions, lookup operations, pivot tables, conditional formatting, and data validation. I am skilled in creating dynamic dashboards, performing complex data manipulation, and organizing large datasets with accuracy and structure. Excel is often my starting point for quick analysis, exploratory work, and preparing datasets for deeper insights.

SQL

I use SQL to extract, filter, join, and manipulate data from relational databases with efficiency and precision. My SQL expertise includes writing optimized queries, performing aggregations, using subqueries, window functions, CTEs, and transforming raw data into clean, analysis-ready datasets. I am comfortable working with large tables, investigating data quality issues, and building queries that support decision-making and reporting. SQL enables me to understand underlying data structures and retrieve exactly what stakeholders need.

Power BI

I leverage Power BI to create interactive dashboards and visual reports that communicate insights clearly and effectively. My expertise covers data modeling, using DAX for calculated measures, building relationships, and designing dashboards that highlight trends, patterns, and KPIs. I focus on clean, user-friendly visuals that tell a compelling story and support fast, informed decisions. I also use Power Query for data cleaning and transformation, ensuring that every report is powered by well-structured, reliable data.

Python

I use Python as a powerful tool for deeper data analysis, automation, and visualization. My strengths include working with Pandas for data cleaning and manipulation, NumPy for numerical analysis, and Matplotlib/Seaborn for producing clear and insightful visualizations. Python allows me to handle larger datasets, perform advanced analytical tasks, and build efficient workflows that go beyond what spreadsheet tools can do. I use it to explore data, identify patterns, and create reproducible analysis pipelines.

My Projects

Finance E-Commerce Fraud Detection Analysis

This project focuses on analyzing e-commerce financial transactions to detect fraud patterns, assess risk exposure, and generate actionable insights for decision-making. The dataset contains 6,055 transactions. The analysis explores trends across customers, merchants, transaction amounts, balances, categories, and geographies, helping businesses proactively reduce fraud.

Hospital Emergency Room Dashboard

This project analyzes Hospital Emergency Room (ER) dataset to enhance operational efficiency and provide actionable insights into emergency room performance, this dataset contains 9,216 cleaned patient data, covering a 19-month period. This solution will enable stakeholders track, analyze, and make data-driven decisions regarding patient management and service optimization. Key Metrics 1. Number of Patients: Tracks total patients visiting the ER daily. 2. Average Wait Time: Measures how long patients wait before seeing a medical professional.

Get in touch

I’m always open to connecting with professionals, collaborators, and anyone interested in data analysis. Whether you have a project in mind, need support with data related tasks, or simply want to discuss insights and ideas, I would be happy to hear from you. Feel free to reach out through email or connect with me on any of my social platforms.

  • nnadikapeace@gmail.com
  • (+234) 816-582-9964
  • Enugu State
    Nigeria