IntroducingPrism IQ

Next-Generation Reporting & Business Intelligence Suite

Built exclusively only for Retail Pro Prism

The reporting revolution retail leaders have been waiting for. PrismIQ converts your Retail Pro Prism database into a live command center arming your leadership team with the real-time intelligence needed to outpace the competition.

v9Native Support
10mDeploy Time
100+Built-in Assets
12c+Oracle Support

Platform Support

Built for Both Retail Pro Platforms

v9

Retail Pro v9

Legacy · CMS Schema

+
2.5

Retail Pro Prism 2.5

Modern · RPS Schema

What is PrismIQ?

A Purpose-Built Intelligence Platform for Retail Pro Prism.

PrismIQ is an advanced reporting and analytics platform built exclusively for Retail Pro Prism environments. It sits directly on top of your existing database and transforms raw retail data into clear, actionable intelligence through a rich, browser-based interface that requires no SQL knowledge, no external BI tools, and no technical expertise from your team. From real-time KPI dashboards to scheduled report delivery, PrismIQ gives every user in your organization exactly the data they need, exactly when they need it all governed by enterprise-grade security and role-based access control.

PrismIQ handles the entire reporting lifecycle so your team never has to leave the platform. Business users can run, filter, and export reports with just a few clicks, while administrators can build complex, SQL-backed reports and widgets through a guided interface that requires no coding. Every user gets a fully personalized dashboard populated with live widgets, tailored to their role and data access. When a report is ready, it can be exported as a formatted Excel file, a branded PDF, or a clean CSV or scheduled to land automatically in someone's inbox. Every action, every query, every export is logged, permissioned, and traceable. PrismIQ doesn't just surface your data it puts the right data in front of the right people, in the right format, at the right time.

What PrismIQ Does

Everything From First Query to Final Report, Handled.

What Modules It Has

Ten Modules. One Integrated Platform.

Dashboard
Report Viewer
Report Builder
Widget Builder
Scheduler
Security & Permissions
User Management
Audit Logs
Settings
Alerts
Live Dashboards

A Workspace That Belongs to You.

No two users see the same dashboard. Every workspace is personal, persistent, and fully in your control.

prismiq.in
Prism IQ
+ Widget
JD
Overview
Sales
Inventory

Today's Sales

AED 24,891

+12.4%

Transactions

847

+5.2%

Units Sold

2,341

-2.1%

Avg Basket

AED 29.40

+7.8%

Revenue Trend · 12 Months

This Year ▾

Multi-Tab Workspace

Five tabs pre-configured Overview, Sales, Inventory, Finance, and one that's yours. Create unlimited additional tabs anytime.

Drag, Resize, Rearrange

Every widget is independently movable and resizable. Build your layout once it stays exactly that way every time you log in.

Always Live, Always Current

Widgets refresh automatically on their configured interval. Your dashboard reflects right now not what happened an hour ago.

Fully Yours, Fully Personal

Every user gets their own independent dashboard. Your layout, your widgets, your tabs saved to your account and waiting exactly as you left them.

Widgets

Six Widget Types. Infinite possibilities.

Today's Sales
AED 48,291
Daily Sales

Stat Widgets

KPIs that speak for themselves.

  • Sales, transactions, returns, margins
  • Configurable format currency, number, %
  • Trend delta vs previous period
Net Revenue
AED 124.5k
+12.4% vs Last Month

Scorecard Widgets

KPIs with period-over-period context.

  • Current value vs prior period
  • Trend arrow with % change
  • Configurable comparison label
Daily Sales Target

Daily Sales

AED 38.2k
Daily GoalAED 50k
76.4% · On Track
AED 11.8k to go

Progress Widgets

Track targets. Stay on pace.

  • KPI vs daily or monthly goal
  • Fixed target or live SQL query
  • % achieved with visual progress bar
Sales by Category
TodayMonthYear
Apparel
Shoes
Bags
Acc.
Jewelry
Home

Chart Widgets

8 chart types. All interactive.

  • Bar, Line, Area, Pie, Donut, Stacked & more
  • Date range filter: Today, This Month, Custom
  • Configurable refresh interval
