Side Projects — ENGR INSIGHT

Beyond the Dashboards

Things I Built Outside of Work.

Small applications and tools built while learning — Python scripts, web utilities, and experiments that don't fit into the main blog. Built to solve a problem or just to see if I could.

// Total

Projects live

sql_export_tool.py — Python 3.11 Live

# sql_export_tool.py — export SQL Server query results to CSV/Excel

─────────────────────────────────────────────

import pyodbc, pandas, argparse

from pathlib import Path

def run_export(query, output, fmt):

conn = pyodbc.connect(CONNECTION_STR)

df = pd.read_sql(query, conn)

if fmt == 'excel':

df.to_excel(output, index=False)

else: df.to_csv(output, index=False)

print(f"✓ Exported {len(df)} rows → {output}")

$ python sql_export.py --fmt excel --out report.xlsx

✓ Exported 9,994 rows → report.xlsx

// Python · CLI Tool

SQL Server → CSV / Excel Exporter

A command-line tool that connects to SQL Server via pyodbc, runs any SELECT query, and exports the result directly to a .csv or .xlsx file. Built because I got tired of exporting data manually from SSMS. Supports connection string config via .env.

Python pyodbc pandas argparse CLI

⬡ View on GitHub → 📄 Read Write-up

WIP

dashboard_validator.html — HTML/JS

<textarea id="daxInput"

placeholder="Paste your DAX measure..."

<button onclick="validate()">Check DAX</button>

</div>

// Checks for: unclosed CALCULATE(), missing VAR RETURN,

// mismatched brackets, and common beginner mistakes.

✓ Syntax looks OK ⚠ 1 warning: missing RETURN

// Web App · HTML / JS

DAX Measure Syntax Checker

A browser-based tool that parses DAX measure code and highlights common mistakes — unclosed CALCULATE(), missing RETURN, mismatched brackets — before you paste it into Power BI. No install needed, runs entirely in the browser. Still in early development.

HTML JavaScript DAX Power BI No Backend

⬡ View on GitHub → ⚠ Not deployed yet

📦

// Coming Soon

Next Side Project

🔧

// In the Pipeline

Another Tool / App

Apps & Tools I've Built.

Things I Built Outside of Work.

Power BI & SQL Blog Posts