Dashboards

Interactive dashboards by Daniel Sánchez Pazmiño, including a live Ecuador seismic monitor plus Power BI and Tableau economic dashboards from Natural Resources Canada and the Government of Alberta.

← Back to main portfolio page

Business intelligence dashboards and sector profiles built with Power BI and Tableau, plus a couple of custom-built interactive tools.

Sismicidad Ecuador: Live Seismic Monitor

A self-contained, interactive console tracking seismic activity in Ecuador, hand-built in HTML, SVG, and JavaScript with no external libraries or backend. Built as a showcase of EcuDataMCP, the MCP server I built for Ecuadorian open data — the dashboard’s event feed comes straight from it, querying Ecuador’s Instituto Geofísico (IG-EPN) in real time. Plotted against real provincial and cantonal boundaries from geoBoundaries (CC0). Built with Claude Code.

Alberta Spatial Price Index Dashboard

This dashboard was developed during my time at the Office of Statistics and Information, again, a team effort. It visualizes the spatial price index for Alberta, which is a measure of the relative cost of living across different regions in the province, relative to Edmonton.

Screenshot of the Alberta Spatial Price Index Power BI dashboard, showing regional cost-of-living comparisons relative to Edmonton.

Alberta Spatial Price Index Dashboard

Superstore Delivery Time Analytics

I give the classic Superstore dataset a twist by analyzing delivery times instead of sales in this Power BI dashboard. Be sure to turn on maps from your security options in Power BI desktop to see the full functionality of the file.

Screenshot of a Power BI dashboard analyzing delivery times in the Superstore dataset.

Ecuador en la Encrucijada: Shiny App

An interactive Shiny app built for El Quantificador, the data journalism blog of the Ecuadorian Development Research Lab (LIDE). The app allows users to explore macroeconomic indicators for Ecuador interactively.

Screenshot of the Ecuador en la Encrucijada interactive Shiny app showing Ecuadorian macroeconomic indicators.

Clean technology companies in Canada

This is a series of work produced during my time as a Junior Data Analyst in the Clean Technology Economic Analysis Unit team at Natural Resources Canada, which I cannot claim as mine but part of a team effort of highly skilled professionals in NRCan. ### Canadian Pureplay Clean Technology Companies Dashboard

A Power BI Dashboard that visualizes the number of Canadian pureplay clean technology companies across provinces and subindustries in the country.

Screenshot of a Power BI dashboard showing Canadian pureplay clean technology companies by province and subindustry.

Footnotes

  1. It is not possible to openly deploy Power BI dashboards as it is on Tableau or Shiny. However, to visualize this dashboard you only need to download Power BI desktop on your computer, which is free. The only issue is that it is only available for Windows.↩︎