phillipsj

# Adventure Works Database on SQL Server 2019
FROM mcr.microsoft.com/mssql/server:2019-CU5-ubuntu-18.04

# Note: This isn't a secure password, and please don't use this for production.
ENV SA_PASSWORD=ThisIsAReallyCoolPassword123
ENV ACCEPT_EULA=Y

# Setting the user
USER mssql

phillipsj

$ python app.py
Dash is running on http://127.0.0.1:8050/

 * Serving Flask app "app" (lazy loading)
 * Environment: production
   WARNING: This is a development server. Do not use it in a production deployment.
   Use a production WSGI server instead.
 * Debug mode: on

phillipsj

import dash
import dash_core_components as dcc
import dash_html_components as html
import plotly.express as px
import pandas as pd
from sqlalchemy import create_engine

app = dash.Dash(__name__)

engine = create_engine(

phillipsj

if __name__ == '__main__':
    app.run_server(debug=True)

phillipsj

app.layout = html.Div(children=[
    html.H1(children='Adventure Works Sales Report'),

    html.Div(children='''
        YTD Sales by Individual.
    '''),

    dcc.Graph(
        id='sales-graph',
        figure=salesFigure

phillipsj

salesFigure = px.bar(df, x="Name", y="SalesYTD", color="Name", barmode="group")
quotaFigure = px.bar(df, x="Name", y="SalesQuota", color="Name", barmode="group")

phillipsj

df = pd.read_sql(query, engine)

phillipsj

query = '''
    SELECT CONCAT([FirstName],' ', [LastName]) as FullName,
        [SalesQuota],
        [SalesYTD]
    FROM [Sales].[vSalesPerson]
'''

phillipsj

engine = create_engine(
    "mssql+pyodbc://sa:ThisIsAReallyCoolPassword123@localhost:1633/AdventureWorks2019?driver=ODBC+Driver+17+for+SQL+Server")

phillipsj

app = dash.Dash(__name__)