The Dunleavy Organization
Data · Analytics · Digital Delivery
The Dunleavy Organization
Data · Analytics · Digital Delivery
An interactive stock market dashboard for roughly one hundred equities and ETFs — built end to end from daily data ingest through a live view on this site. Earlier work used Microsoft Fabric and Power BI for a single-stock report; the current product runs on a stack I operate day to day.
An early build used Microsoft Fabric and Power BI for automated AAPL daily bars. That demonstrated cloud Microsoft analytics delivery, but trial capacity and a single-stock scope limited it as an ongoing public demo.
Outcome: a stock market dashboard covering roughly one hundred equities and ETFs, with nightly data refresh, a private SQL Server on the workstation, and overview, detail, and compare views on this site. Only a controlled public snapshot is published to the web — the database itself stays private (normal for a system of record).
Earlier Fabric and Power BI work remains the proof path for that stack; the multi-ticker product is what visitors open today.
Interactive preview below (scroll inside the panel for Detail and Compare). For the full-page experience — site header, room for charts, and page scroll — use Open full page.
The same product idea, built twice — cloud Microsoft tools first, then a durable stack under my control.
| Earlier — Fabric & Power BI | Current — live product | |
|---|---|---|
| Scope | AAPL-focused | ~100 tickers (indices, sectors, mega-caps) |
| Pipeline | Fabric schedule, lakehouse, notebooks | Python ingest and SQL Server upsert |
| Dashboard | Power BI report | Interactive dashboard on this site |
| Public presence | Screenshots and GitHub project | Live product page and project page |
| Operating model | Trial and capacity dependent | Hardware and hosting I already operate |
The system of record stays private. The public site only receives a published snapshot and the dashboard interface.
flowchart TB A["Massive.com API"] --> B["Nightly Python pipeline"] B --> C["Private SQL Server"] C --> D["Published JSON snapshot"] D --> E["Dashboard on this site"]
Credentials and the database stay private. Visitors only receive market data and the dashboard interface.
Database: private SQL Server on the development workstation. Not exposed as a public endpoint; the site serves a published snapshot only.
Public site: Cloudflare Pages on this domain. The dashboard UI and published JSON ship with the site.
Automation: a scheduled nightly job loads data, prepares the public snapshot, and updates the live dashboard.
Selected for reliability, multi-ticker scale, and a public demo that stays available.
| Layer | Choice | Why |
|---|---|---|
| Ingest | Python and Massive.com API | Reliable daily bars; overnight batch |
| Database | SQL Server with upsert by ticker and date | Safe re-runs; Microsoft-friendly |
| Public data | Published snapshot files | No open database; bounded history on the web |
| Dashboard | HTML, CSS, JavaScript, charts | Interactive filters; static hosting |
| Earlier path | Fabric, lakehouse, Power BI | Cloud Microsoft analytics proof |
| Schedule & deploy | Task Scheduler, PowerShell | Same ops pattern as other properties |
Ready to open the live dashboard?
Brief project notes are enough — I reply by email.