Hi, I'm Samatar

Data Analyst

I turn raw data into actionable insights. Experienced in SQL, Excel, Python, Power BI, and machine learning. I clean, analyze, and visualize data to support smart business decisions.

SQL
Excel
Python
Power BI
ML
ETL
View CV View Projects
Samatar Abdirahman Profile

About Me

I'm a passionate Data Analyst with a strong foundation in statistics, programming, and business intelligence. I specialize in extracting, cleaning, and analyzing data to uncover trends and patterns that drive strategic decisions. My toolkit includes SQL for data querying, Python (Pandas, NumPy, Scikit-learn) for analysis and machine learning, Excel for quick insights, and Power BI for interactive dashboards. I also build ETL pipelines to ensure data quality and availability.

0

Records Analyzed

0

Dashboards Built

0

ML Models Trained

0

Projects Delivered

Education

Amoud University
Bachelor of Information Technology (2022 – 2026)

Focused on Data Analytics, Machine Learning, and Business Intelligence.

Skills

Data Analysis & BI

SQL (Queries, Joins, Aggregations)
Excel (Pivot Tables, Formulas, Power Query)
Python (Pandas, NumPy, Matplotlib, Seaborn)
Power BI & DAX
Machine Learning (Scikit-learn, Regression, Classification)
ETL (Extract, Transform, Load)
Data Cleaning & Preprocessing
Data Visualization & Storytelling

Tools & Technologies

Microsoft SQL Server
Power BI Desktop & Service
Microsoft Excel
Python / Jupyter Notebook
Git & GitHub
KoboToolbox
SQL
Excel
Python
Power BI
ML
ETL

Services

Data Analysis

Actionable business insights

Dashboard Development

Power BI & Excel dashboards

Data Cleaning

Preprocessing & quality assurance

ETL Development

Scalable data pipelines

Machine Learning

Predictive modeling & classification

Featured Projects

Bank Transaction Analysis

Analyzed banking transaction data using SQL and Power BI to detect patterns, customer behavior, and fraud indicators. Built interactive dashboards showing transaction volume, trends, and KPIs.

Focus: Transaction Analysis, Fraud Detection & Business Intelligence

SQL Power BI DAX Data Cleaning KPI

Sales Performance Analysis

Developed an interactive Power BI dashboard to analyze sales performance, revenue, products, customers, and business trends. Created DAX measures and interactive visualizations to provide meaningful insights and support data-driven decision making.

Focus: Data Analysis, Sales KPIs & Business Intelligence

Power BI DAX SQL Data Modeling Data Visualization

Construction Project Data Analysis

Analyzed construction project data using SQL Server and Power BI. Examined project budgets, expenses, payments, and financial performance. Developed dashboards to monitor project KPIs and budget utilization.

Focus: Financial Analysis, Project KPIs & Dashboarding

SQL Server Power BI DAX Budget Analysis Data Modeling

Experience

Data Analyst Intern — Amal Bank

2025

  • Collected, cleaned, and analyzed data using SQL, Excel, Python, and Power BI.
  • Prepared reports and dashboards to communicate key findings and insights.
  • Supported data analysis and reporting activities for business decision-making.

Data Collection — BAHDA Project

Borama | June 5, 2026

  • Participated in household data collection across Borama using KoboToolbox.
  • Collected and recorded accurate household information through field surveys.
  • Reviewed collected data for completeness, consistency, and accuracy.

Bank Transaction Analysis

Personal Project

  • Analyzed banking transaction data using SQL and Power BI to detect patterns and customer behavior.
  • Built interactive dashboards showing transaction volume, trends, and key performance indicators.
  • Identified fraud indicators and anomalies through data exploration and visualization.
  • Created DAX measures for financial analysis and transaction reporting.
  • Delivered actionable insights to support data-driven banking decisions.

Construction Project Data Analysis

Personal Project

  • Analyzed construction project data using SQL Server and Power BI.
  • Analyzed project budgets, expenses, payments, and financial performance.
  • Developed Power BI dashboards to monitor project KPIs, budget performance, and expenses.
  • Created DAX measures for financial analysis and project performance reporting.

Let's Work Together

Open for Data Analysis opportunities

Hire Me

Contact

samataryare088@gmail.com
+252 636558966
Borama, Somaliland
github.com/samatar-yare