Use FDI usage tracking data to monitor adoption, analyze performance, and prioritize optimization opportunities. This blog provides a downloadable Performance Insights workbook that you can deploy in your instance.
Key Questions This Workbook Answers
This workbook answers questions such as:
- Which workbooks are performing below expectations?
- Where is the workbook slow — at the workbook, canvas, or execution level?
- Which workbooks or canvases should be optimized first?
- Which users or usage patterns are contributing to the highest workload?
- Are performance issues occasional, recurring, or trending worse over time?
By bringing adoption, usage, and performance metrics together, the workbook helps teams move from observation to action and make more informed optimization decisions.
Download the .dva file below and refer to the Instructions canvas for deployment steps.
Introduction
In many Oracle Analytics and FDI implementations, performance conversations often start with the concern:
“This workbook is slow.”
But addressing that concern is not always straightforward. Which canvas is causing the delay? How many users are impacted? Is the issue recurring? Most importantly, what should be optimized first?
A rarely used canvas that takes 30 seconds to load may not be the top priority, while a heavily used canvas with moderate slowness can have a much greater impact.
The Common – Usage Tracking subject area delivered with FDI captures valuable information about workbook usage, canvas activity, query execution, user behavior, and performance. However, while the data is available, turning it into clear optimization decisions can still be challenging.
To address this, we created a curated dataset using Usage Tracking data and built a Performance Insights workbook on top of it. The workbook brings usage, performance, and impact metrics together to help administrators, developers, and content owners identify high-impact optimization opportunities and prioritize improvements where they matter most.
Investigation Workflow
A typical analysis starts with the Performance Summary canvas to identify heavily used or potentially underperforming content.
From there, drill into canvas-level details, review user activity patterns, analyze historical performance trends, and investigate execution-level details for root cause analysis.
This workflow helps you move efficiently from high-level performance observations to focused optimization actions.
Key Capabilities
Instructions Page : Includes metric definitions, page descriptions, and deployment guidance.
Performance Summary : Shows workbook adoption, canvas activity, execution performance, and optimization priorities.
Canvas Performance Detail: Shows canvas-level usage and performance for deeper investigation.
User Activity Analysis : Highlights usage patterns, workload distribution, and user activity across workbooks and canvases.
Performance Trend Monitoring: Tracks performance trends, workload changes, and recurring performance issues.
Execution-Level Diagnostics: Provides execution-level details for root cause analysis.
Looking for Feedback
Usage Tracking provides a strong foundation for understanding how analytical content is being used and how it performs over time. With the Performance Insights workbook, our goal is to bring usage, performance, and impact metrics together into a single analytical experience that supports adoption monitoring, performance analysis, and optimization prioritization.
We are interested in hearing how others approach usage and performance monitoring within Oracle Analytics and FDI environments.
- What metrics do you find most valuable?
- How do you prioritize optimization opportunities?
- Are there additional views or analyses that would be useful?
We look forward to hearing your feedback and suggestions.
