What are some good tools for database analysis / visualization / reporting

Question

I developed a web application based on the mysql database that stores information about users, site usage, photo uploads (its photo site), etc. I have several databases storing data for different aspects of the site. I want to be able to create reports on some of the issues that I will have about how the site is growing and how it is used. For example, how many new users have uploaded for a certain number of photos this month.

What tools are available for database analysis - I used a trial version of access to Microsoft and exported each database as an XML file and imported it for access, where I created relationships and used the query wizard to create some queries and reports. These are the actions that I want to do, and they prepared the reports that I want to have. I also want to be able to run queries through databases ...

What other tools for people use for this task with mysql databases? Are there any good tips / training materials on the workflow for creating such reports and managing these activities over time - for example, should I export the databases weekly and run queries to create reports?

What do people experience in this type of task?

Any advice, input is welcome.

Answer 1

Welcome to business intelligence, the art of creating information from data.

Conventional Architecture - Source -> ETL -> Data Warehouse -> Reporting Tools

ETL: extracting transformed workloads (today you are copying your databases, but some free tools can help you change this: CloverETL, Talend, etc.)

Datastore: this is the place where you put your data and prepare it for easy use in reports

: , BIRT, JasperReports .., QlikView, ( ), .

Answer 2

, MSAccess, - .

Crystal - . IIRC .

JasperReports, ReportMan, BIRT, DataVision Agata

Answer 3

, . , , ?

, PHP-MySQL Bridge. PHP script. JDBC . Java. , ( ) designer i-net Clear Reports ( i-net Crystal-Clear).

Answer 4

myDBR PHP mySQL. myDBR .

SQL myDBR, . , , .

, :

select 'dbr.chart', 'Column', 'Usage statistics';
select name, count(*) 
from user_access
group by name;

myDBR demo. myDBR - (129 ).