How to Create Custom Enterprise Insights Dashboards Using IMDB Database Tables
Overview
Enterprise Insights dashboards provide valuable visibility into user activity, dashboard performance, query execution, embedded analytics usage, and AI-powered interactions within Bold BI. Administrators and users with the appropriate permissions can also create their own custom Enterprise Insights dashboards using the corresponding tables available in the IMDB database of a site.
This article explains the available Enterprise Insights dashboards and the database tables that can be used to create or customize these dashboards.
Available Enterprise Insights Dashboards
Users can create custom dashboards based on the following Enterprise Insights categories:
- Dashboard Usage Analytics
- Performance Monitoring Dashboard
- Query Performance Tracking Dashboard
- Embedded Analytics Dashboard
- AI-Powered Dashboard Usage Insights
1. Dashboard Usage Analytics
The Dashboard Usage Analytics dashboard helps administrators understand how users interact with dashboards by tracking activities such as dashboard views, edits, permissions, comments, and scheduling operations.
Utilize the following database tables to create a custom Dashboard Usage Analytics dashboard:
Required Tables
BOLDBI_Item
BOLDBI_ItemType
BOLDBI_ItemLog
BOLDBI_ItemLogType
BOLDBI_User
BOLDBI_Source
BOLDBI_ScheduleLog
BOLDBI_ScheduleDetails
BOLDBI_ScheduleStatus
BOLDBI_UserPermission
BOLDBI_UserPermissionLog
BOLDBI_PermissionLogType
BOLDBI_PermissionEntity
BOLDBI_Group
BOLDBI_GroupPermission
BOLDBI_GroupPermissionLog
BOLDBI_Comment
BOLDBI_ItemCommentLog
BOLDBI_ItemCommentLogTypeUse Cases
- Dashboard view statistics
- Most frequently accessed dashboards
- User activity monitoring
- Permission change tracking
- Dashboard comment analysis
- Scheduled report execution tracking
2. Performance Monitoring Dashboard
The Performance Monitoring Dashboard allows administrators to monitor dashboard performance and identify dashboards that may be causing performance bottlenecks.
Utilize the following database tables to create a custom Performance Monitoring dashboard:
Required Tables
BOLDTC_QueryMetrics
BOLDTC_TenantInfo
BOLDTC_TenantUse Cases
- Dashboard load time analysis
- Resource consumption monitoring
- Dashboard performance comparison
3. Query Performance Tracking Dashboard
The Query Performance Tracking Dashboard helps monitor the performance of queries executed within the application. This information can be used to identify slow-running queries and optimize overall system performance.
Utilize the following database tables to create a custom Query Performance Tracking dashboard:
Required Tables
BOLDTC_QueryMetrics
BOLDTC_TenantInfo
BOLDTC_TenantUse Cases
- Query execution time monitoring
- Slow query identification
- Query frequency analysis
- Performance trend reporting
4. Embedded Analytics Dashboard
The Embedded Analytics Dashboard is designed to track and analyze user activity related to embedded dashboards, including dashboard views and user engagement.
Utilize the following database tables to create a custom Embedded Analytics dashboard:
Required Tables
BOLDBI_Item
BOLDBI_ItemType
BOLDBI_ItemLog
BOLDBI_ItemLogType
BOLDBI_Source
BOLDBI_User
BOLDBI_ScheduleLog
BOLDBI_ScheduleStatus
BOLDBI_ScheduleDetailsUse Cases
- Embedded dashboard usage tracking
- User engagement analysis
- Dashboard view trends
- Scheduled embedded report monitoring
5. AI-Powered Dashboard Usage Insights
The AI-Powered Dashboard Usage Insights dashboard leverages AI interaction data to monitor and analyze how users engage with AI-powered dashboard features. This dashboard can help identify usage patterns, improve user adoption, and optimize AI-assisted experiences.
Utilize the following database tables to create a custom AI-Powered Dashboard Usage Insights dashboard:
Required Tables
BOLDBI_AI_SESSIONS
BOLDBI_AI_CHAT
BOLDBI_AI_REQUESTSUse Cases
- AI feature adoption analysis
- Chat interaction monitoring
- AI request volume tracking
- AI usage trend analysis
- User engagement insights
Bold BI provides powerful self-service analytics capabilities that allow administrators and authorized users to create custom Enterprise Insights dashboards. By utilizing the appropriate IMDb database tables, users can build dashboards that track dashboard usage, system performance, query execution, embedded analytics activity, and AI-driven interactions according to their organization's specific reporting requirements.
Additional References
