SQL Data Analysis
Import data sets from your databases using SQL queries. Analyze your data sets using analysis tables and pivot tables. Discover new patterns and trends from your analysis. Share your discoveries using PDF reports, or export to Excel, HTML, and XML files. Get actionable insights from your SQL data sets in a fast and easy way. Sort, filter, group, and summarize your SQL data sets in whichever way you need. You can group columns in whichever order you require. This allows you to summarize your data in many possible ways, potentially uncovering new information or patterns. Create summaries for any columns, or even multiple summaries for the same column using different functions. View summaries in group headers, group footers, and column footers. Highlight exceptional values using flexible rules and formulas. Sort one or more columns in ascending or descending orders, in the sequence you require. Each column can be filtered to display only the data you want to see.
Learn more
AQURA
AQURA is a windows based software. It has an easy to use graphical user interface (GUI). AQURA uses a proprietary data base engine, and hence it is much more faster and reliable than the software based on some RDBMS. AQURA has a very powerful set of drill-in browsers, which make it easy to view / organize and modify the financial data. The browsers are customizable. You can change the widths of the columns, hide un-wanted columns, select the level of details displayed etc. Browsers have support for searching the text or amount, sorting on a particular column and filtering of the displayed data. AQURA supports versatile set of reports. Reports can be customized by selecting date ranges / filters, styles and the columns. Currently AQURA supports more than 100 reports, each having various options for customization. AQURA supports use of different type of stationery for different types of reports like invoice, normal reports, vouchers etc.
Learn more
Column Case Management
Launched in 2006, Column Case Management is the leading web-based case management software for commercial and public sector organizations. Built on the BMC Remedy Action Request System (ARS), Column Case Management helps businesses automate simple and complex transactions in order to achieve standardization and best practices. Its core functionality includes reporting and analytics, automation, knowledge and task management, SLAs, notifications management, and audit control, among others. Popular Column Case Management apps include Column Case Investigative, Column Customer Service Support, and Column Records Management.
Learn more
Webix Grid
Webix Grid is a standalone JavaScript DataGrid component (table/grid UI widget) that is optimized for high-performance, large-dataset scenarios, and is designed to be dropped into web applications where tabular data needs to be displayed, edited, filtered, sorted, etc.
Key positioning points:
Lightweight: you don’t have to bring in the full Webix UI library if you only need the grid.
Focused on “just the grid” use-case rather than a full UI framework.
Feature-rich, offering a wide set of capabilities for enterprise-style data apps:
- Virtual scrolling
- Frozen columns
- Inline editing
- Sorting
- Filtering
- Grouping
- Column resizing
- Column reordering
- Multi-line headers
- Row selection
- Cell selection
- Copy/paste
- Excel export
- PDF export
- CSV export
- Paging
- Validation
- Undo/redo
- Drag and drop
- Spanning cells
- Context menus
- Keyboard navigation
- Conditional formatting
- Column summaries
- Custom rendering
- Live updates
Learn more