Audience
Individuals interested in a solution to get actionable insights from their SQL data sets
About 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.
Other Popular Alternatives & Related Software
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 about Column Case Management
InstaDB
It has been extensively tested on real-life business projects. It is stable and robust, easily extendable and efficient. It can be used in a vast range of applications. Every column added to a table is automatically accessible in the table filters. Moreover, in the case of references, you may filter using any parameter of referee tables. You may use any column (including columns of referee tables) for sorting your records. You may compose several filters to get a hierarchical order. Export to xls or csv is simple. You just copy-paste or download a csv file. Importing from spreadsheets is supported. InstaDB checks whether the formats are correct and referenced records exist in the database. Before any update, a preview of changes is displayed in order to avoid unwanted changes. It is easy to show, hide and change the order of columns. The Reset View button always restores the default column composition.
Learn more about InstaDB
Tomat AI
You don’t have to be a Data Scientist to Explore your CSV Excel-like interface. If you have ever worked with spreadsheets, your can start working with Tomat right away. No need to upload large CSVs to the cloud, no ZIPs, and no timeless loaders. Just open Tomat app, select your local files, and start exploring them with point-and-click UI. Become a data pro! Explore your sheets without writing any code or formulas! Use advanced filters, sort rows, and group by categories easily with our intuitive and powerful visual interface. Easily combine your CSVs into a single file. Stack your tables even if column order is a mess, Tomat will do the work for you. Or add columns from one table to another without formulas. Tomat works without hitting the cloud. Your files never leave your laptop. You are in a safe place and you are the sole owner of your sensitive data.
Learn more about Tomat AI
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 about Webix Grid
Pricing
Starting Price:
$45 one-time payment
Free Trial:
Free Trial available.
Integrations
Company Information
Yohz Software
Malaysia
www.yohz.com/sda_details.htm
Videos and Screen Captures
Other Useful Business Software
99.99% Uptime for MySQL and PostgreSQL Databases
Cloud SQL Enterprise Plus delivers near-zero downtime with 35 days of point-in-time recovery. Supports MySQL, PostgreSQL, and SQL Server.
Product Details
Platforms Supported
Windows
Training
Documentation
In Person
Videos
Support
Phone Support
Online
SQL Data Analysis Frequently Asked Questions
Q: What kinds of users and organization types does SQL Data Analysis work with?
SQL Data Analysis works with these users and organization types: Mid Size Business, Small Business, Enterprise, Freelance, Nonprofit, Government, and Startup.
Q: What languages does SQL Data Analysis support in their product?
SQL Data Analysis supports these languages: English.
Q: What kind of support options does SQL Data Analysis offer?
SQL Data Analysis offers support via phone support and online.
Q: What other applications or services does SQL Data Analysis integrate with?
SQL Data Analysis integrates with: Azure SQL Database, Collate, Microsoft Excel, Firebird, HTML, MariaDB, Microsoft Access, Oracle Database, MySQL, PostgreSQL, SQL Server, and XML.
Q: What type of training does SQL Data Analysis provide?
SQL Data Analysis provides training in the form of documentation, in person, and videos.
Q: Does SQL Data Analysis offer a free trial?
Yes, SQL Data Analysis offers a free trial.
Q: How much does SQL Data Analysis cost?
Pricing for SQL Data Analysis starts at $45 one-time payment.
