Understand your Data
InSights will help your Data tell you its Stories. It is those stories that bring greater understanding. And it is with understanding that knowledge comes. InSights unique interface and data visualization features offers the user a multitude of ways of viewing and interpreting their data.
InSights Into Data Ad-Hoc reporting, charting capabilities and export features will allow you to generate better reports - faster.
Learn from your Data...
Information is really nothing more than Data wrapped up in a Story.
Good Information leads to Understanding.
Understanding is the basis for Knowledge.
...And it all starts from the Stories your Data can tell you...
Let InSights show you the Patterns in your data and help you unlock the many stories within!
InSights Into Data Features
Read more about what sets InSights Into Data apart from our competitors.
InSights can access many different database servers, such as Microsoft SQL Server, MySQL, MariaDB, Oracle, Postgresql, Firebird, etc. In version 2.0 we will be adding additional support for other database servers such as DB2, Access, SQLite, etc.
This means that no matter what database technology you use now, or in the future, InSights will be able to work with it!
Writing SQL is never fun, even for those that are experienced with it. Our Visual Query Builder allows you to view the tables in your database, their fields, create SQL, and add filtering/sorting options - and all done visually...
Query results are displayed in a powerful grid that allows the user to arrange the data in a multitude of ways.
Standard Grid Display
The standard gird allows you to arrange columns, sort, filter, group and even perform calculations
Grid Column Grouping
You can group the data in the gird simply by dragging a column into the group box. The grid below shows the results of a grouping by column - where a simple count has been put on the number of people in each city.
Grid String Filtering
The user is able to filter records by entering a filter string at the top of the grid. It will search every column in the grid and only display records that have a matching string in at least one column.
Grid Row Highlighting
There are many times that you may want to quickly scan a result grid. looking for certain values. The row highlighting feature allows you to have the grid do that for you!! Now you can focus only on records that you know meet the criteria you are looking for!
InSights can display the results of a query in a powerful pivot grid, rather than the standard result grid. This pivot grid allows the user to re-arrange the data to show the data in different ways, with different breakdowns. And it is all drag-and-drop. As well as looking at the raw data, it allow allows graphing - simply by selecting cells in the grid.
Here is a sample pivot grid showing a breakdown by sex of all prescriptions written at a clinic. Here the drug name and sex fields were dragged onto the grid and the data was automatically rearranged to what you see below. Note that a few cells have been selected which are then automatically graphed (as shown at the bottom).
Viewing your data in a grid is very useful, but it is not the end of the process. You will need from time to time to generate a full professional level report. InSights has that capability in the form of a full banded end user report designer. As with almost everything else in InSights, it is all done via drag and drop. This will allow you to easily create fully branded professional looking reports.
End User Report Designer
Sample Report from the above design
The old saying - "A picture is worth a thousand words" is very true when you are looking at data. It can convey a lot of meaning in a very short period of time. In charts we can see and understand relative sizes quickly and take in more about the entire dataset than just by looking at numbers in a grid.
To this end, InSights Into Data allows the user to graph the data from both the Grid and the Pivot Grid easily and quickly. And we provide many ways to customize your charts as well. You can choose the type (Pie, Bar, Line, etc.) and change hundreds of settings in the chart to make it fit your every need.
this chart shows the breakdown of some medications from the pivot grid - breaking down prescription counts by patient sex.
Grid Chart Selection
This screen shot shows the simple selection form that allows you to easily pick which fields to use for the legend and values, what records to select and how to label the chart. Just point and click!
Here is the chart created from the above selection screen. It shows the most commonly prescribed medications and how they rank.
Let's be honest, very few of us like writing or modifying SQL queries. And any time you change something, you increase the risk of introducing errors. As well, who wants to be constantly changing dates or complex strings in a SQL query all the time?
To get around this, InSights Into Data has introduced extensions to standard SQL that allow the user to create popup windows that allow users to enter strings, numbers and dates - including picking values from lists. This means that you do not have to change SQL statements with each run - just pick a different value in the popup window.
InSights also has extensions for table lookups! This means that when you want something like a list of all the patients on a particular medication - you do not have to change the medication name every time (can you say misspellings!) - but simply pick from a list of medications that is already defined in your database (perhaps from the list of medications you have prescribed in the past?).
Everyone is familiar with Microsoft Excel. And many people use it for data analysis. And while it is a powerful tool, it is also very complex - and most people don't use very much of its power.
To that end, InSights Into Data has it own spreadsheet built right into the application. It has all the normal formulas, charting, tables, pivot grids, etc. - but all in a easy to use format. This means that for simple spreadsheet needs, you do not have to have Excel installed!
As well, it is built right into the program and has a number of interesting features:
- when you export from the Grid or Pivot Grid in InSights - the basic formatting is kept when the data is moved to the Spreadsheet form. Including formatting such as groups and and formulas!
- the Spreadsheet form is able to save its data in Native Excel formats (xls & xlsx). It is also able to load most Excel files and allow you to work on them.
- As with everything else in InSights, it is all point & click, including the charting of data.
As great as InSights is in allowing you to look at your data in your way, there will always be a need to export the data for other reasons. Perhaps you have another process that needs the data in a particular format?
To this end, InSights has a flexible data export feature that allows you to export the data in the Grid. As you can see in the screen capture below, the program supports exports to CSV (your choice of separator), Text, Excel, PDF, HTML and RTF.
As well, the export is WYSIWYG. So, if you hide columns in the grid, or filter rows - then those items are hidden from the export as well. Only the data that is currently visible in the grid will be exported.
Here is a sample Chart that shows the options when you want to export the chart. You can export to PDF, HTML, MHT, Excel (XLS & XLSX), RTF, and Images (BMP, GIF, JPEG, PNG, and TIFF).
As well as Grid data and Chart images, you can also export the Reports! The image below shows that you can export Report data to PDF, HTML, MHT, RTF, DOCX, Excel (XLS & XLSX), CSV, Text, and Image formats (BMP, GIF, TIFF, PNG, EMF, WMF, JPG, etc.).
Once you have a query written, a report designed and the grid layout for that query the way you want it - all the parts are automatically saved every time you save the query.
However, what if you want to share your work with other people in a different department or even a separate organization? InSights has the ability to Save all of the Metadata about your query (NO DATA!) - as easily as clicking the Save Query button and entering a file name. Once that file is created - you can email it to whomever you would like to share it with and all they have to do is click the Load Query button and choose that file. The program will then import the Query, Report definition and Grid layouts into their copy of InSights - and they are ready to run it!
Now you can share your workload with others and save effort by co-operating!