Robert Junek
I turn data into clear decisions
Who am I?
I'm a BI consultant and data analyst with over 15 years of experience. I help companies extract what matters from their data—quickly, clearly and sustainably.
I have a strong background in e‑commerce (running shops with hundreds of millions in turnover, leading a team of consultants in a marketing agency). I understand warehouses, fulfillment, pricing, products and logistics—so I build solutions that work in real operations.
I specialize in Power BI, SQL and Keboola. I choose tools based on the goal, not the other way round—so results make sense to your team and your business.
Technologies I use
Proven tools for fast, reliable and readable work with data.
Power BI
A leading reporting and visualization tool. DAX and Power Query (M) let me build fast, readable and maintainable reports as well as more complex data models.
Use: Reporting, visualization
SQL (MS SQL, MySQL/MariaDB, PostgreSQL)
The core of every good solution. Data modelling, cleaning, query optimization and preparing the groundwork for reporting and analytics across different databases.
Use: Data models, queries
Keboola
Modern ELT/ETL platform with many connectors and simple orchestration. Reliable collection, transformation and versioning of data across sources.
Use: ELT/ETL, orchestration
Other Microsoft technologies (SSAS, SSIS)
SSAS for tabular/OLAP models and cubes; SSIS for robust integrations and data flows in the Microsoft SQL Server ecosystem.
Use: Data models, integrations
dbt
Transformations as code. Clean SQL, tests, documentation and versioning in one—ideal for transparent, scalable data models.
Use: Transformations, tests
Airbyte
Open‑source data ingestion platform with dozens of connectors. Reliable loading (including incremental) from cloud services and databases.
Use: Ingest, connectors
Mage.ai
Orchestration and data pipelines "notebooks‑first". Rapid prototyping and production scheduling of jobs in one place.
Use: Orchestration, pipelines
Online platforms (Google Analytics, Ads, Sklik, …)
Marketing and web data via official APIs and connectors. I unify metrics and dimensions so comparisons and attribution make sense.
Use: Marketing data sources
E‑commerce platforms (Shoptet, Shopsys, Oxyshop, PrestaShop, …)
Connections to orders, products, stock and customers. I convert e‑commerce data into a model that supports commercial management and margin.
Use: E‑commerce data
Accounting & other systems (Pohoda, Abra, Pamica, Giriton, Retino, …)
Import of accounting, payroll, attendance and returns. I link back‑office with sales/marketing to keep the view of company performance complete.
Use: Back‑office data
Let's talk about your data
Looking for clear reporting, better decisions or data integration? Get in touch and together we'll design a solution that makes sense for your business.
Contact me