audit-labs/audit-tools

 1"""
 2Extensible dashboard for project status.
 3"""
 4
 5# Import packages
 6import pandas as pd
 7import plotly.express as px
 8from dash import Dash, dcc, html
 9
10# Incorporate data
11df = pd.read_excel("project_data.xlsx")
12
13# Initialize the app
14app = Dash()
15
16# App layout
17app.layout = [
18    html.H1(children="Project Dashboard", style={"textAlign": "center"}),
19    html.Div(
20        children=[
21            dcc.Graph(
22                figure=px.histogram(
23                    df,
24                    x="Preparer",
25                    color="High Priority?",
26                    title="Control Count by Preparer",
27                ),
28                style={"flex-grow": "1"},
29            ),
30            dcc.Graph(
31                figure=px.histogram(
32                    df,
33                    x="Preparer",
34                    y="Projected Hours ",
35                    color="Status ",
36                    title="Project Hours by Preparer",
37                ),
38                style={"flex-grow": "1"},
39            ),
40        ],
41        style={
42            "display": "flex",
43            "flex-wrap": "wrap",
44            "justify-content": "space-between",
45            "align-items": "center",
46        },
47    ),
48    dcc.Graph(
49        figure=px.pie(
50            df,
51            values=df["Preparer"].value_counts().values,
52            names=df["Reviewer"].value_counts().index,
53            title="Reviewer Breakdown",
54            hole=0.5,
55        )
56    ),
57]
58
59# Run the app
60if __name__ == "__main__":
61    app.run(debug=True)