CV — Dominik Pałka

Portrait of Dominik Pałka wearing a navy suit outdoors

Data Analyst / BI Analyst

Kraków, Poland

Profile

I completed an Engineer's degree in Computer Science with a specialisation in databases and I'm now completing postgraduate studies in Business Analysis. SQL is my strongest tool. My portfolio also includes Power BI and Excel reporting projects.

Skills

SQL & Databases

T-SQL
SQL Server
SSMS
Joins and subqueries
CTEs and recursion
Data cleaning
Relational modelling

Power BI

Power Query
DAX
Measures
Data modelling
Relationships
Row-level security
Report development

Excel

Advanced formulas
Lookup functions
PivotTables
Power Query
Data validation
Data cleaning
Business reporting

Analysis & Reporting

Exploratory analysis
Descriptive statistics
KPI reporting
Data-quality checks
Validation and reconciliation
Explaining analytical results

Python

Python fundamentals
Object-oriented programming
Pandas — in progress
Data visualisation — in progress

Selected Projects

Retail Reporting & Analysis
SQL Server · T-SQL · SSMS
- Built reusable reporting views for daily and monthly KPIs, customer profiles, product hierarchies and operational audits.
- Created a 25-question SQL analysis set covering sales, cohorts, retention, products, shipping, returns and web conversion.
- Defined metric rules and added reconciliation and anomaly checks to validate reporting outputs.
View project
Data Professional Salary Survey
Power BI · Power Query · DAX · Excel
- Cleaned inconsistent survey responses in Power Query and built a dimensional model with a bridge table for multi-select hosting data.
- Created explicit DAX measures for salary analysis, response coverage, management comparisons and minimum sample-size rules.
- Built a four-page report with field parameters, bookmarks, tooltips, dynamic country RLS and a hidden QA page.
View project
TV Series Convention Analysis
Excel 365 · Formulas · PivotTables · PivotCharts
- Built an Excel 365 workbook for episode-level data entry, duration conversion, calculated measures and arithmetic quality control.
- Created runtime-weighted and average-episode summaries using modern formulas and reusable calculation logic.
- Developed series- and episode-level dashboards with PivotTables, PivotCharts and slicers.
View project

Education

Business Analyst — Postgraduate Studies

Kraków University of Economics

Mar 2026 — Jan 2027

In progress

Current coursework includes requirements analysis, SQL, Python, Excel, Power BI and Power Query, UML and BPMN, AgilePM and AI in business analysis.

Computer Science — Database Specialisation

Wyższa Szkoła Zarządzania i Bankowości w Krakowie

Oct 2021 — May 2025

Engineer's degree covering databases, programming and related computer science subjects. My thesis used social network analysis to examine collaboration between EDM artists.

Degree thesis

Network Analysis of Collaboration Trends Between Artists in Electronic Dance Music

Experience

IT Support