Is there a drupal module that can create custom dashboards / reports / map data from a mySQL database?

I want to create a backend analytics console for my users. I was wondering if there was a 3rd party service / drupal module that I can use as a starting point for this. Or is this more of a custom job?

-------------Problems Reply------------

I would use Google Charts with the Chart project:

You didn't mention if you are using Drupal 6 or 7, but it supports both.

Most likely, what you are wanting to do is a custom job--if you are seeking some sort of specialized reporting. It really depends on what you want to accomplish. If you could provide additional detail, I would be happy to try and offer a more precise answer.

If you are just querying the database, it is quite easy to either use Views or write a simple custom module to produce basic reports.

There is also a module called Forena Reports which you may find useful.

If you are looking for analytics on site access, my recommendation is to start by adding in the Google Analytics module and using Google for your statistics. Its painless and their insights are exceptional.

In the meantime, take a look at The site is fantastic and is extremely helpful in locating useful modules.

Please note that the specific version of Drupal you are using will affect which modules are available.

Here are a few modules that might be of some value.

Hope this helps.

Category:drupal Views:0 Time:2011-10-20

Related post

  • How to create a hyperlink in a data in a mysql database 2011-07-05

    can any one tell how to hyperlink in the data in a mysql database. I am creating a website where users can upload images/text.These images/text will be be shown in the index page say a list of 20 images/text.if any visitors want to go to that users s

  • Which code snipplets in PHP can create a input form, which creates a new set of data in my mysql database? 2010-05-22

    I am using the Google Maps API with parts in javascript and others in PHP. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" ""> <html xmlns=""> <head

  • Creating Custom GnuCash Reports with Scheme 2008-09-22

    Are there any resources which show how to create custom GnuCash reports? I don't know the intricacies of Scheme but I do know the basics of Lisp, based on tinkering with Emacs. Is there a site which lays out the API for GnuCash reports, ideally with

  • Utility to create "data dictionary" for MySQL database 2011-01-14

    I'm wondering if there is a utility that exists to create a data dictionary for a MySQL database. I'm considering just writing a php script that fetches the meta data about the database and displays it in a logical format for users to understand but

  • How to create a hexagon world map in PHP from a database for a browser based strategy game 2010-12-10

    I'm trying to create a hexagon world map for my PHP browser based strategy game. I've created a table in my database with the following data per row: id, type, x, y and occupied. Where type is the kind of tiles, which are defined in numbers. For exam

  • Creating Work Shift Calendar to be used wit MySQL Database 2010-12-13

    Greetings, I would like to ask on how do I create a work shift calendar to be used with MySQL database. What I am trying to achieve is that when user access my page on a specific date, the script will check work shift calendar on what is the shift on

  • Creating Moose Objects to interact with an Oracle/mysql Database 2011-02-22

    I need guidance on creating Classes that will interact with Oracle/mysql. The basic requirements would be to : connect/disconnect to/from oracle/mysql database. query tables and return data. process data and create relevant html reports. I am using M

  • Drupal 7 - How to create custom admin menu for client management of content 2012-01-17

    I'm trying to find the best way to create a user friendly admin menu for my client on the site I am building. So far I have been able to set access rights to the various types of content which I would like the client to edit, however this has some dr

  • Create custom driver for System.Data.Common 2009-10-07

    Background: Our C# application generates and executes queries to several types of databases (Oracle, SQL Server, MySQL), but a requirement came up to also apply them to a proprietary file format. The namespace used until now is System.Data.Common. Th

  • Create customized Jasper report layout 2011-01-14

    I would like to create a report that has the following layout: It has three parts as you can see. The third part is a subreport done as a list, that is the easy part! My question is this: is there a better way of doing the first two parts than drawin

  • Create custom survey with expiration date in SharePoint 2010 2011-05-02

    I want to create survey using SharePoint 2010 which will have expiration date. After this date, no user should be able to respond to that survey. But the data of previous responses should retain. What will be the best option to achieve this? Regards,

  • Creating Objects with variable object names from a mysql database 2011-12-30

    I am trying to create objects with variable names, when I print out my objectname variable the correct name is assigned to it. But when i try and create an object using the objectname variable, the object created is literally called "objectname", not

  • R how to create custom x-axis with dates 2012-01-19

    I'm trying to plot some prices vs dates. There are about 10k lines of data. The dates are a range from ~ 7/1/2008 - 12/1/2011. I'd like to be able to create a custom x-axis with the following ticks on it for each year: 1) at 1/1 have the YYYY (ie 201

  • Creating custom JavaScript object from data returned by jQuery AJAX request 2012-02-14

    I want to create a custom javascript object which contains data returned from a jQuery AJAX request, but I don't know which is the right way to do it. I was thinking maybe one way could be to include the AJAX request inside the constructor function s

  • Creating a function to grab data from an Oracle database (array by ID) 2012-03-21

    I'm trying to create a function that will simply allow me to pass an SQL statement into it, and it will generate an array based on a unique ID I pass it: function oracleGetGata($query, $id="id") { global $conn; $sql = OCI_Parse($conn, $query); OCI_Ex

  • How do I create custom generated reports of various length? 2012-04-18

    I am attempting to create a standardized form in Excel for data that I pull from other workbooks. I would like to automatically generate the form (Report Sheet) based on the data provided in a separate sheet (Data Sheet). I figure this would be simpl

  • Create custom Office ribbon MRU list for Access backend databases 2013-03-15

    I have a split Access 2007 database and have a custom Ribbon. My custom ribbon has a Recent Document heading in the Office button, but it does not show any items. I would like to show the most recent backend databases that were opened by the user in

  • Creating Custom .NET Object Maps from JSON strings 2010-08-06

    I dread coding this but has anyone coded this before or are you using a 3rd party lib like Json.NET? I'd prefer to code my own parser and just wondering what others have done to parse Json and handle that generically. --------------Solutions---------

  • Creating a series of dropdown boxes from a MySQL database 2011-10-17

    I have a problem that I just can't think of a logical way to overcome. I have a table similar to this: +-------------+--------------+---------------+ | id | catName | parentId | +-------------+--------------+---------------+ | 1 | Category 1 | 0 | |

Copyright (C), All Rights Reserved.

processed in 0.424 (s). 11 q(s)