BI & DWH Management System
Real-time pipeline status & trigger
CPU, RAM, Disk, Query monitor
DAX, RLS, Refresh, Usage
Multi-channel notifications
Sign in to BDMS Dashboard
Authenticate using your Lippo Karawaci AD account
System overview — Last updated: --
Monitor all ETL/ELT pipelines across data sources
| Pipeline Name | Source | Target | Status | Last Run | Duration | Next Run | Actions |
|---|---|---|---|---|---|---|---|
| ETL_DIM_Customer | Sphinx (SQL) | DWH_RE | ● Success | 06:00 WIB | 2m 34s | Tomorrow 06:00 | |
| ETL_FACT_Sales_Daily | Sphinx (SQL) | DWH_RE | ● Failed | 06:15 WIB | 5m 12s | — | |
| ELT_STG_Inventory | DB_Maxx (PG) | DWH_MPPA | ● Success | 07:00 WIB | 8m 45s | Tomorrow 07:00 | |
| API_Booking_Sync | Booking API | DWH_RE | ● Running | 08:30 WIB | 3m 22s... | — | |
| ETL_DIM_Property | SharePoint | DWH_RE | ● Success | 06:30 WIB | 1m 15s | Tomorrow 06:30 | |
| CSV_Import_Finance | Flat File (CSV) | STG_Finance | ● Queued | — | — | 09:00 WIB |
Real-time server performance monitoring — Auto-refresh: 30s
| SPID | Query (truncated) | Duration | CPU | Status |
|---|---|---|---|---|
| 87 | SELECT TOP 1000 FROM fact_sales... | 2.3s | 120ms | Running |
| 112 | MERGE INTO dim_customer USING... | 45.1s | 8.2s | Blocking |
| 143 | INSERT INTO stg_booking_raw... | 12.5s | 3.1s | Waiting |
Monitor data completeness, accuracy, and timeliness
| Table | Rule | Score | Records Affected | Severity |
|---|---|---|---|---|
| fact_sales | Null check: customer_id | 97.2% | 1,240 / 44,500 | Medium |
| dim_property | Timeliness: last update > 24h | 85.0% | — | High |
| stg_booking | Duplicate check: booking_id | 99.8% | 12 / 6,300 | Low |
Browse all Power BI datasets, tables, columns & relationships
Loading...
Browse and search all DAX measures across datasets
| Measure | Table | Dataset | Workspace |
|---|---|---|---|
| Total Revenue | _Measures | ds_realEstate | |
| Total Revenue YoY% | _Measures | ds_realEstate | |
| Net Revenue MTD | _Measures | ds_realEstate | |
| EBITDA Margin | _Measures | ds_realEstate | |
| Booking GDV | _Measures | ds_realEstate | |
| Collection Rate | _Measures | ds_realEstate |
Row-Level Security roles, filters, and member assignments
| Role Name | Dataset | Workspace | Tables Filtered | Filter Expression |
|---|---|---|---|---|
| RLS_Meikarta | dim_project, fact_sales | 12 users | [project_group] = "Meikarta" | Active |
| RLS_HollandVillage | dim_project, fact_sales | 8 users | [project_group] = "Holland Village" | Active |
| RLS_Corporate | dim_bu | 5 users | [bu_level] = "Corporate" | Active |
| RLS_Region_West | dim_region | 15 users | [region] = "West Java" | Active |
Dataset refresh status, schedule, duration trends & failure analysis
| Dataset | Date/Time | Status | Duration | Type | Records | Error |
|---|---|---|---|---|---|---|
| ds_realEstate_dwh_prod | 31 Mar 06:00 | ● Success | 12m 34s | Scheduled | 2.4M rows | — |
| ds_retail_mppa | 31 Mar 06:00 | ● Failed | 5m 12s | Scheduled | — | Gateway timeout |
| ds_fpa_corporate | 31 Mar 07:00 | ● Success | 3m 45s | Scheduled | 450K rows | — |
| ds_realEstate_dwh_prod | 30 Mar 06:00 | ● Success | 11m 58s | Scheduled | 2.3M rows | — |
| ds_retail_mppa | 30 Mar 06:00 | ● Success | 8m 22s | Scheduled | 1.8M rows | — |
Report views, active users, peak hours & unused assets
Active alerts, history, and notification configuration
Track, resolve, and analyze incidents
Connection timeout — recurring issue
ds_retail_mppa refresh fails since 30 Mar
Need to archive old staging tables
MERGE operation blocking other queries
Fixed ETL mapping, backfilled data
Meikarta role showing all projects
ISP issue, resolved with provider
Monitor job schedules, trigger re-runs, manage dependencies
| Job Name | Engine | Schedule | Last Status | Next Run | Actions |
|---|---|---|---|---|---|
| SQL Agent: DWH_ETL_Master | SQL Agent | Daily 05:00 | Success | 01 Apr 05:00 | |
| SQL Agent: DWH_Maintenance | SQL Agent | Weekly Sun 02:00 | Success | 06 Apr 02:00 | |
| Python: API_Sync_Booking | Task Scheduler | Hourly | Running | — | |
| PBI: Scheduled Refresh | Power BI Service | Daily 06:00, 12:00 | Partial Fail | 31 Mar 12:00 |
Track all system changes — who, when, what
Total Revenue in ds_realEstate — added USERELATIONSHIPRLS_Meikartacommission_rate to fact_sales (DECIMAL 5,2)Manage BU onboarding, service model & data scope
| Business Unit | Service Model | Status | Databases | PBI Datasets | PIC BI | SLA Score |
|---|---|---|---|---|---|---|
| Real Estate | Shared Service | Active | DWH_RE_LPKR | 3 | Ahmad | 96% |
| Retail / MPPA | Consultant | Active | DB_Maxx | 2 | Budi | 91% |
| Healthcare | Shared Service | Onboarding | — | 1 | Rina | 88% |
| Hospitality | Consultant | Onboarding | — | 0 | — | 78% |
| Education | Consultant | Planned | — | 0 | — | — |
Service Level Agreement tracking per Business Unit
| Date | BU | SLA Metric | Target | Actual | Root Cause |
|---|---|---|---|---|---|
| 31 Mar | Retail/MPPA | PBI Refresh | 98% | 50% | Gateway timeout |
| 28 Mar | Hospitality | Data Freshness | 99% | 72% | Source system downtime |
Storage, CPU, memory forecasting & upgrade recommendations
Data dictionary, SOPs, troubleshooting guides & documentation
Data Warehouse untuk Business Unit Real Estate. Berisi data operasional dari sistem booking, sales, collection, inventory, dan property management.
| Prefix | Category | Count | Example |
|---|---|---|---|
dim_ | Dimension | 15 | dim_customer, dim_property, dim_date |
fact_ | Fact | 12 | fact_sales, fact_collection, fact_booking |
stg_ | Staging | 18 | stg_booking_raw, stg_sales_daily |
Last updated: 28 Mar 2026 by Budi • Version 4.2
Manage users, roles, BU scope & AD integration
| Name | Role | BU Scope | Status | Last Login | Actions | |
|---|---|---|---|---|---|---|
| Loading... | ||||||
General configuration, API connections, and maintenance