I'm Dean Udsen — an independent data and analytics consultant. I turn scattered, hard-to-reach data into dashboards your team can actually use. Goodbye spreadsheets, copy-paste, and time-wasters.
Analytics, big data, automation — they're all fancy words for one thing: helping you get the information you need, when you need it.
I enjoy solving business problems, from the simple to the genuinely tangled, and building dashboards that hand my clients clear answers quickly and without hassle.
Goodbye spreadsheets, copy-paste, and time-wasters.
Data management means a lot of things to a lot of people. To me it's simple: making sure the best possible data is available to the people who need it, when they need it.
Whether that's cleaning up messy records, integrating data from systems that were never meant to talk to each other, or automating a process nobody enjoys — it all serves one goal: making information accessible.
Cleaning, integrating, and connecting data across systems so the right numbers are ready before anyone asks for them.
Translating fuzzy business questions into clear requirements — and answers your stakeholders actually trust.
Finding the manual exports and the Friday-afternoon spreadsheet — and automating them out of your week.
Power BI and Spotfire dashboards that turn production and financial data into decisions, not homework.
Hands-on sessions that get your team building and reading their own reports with confidence.
Workshops that bring technical and business people to the same table — and the same conclusion.
Across two enterprise data-virtualization platforms, I design and maintain federated layers that turn dozens of disconnected systems into a handful of clean, governed data products. The counts below come straight from the live catalogs.
The same data instincts, off the clock — personal projects where I get to be the source, the modeller, and the consumer all at once.
Replay any race from 2023 on — cars moving round the circuit beside a live leaderboard — dig into every Grand Prix back to 1950, and tinker in an ML workbench for race predictions. All in the browser.
A safety-first deduplication pipeline that inventories local drives and cloud storage, fingerprints everything with dual hashing, and plans every removal before a single file is touched.
An ETL that pulls the public NHL Stats API, flattens nested JSON with pandas, and loads a cloud SQL warehouse — staged as the base for a hosted visualization layer.
A key asset — a rare breed who spans the technical side of data wrangling and many years facilitating a diverse spectrum of data consumers. Dean develops the "quick wins" that make adopting analytics far less intimidating, and quite contagious.
Spotfire lets us bring together disparate data sets and visualize relationships without spending all our time collecting and curating data. The results are easily shared and often spark new ideas. Dean is instrumental in all of that.
By day I'm a data management and analytics consultant. In my spare time, I explore my creativity with a camera.
Surprisingly, the two are more related than they first appear. Applying creativity to code or to a chart is a lot like composing a photograph — there are rules and guidelines, but knowing when to think outside the frame matters just as much.
That's the eye I bring to every engagement: I help clients get the most out of their data by streamlining their processes, automating their tasks, and driving faster business decisions.
For me, photography is the perfect combination of technology and creativity. I can get lost in the camera specs, exposure settings, and tricks of the trade — but it's the resulting images that get me out the door with a camera almost every day.
For professional inquiries, email or call — or connect on LinkedIn. Curious about the photography side? It's just up the page.
Dean Udsen
Data & Analytics Consulting
Independent consulting · est. 2004