Geek Answers Handbook

An easy way to visually manage tabular data

I am working on a project in economics where I need to manage big data in linked tables with many foreign keys. I have several years of experience working with Oracle DBA, so I can handle it without problems, But I need to be able to share data with others who do not have knowledge in the field of databases, There, in order for me to show them the graphical way to display data. The toad does everything I need and much more, but the program is too complicated for my needs.

Instead of wasting time writing a C # program that manages the data, I'm looking for a good program that:

  • Shows the main table / data view with the ability to filter / group / order using the drop-box options.
  • Selects a row and displays data in related tables for selected row data
  • Makes report / data pages of my selected rows that I can customize and print. (I know this is a big request).

In addition, what is the most suitable and simple database for him? I only worked with Oracle, but there is too much for this, why MySql? Access (I first tried to do all this in the Access program, but it’s too difficult to set up forms and so on, and in the end you cannot publish the version.

And the tables will be with start_date and finish_date, which follow each other for the same ID, But I do not think that this will be a problem that I can do as much as possible, showing only the last one. (By the way, what is the name of such a table, I never knew)

+4
source share
1 answer

Take a look at the table http://www.tableausoftware.com

It allows users to view data in different ways, makes excellent visualization and works with most databases. This is a reading tool, so it is ideal for safe reporting, but you will need to associate it with something else if you want your users to make changes to the data.

You can define a connection in Tableau that establishes relationships for users who do not understand foreign keys and the like. Or create views that hide these details, of course, regardless of the tool you choose.

+1
source

More articles:


All Articles