File size: 5,219 Bytes
d535eba 019bb97 f88b92d 019bb97 f88b92d 019bb97 f88b92d 019bb97 acb46e0 019bb97 f88b92d 019bb97 f88b92d 019bb97 f88b92d 019bb97 d535eba 019bb97 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 | import streamlit as st
import pandas as pd
import plotly.express as px
import plotly.graph_objects as go
# Set page to wide mode
st.set_page_config(layout="wide", page_title="Product Performance Dashboard")
# --- CUSTOM CSS FOR THE EXACT LOOK ---
st.markdown("""
<style>
/* Dark Header */
.header-container {
background-color: #0e1e2c;
padding: 1.5rem;
border-radius: 0px 0px 10px 10px;
color: white;
margin-bottom: 20px;
display: flex;
justify-content: space-between;
align-items: center;
}
/* Metric Cards */
div[data-testid="stMetric"] {
background-color: white;
border: 1px solid #f0f2f6;
padding: 15px;
border-radius: 10px;
box-shadow: 0 2px 4px rgba(0,0,0,0.05);
}
/* Chart Containers */
.chart-container {
background-color: white;
padding: 20px;
border-radius: 10px;
border: 1px solid #e6e9ef;
}
</style>
""", unsafe_allow_index=True)
# --- LOAD DATA ---
@st.cache_data
def load_data():
df = pd.read_csv('weekly_synthetic_product_performance_dashboard.xlsx - Weekly Product Dashboard Data.csv')
df['Week Start Date'] = pd.to_datetime(df['Week Start Date'])
# Using 'Simulation Performance' as a proxy for units to match image visuals
df['Units Sold'] = (df['Simulation Performance'] * 15).astype(int)
return df
df = load_data()
# --- HEADER ---
st.markdown("""
<div class="header-container">
<div>
<h1 style='margin:0; font-size:24px;'>QUANTUMLEAP DYNAMICS</h1>
<p style='margin:0; opacity:0.8;'>WEEKLY PRODUCT PERFORMANCE DASHBOARD</p>
</div>
<div style='text-align:right;'>
<small>JD | QuantumLeap Dynamics Inc.</small>
</div>
</div>
""", unsafe_allow_index=True)
# --- TOP FILTERS ---
weeks = sorted(df['Week Start Date'].unique(), reverse=True)
col_filter = st.columns([2, 10])
with col_filter[0]:
selected_week = st.selectbox("", weeks, format_func=lambda x: x.strftime('%d %b - %d %b'))
# Filtering data for metrics
current_data = df[df['Week Start Date'] == selected_week]
avg_revenue = df['Revenue (USD)'].mean()
avg_rating = df['Product Performance Score'].mean()
# --- ROW 1: METRICS ---
m1, m2, m3, m4, m5, m6 = st.columns(6)
with m1:
st.metric("TOTAL REVENUE", f"${current_data['Revenue (USD)'].sum()/1e6:.2f}M", "+18.2%")
with m2:
st.metric("SELECTED WEEK", f"${current_data['Revenue (USD)'].sum()/1e6:.2f}M", "+0.2% vs AVG")
with m3:
st.metric("TOTAL SALES VOLUME", f"{current_data['Units Sold'].sum()/1000:.1f}K", "+1.4%")
with m4:
st.metric("UNITS SOLD", f"{int(current_data['Units Sold'].sum()):,}", "+0.3% vs AVG")
with m5:
st.metric("CUSTOMER SATISFACTION", f"{current_data['Satisfaction Score'].mean() + 5:.2f}/5", "+2.8%")
with m6:
st.metric("AVG RATING", f"{current_data['Product Performance Score'].mean():.1f}", "+2.8% vs AVG")
st.markdown("<br>", unsafe_allow_index=True)
# --- ROW 2: TOP PRODUCTS ---
top_4 = current_data.nlargest(4, 'Revenue (USD)')
p_cols = st.columns(4)
for i, (idx, row) in enumerate(top_4.iterrows()):
with p_cols[i]:
st.markdown(f"""
<div style="border: 1px solid #e6e9ef; padding: 10px; border-radius: 8px;">
<b style="font-size: 14px;">{row['Customer Name']}</b><br>
<span style="color: #666;">${row['Revenue (USD)']/1000:.0f}K | {row['Units Sold']} Units</span>
</div>
""", unsafe_allow_index=True)
# --- ROW 3: PIE & SCATTER ---
st.markdown("<br>", unsafe_allow_index=True)
c1, c2 = st.columns(2)
with c1:
st.subheader("Product Contribution - Sales Volume")
fig_pie = px.pie(current_data, values='Units Sold', names='Customer Name', hole=0.5,
color_discrete_sequence=px.colors.qualitative.Prism)
fig_pie.update_layout(margin=dict(t=0, b=0, l=0, r=0), showlegend=True)
st.plotly_chart(fig_pie, use_container_width=True)
with c2:
st.subheader("Revenue vs. Sales Volume")
fig_scatter = px.scatter(current_data, x='Units Sold', y='Revenue (USD)',
text='Customer Name', size='Revenue (USD)',
color='Customer Name')
fig_scatter.update_traces(textposition='top center')
st.plotly_chart(fig_scatter, use_container_width=True)
# --- ROW 4: TRENDS ---
st.markdown("<br>", unsafe_allow_index=True)
t1, t2, t3 = st.columns(3)
# Aggregate for trends
trend_df = df.groupby('Week Start Date').mean().reset_index()
with t1:
st.caption("Unit Price Trend")
fig1 = px.area(trend_df, x='Week Start Date', y='Revenue (USD)', color_discrete_sequence=['#4e7054'])
st.plotly_chart(fig1, use_container_width=True)
with t2:
st.caption("Customer Satisfaction Trend")
fig2 = px.area(trend_df, x='Week Start Date', y='Satisfaction Score', color_discrete_sequence=['#8e5194'])
st.plotly_chart(fig2, use_container_width=True)
with t3:
st.caption("Average Rating Trend")
fig3 = px.line(trend_df, x='Week Start Date', y='Product Performance Score', color_discrete_sequence=['#77b38d'])
st.plotly_chart(fig3, use_container_width=True) |