Oracle Transactional Business Intelligence (OTBI) empowers organizations with powerful analytical tools to extract insights from their data. OTBI Graphical analysis offers a visual representation of data trends and patterns, aiding decision-making processes across various business functions. It enhances data interpretation by presenting complex information in intuitive visual formats, such as charts, graphs, and dashboards.
The beauty of OTBI lies in its simplicity and power. You get real-time insights, the ability to customize reports, and the flexibility to create visually compelling graphics without needing a deep technical background.
Creating Graphical Reports in OTBI
Before diving into graphical analysis, ensure you have the necessary permissions and access to OTBI within your Oracle Cloud environment and for this, you’ll need a user account with roles that allow you to create and view reports.
Create Tabular Analysis
Create analysis as it is already explain in post.
Choose Subject Area
We will choose again Payables Invoices – Transactions Real Time subject area as we did in previous post.
Select Columns and Configure Filters
We will include supplier and invoice amount columns as we will display top 5 suppliers based on sum of invoice amounts. Click gear icon on invoice amount column as shown in step 1 and choose edit formula and then choose sum under aggregate functions in step 2. Add “BY” clause in Column Formula and select Supplier column as per steps 3 below.
On supplier column, click gear icon and select filter. Then choose filter type as per step 2 and specify value as in our case it should be top 5 suppliers.
Adding and Customizing the Graph
Go to results tab and choose create views as per step 2 below. Then choose graph and then Pie Graph per step 4.
Customization is key to making your graph both informative and visually appealing. Therefore, adjust the colors, labels, and formatting to ensure clarity and ease of understanding.
Conclusion
Creating graphical analysis in OTBI doesn’t have to be daunting. With the right approach and understanding, you can turn raw data into powerful insights that drive decision-making. Whether you’re just getting started or looking to refine your skills, OTBI’s robust features and user-friendly interface make it a valuable tool for any data-driven professional.