Ubiq is an easy to use but powerful web based reporting tool for MySQL data. It can be used to analyze your business data, create web based reports & dashboards to track signups, sales, operations, and other business information without any programming. Data can be queried using drag and drop, and dashboards are updated automatically to reflect the latest information.
In drag and drop mode charts can be created by selecting fields from a list reflecting data available in connected databases. Functions can also be applied to data by selecting dropdown options, and filters and joins can be created with changes reflected in real-time. There is a choice of most charting types – table, line, bar (stacked, group, percent), scatter plots, stacked area, column (grouped, percent, stacked), pie, donut and funnel. Charts can also be created using sql syntax, and regardless of creation method can be exported to PDF, PNG or CSV.
Dashboards are easy to create and support filters which apply to all charts on a dashboard. Charts are added to a dashboard when the chart is saved. Each chart can be moved or resized as necessary and themes can be applied to dashboards for a consistent look and feel.
MySQL databases can exist on a PC, an intranet or on Amazon RDS and EC2.
A free 30 day account is offered and subscription starts at $18/month for an individual (3 dashboards). Other plans are offered and bespoke subscriptions are available. Given the ease of use and productivity of ubiq, users will quickly see a return on the modest subscription pricing.