Omniscope Features

Import, visualise, analyse, manage, present and publish your data

Omniscope combines the features of local databases, spreadsheets, presentation packages, web browser-based reporting and portable document formats in a single easy-to-use application.

Import, enrich and save data

Import tabular data, then merge, join, visualise, analyse and share or publish reports and presentations as compact, highly-visual, interactive Omniscope files. Much more than a simple Excel Viewer, Omniscope files open as full presentations, as they were last saved, with multiple tabs containing any combination of 14 different views. Files can include online/offline maps, images and links to related content located on your network and/or the web. The navigable data is all contained in the highly compressed Omniscope file, so all views update automatically as users search and filter the data interactively. No special knowledge or commands needed, just a mouse.

Visualise, analyse and define formulae and alerts

Omniscope's 14 different views allow you and others to make sense of the data, no matter how many rows there are. Specify calculated formula columns and define assumption variables that users can vary in real time, just by moving a slider. As users filter the data and change the assumptions, all charts and displays (including related web displays if online) will update automatically. 

Configure report tabs and distribute

More presentable than spreadsheets, more visual and much easier to use than database files, anyone can open and navigate interactive, filterable, .IOK files using the free Viewer. Files are small enough to be e-mailed. Depending on your edition, you can import data from spreadsheets and databases, refresh on demand, and configure interactive, multi-view tabbed Report Pages that look (and print) just like presentations. You can even mix existing PowerPoint slides into Omniscope interactive graphical presentations.

Export and re-purpose/re-use data

Omniscope will export selected data for re-use in spreadsheets. It will post user input and selected subsets of the data back to a configured web service, with the response appearing in one or more integral web browser windows. Selected subsets of the data can also be exported as universally-accessible, dynamic Flash DataPlayers inserted in common documents (PowerPoint, Excel, .PDF) and web pages with full interactivity. More on DataPlayers.

Features in detail:

Open, import and save selected data:

• Explore, visualise, filter and analyse compact .IOK files of practically unlimited size
• Import and refresh from one or more Excel .XLS workbook tabs, delimited .CSV data files, even tabular .XML
• Import and refresh by connecting directly to multiple database tables/reporting views using ODBC/JDBC
• Create new files from 'scratch' by typing values into rows and columns...just like a spreadsheet
• Merge/join additional data into your files using mulit-criteria column matching
• Add images, maps, links, branding, help pages, banner ads, web services menus, etc. to each file
• Save as secure .IOK files with many access control, and data/revenue protection options
• Share non-commercial or commercial .IOK files with anyone via the free Omniscope Viewer
• Export user-selected subsets of data in Excel, .CSV, tabular XML or as Flash .SWF DataPlayers (unless data has been locked in by the file's creator)

Query, analyse and explore:

• Use 14 different views to show all aspects of your data in multiple windows
• Filter data and change assumptions rapidly with intuitive check boxes and sliders...no keyboard required
• Select and include/exclude records by attribute- powerful point-and-click query definition
• Display records by latitude/longitude coordinates on Google Maps or offline vector maps downloaded from our Map Library
• Combine local and remotely-generated web views, creating granular, interactive 'dashboard' reports with
  pies, bars, maps, graphs and tables

Edit data and create dynamic models:

• Edit (scrub) your data visually in Omniscope...spot and fix errors easily
• Add/refresh data by merging in additional rows or columns from other files automatically
• Add missing geographic coordinates to your data by merging or positioning records with a mouse
• Find and browse statistical trends in your data using the Graph View: Trends > Find Trends command
• Add formula-based calculated columns using typical spreadsheet functions and syntax
• Create real-time simulation models with multiple assumption variables controlled by sliders

Add maps, images and links

• Plot your data on free, offline vector or online Google Maps
• Import maps, scanned images, floor plans, etc. and overlay coordinates
• Link image sets to your data and embed them in portable .IOK files
• Re-size embedded image sets to manage .IOK file size automatically
• Create multi-image slide shows for each row/record that run automatically
• Create data-driven links to external documents, media files and web sites
• Use library of pre-configured free web services to link your data to related web content

Create multi-view reports & presentations

• Combine various views and filter settings with titles and annotations to define Report Pages
• Navigate and present tabbed Report Pages just like  like PowerPoint slide shows
• Make live presentations interactive with data filtering and sliders for sensitivity analysis
• Import static PowerPoint slide images directly into dynamic Omniscope presentations

Refresh from data sources on demand

• Combine many different refresh schemes to create a work flow and publishing solution 
• Refresh on opening- changes in linked source data files (.XLS, .CSV, or other .IOK files) imported automatically
• Automatic regular or 'on demand' updates direct from database tables/views
• Live refresh of multiple desktops from single source file...over your LAN, WAN or the open web

Print as static documents

• Print single views or multi-page presentations
• Print as PowerPoint slide packs
• Print as Adobe Acrobat .PDF files

Export interactive Flash DataPlayers

• Professional and Enterprise Editions export universally-accessible interactive Flash DataPlayers (.SWF files)
• Choose from  6 different view types in tabbed or multiple 'dashboard' DataPlayer presentations
• Automatically insert fully-interactive DataPlayers in documents (PowerPoint, Excel, .PDF) or export to web pages

Edit your own folders of files

• Use Omniscope to analyse your own file folders of images, music or video
• Edit tags and export selected images or playlists (from version 2.5 beta)

Connect to and import/edit online data

• Bloomberg: Professional and Enterprise editions installed on Bloomberg PCs can capture and update Bloomberg data in real time. if files are forwarded to others with Bloomberg access, data can be refreshed on opening and on-demand. More on using Omniscope with Bloomberg
• Salesforce: Omniscope Connector for Salesforce is available as both a Web Connector (certified and listed on the AppExchange) that allows any Salesforce user to download and visualise their Reports and Data Objects/Tables in Omniscope, and (from Omnscope 2.5 beta) as a direct connector* that can open Reports and edit and synchronise Data Objects/Tables with your Salesforce account. More on using Omniscope with Salesforce. Note: the Direct Connector from Omniscope 2.5 (beta) can be used only with Salesforce Professional, Enterprise or Unlimited accounts

Find out more...

See screenshots, download and install the free Viewer and try some demos. The free Viewer includes a 30-day free trial of all the authoring and configuration features available in Omniscope Professional, including DataPlayer creation and export/refresh.