Nanaimo, BC · Remote across Canada
Data Analytics Consultant in Nanaimo, BC
I'm Trevor Heshka, a data analytics consultant and full-stack developer in Nanaimo, BC. Through Hesh Co. I turn messy data into searchable, charted and mapped web apps, with AI summaries where they help. My live examples cover real estate, City of Nanaimo bylaws and BC court lists, and I work with any kind of business or public data.
What I do
- Collect data from public sources, spreadsheets, files and APIs
- Clean, structure and migrate data into SQL databases
- Searchable data apps and dashboards with charts
- Map-based views of regional and location data
- AI-written summaries and LLM apps on top of your data
- Sign-in and role-based access for internal data portals
- Hosting and automated updates (IIS, Firebase, Cloudflare Workers/R2, GitHub Actions)
- Plain-language explanations of what the data shows
Examples: real estate, bylaws and courts
- BC Real Estate Market Pulse — map-based regional real estate market data, charts and AI-written summaries across BC boards.
- Nanaimo Bylaw Tracker (Nanaimo City Portal) — searchable City of Nanaimo bylaws, amendments and Council activity built from public data.
- BC Court List Archive — search archived British Columbia daily court lists by name or court file number.
More on how these were built: Building public-data apps for BC. All live builds are on the projects page.
Who it's for
Businesses, organizations and teams in Nanaimo, on Vancouver Island and across Canada that have data in spreadsheets, websites, PDFs or systems and want it searchable, charted, mapped or summarized. Real estate is one example; civic and legal data are others.
Hiring a data analytics consultant in Nanaimo
If you are looking for a data analytics consultant in Nanaimo, BC, the first question is usually what you get at the end. With me it is a working web app, not just a report: your data collected from spreadsheets, PDFs, websites or APIs, cleaned into a SQL database, and shown as search, charts and maps your team can open in a browser. I'm local to Nanaimo, so small businesses and organizations on Vancouver Island can meet in person, and I work remotely across Canada.
How does data analytics help real estate? BC Real Estate Market Pulse pulls regional market data into one map-based view with charts and AI-written summaries, so trends across BC areas can be compared at a glance instead of read board by board. How does it help municipalities and the public? The Nanaimo Bylaw Tracker turns City of Nanaimo public data on bylaws, amendments and Council activity into something residents can search, and the BC Court List Archive does the same for daily court lists. I also served two years on the City of Nanaimo Parks and Recreation committee, so I know how civic decisions and records move.
For a small business, data analytics consulting often starts smaller: combining sales, customer or job records that live in separate spreadsheets, building a simple dashboard, or adding sign-in so only the right staff see it. I build it, host it, and explain in plain language what the numbers show.
Why work with me
I've worked in customer-facing technical support since 1998 and now build and deploy full-stack data apps through Hesh Co. I handle the whole job: getting the data, cleaning it, building the app and keeping it running. See also full-stack development and AI and LLM development.
Contact or get a quote
Pricing: contact for a quote. Email trevor@trevorheshka.com with a short description of what you need, where you are, and when it suits you. I'll reply to set up a call, a remote session or an on-site meeting. You can also reach me on LinkedIn.
FAQ
Who is a data analytics consultant in Nanaimo, BC?
I'm Trevor Heshka, a Nanaimo-based developer and the founder of Hesh Co. I build data apps that collect, clean, search, chart and map data, such as BC Real Estate Market Pulse, the Nanaimo Bylaw Tracker and the BC Court List Archive. I work on site in Nanaimo and remotely across Canada.
Is your data analytics work only for real estate?
No. Real estate is one example. I also built a bylaw and council tracker for the City of Nanaimo's public data and a searchable archive of BC daily court lists. The same approach works for other business, public or operational data.
What tools do you use for data analytics?
SQL and Python for collecting and cleaning data, JavaScript/TypeScript, React and Node.js for dashboards and search, interactive maps, and Firebase, IIS and Cloudflare Workers/R2 for hosting.
Can you add AI to a data app?
Yes. BC Real Estate Market Pulse includes AI-written market summaries, and I build and fine-tune custom LLM models and build LLM apps on top of a client's data.
How can data analytics help a municipality or real estate business?
It turns scattered records into something people can search and compare. My Nanaimo Bylaw Tracker makes City of Nanaimo bylaws, amendments and Council activity searchable from public data, and BC Real Estate Market Pulse maps regional market data with charts and AI-written summaries.
What does a data analytics consultant do for a small business?
I collect data from your spreadsheets, files, websites or systems, clean it into a SQL database, and build a web dashboard with search, charts or maps, with sign-in so only the right people see it. Then I host it and explain what the numbers show.
How much does data analytics consulting cost?
Contact for a quote. Cost depends on the data sources, the volume and what you need at the end. Email trevor@trevorheshka.com with a short description.
Do you work remotely?
Yes. I work remotely with clients anywhere in Canada and can meet on site in Nanaimo, Lantzville, Parksville, Ladysmith, Duncan and the Comox Valley.