dataroa

Reliable analytics systems that scale

Independent consultant specializing in Power BI semantic modeling, CI/CD for analytics, and platform architecture.

[ CORE EXPERTISE ]

Semantic modeling & BI

Power BI, Tabular, DAX optimization, performance profiling.

  • Reduce model load times with partitioning and aggregation tuning.
  • Align business definitions through consistent semantic layers.
  • Optimize DAX for responsive, reliable executive dashboards.

BI platform architecture

Structure, security, and governance.

  • Workspace layouts and ownership boundaries.
  • Access control with RLS, roles, and groups.
  • Shared models and dataset/report responsibilities.

DevOps

CI/CD, governance, automated quality gates.

  • Ship data products with automated validation and approvals.
  • Build release pipelines and workspace lifecycle automation for Power BI assets.
  • Codify governance, access controls, and audit trails.

Platform automation

Automation to reduce manual Power BI platform work.

  • Build internal tools to eliminate repetitive admin tasks.
  • Perform bulk export/import and consistency checks across workspaces.
  • Automate permissions and role changes via Power BI and Fabric APIs.

[ work ]

End-to-End Analytics Data Pipeline

View →

End-to-end analytics pipeline from external APIs to Power BI semantic models and reports.

Enterprise Semantic Model Re-Architecture

View →

Re-architected Power BI semantic models to improve performance, reuse, and refresh efficiency.

Ephemeral Workspace Deployment Architecture

View →

Production-only Power BI architecture using ephemeral workspaces and Git-driven deployments.

CI/CD for Power BI

View →

Automated deployments, regression tests, and approvals for Tabular models and Power BI reports.

[ tech stack ]

Work / Professional

Platforms Microsoft Fabric · Databricks · Snowflake
Analytics Modeling Power BI · Tabular Editor
Ingestion & Orchestration Azure Data Factory · Airflow
Transformations dbt · Python (Polars)
DevOps & Automation GitHub Actions · Azure DevOps · APIs

Home lab / Personal

Infrastructure Linux · Proxmox · OPNsense · OpenWrt
Containers & Runtime Docker · Docker Compose
Networking & Edge Caddy · Tailscale · WireGuard
Datastores PostgreSQL · MySQL · InfluxDB · DuckDB
Automation & IaC Ansible · Terraform · Dagster