← /work— / —
$ cat /work/market-data-analytics-tool.md
industry
Wholesale electricity market operator
region
Türkiye
year
2025
status
●Delivered
# at a glance
Desktop dashboard against a national wholesale market API. Time-series charts, one-click Excel and PDF export, scheduled reporting.
# problem
An operator working with wholesale electricity market data needed a way to query the national transparency API, build views, and export them without rebuilding the same queries each time.
Existing tooling required either Excel hand-work or full BI infrastructure.
# approach
Built on Streamlit with a typed client wrapping the market API endpoints.
Plotly for time-series and price-curve visualizations; openpyxl and fpdf2 for one-click Excel and PDF export.
Local SQLite cache so repeated queries don't re-hit the API.
# outcome
Delivered as a desktop tool runnable from a Windows .bat launcher. Recurring reports moved from manual Excel work to a single screen.
# stack