Skip to content

Releases: tabrez-source/NovaTrade-Sales-Inventory-Analytics

Release list

NovaTrade v1.0.0

Choose a tag to compare

@tabrez-source tabrez-source released this 09 Aug 09:34
cb85933

NovaTrade v1.0.0

First portfolio release of the validated NovaTrade Sales & Inventory Analytics platform. All business data and identities are synthetic.

Highlights

  • End-to-end synthetic data platform from Python generation through SQL Server staging, OLTP, dimensional warehouse, and Power BI.
  • Five decision-focused report pages: Executive Overview, Sales Performance, Product Performance, Inventory Operations, and Management Insights.
  • Two-fact star schema with 11 active single-direction relationships and 81 centralized DAX measures.
  • Four hidden governance/security pages plus a hidden UI template.
  • Dynamic branch-level RLS with global and regional scopes and fail-closed unexpected identities.
  • Automated PBIP, page, governance, RLS, accessibility, and repository-package validation in GitHub Actions.
  • Portfolio-ready documentation, diagrams, data/model/KPI definitions, operating guide, and case study.
  • Seven approved final-state screenshots covering the five public pages, model overview, and Mumbai-only RLS evidence.

Validation summary

  • 10 serialized report pages and 527 visuals pass the PBIP repository gate.
  • Five analytical page checkpoints pass with zero issues.
  • Governance checks cover six reconciliation tests, 18 validation measures, and 11 relationships.
  • RLS checks cover six synthetic grants and global/regional/unknown/inactive behavior.
  • Accessibility checks report no missing alt text, duplicate tab orders, or out-of-canvas data/interactive visuals in the governed pages.

Important limitations

  • All data is synthetic.
  • Net Stock Flow is not Stock on Hand.
  • The current movement fact contains no transfer rows.
  • Profitability, targets, forecast, lead time, and service levels are not modeled.
  • Dynamic RLS was manually tested in Desktop; multi-account dynamic Service assignment was not tested.
  • Automated Power BI Service deployment and production refresh monitoring are not included.

Release verification