I'm a data-driven analyst who loves turning messy, real-world problems into clean, actionable insights. I care about systems, small improvements, and tools that scale.
I'm honing my data skills with a bias toward practical business impact. Long-term, I want to use data to drive meaningful, positive change. Right now I'm working through the Python Developer path on JetBrains’ Hyperskill and a Coursera AWS Fundamentals specialization.
I completed my Economics degree two years ago and have been deepening my toolkit across Python, SQL, and analytics engineering since.
I love coding and crafting efficient data workflows in service of sustainable development, and I’m a proponent of open-source software; you’ll find projects here showcasing Python, SQL, Power BI, and Bash.
For data visualization, see both:
- My Power BI report repos here on GitHub, and
- Selected work on Tableau Public
At a glance:
Power BI | SQL | Python | Data Modeling (Star Schema) | DAX | Power Query/M | ETL | MySQL | Excel (Power Query/Power Pivot) | Git/GitHub | JupyterLab | VS Code | WSL (Bash) | Linux | Anaconda | REST APIs | Looker Studio
Full skills (expand)
Business Intelligence
Power BI (Data Modeling/Star Schema, DAX, Power Query/M, Drillthrough, Bookmarks, Field Parameters) | Power BI Service (Workspaces, Dataflows, RLS, Incremental Refresh, Gateways, Pipelines, Parameters)
SQL & Databases
SQL (Joins, Window Functions, CTEs, Aggregation, Subqueries) | MySQL | Basic Query Tuning
Excel (Advanced)
Power Query (Get & Transform) | Power Pivot | PivotTables | SQL-Connected Pivots (CRM-to-Excel)
Python (Analytics)
pandas | NumPy | Matplotlib | Scripting & Automation | Web Scraping (BeautifulSoup) | SQLAlchemy
Data Engineering / ETL
Source-to-Model Pipelines | Data Cleaning & Shaping | CSV/Excel/Database Ingestion
Tools & Platforms
Git | GitHub | Looker Studio | Tableau | JupyterLab | VS Code | WSL (Bash) | Linux | Anaconda | REST APIs
Methods
KPI Design | A/B Testing | Trend/Variance Analysis | Cohort Analysis | Regression & Inference | Hypothesis Testing | Research Design (Sampling, Interviews) | Stakeholder Alignment | Process Mapping | Data Storytelling | Agile
-
Power BI — AdventureWorks
Star schema, robust DAX measures (AOV, T12M, Time Intelligence), KPI tiles, drill-throughs, and clean UX; focused on performance and business storytelling. -
Python — Investor Calculator
CLI/Notebook tool to evaluate investment scenarios (lump-sum vs DCA, fees, taxes, FX), with charts and sensitivity analysis. -
SQL — Expense Tracker
End-to-end SQL project modeling expenses: clean, categorize, and aggregate transactions; views for monthly burn, vendor analysis, and rolling 12-month trends. -
Bash — True or False (mini-game)
Lightweight Bash project demonstrating CLI UX patterns, input validation, and file I/O.
Want a deeper dive? Explore more in my GitHub repos and portfolio.
- Data analysis & visualization
- SQL modeling and data cleaning
- Python automation & scraping
- Building practical, readable dashboards
- Zen + small habits that compound
I’ve lived in enough places that the whole world feels like home. These days, I’m based in Tokyo.
- 🖇️ LinkedIn: https://www.linkedin.com/in/rafael-karcz/
- 📝 Portfolio: https://rafaelkarcz.github.io