Karo Majesty Onoriose

About

As a dedicated and detail-oriented Data Analyst, I bring a robust skill set in various data analysis tools and techniques. My expertise includes Microsoft Excel for efficient data manipulation and analysis, Tableau for creating insightful visualizations, and Data Modelling to structure and interpret complex datasets. I am proficient in Microsoft Power BI for interactive data reporting and Database Management to ensure data integrity and accessibility. I excel in Data Cleaning to maintain high-quality datasets and use Python for Data Science to perform advanced analytics and machine learning. My experience with Data Warehousing allows me to manage and retrieve large volumes of data efficiently. Additionally, I am skilled in SQL/MSSQL for querying databases and Data Manipulation to transform raw data into actionable insights. My ability to create compelling Data Visualizations helps stakeholders make informed decisions based on clear and concise data presentations.

Data Analyst/ BI Analyst

  • Phone: +234 916 709 1342
  • City: Lagos , Nigeria
  • Email: Onoriosekaro@gmail.com
  • Freelance: Available

Skills

Programming & Database

  • Python: Pandas, NumPy, Matplotlib, Seaborn
  • SQL: MSSQL, MySQL, Database Management
  • ETL: Data Integration, Data Pipelines
  • DAX, Power Query,Mcode

Methodologies & Concepts

  • Exploratory Data Analysis (EDA)
  • Statistical Analysis
  • Trend Identification
  • Key Performance Metrics Analysis (KPIs)
  • Automation(Excel, python)

Data Quality & Governance

  • Data Cleaning
  • Data Profiling
  • Data Validation
  • Data Governance
  • Data Modelling
  • Data Collection(web Scaping)
  • Data manipulation

BI & Visualization

  • BI Tools:Microsoft Power BI (),Microso Tableau
  • Visualization: Dashboard & Report Development, Data Storytelling
  • Analytics: Google Analytics, Web Analytics

Soft Skills

  • Critical Thinking & Problem-Solving
  • Communication & Presentation Skills
  • Stakeholder Engagement & Collaboration
  • Attention to Detail
  • Time Management

Portfolio

Explore my portfolio to see how I leverage data to optimize operational efficiency and support Company growth. Let’s connect and discuss how I can contribute to your organization’s success!.

  • All
  • Power Bi
  • Tableau
  • Python
  • SQL
  • Excel

Beyond the Cart: Behavioral Analytics in Brazilian Retail

Leveraging RFM segmentation to identify high-value customer segments and drive targeted retention, loyalty, and win-back strategies

Consumer Performance dashboard

Interactive Power BI dashboard for analyzing customer demographics and purchasing behavior.

Human Resourses Dashboard

An interactive Tableau dashboard providing strategic insights into workforce demographics, performance, departmental trends, and compensation

Covid-19 Impact on Airport Traffick

This project shows analysis on traffic to and from airport around the world as a Percentage of the Traffic volume during the Covid-19 period.

A Day in World Shipping

An interactive Tableau dashboard that visually analyzes global maritime operations for a single day

LimeCore Finance Bank Churn Analysis Dashboard

a comprehensive report on customer churn, providing actionable insights for improving customer retention and making strategic business decisions.

Furniture Sales Dashboard

The Furniture Sales Dashboard provides an overview of key performance indicators, sales trends, regional distribution, and logistical insights

Unicorn Companies Data Ananlysis With Python

An andept analysis of biggest companies in the world using With Python

Supermarket Stores Analysis

An indept analysis of supermarket Stores with python

Historical Stock Price of 10 Popular Companies

The subject matter of this Analysis is the stock prices of the 10 popular companies ( Apple, Amazon, Netflix, Microsoft, Google, Facebook, Tesla, Walmart, Uber and Zoom)

Adventureworks Analysis with Microsoft SQL Server

Adventureworks Analysis with Microsoft SQL Server

Who Covid 19 dashboard

The dashboard includes information on the number of cases and deaths by country and by WHO region, as well as a map visualization.

SQL Data Cleaning Project: Global Layoffs Dataset

SQL-based project to clean and standardize a raw global layoffs dataset for analysis.