Top Stores Today
TodayWeek
StoreSalesTxns
Dubai MallAED 4,291142
Abu DhabiAED 3,847118
JBR WalkAED 3,21097
Deira CityAED 2,89184

Table Widgets

Live tabular data, always current.

  • Sortable columns
  • Date range filter control
  • Auto-refresh on schedule
Sales by Hour × Day
8a
10a
12p
2p
4p
6p
8p
10p
Mon
Tue
Wed
Thu
Fri
Sat
Sun

Heatmap Widgets

Spot patterns at a glance.

  • Intensity grid e.g. sales by hour × day
  • Auto-formatted time axes
  • Color gradient highlights peaks and lows
Report Viewer

Three Ways to See. Infinite Ways to Think.

The most capable reporting interface ever built for Retail Pro Prism. One report, three perspectives all from the same screen.

prismiq.in/report-viewer
Prism IQ
▶ Run
Filters
CSV
PDF
Table
Chart
Pivot
Store ↕DeptNet Sales ↓Qty
Dubai MallApparelAED 4,291.00128
Abu Dhabi MallFootwearAED 3,847.5094
JBR WalkAccessoriesAED 2,103.20211
Festival CityApparelAED 5,672.80203
Deira CityKidsAED 1,891.6087
1–50 of 2,847
‹
1
2
…
›
Table View

Every row. Every detail. Perfectly sorted.

  • 1Drag-and-drop column reordering
  • 2Show / hide any column
  • 3Click-to-sort with Excel-like indicators
  • 4Pagination with record count in footer
Filter Panel

Precision Before Execution.

Date Range

Long Date Range

Lookup

Cascading Lookup

Numeric Range

Text

Report Filters2 active
01 Jan 2026 → 31 Mar 2026
3Dubai Mall, Abu Dhabi...
Search stores...
6 options
Select All·Clear
Dubai Mall
Abu Dhabi Mall
Festival City
JBR Walk
ClearDone
From1,000
To50,000
Clear all filters
Close
▶ Run Report
Smart Analytics

Go Deeper. Go Further.

Calculated Fields

Runtime formula engine (ƒx)

Add Computed Columns.
On the Fly.

Add any computed column to any report live, in-session, with an Excel-like syntax your team already knows. No database changes. No admin involved.

  • 1Excel-like expression syntax familiar to every analyst
  • 2Supports number and currency format types
  • 3Included automatically in CSV, Excel & PDF exports
  • 4Session-scoped no database changes, ever
ƒxFormula Editor
( [NET_SALES] - [COST_AMT] ) / [NET_SALES] * 100
Column Label: Gross Margin %Format: number
StoreNet SalesCostGross Margin %
Dubai MallAED 4,291AED 2,57339.8%
Festival CityAED 5,672AED 3,28942.0%
Abu DhabiAED 3,847AED 2,40137.6%
JBR WalkAED 2,103AED 1,38734.0%

ROWS

Store Code
drag field here

COLUMNS

Month
drag field here

VALUES

Net Sales (Sum)
drag field here
StoreJanFebMarTotal
Dubai MallAED 82,411AED 71,230AED 24,891AED 178,532
Festival CityAED 91,840AED 84,210AED 31,420AED 207,470
Abu DhabiAED 67,920AED 59,810AED 19,847AED 147,577
Pivot Table

Runtime cross-tab builder

Cross-Tab Intelligence,
Built In.

Drag fields into rows, columns, and values. Instantly. No pivot pre-configuration, no admin needed just results from any report you already have.

  • 15 aggregation functions: Sum, Count, Avg, Min, Max
  • 2Fully runtime works on any report instantly
  • 3No admin setup or pre-configuration needed
  • 4Drag-and-drop field assignment in seconds
Chart View

Eight types, all runtime

Eight Chart Types.
All Runtime.

No pre-configuration. Switch chart type with a single click right inside the Report Viewer. The chart re-renders instantly from the same data.

PNG Download
Runtime Only

Bar: Compare categories side-by-side

Report Builder

Infinite Complexity. Guided Flow.

