Building a customized dashboard using SQL Server and Dash. (Part 1: SQL Server)

“Visualization gives you answers to questions you didn’t know you had.” — Ben Schneiderman

Dashboard

Prerequisites

Step1: Downloading tools.

Step2: Downloading the pyodbc module.

Command to install pyodbc

Step3. Creating a connection string.

The syntax for a connection string
Getting details of Database
Actual connection string.

Step4. Creating cursors and executing a query.

Defining Cursor and executing a query.
Code for accessing SQL Server Database.

Bonus Material:

Query with incorrect syntax.
Query with correct syntax.
Getting data as a Pandas Dataframe

Developer with keen interest in everything tech!