Cholera Outbreak, Stockholm, 1853

This Analysis is on research work on Cholera Outbreak in Stockholm in the 19th century.

Shark attack Analysis

The analysis provides a comprehensive insight on shark attacks, including data on total fatalities, survivors, cases by time of day, cases and fatality by city, and the most common shark species involved in attacks.

Data Cleaning With Python (Absenteeism Dataset)

A Python Data Cleaning Project Using Pandas

Airlines and Airlines Flight Delay and Cancellation

Here we analyze records for 5,000,000+ commercial airline flights in 2015, compiled for the U.S. DOT Air Travel Consumer Report.

NYC taxi Trips Analysis

provides a comprehensive overview of taxi activity in New York City.This analysis helps in understanding the patterns and trends in taxi usage across different zones and times in NYC

Student Mental Health Analysis

The analysis provides insights into the mental health status of students, focusing on depression, anxiety, and panic attacks.

Brazilian Olist Store Analysis

This Power BI dashboard explores customer behavior, order trends, delivery performance, and review sentiment across Brazil’s e-commerce landscape from October 2016 to October 2018.

Bitcoin Historical Data Analysis

This project provides a detailed historical analysis of the Bitcoin market, including data on the total volume, price trends, and key events over the years.

US Censors Population project

a project on US population censors

Space Missions Analysis

This analysis provide key insights into space exploration history and performance .

Mexican Resturant Rating analysis

This Analysis effectively provides insights on customer preferences, restaurant ratings, and pricing insights within the Mexican restaurant sector.

Instanbul Customer Shopping

Welcome to the shopping world of Istanbul! this Analysis contains insights on shopping information from 10 different shopping malls between 2021 and 2023 to provide a comprehensive view of shopping habits in Istanbul.

US Birth Analysis

This Project provides an analysis of US birth data, including the total number of births, the number of births by mother's age and education level, the number of male and female babies, and the birth weight trend over the years.

Microsoft Stock Market Analysis

This Analysis provides a comprehensive overview of Microsoft's trading performance.

Nigeria (NCDC) Covid-19 Dashboard

The analysis provides an overview of the COVID-19 situation in Nigeria as of December 3, 2023. It includes information on the number of active cases, confirmed cases, discharged cases, and deaths across different states in Nigeria.

Maternity Health Analysis

This analysis aims to predict health risks for pregnant patients. Data has been collected from different hospitals, community clinics, and maternal health cares through the IoT-based risk monitoring system.

Services

I help organizations unlock the full potential of their data. From cleaning and transforming raw datasets to designing sleek dashboards and drawing actionable insights—these are the services I provide as a data analyst.

Data Cleaning and Wrangling

Transforming raw, messy datasets into structured, analysis-ready formats using Power Query, Excel, and Python (pandas).

Data Visualization (Interactive Dashboards)

Designing powerful, in dashboards with Power BI, Tableau, Excel and Charts with python to visualize business KPIs and trends in real time

Business Reporting

Creating polished, executive-friendly reports in PowerPoint, Excel, and PDF formats—with data pipelines powered by SQL and Python.

Exploratory Data Analysis

Identifying patterns, trends, and hidden insights in data using Python (pandas, matplotlib, seaborn) and Excel pivot tools.

Database Management

Writing optimized SQL queries, managing relational databases, and integrating with PostgreSQL, MySQL, SQLite, and cloud platforms.

Web Scraping

Extracting structured data from websites using Python libraries like BeautifulSoup, Selenium, and Requests for custom dashboards and analysis.

Insights & Decision Support

Translating complex datasets into clear business recommendations with visualizations and written narratives.

Predictive Analysis

Building regression, classification, and time-series models using Python (scikit-learn, statsmodels) to forecast trends and business outcomes.

Excel & Python Automation

Automating repetitive tasks and workflows using Python ( pandas), Excel macros, and VBA scripting for efficient reporting.

Contact

Location

Lagos, Nigeria

Call me

+(234) 916 709 1342

+(234) 802 554 5280

Email me

Onoriosekaro@gmail.com