Allen The Analyst

Allen The Analyst

Former Product Engineer turned Data Analyst with a strong foundation in technical problem-solving and systems thinking. I now apply analytical tools like Python, SQL, Power BI, and Tableau to transform complex datasets into actionable business insights.

“Engineer at heart. Analyst by choice. Turning data into product-driven decisions.”

Profile Picture

What I do

I help organizations make smarter decisions through data. From cleaning messy datasets to building interactive dashboards, I turn numbers into clear, actionable insights using tools like Python, SQL, Tableau and PowerBI.

Data Cleaning & Transformation

I clean, filter, and structure messy or incomplete datasets using Python (Pandas), Excel, PowerBI (Transformation) and SQL—ensuring data integrity for accurate analysis.

Exploratory Data Analysis (EDA)

I uncover trends, correlations, and patterns using descriptive statistics, data profiling, and visualizations through Seaborn, Matplotlib, and Plotly.

Data Visualization & Reporting

I build interactive dashboards and insightful reports using Power BI, Tableau, and Excel to support decision-making and storytelling.

Dashboard Customization for Stakeholders

Build role-specific dashboards (e.g., for sales, marketing, HR) to ensure each team sees the most relevant KPIs at a glance.

ETL (Extract, Transform, Load) Pipelines

Create and manage automated pipelines to gather, clean, and push data to BI tools or databases using Python, Airflow, or Power Automate.

IBM Data Analyst Capstone Project

This project presents findings from a global developer survey focused on current and future technology trends.

World University Rankings 2011-2016

University Ranking Analysis (2011-2016) Dataset from Kaggle Overview. This project analyzes key factors influencing global university rankings from 2011 to 2016. Using academic and demographic metrics, the study identifies the strongest drivers of ranking performance and offers insights into trends over time.

Student Social Media Addiction Analysis

A Data set from Kaggle. This project explores the relationship between students' average daily social media usage and their academic performance across different academic levels..

Data Visualization & Dashboard Projects Tools: Tableau • Power BI • IBM Cognos Analytics

This project presents findings from a global developer survey focused on current and future technology trends.

Discover More Data Projects

Get in touch

If you have a question, project idea, or just want to connect, feel free to send a message. I’ll get back to you as soon as possible.