Panorama combines the best elements of database and spreadsheet technology into a single package, making it an unparalleled tool for working with and analyzing any kind of information. Like a spreadsheet, Panorama is RAM based for speed and flexibility, but with all of the data processing power of a full blown database application. The short video below demonstrates the benefits of this hybrid database/spreadsheet technology in action. After watching the video, download the Panorama free trial and experience it for yourself !
Panorama's unique hybrid database/spreadsheet technology is perfect for any application that requires storing, organizing and analyzing information. Since 1988, customers all over the world have been using Panorama for a wide variety of applications — everything from custom accounting and office management, medical research, project management, event organizing, even managing thousands of visual effects in blockbuster Hollywood productions. Panorama scales from affordable single user versions for individuals to large mutli-user/web applications. Key features of Panorama include:
  • Lightning Fast RAM Based Speed — Like most spreadsheets, Panorama bypasses the hard disk. All time sensitive operations are performed completely in RAM, including sorting, searching, analysis, data restructuring, import and export. As a result, many operations can be completed over 10,000 times faster than disk based products, including normally time consuming operations like splitting and merging fields.
  • Super Efficient — Panorama databases contain no indexes, so they are extremely space efficient (high speed RAM operation makes indexes unnecessary). In fact, Panorama databases can typically store over 10,000 records per megabyte of RAM, allowing Panorama to easily handle databases up to several million records (the exact capacity depends on the average amount of data per record).
  • Live Preview — When setting up a search, analysis or data manipulation, Panorama instantly previews the results as you type and click. The preview updates in real time, so you can quickly and easily see how different options interact with your actual data. You'll see in advance exactly what's about to happen to your data, so there are never any unpleasant suprises after you press the Apply button.
  • Deep Searching — Panorama can easily search all fields in a database or any combination of specific fields. Text fields can be searched for complete or partial matches, or even searched phonetically (for example Name soundslike Guiterrez). Numbers and dates can be searched using a variety of comparisons (equal to, greater than, less than, within 10%, before, after, by month, by year, etc.). Multiple searches can be combined for very specific results, and for advanced searching boolean formulas can be included (for example Debit > Credit * 2.5). Your favorite searches can be stored for later use, and of course for any search option, the results are live previewed in real time as you type. (Bonus: Right clicking on any data cell pops up a menu with options for quickly showing data similar to the current cell, for example same name, same amount, same month, etc.)
  • High Data Malleability — Panorama allows huge data sets to be bent, reshaped or refactored at will. Fields can be added, removed, rearranged, hidden, merged or split at any time. Entire datasets can be rapidly altered based on parsing/manipulation rules set up from pop-up menus (advanced users can also use arbitrary formula expressions). Typical examples include swapping first and last names, extracting area codes, removing extraneous punctuation, shifting all or part of a field to upper or lower case, or splitting combined addresses into separate city, state and zip fields. Multiple parsing/manipulation rules can be chained together for complex transformations, and sets of parsing/manipulation rules can be saved for later re-use. The effect of all parsing/manipulation rules are live previewed in real time as they are changed (actual database manipulation occurs at 10k-50k records per second).
  • Interactive Analysis —Panorama tools for interactive data analysis include data outlines, crosstabs (pivot tables), and charts. Data outlines are a unique Panorama feature that summarize raw data in a multi-level outline, with each higher level corresponding to higher level categorizations of the data (for example Date (by month) -> Department -> Employee or State -> City). The outline is interactive, so it can be collapsed to show overall trends or selectively expanded to reveal specific details at lower levels. Summary levels in the outline can be further processed by sorting or selection, make it easy to answer questions like who were the top five sales associates in each region last quarter? or which sectors are growing the fastest internationally? The outline specifications can be changed at any time for different analysese.
  • Flexible Import & Export — Panorama can transfer data directly to or from spreadsheets (Excel or Numbers) by drag and drop (Mac only) or via the clipboard (Mac or Windows). Data can also be imported into Panorama from text files (CSV or tab separated), files containing HTML tables, and files in several financial data formats (QIF, QFX and OFX). Supported export formats include text files (CSV or tab separated) and HTML. Data can be automatically restructured as it is imported or exported to match up with external programs (for example re-arranging, merging or splitting fields as the data is imported or exported).
  • Assisted Data Entry — With features like Clairvoyance™ (auto-complete), automatic capitalization, input and output patterns, duplicate checking and default values, Panorama can help make data entry a much less tedious and error prone process. Panorama's unique smart date feature allows input of human friendly dates like today, friday or last monday.
  • Fully Relational —Panorama's relational model supports one record-to-one record links, range-to-one record (shipping and tax tables, for example), and one record-to-many records.
  • Drawing Tools — Panorama's object based drawing tools allow you to rapidly design and create windows, forms, labels, custom reports, and web forms. Forms can be customized with pushbuttons, checkboxes, radio buttons, pop-up menus, lists, matrices, images and movies, and you can also easily create elastic forms that adjust automatically as the window size changes.
  • Fully Programmable and Extensible — Automate repetitive tasks by simply turning on Panorama's built in script recorder. Recorded scripts can be played back at any time, and can also be modified with a built in script editor. Advanced users can customize scripts using Panorama's extensive (and extensible) programming language and debugging tools, and scripts can also include embedded code written in one of six popular scripting languates (AppleScript (Mac only), shell scripts (UNIX or DOS), Perl, Ruby, Python or PHP).
  • Crash Proof — Panorama's Total Recall feature protects your vital data from power failures and system crashes. When Panorama is relaunched after a crash, everything goes right back to where it was. All databases, windows and variables are restored to where you left off, so you can get right back to work as if nothing had ever happened. If anything goes wrong, we’ve got you covered - the most you can lose is a few seconds of work.
  • Goof Proof — To help protect you from yourself, Panorama keeps snapshots of database history over time. Unsaved changes can be immediately reversed with the Revert to Saved command. For mistakes or wrong turns made further back, the Time Lapse feature can "roll back" the database to a previous snapshot from minutes, hours, days or weeks ago. You can even compare different snapshots of a database to see how it has changed over hours, days, weeks or months. (Time Lapse is similar to Apple's Time Machine feature, but is fully integrated with the database and keeps snapshots based on database activity, rather than at fixed intervals.)
  • Multi-User/Web Applications — Panorama Enterprise Server uses a unique distributed mesh client/server architecture that eliminates server and network bottlenecks and allows off-line database operation. The system keeps duplicate data sets on the server and each client, with the server managing synchronization and record locking. The server handles data modification only, while operations like sorting, searching and analysis are performed in RAM on each client. Off-line clients can access and (optionally) modify the database, with automatic synchronization when reconnecting to the server. The Panorama Enterprise Server web publishing option works with the Apache server on OS X or OS X Server to allow access to Panorama databases from any web browser.

Download Your No Risk 15 Day
Panorama Trial Now!
Mac Requirements: Mac OS X 10.4 or later
Win Requirements: Win XP, Vista, 7 or later

Includes software, documentation and example files.