Data & Analytics Consultant
Jonas Hertz
Business understanding, data engineering and analytics delivery.
I work across the full analytics chain, from business requirements and data modelling to data engineering, semantic models and reporting.
I use this site to write about data platforms, analytics engineering and things I learn while building real solutions.
Latest Articles
Practical notes and opinions on data engineering, analytics platforms and BI.
-
Guide to Transferring Power BI Tables to Fabric Data Warehouse
Have you ever had data in a Power BI file locally or in the service that you wish could be exported easily? Microsoft have released a Python Library…
-
Load API Data into Fabric Lakehouse using Pipeline: A Step By Step Guide
Calling a web API and saving the result for further analysis is a common scenario for Data Engineers. Microsoft Fabric brings together many capabilities into a unified platform…
-
Load API Data into Fabric Lakehouse using Notebook: A Step By Step Guide
Calling a web API and saving the result for further analysis is a common scenario for Data Engineers. Microsoft Fabric brings together many capabilities into a unified platform…
Projects
Things I am building, testing or writing about.
Nyckelklart
A data service for Swedish businesses using Fortnox. It turns financial data into a curated dataset ready to use in Excel and Power BI.
Visit NyckelklartTechnical writing & experiments
Experiments with Microsoft Fabric, Databricks, DuckDB, Python, SQL and AI-assisted development. Some become useful tools; others become articles.
Browse the articlesAbout
I am a Senior Analytics Engineer and Data & Analytics Consultant based in Malmö.
I have worked with BI and analytics since 2012. My work usually sits somewhere between the business problem and the technical implementation: understanding what people need from the data, modelling it properly, and building the pipelines, semantic models and reports needed to use it.
What I do
- Turn business questions into reports, KPIs and analytical solutions.
- Design dimensional models, semantic models and reusable datasets.
- Build and improve data pipelines and transformations.
- Develop Power BI applications and optimise DAX, models and report performance.
- Work directly with both business users and technical teams.
Tools & platforms
Analytics: Power BI, DAX, Qlik Sense, QlikView and Excel.
Engineering: SQL, Python, PySpark, ETL/ELT, dimensional modelling and semantic modelling.
Platforms: Microsoft Fabric, Databricks, DuckDB, Azure Synapse, Azure SQL and Google BigQuery.
Selected Experience
A few examples of the work I have done over the years.
Jonas Hertz AB
Independent consulting across Power BI, Qlik, SQL, Python, Databricks and Azure. Recent work includes a new Power BI application and semantic model with Databricks transformations for Asker Healthcare Group.
IKEA INGKA Procurement
Worked between business and technical teams on BI migration, support and delivery. Helped move an Excel-based ETL and reporting setup into a Google BigQuery data mart with a redesigned Power BI application.
Stratiteq
Worked with requirements, data modelling, ETL, platform setup and reporting across Microsoft and Qlik technologies. Assignments included Øresund Bridge, Vattenfall Wind, Skånetrafiken and several retail companies.
Background & education
Earlier roles include BI and management consulting at Vimur and automation engineering at IT Automation. I hold an MSc in Industrial Engineering from Lund University and speak Swedish and English.
Connect with me
LinkedIn is the best place to reach me about data and analytics, my articles or Nyckelklart.