Augustine Ansu

Senior Power BI Architect & Data Analyst
Product, Operations & Executive Analytics

Power BI Service Dev/Test/Prod pipelines Entra ID dynamic Row-Level Security Semantic Modeling star schema & governance

About

I design production-grade analytics solutions that help leadership teams understand performance, identify risk, and take action. My work emphasizes strong semantic modeling, governance, and executive-focused storytelling.

Featured Project

Power BI • SaaS Analytics • Executive Decision Support

SaaS Product & Support Analytics Platform (NimbusSoft)

End-to-end enterprise analytics architecture — from semantic modeling to production deployment.

A production-style analytics platform designed for a fictional SaaS company (NimbusSoft), reflecting patterns and approaches used in real SaaS analytics environments.

New: Deployed to Power BI Service using Dev → Test → Prod pipelines, on-premises gateway connectivity (PostgreSQL + file sources), and dynamic RLS using Entra ID security groups, with role-based App audience segmentation (Exec, CSM, Support, Product).

  • Star schema semantic model
  • Conformed dimensions
  • Role-playing dates
  • Measure catalog
  • Rolling windows
  • Risk scoring
  • Performance Analyzer
  • Power Query Diagnostics
  • Dev/Test/Prod pipelines
  • Entra ID dynamic RLS
  • On-prem gateway
  • App audiences

Skills & Focus Areas

Next Projects

Additional portfolio projects in healthcare and finance are planned. This site will be updated as new work is published.