This is a one page template project to access to a DDBB with exact front User Interface as google analytics. (Graphics based on http://code.google.com/apis/ajax/playground/?type=visualization#area_chart ) We have an mysql database and want you to create a easy report tool with the same ("exact") display, graphics, icons... as google analytics. MOST IMPORTANT IS TO GET SAME AJAX RESPONSE AND LOOK AND FEEL. Basically you will construct multiple "select" SQL queries based on user parameters that will be described on detail (see image to get an idea) in order to get a "similar to analytics" report For each "conditional variable" (selected "where" clauses, image up-left menu ) we will have specific "analysis variables" options (predefined "select" clauses, center option box) and "segment options" (predefined "where" clauses, center upper option box ) Same colors for central graphics and (day/week/month) data representation agregation options. Same calendar display to choose data origin/end (exact same efect) Same results squema for "query results summary"(center center), "query results" (left down) and "lateral graphics" (rigth down) and diferent type of graphics: Graphic options: same pie color representation for first 8 results, agregated for rest horizontal absolut value bars horizontal compared to mean tabular results Same explanations layer "explanations" In general: Same ajax response (ajax response is the MAIN issue in this project) Speed is an issue (must be very fast, no frameworks for query, php) Same CSS Prepared for multiligual Graphics based on http://code.google.com/intl/es-ES/apis/visualization/documentation/gallery.html With export options to csv and excell Red stripes mean funtionalities not needed, rest must be performed. ¡Ask if have any doubt! Keywords: AJAX, MySQL, SQL, PHP, CSS