Oracle ATP Visual Analytics Showcase

Building Charts & Dashboards with Autonomous AI Transaction Processing(ATP)

As part of our recent Oracle technology exploration, we decided to spend some hands-on time with (ATP).

While ATP is often viewed primarily as a cloud database for transactional workloads, we discovered that it can also serve as an excellent foundation for rapid analytics, visualisations & operational dashboards.

Why We Chose Oracle ATP

Many organisations use ATP as a backend database but rarely explore its built-in analytical capabilities. Our objective was simple:

• Create sample business tables
• Populate realistic operational data
• Build analytical SQL queries
• Generate charts and dashboards
• Evaluate ATP for quick business insights The results were surprisingly impressive.

Query Sample Business Tables

For our proof of concept, we created a simple sales analytics model.

SQL Queries for Quick Insights
Revenue by Product Category

Sample Chart

1. Click on Charts as below

2.As follwed Enter respective names to your charts , Oops Oracle provided the auto refresh for us!!

3.Chart Definition , Here you write your visual query & define X & Y Labels ,
Try various charts 3D also available

I prepared another chart 😁

We could bring two charts into one Dashboard

Create Dashboard as below marked

Add the charts to layout

Successfully we Created Our chart & Dashboard in ATP