Dashboard Analytics

Data Visualization

Dashboard temps réel d'analyse avec graphiques interactifs D3.js et backend Python.

ClientProjet Lab

RoleDéveloppeur Full Stack

Year2024

StackReact, TypeScript, PostgreSQL, Python

THE CHALLENGE

Optimiser les requêtes de données volumineuses et assurer la réactivité de l'interface en temps réel.

analytics.py

from flask import Flask, jsonify
import psycopg2
from datetime import datetime, timedelta
 
app = Flask(__name__)
 
@app.route('/api/analytics/daily')
def get_daily_analytics():
    conn = psycopg2.connect(
        dbname="analytics",
        user="admin",
        password="secret",
        host="localhost"
    )
 
    cursor = conn.cursor()
    cursor.execute("""
        SELECT date, COUNT(*) as visits, SUM(revenue) as revenue
        FROM analytics
        WHERE date >= %s
        GROUP BY date
        ORDER BY date DESC
    """, (datetime.now() - timedelta(days=30),))
 
    results = cursor.fetchall()
    conn.close()
 
    return jsonify([{
        'date': str(row[0]),
        'visits': row[1],
        'revenue': float(row[2])
    } for row in results])
 
if __name__ == '__main__':
    app.run(debug=True)

Explore More

1	`from flask import Flask, jsonify`
2	`import psycopg2`
3	`from datetime import datetime, timedelta`
4
5	`app = Flask(__name__)`
6
7	`@app.route('/api/analytics/daily')`
8	`def get_daily_analytics():`
9	`conn = psycopg2.connect(`
10	`dbname="analytics",`
11	`user="admin",`
12	`password="secret",`
13	`host="localhost"`
14	`)`
15
16	`cursor = conn.cursor()`
17	`cursor.execute("""`
18	`SELECT date, COUNT(*) as visits, SUM(revenue) as revenue`
19	`FROM analytics`
20	`WHERE date >= %s`
21	`GROUP BY date`
22	`ORDER BY date DESC`
23	`""", (datetime.now() - timedelta(days=30),))`
24
25	`results = cursor.fetchall()`
26	`conn.close()`
27
28	`return jsonify([{`
29	`'date': str(row[0]),`
30	`'visits': row[1],`
31	`'revenue': float(row[2])`
32	`} for row in results])`
33
34	`if __name__ == '__main__':`
35	`app.run(debug=True)`

Dashboard Analytics

Data Visualization

THE CHALLENGE

All Projects