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
| Job Name | Status | Enabled | Last Run | Actions |
|---|---|---|---|---|
| Loading... | ||||
| Job Name | Server | Active | Database | Schedule | Command | Last Run | Last Status | Next Run |
|---|---|---|---|---|---|---|---|---|
| Loading... | ||||||||
Job execution Gantt chart — SQL Agent + Task Scheduler (today)
Loading...
Real-time server performance monitoring — Auto-refresh: 30s
Loading SQL Server health...
Loading Linux server health...
Loading BI-on-Premise health...
| SPID | Query | Duration | CPU | DB | Status |
|---|---|---|---|---|---|
| Loading... | |||||
Loading...
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 |
Browse, search, and inspect stored procedures across DWH SQL Servers
| Name | Schema | Database | Server | Modified |
|---|---|---|---|---|
| Loading procedures... | ||||
Choose a stored procedure from the list to see its definition, parameters, and dependencies.
Row-Level Security roles, filters, and member assignments
| Role Name | Dataset | Workspace | Tables Filtered | Filter Expression |
|---|---|---|---|---|
| Loading... | ||||
| User | Workspaces | Total Reports | |||
|---|---|---|---|---|---|
| Click "User View" tab to load | |||||
| Report | Workspace | User | Workspace Role | |
|---|---|---|---|---|
| Click "Report View" tab to load | ||||
Dataset refresh status, schedule, duration trends & failure analysis
| Dataset | Workspace | Status | Start Time | End Time | Type | Error | Actions |
|---|---|---|---|---|---|---|---|
| Loading... | |||||||
Dataset refresh schedule matrix — hours vs datasets
Note: The hour reflected are datasets that refreshed today and it will be replaced if there is a manual refresh request (shows last refresh time per dataset)
Loading timetable...
Report views, active users, peak hours & unused assets
Loading...
Loading...
Reports from PBI catalog with zero views in the selected period
Loading...
Active alerts, history, and notification configuration
Loading...
| Alert | Category | Severity | Created | Resolved | Resolved By |
|---|---|---|---|---|---|
| No resolved alerts | |||||
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 |
|---|---|---|---|---|---|
| Loading... | |||||
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 | Projects | PIC BI | SLA Score |
|---|---|---|---|---|---|---|---|
| Loading business units... | |||||||
Track ETL & BI delivery projects through the 6-stage pipeline
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 notifications
Manage who receives email alerts when failures are detected
Loading...
Background alert checker runs every 5 minutes. Emails sent automatically for new failures.