PICALO. is a data analysis application, with focus in fraud detection and data retrieved from corporate databases. It is also the foundation for an automated fraud detection system.
Picalo is released in two formats. First, as a pure-Python library that is used by simply "import picalo" or "from picalo import *" in any Python script. Python programmers will be primarily interested in the library version. This format is installed in the typical Python fashion, either as an .egg via setuptools, or via "python setup.py install" from the source
Second, Picalo is released as a standalone, wx-Python-based GUI environment that allow end users to access the Picalo libraries. This version is packaged as a Windows setup.exe file, Mac application bundle, and Linux rpm and deb files. The user may not realize Python is even being used when running the full application environment.
The project browser
shows the tables, database connections, saved queries, and scripts available in this project. These correspond to a directory on the user’s machine.
The work area
shows the tables or scripts that are currently open and in memory. It provides a spreadsheet-type view of the data and filter capabilities along the top.
provides a direct interface to the Picalo engine. As the user interacts with tables, menu options, etc., Picalo shows the actual commands being run behind the scenes. The user can simply use the graphical menus or type commands directly into the shell. The Script Output and History tabs provide feedback from scripts as well as a full history of everything done in the project.
Importing of data
Picalo contains a large library of functions that help users analyze their data. The Function Composer (pictured above) lists all the available functions with their documentation, parameters, and return values.
Detectlets are one of the most exciting parts of the Picalo architecture. They allow non-programmers to run analysis routines created by others. See the detectlets page for more information.
Detectlet Wizard: This open source wizard provides access to all detectlets installed at your location. It guides users through the use and application of detectlets in fraud analysis.
Example uses of Picalo:
- Analyzing financial data, employee records, and purchasing systems for errors and fraud
- Interactively analyzing network events, web server logs, and system login records
- Embedding controls and fraud testing routines into production systems