Etim Antai | Data Analyst |Power Bi, Python, SQL| Policy & Energy Insight

Etim Antai

Data Analyst |Power Bi, Python, SQL| Policy & Energy Insight

Based in Lagos

About

I am a Data Analyst with a strong background in engineering, analytics, and energy systems, focused on transforming complex data into clear, actionable insights using Power BI, Python, SQL, and Excel. I hold a First Class degree in Electrical & Electronic Engineering from the University of Uyo, Nigeria, which provides a solid foundation for my analytical thinking, systems modeling, and problem-solving approach. Professionally, I currently head Operations at FirstOption Solar, Lagos, where I work at the intersection of renewable energy deployment, operational data, and performance analysis. My analytics work spans energy production and consumption, emissions analysis, and public safety (road crash) intelligence. I design robust data models, clean and structure complex datasets, and build

Skills

Projects

Road Transport Accident Analysis & Safety Insights

This project analyzes road transport accident data to identify patterns, risk factors, and trends affecting road safety. The goal is to support data-driven decision-making for accident prevention, policy planning, and public safety awareness. The analysis focuses on accident frequency, severity,

Global Energy Production, Consumption & Emissions Analysis (1990–2020)

This project analyzes global energy systems across regions and countries, focusing on energy production, consumption, fuel mix, trade balance, and CO₂ emissions. Using historical energy data, the dashboard highlights long-term trends and relationships between energy use and environmental impact.

Café Sales Analytics Case Study: From Raw Data to Business Insights

This project analyzes transactional sales data from a café to uncover key business insights such as revenue trends, product performance, and payment behavior. The dataset was cleaned using Python, analyzed using Pandas, and visualized using Power BI to build an interactive dashboard that highlights

Tuberculosis (TB) Surveillance Dashboard in Excel

Developed an interactive Excel dashboard to monitor TB case trends, identify peak reporting periods, and support evidence-based public health decision-making. Objectives Analyze TB case trends over time. Identify quarters with the highest TB burden. Provide stakeholders with an interactive reportin

Café Sales Analytics Case Study: From Raw Data to Business Insights

Firstoption 2025 Sales & Revenue Performance Dashboard

This project analyzes Firstoption’s 2025 sales transactions to evaluate revenue performance, payment behavior, and outstanding receivables. The goal was to provide management with a one-page executive dashboard that tracks sales growth, cash collection efficiency, and client payment risk.

Sales & Inventory Transaction Analysis

This project analyzes transactional data containing sales, purchases, returns, projects, and inter-branch transfers. The goal was to build an interactive Power BI dashboard that provides clear insights into sales performance, customer behavior, and inventory movement across branches over time.

Exploratory Data Analysis & Market Insights from USA Real Estate Listings

This project analyzes a large-scale real estate dataset containing over 2.2 million property listings across the United States. The goal was to explore pricing patterns, property characteristics, and regional trends, and to design an interactive dashboard that supports data-driven decision-making

Football Match Analysis & Performance Dashboard

Project Overview This project analyzes professional football match data to uncover performance patterns, match intensity, and discipline trends. Using Power BI, I built a multi-page interactive dashboard that explores match outcomes, attacking efficiency, goal distribution, and disciplinary

Experience

2020 -2026

Data Analyst

I am a Data Analyst and Electrical & Electronic Engineering graduate (First Class) with experience in energy data analysis, data modeling, and Power BI dashboard development. In this project, I handled the end-to-end workflow—data cleaning, transformation, modeling, and visualization—to deliver clear insights on global energy and CO₂ emissions. I also serve as Head of Operations at Firstoption Solar (Lagos, Nigeria), bringing real-world renewable energy context to data-driven analysis.

Education

2015-2020

Electrical Engineering at The University of Uyo, Nigeria

I hold a First Class degree in Electrical & Electronic Engineering from the University of Uyo, Nigeria, where I developed a strong foundation in power systems, energy engineering, data analysis, and problem-solving.