Years Experience
5+
BI & data roles
ERP Systems
10+
integrated
Business Areas
7+
data warehouse scope
Degrees
3
MSc · BSc · AP
HK
Hoang Khoa
BI Analyst · BI Consultant · Freelancer
I build end-to-end Business Intelligence solutions — from raw data ingestion and warehouse design to semantic models and Power BI reports that turn complexity into clarity.
Data Warehousing
Power BI
DAX
Databricks
Azure
SQL
Finance Reporting
Copenhagen, DK
Domain Expertise
| Domain | Coverage | Level |
|---|---|---|
| Finance Reporting | Expert | |
| Sales BI | Advanced | |
| HR Analytics | Advanced | |
| Data Governance | Expert | |
| Ticketing Systems | Proficient |
Work History
Timeline-
▶Business Analyst – Finance Data & InsightsFalckJul 2024 – PresentImplementing the new Group Finance Data Warehouse integrating data from 10+ ERP systems across 5+ business units. Responsible for data maintenance & governance, financial data analysis & visualization, and collaborating with FP&A partners and finance officers to generate actionable insights.
-
◆Business Intelligence ConsultantJUNU.IOJan 2022 – Jun 2024Delivered end-to-end BI consulting across Sales, HR, Finance and Ticketing domains. Addressed data consistency and governance challenges, built data warehouses, and integrated multiple business systems via REST APIs.
-
◆Student Assistant – Digital Solutions & Product ManagementEPOS AudioJul 2020 – Jun 2021Tracked market trends, produced market analysis reports, managed product scheduling and documentation, generated customer data reports.
-
◆Frontend DeveloperDigitalization Dept. – CBSJul 2020 – Aug 2021Restarted a PHP web project (selfsurvey.org) on hold since 2013 — migrated from PHP 4 to PHP 7, redesigned the front page and dashboard, and implemented new features.
Education
AcademicMSc
Information Studies
Aalborg University (AAU)
Sep 2019 – Jun 2021
BSc Top-Up
Web Development
ZIBAT
Sep 2017 – Jan 2019
AP Degree
IT Networking
KEA – Copenhagen
Feb 2015 – Jan 2017
Primary Tool
Power BI
DAX · Power Query
Cloud Platform
Azure
ADF · Azure SQL
Query Language
SQL
SSMS · T-SQL
Automation
PA
Power Automate
BI & Analytics
Power BI95%
DAX90%
Power Query / M90%
Qlik Sense72%
Excel70%
Data Engineering & Cloud
SQL / T-SQL / SSMS90%
Azure Data Factory82%
Azure SQL / Databricks90%
Power Automate70%
REST API Integration75%
Technology Stack
📊
Power BI☁️
Azure🗄️
SQL Server⚙️
Azure Data Factory🔁
Power Automate📐
DAX🔗
HubSpot📦
Dynamics 365 BC📈
Qlik Sense🌐
REST APIs🕸️
Timelog📋
ExcelFreelance Services
What I OfferPower BI Report Development
End-to-end report and dashboard design — from data model to final visuals. Interactive, cross-filtered, mobile-ready reports tailored to your business needs.
Data Warehouse Architecture
Design and build scalable data warehouses on Azure SQL, including star/snowflake schemas, staging layers, and dimensional modeling (Kimball methodology).
Data Integration & ETL/ELT
Connect your ERP, CRM, HR, and other systems using Azure Data Factory, Power Automate, and REST APIs. Automate pipelines that keep your data fresh.
Semantic Model & DAX
Build well-structured Power BI semantic models with clean DAX measures, calculated columns, and row-level security for reliable self-service analytics.
Finance Reporting & FP&A
Deliver P&L, balance sheet, cash flow, and budget-vs-actual reports. Bridge the gap between finance teams and data systems with trusted numbers.
BI Consulting & Governance
Audit your existing BI landscape, improve data quality, define governance standards, and train business users to work confidently with data.
Typical Engagement Flow
🔍
Discovery
Understand your data sources, reporting needs and pain points
🏗️
Architecture
Design the data model, pipelines, and report structure
⚙️
Build
ETL pipelines, semantic model, DAX measures and reports
✅
Validate
UAT with business stakeholders, data reconciliation
🚀
Deploy & Support
Go live, documentation, knowledge transfer
Engagement Type
Remote & On-site (Copenhagen)
Rate
Available on request
Availability
Open to new projects
Languages
English · Danish · Vietnamese
Get In Touch
ContactWhether you need a Power BI solution, a data warehouse built from scratch, or just want to talk through a challenge — I'm happy to connect. Based in Copenhagen, available for remote and on-site engagements.
Email
Phone
LinkedIn
Location
Copenhagen, Denmark