From simple sales reports to complex stock movement across multiple union branches build any report in just 5 guided steps with our powerful low-code interface

prismiq.io/builder
Prism IQ
1/5 · Identity
Sales by Dept (YTD)
SALES_ANALYTICS
Auto-SluggingSlugify Engine Active
/reports/sales_by_dept_ytd
Identity

Define the report's DNA.

  • 1Automatic URL slug generation
  • 2Branded category assignment
  • 3Draft vs. Production state management
  • 4SEO-friendly naming conventions
Schema Intelligence

Relationship Discovery. Fully Automated.

Stop guessing join conditions. PrismIQ automatically detects PK/FK relationships across the entire Oracle schema and suggests the most confident connections for you.

200+ Tables

Auto-Alias

Smart Search

Confidence Joins

Auto-On Matching

Schema Browser

Advanced Query Engine

Master the Power of CTEs.

Chain result sets like building blocks. Perform unions, multi-stage aggregations, and advanced analytics without writing a single line of SQL.

Primary

Join Query

Branching

Union All

Post-Processing

Computed Query

Manual

Raw SQL

Core Engine Feature

Import complexity using
Load from Raw SQL.

Have a legacy SQL query? Paste it directly into the builder. The parser instantly maps all tables, detects columns and aliases, and converts raw code into modular, editable visual blocks.

  • Automated syntax parsing & validation
  • Dynamic column and alias detection
  • Automatic mapping to RPS schema metadata
  • Zero-loss migration from manual SQL scripts
sql_logic_parser.v2
Input: Raw SQL String
SELECT t.invoice, s.name
FROM trs t JOIN str s...
Parsing SQL…
Analytic Layer

Complex Windowing. Purely Visual.

Leverage the full power of Oracle analytic functions. Rank, Dense Rank, Row Number, and Time-Series offsets (Lag/Lead) are now a matter of clicks, not syntax errors.

Rank & Dense Rank

Row Number

Lag & Lead

Window Frames

Report Layouts

Two Layouts. Choose Your Structure.

Each report is configured in one layout mode. Flat delivers a clean tabular view. Hierarchical unlocks multi-level grouping with subtotals at every level and a grand total at the bottom.

prismiq.in/report-viewer
Prism IQ
Flat
Hierarchical
▶ Run
Flat TableAll columns · All rows
Store / DeptNet SalesQty
Dubai MallApparelAED 4,291128
Dubai MallFootwearAED 3,84794
Dubai MallAccessoriesAED 2,103211
Festival CityApparelAED 5,672203
Festival CityFootwearAED 3,112119
1–5 of 1,284 records · 0.28s
HierarchicalGroups · Subtotals
DepartmentNet SalesQty
Dubai Mall
ApparelAED 4,291128
FootwearAED 3,84794
AccessoriesAED 2,103211
SubtotalAED 10,241433
Festival City
ApparelAED 5,672203
FootwearAED 3,112119
SubtotalAED 8,784322
2 groups · 5 rows · 0.28s
Flat Table
  • Every column visible on every row
  • Click any column header to sort
  • Best for detail and drill-down reports
Hierarchical — Multi-Level
  • Multi-level grouping — group within group
  • Subtotal row injected at every group level
  • Grand total row at the bottom of the report
Scheduler

Reports in Your Inbox
Before You Ask.

Set a schedule once. PrismIQ runs the report, generates the attachment, and delivers it to every recipient automatically, every time. No external tools. No manual steps.

Daily, Weekly & Monthly
To, CC & BCC Delivery
CSV, Excel & PDF
Filter Snapshots
Run Now
Live Activity Monitor
prismiq.io/scheduler
Prism IQ
Scheduler
+ New Task
Scheduled Tasks4 tasks active
Daily Sales Summary
Daily · 08:00 · Today 08:00
Excel
Weekly Inventory Alert
Mon · 07:30 · Running now
PDF
Monthly P&L Report
1st · 07:00 · Mar 1 07:00
CSV
Hourly Stock Check
Every 1 hr · SMTP Error
Excel
Activity Monitor Live
✓ 2✗ 1
[08:00:01]✓Daily Sales Summary1,248 rows342ms
[07:30:14]✓Weekly Inventory Alert3,901 rows891ms
[07:00:03]✗Monthly P&L Report—timeout
Alerts

