Business Analyst — Postgraduate Studies
Kraków University of Economics
Current coursework includes requirements analysis, SQL, Python, Excel, Power BI and Power Query, UML and BPMN, AgilePM and AI in business analysis.
Hey, I'mDominik Pałka.
I work mainly with SQL, Power BI and Excel, with SQL as my strongest tool. I'm looking for a Data or BI role.
About me
I completed an Engineer's degree in Computer Science with a specialisation in databases. SQL was the part I enjoyed most, especially working through how data is structured and checking whether a result matches the underlying logic.
For my degree thesis, I used social network analysis to study collaboration between EDM artists. I worked with NetworkX, Gephi, SQL Server and Power BI to examine centrality, artist communities and the relationship between network position and popularity. I'm now completing postgraduate studies in Business Analysis at Kraków University of Economics.
How I work
Before I build a chart, I want to know exactly what the number means and where it came from. I check source data, test edge cases and compare outputs with another calculation when I can.
Define the number
I write down the scope, filters and calculation rules before treating a metric as final.
Break down the question
I split broad questions into smaller checks and outputs instead of trying to solve everything in one query or report page.
Check as I go
I compare totals, inspect unexpected values and test edge cases throughout the work.
Explain the result
I say what a number includes, what it leaves out and where the limits are.
Toolkit
SQL is my strongest tool. I also use Power BI and Excel for modelling and reporting, while I'm rebuilding my Python skills through a new analysis project.
SQL & DatabasesMy strongest area, covering analytical queries, reporting views and data checks in SQL Server.
- T-SQL
- SQL Server Management Studio
- Joins
- CTEs
- Recursive queries
- Subqueries
- Data cleaning
- Relational modelling
Power BIData cleaning in Power Query, dimensional models, DAX measures and report development.
- Power Query
- DAX
- Measures
- Data modelling
- Relationships
- Row-level security
- Dashboard development
- Report design
ExcelFormula-driven workbooks, PivotTables, data checks and dashboards.
- Advanced formulas
- Lookup functions
- PivotTables
- Power Query
- Data validation
- Data cleaning
- Reporting
PythonI studied Python and object-oriented programming at university. I'm now revisiting it for data analysis.
- Python fundamentals
- Object-oriented programming
- Pandas — in progress
- Data visualisation — in progress
Analysis & ReportingMetric definitions, descriptive analysis, reconciliation and explaining what the result does and does not show.
- Exploratory analysis
- Descriptive statistics
- KPI reporting
- Data-quality checks
- Validation and reconciliation
- Insight communication
Education & Experience
Computer Science — Database Specialisation
Wyższa Szkoła Zarządzania i Bankowości w Krakowie
Engineer's degree covering databases, programming and related computer science subjects. My thesis used social network analysis to examine collaboration between EDM artists.
IT Support
Wyższa Szkoła Zarządzania i Bankowości w Krakowie
Configured and updated Windows and Linux workstations, installed teaching software, monitored hardware and assisted with equipment inventory. I also tested computer labs, network connectivity, systems and applications, investigated user-reported issues and supported lecturers, students and staff during regular and weekend IT support shifts.
Music
- 8 years
- producing music
- ~40K
- Spotify streams on one track
I've been producing music for about eight years, mostly electronic music, pop, trap and hip-hop. It is the main thing I do outside data work.
One track I worked on has reached about 40,000 streams on Spotify. I may add a separate music page later for tracks I can share publicly.