J&D Report With CI/CD

This project applies Power BI CI/CD best practices with Azure DevOps and Microsoft Fabric, focusing on:

Enabling dynamic, user-driven metric selection through Power BI parameters for instantly updated, context-relevant dashboards.
Delivering a clear, actionable dashboard that highlights current performance, trends versus the previous month, and progress against targets.
Showcasing top-performing customers by segment and enabling rapid identification of anomalous customer behavior.

Check the whole report in Power BI service here.

Power BI CI/CD Architecture

Validation Pipeline: Automatically runs on each commit to the dev branch. Checks that datasets and reports follow best practices, verifies figures and measure accuracy, and applies a wide range of validation rules (such as reviewing data model relationships or flagging report pages with too many visuals). Ensures all requirements are met before allowing pull requests to the main branch.
Release Pipeline: Automatically deploy changes that pass validation to different deployment stage, each deployment stage has its own workspace, reducing the risk of unintended changes and supporting robust testing before production rollout.
Approval Process: Release managers review and approve deployments to production, ensuring oversight and compliance before changes go live.

For more information of the dataset rule and report rule, please visit GitHub here.

Hidden Slicers: Keep slicers out of view to create a cleaner, less cluttered report page.
KPI Tracking: Effortlessly monitor key performance indicators over different time periods.
Drill-Through Enabled: Quickly access detailed data by drilling through visualizations for in-depth analysis.

KPIs Selection: easily select kpis you want to follow, customer view or revenue per customer view.
Top Customer Analysis: easily analyse customer per customer segament.
No Purchase Customer Analysis: Identify and analyze customers who have not made a purchase to uncover potential opportunities and improve engagement strategies.

View the full interactive report in Power BI Service here.