Know Before It Costs You.

SQL-powered alerts that run on your schedule, check your data, and notify your team the moment something needs attention. No third-party tools. No polling dashboards.

THRESHOLD

Threshold

SQL returns a single number. Alert fires when it crosses your configured target — above, below, or equal.

e.g. Daily sales < AED 50,000
OCCURRENCE

Occurrence

SQL returns event rows. Fires for every new row since the last check using a High-Water Mark to track state.

e.g. Transaction > AED 10,000 detected
ABSENCE

Absence

Fires when the SQL returns zero rows — the expected activity is completely missing.

e.g. No sales recorded in last 2 hours
prismiq.in/alerts
Prism IQ
Alerts
+ New
ALL
SALES
INVENTORY
CRITICALTHRESHOLDActive

Daily Sales Below Target

Fires when net sales drop below AED 50,000

Every 1hFired: 3×
WARNINGOCCURRENCEActive

Large Transaction Detected

New event row for each transaction over AED 10,000

Every 15mFired: 11×
Business Hour Window
Restrict checks to active hours & days. No false alarms outside trading hours.
Alert Library
Pre-built templates across Sales, Inventory, Employee and more. One-click install.
Test In Place
Run the SQL live before activating. See exactly whether it would fire.
Full Alert History
Every trigger event logged: outcome, matched rows, execution time.
Import / Export
Portable .pialert files. Share alerts across any PrismIQ environment.
Security Architecture

Enterprise-Grade Security. Out of the Box.

Security isn't an afterthought it's baked into every layer, from the Oracle connection to the API response to the browser session.

JWT + Session Validation

Every API request requires a valid JWT token AND a live session UUID matched against the active sessions table invalidated sessions are rejected instantly.

One Session Per User

If a user logs in from a new device or browser, their previous session is automatically terminated. No concurrent access, no shared logins.

Rate Limited Login

The login endpoint is rate-limited to block brute-force attacks. Repeated failed attempts are rejected automatically before they can escalate.

SQL Injection Proof

Read-only Oracle connection. Table and column names are whitelist-controlled. All user values use cx_Oracle bind parameters never string-interpolated.

XSS Attack Proof

Security headers enforced on every response: X-Content-Type-Options, X-Frame-Options: DENY, and X-XSS-Protection blocking injection and framing attacks.

Full Audit Trail

Every report execution is logged: user, timestamp, applied filters, row count, execution time, and export type. Full accountability on every action.

User Management

Access Control
Down to the Column.

Full user lifecycle management with group-based access control, a visual permissions matrix, and server-enforced column-level field masking all in one place.

User Lifecycle

Create, edit, deactivate, or delete users. Reset passwords without knowing the current one.

Groups

Logical groupings drive all access. Assign each user to exactly one group. System groups are protected.

Permissions Matrix

A visual checkbox grid mapping each group against every report and widget. Bulk grant or revoke in one action.

Column Field Masking

Hide sensitive columns (cost, margin) from specific groups. Enforced server-side the masked data never reaches the browser.

prismiq.io/user-management
Prism IQ
User Management
All Users
J
John Smith
Sysadminactive
S
Sarah Connor
Business Adminactive
M
Mike Ross
Sales Teamactive
J
James Wilson
Sales Teaminactive

New

Row-Level Security — Subsidiary & Store Access Control

Server-Side Enforcement
Injected as a WHERE clause in Oracle — filtered at the database, never the browser.
Subsidiary → Store Tree
Hierarchical access: grant a whole subsidiary or pick individual stores per user.
Zero-Row Default
A user without a profile sees zero rows on protected reports until access is granted.
Full Access Option
One checkbox grants unrestricted access to all current and future subsidiaries and stores.
Pre-Built Library

Productivity from Day One. Zero Setup.

Log in and your most critical retail metrics are already waiting — no configuration, no SQL, no onboarding friction.

