SaaS Product & Support Analytics Platform (NimbusSoft)
Enterprise-style analytics architecture designed for executive, product, and support leadership —
built using dimensional modeling, advanced DAX, and secure deployment patterns.
Business Objective: Provide executive visibility into support health, customer adoption, and SLA performance to prioritize action.
Model Design: Two fact tables (Tickets, Usage) with conformed dimensions and role-playing date tables to ensure consistent metrics.
Deployment Pattern: Dev → Test → Prod pipelines with dynamic RLS via Entra ID security groups and role-based app audiences.
- 2 Fact Tables
- Conformed Dimensions
- Role-playing Dates
- Rolling Windows + Risk Score
- 3 App Audiences
- Gateway + Cloud Hybrid
Live Interactive Demo
Public demo note: This embedded report is a showcase build intended for portfolio viewing.
Enterprise features such as dynamic RLS, audience segmentation, and secure workspace deployment
are implemented in the production configuration and documented in the repository.
Architecture & Modeling
- Star schema with conformed dimensions across Product, Support, and Customer views
- Role-playing date tables to support consistent time intelligence and SLA/adoption trending
- Measure catalog with defensive DAX patterns (safe division, blanks handling, filter-safe logic)
- Rolling windows and risk scoring logic to highlight customers needing attention
Security & Deployment
- Dynamic Row-Level Security (Entra ID security groups; security bridge pattern)
- Dev → Test → Prod deployment pipelines (promotion discipline, environment separation)
- On-Premises Data Gateway configuration (hybrid connectivity: PostgreSQL + file sources)
- App-based audience segmentation to tailor consumption for Exec, CSM, and Support