Data Analytics Dashboard

import plotly.express as px
import plotly.graph_objects as go
from fastapi import FastAPI
from sqlalchemy import create_engine

app = FastAPI()
engine = create_engine(DATABASE_URL)

@app.get("/api/metrics")
async def get_metrics():
    import pandas as pd
    df = pd.read_sql("SELECT * FROM metrics", engine)
    fig = px.line(df, x="timestamp", y="value",
                  title="System Metrics")
    return {"chart": fig.to_json()}

@app.get("/api/summary")
async def get_summary():
    import pandas as pd
    df = pd.read_sql("SELECT AVG(value) as avg FROM metrics", engine)
    return {"average": df.iloc[0]["avg"]}