0+
Reports
0+
Widgets
0+
Alerts
0+
Categories

Sales

Reports35
Widgets18
Alerts8

Inventory

Reports20
Widgets10
Alerts6

Customers

Reports15
Widgets8
Alerts3

Audit

Reports12
Widgets6
Alerts4

Employee

Reports8
Widgets4
Alerts2

Operations

Reports6
Widgets2
Alerts1

Vendor

Reports4
Widgets2
Alerts1
PrismIQ Marketplace

Need More? Browse the Marketplace.

Go beyond the built-in library with premium report and widget packs verified by the PrismIQ team, designed for specific retail use cases. Buy once, import in seconds.

  • Every pack verified and tested by the PrismIQ team
  • One-click import directly into your running instance
  • Advanced analytics: RFM, CLV, YOY, window functions
  • New packs added regularly as new use cases are built
marketplace.prismiq.io
Prism IQMarketplace
AllAnalyticsFinanceInventory
Popular6 reports
Advanced Analytics Pack
YOY comparison, rank analysis, moving averages & cumulative totals.
5
$99
New4 reports
Customer Intelligence Suite
RFM segmentation, customer lifetime value & purchase frequency.
4.8
$79
Premium7 reports
Financial Reporting Bundle
P&L deep-dive, budget vs actual, period-over-period comparisons.
4.9
$149
Popular5 reports
Inventory Optimization Pack
Dead stock alerts, reorder point calc & inventory turnover ratio.
5
$89
White-Label Control

Your Brand.
Your Theme.

PrismIQ gets out of the way. Your logo, your name, your colors applied globally across the app, PDF exports, and every user-facing surface.

Company Name & Logo

Your name and logo replace PrismIQ in the header, PDF reports, and everywhere else.

18 Brand Color Themes

Pick from 18 pre-built color options the entire interface adapts to your brand instantly.

Branded PDF Exports

Every exported PDF includes your logo, company name.

CSS Custom Overrides

Fine-tune colors beyond the preset themes with CSS custom property overrides.

Persistent Config

Branding is stored in local config and survives server restarts set once, stays forever.

Per-Tenant Instances

Deploy separate PrismIQ instances for different clients, each with their own brand identity.

Theme
app.yourbrand.io/dashboard
R
RetailPro BI
SC
Sarah C.
Admin
Good Morning, Sarah 👋
Live
Revenue
AED 284K
Transactions
1,842
Avg Basket
AED 154
Revenue Trend This Month
Powered by RetailPro BIOcean Blue
18 Built-in Themes
Logo Upload
PNG / SVG
Replaces logo everywhere
Product Roadmap

What's Coming — The Platform Keeps Growing.

PrismIQ is a living platform. Every release adds real capabilities shaped by real retail operations feedback.

Coming Soon
High Impact · Short Effort
Report Favourites
Filter Presets
Conditional Formatting
Report Cloning
Run with Last Filters
In Development
High Impact · Medium Effort
Row-Level Security
Data Alerts & Notifications
Drill-Down Navigation
Report Subscriptions
Planned
Medium Impact
Report Tags & Labels
Column Groups
Sort Persistence
API Key Access
Two-Factor Authentication
LDAP / Active Directory
Vision
Strategic Long-term
AI Natural Language Query
Anomaly Detection Alerts
Multi-Tenant SaaS Mode
Mobile-Optimised Views
Report Embedding (iframe)
Technology Stack

Built on a Rock-Solid Foundation.

Every technology choice was made for production reliability, not trend-chasing battle-tested in enterprise retail environments.

Backend
FastAPI (Python 3.11)Oracle cx_OracleSQLite (auth.db)APSchedulerReportLab (PDF)OpenPyXL (Excel)bcryptPyJWT
Frontend
Next.js 16 (App Router)React 19TanStack Table v8RechartsReact Grid LayoutZustandTailwind CSS v4Framer Motion
Deployment
Standalone installer everything compiled in
Installs as a Windows Service via NSSM
Accessible from any device on the local network
Point to any Oracle DB server no schema changes
All packaged into a single Windows installer no dependencies, no environment config, no IT headaches.