Drag to rotate · Hover a dark point

Data analytics portfolio

Yalchin Hasanov

Junior Data Analyst

I build clear analyses and dashboards using Excel, SQL, Power BI and Python — shaped by four years in banking and financial services.

Open to Data Analyst opportunities

About

Business experience,
strengthened by data.

Four years in banking and financial services shaped the way I assess risk, question data and communicate findings.

My professional background is in banking and financial services, where I assessed credit applications, reviewed customer financial information, identified risks and prepared reports.

Today I apply that business perspective to practical analytics work: cleaning and validating data, writing SQL queries, building data models, defining KPIs and presenting findings through dashboards.

I am focused on Data Analyst opportunities where structured analysis, business judgment and clear communication support better decisions.

01Business context

Banking, reporting and credit-risk perspective.

02Reliable data

Careful cleaning, validation and documentation.

03Useful reporting

KPI design, dashboards and actionable summaries.

04Clear communication

Analysis explained for non-technical stakeholders.

Toolkit

Four tools.
One workflow.

From raw files and relational data to analysis, models, dashboards and concise business recommendations.

XL

Excel

Power Query, PivotTables, XLOOKUP, INDEX/MATCH, SUMIFS and interactive dashboards.

Analysis & reporting
SQL

SQL

SQLite, JOINs, CTEs, subqueries, aggregations, window functions and query optimization.

Querying & exploration
BI

Power BI

Power Query, dimensional modeling, DAX measures, KPIs, slicers and visual storytelling.

Modeling & visualization
PY

Python

Pandas, NumPy, web scraping, data cleaning, feature engineering and exploratory analysis.

Preparation & EDA

Selected work

Five project
collections.

Real project previews covering data collection, cleaning, exploratory analysis, SQL, dashboards and business recommendations.

Global Economic Indicators Power BI dashboard 01 End-to-end analytics

Python · Power BI

Global Economic Data Pipeline

Web scraping, data cleaning, exploratory analysis and an interactive dashboard covering 213 economies.

213 economiesWeb scrapingPower BI
Northwind SQL analysis Excel Sales and KPI dashboard Sales Performance Power BI dashboard Marketing Performance business case dashboard 02 Four-module internship

SQL · Excel · Power BI

DevJoint Analytics Sprint

Four practical modules spanning Northwind SQL, Excel KPI reporting, Power BI and a marketing business case.

4 modulesSQL & ExcelBusiness case
Hotel booking Python notebook preview 03 Booking analytics 37.04% cancelled

Python · Pandas

Hotel Booking Analysis

Data preparation and EDA across booking status, lead time, ADR, hotel type and estimated booking value.

119,390 records32 columnsEDA
Telco customer churn Python notebook preview 04 Customer analytics 26.54% churn

Python · Pandas

Telco Churn Analysis

Customer risk segments and churn patterns across contracts, tenure, payments and support services.

7,043 customers21 variablesRisk groups
Video Game Sales Power BI dashboard 05 Market dashboard

Power BI · DAX

Video Game Sales Dashboard

A multi-page report exploring global and regional sales across platforms, genres, publishers and years.

16,598 records6 report pagesData model

Credentials

Verified learning,
one clear system.

Seven credentials presented with the same structure, priority and visual weight.

IS
InStudyAugust 2026

Data Analyst (Big Data Analyst)

Professional data analytics training completed with distinction.

DJ
DevJointAugust 2026

Data Analytics Internship

Four-week practical program covering SQL, Excel, Power BI and business analysis.

CA
CodeAlphaAugust 2026

Data Analytics Virtual Internship

End-to-end internship covering web scraping, EDA and dashboard development.

G
GoogleAugust 2026

Foundations: Data, Data, Everywhere

Foundational concepts, analytical thinking and the data analysis lifecycle.

MS
MicrosoftAugust 2026

Excel and Copilot Fundamentals

Spreadsheet fundamentals, practical analysis and AI-assisted productivity.

IBM
IBMAugust 2026

Introduction to Data Analytics

Core analytical roles, workflows, tools and real-world applications.

C
CourseraAugust 2026

Data Visualization & Descriptive Statistics

Descriptive analysis, visual communication and evidence-based interpretation.

Let's work with data

Looking for a data analyst who connects numbers with business context?

Based in Baku · Open to local and remote opportunities

Python · Web scraping · Power BI

Global Economic Data Pipeline

An end-to-end workflow that collects economic indicators, prepares the data, explores patterns and presents the results in Power BI.

Global Economic Indicators Dashboard
Economies213
Total GDP126.56T
Median GDP per capita10.46K
Average GDP growth3.43%
01

Web scraping

Collected country-level indicators from Worldometer with Python, BeautifulSoup and Requests.

02

Exploratory analysis

Cleaned data, reviewed distributions and compared GDP, income and growth patterns.

03

Data visualization

Built KPI cards, rankings, a scatter plot, filters, tooltips and cross-filtering in Power BI.

SQL · Excel · Power BI · Business analysis

DevJoint Analytics Sprint

A four-week project-based internship documented as one complete analytics collection.

01

Northwind SQL

JOINs, CTEs, subqueries, aggregations, window functions and optimization.

02

Excel KPI

Cleaning, formulas, PivotTables, slicers and an interactive sales dashboard.

03

Sales Power BI

Data model, DAX measures, targets, YoY analysis and management reporting.

04

Marketing case

CPA, ROAS, conversion analysis, root-cause review and a measurable recommendation.

Python · Booking analytics

Hotel Booking Analysis

Data preparation, feature engineering and exploratory analysis across 119,390 booking records.

Records119,390
Original columns32
Cancellation rate37.04%
Longest average stay5.32 nights

Python · Customer analytics

Telco Churn Analysis

Exploratory analysis identifying customer groups with higher churn risk while separating association from causation.

Customers7,043
Variables21
Overall churn26.54%
Month-to-month churn42.71%

Power BI · Market analysis

Video Game Sales Dashboard

A six-page Power BI report built from 16,598 records with regional analysis and custom tooltip pages.

Records16,598
Report pages6
Total sales8,815.57
Game count11,359