digitalDuquette

Data builds clarity. AI amplifies it. You drive it forward.

2026

Feb 26 · 2 min

What Bill Inmon Actually Meant by Integration

We keep landing raw data in warehouses and expecting magic to happen. It doesn’t. Bill Inmon wrote about “integration” as a core principle of data warehousing. Most …

Feb 21 · T-SQL · 2 min

The @push_to_prod Pattern

A practical pattern for SQL Server stored procedures that modify production data: default the write gate to 0, and use the ELSE branch to return diagnostic result sets showing exactly what would change before it does.

Jan 21 · AI, Productivity · 2 min

How Claude Code Fixed My Weekly Review

I skipped my weekly reviews for months. Not because they weren’t valuable, I’ve drunk the kool-aid after all. But staring at a week’s worth of scattered daily notes, …

Jan 19 · Productivity · 3 min

There's Never a Question Where Something Is

A practical guide to using the PARA framework (Projects, Areas, Resources, Archive) to create consistency across all your tools and platforms. The focus is on organizational structure over tool features, showing how the same four folders work in email, notes, and file systems to eliminate the constant question of where you put something.

Jan 12 · Productivity · 4 min

Your Brain Is For Having Ideas, Not Holding Them

A practical approach to getting thoughts out of your head and into systems you're forced to look at. Emphasizes treating yourself like your own customer with SLAs, capturing immediately, and actually processing what you capture. The goal: peace of mind and confidence nothing falls through the cracks.

Jan 9 · AI · 1 min

Agentic Workflows with Markdown

How I automated PR reviews with Claude Code using a simple markdown file. Enforces team standards, catches obvious issues, keeps humans in the loop.

2025

Dec 30 · 1 min

EM Dash Lament

Em dash and spaced en dash, RIP. 1800-2020s

Dec 29 · T-SQL · 3 min

Why I Prefer Temp Tables Over Variables in SQL Server

This is why I structure stored procedures with temp tables instead of variables. It's not about performance. It's not about best practices. It's about getting out of the office on time.

Dec 12 · AI · 5 min

Why AI Projects Fail (and How to Fix It)

I asked ChatGPT about a video game with 23 years of fan documentation. It got basic facts wrong. Then I asked two AI models to audit my own LinkedIn profile—and they both confidently told me my job title was wrong. The problem isn't AI. It's how we're using it.

Dec 6 · 5 min

From Dashboards to Data Platforms: How My Work Has Evolved

I went from building dashboards to leading teams. From Tableau Server administration to architecting data platforms. From asking "what chart should this be?" to asking "what problem are you trying to solve?"

2019

Nov 5 · Tableau · 4 min

Tableau Conference Survival Guide

Visiting Vegas this year will be my third Tableau Conference and second for the core Analytics department at PADNOS. Here is a little that I’ve learned along the way and …

Jun 14 · 2 min

Communicating 2019.2 Server UI Changes to your team

With the new changes coming to Tableau Server 2019.2 user interface, I need a method to communicate the UI changes. I didn’t want my users to come in on Monday morning …

May 17 · 1 min

Building an Analytics Culture

I was fortunate enough to be asked to present at a breakout session during the Grand Rapids IT Symposium downtown Grand Rapids on Wednesday, May 15th, 2019 — excellent …

Apr 3 · #WorkoutWednesday, Tableau · 1 min

Dynamic Stock Prices and Overcoming Challenges

Have you ever wanted to create a dynamically scaling range of dates to display data? This viz shows DATA stock prices through time, aggregated to month, week, or day, …

Mar 23 · Tableau, Design · 1 min

Barchart Bakeoff: To Radial or Not to Radial

#MakeoverMonday week 12 2019 takes a look at how we really feel about women leaders, presenting the findings in a radial bar chart: far too close to a pie chart for …

Mar 22 · #WorkoutWednesday, Tableau · 1 min

Tracking customer retention with Tableau

Are you stuck on solving #WorkoutWednesday2019 week 12? This week expanded my understanding of the Tableau Order of Operations found here. Checkout the video below to …

Mar 19 · 1 min

PostgreSQL in Azure Data Studio!

Today is a great day. Azure Data Studio, one of my top applications for day-to- day work, received an amazing March 2019 update. PostgreSQL support Query Plan viewer Dark …

Mar 14 · #WorkoutWednesday, Tableau · 1 min

#WorkoutWednesday2019 Week 11 - Quick Tips

🤯 Quick Tips This week I put together a video on some quick tips to completing this challenge. #WorkoutWednesday2019 Week 11 Click to view the completed submission Video: …

Mar 14 · Tableau Tips, Tableau · 1 min

Explain your #DataViz like a pro!

Looking to add explanations or more information bubbles to your viz but not sure how to go about it? Checkout out this #TinyTableauTip to explain how you can quickly make …

Mar 8 · Tableau Tips, Tableau · 1 min

#TableauTip Easy KPI Trends

Easy KPI Trend Marks Paste the following into the custom pallet for numbers to bump up your KPI power. ▲ 0%;▼ 0%;▬ View fullsize

Mar 7 · Presentation, Tableau · 1 min

Containers and KPIs - #WMTUG demo workshop

Thanks to all the participants and presenters for the March 2019 WMTUG. Shoutout to Nolan for keeping this TUG together and to Greg for giving me the motivation to put …

Feb 26 · Tableau Tips · 1 min

Tableau Tips: Using data formatted for other countries in Tableau

This weeks #MakeoverMonday features data in values from the United Kingdom, where date format and currency value are measured and recorded differently. I noticed on …

Jan 3 · #WorkoutWednesday, Tableau · 1 min

#WorkoutWednesday 2019 Week 1 - Now with video!

Challenge one for 2019 is in the bag! This week I recorded my processes of solving week one from data prep to formatting. The YouTube clip is a little over 30 minutes …

2018

Dec 31 · Tableau · 2 min

Let's Talk Data - #DataFam Discord

View fullsize UPDATE The Tableau Community loves Twitter. After discussing with the greater community, Twitter DMs and Zoom meetings are the way to go. I love talking …

Dec 30 · Tableau, Tableau Tips · 2 min

Tableau Tips: Dates by Week

Tableau handles the use of dates organized by week different from day, month, year. To bring some control and transparency to the process of handling dates, using custom …

Dec 28 · #WorkoutWednesday, Tableau · 5 min

#WorkoutWednesday 2018 Week 52

Whenever I’m presented with a visualization design that I’ve never seen before I react in one of two ways: total confidence or total bewilderment. This week, I was firmly …

Dec 28 · Presentation · 1 min

Building an Analytics Culture

Building an Analytics Culture Presentation at the Dec 13, 2018 ITMA meeting on data analytics in Grand Rapids, MI. Download Deck Download the slide deck from ITMA …

Dec 12 · Tableau, #WorkoutWednesday · 2 min

#WorkoutWednesday 2018 Week 50

#WorkoutWednesday (WoW) week 2 in the bag! Part of my daily responsibilities is to review and approve publication requests from our development server to our production …

Dec 9 · Tableau, #WorkoutWednesday · 3 min

My First #WorkoutWednesday

I learned some lessons from #TC17: take your time. There is so much to do and absorb at conference that rushing in and out devalues the experience. This year, we took …

2017

Jul 19 · Tableau, Presentation · 1 min

West Michigan Tableau User Group (WMTUG) Presentation on tabcmd

To download the slide deck from the July 19, 2017 WMTUG presentation on tabcmd, click the button below. Download Deck

Feb 25 · Tableau, Tableau Tips · 7 min

Drill Deeper: Mapping Geolocation in Tableau

Tableau maps address information by ZIP. When your organization needs more detailed mapping of addresses, show off your skills with Google Geolocation API, VBA, and Excel.

Feb 18 · Tableau, Server Admin · 3 min

Using tabadmin to Clean House and Free Storage Space

Use Tableau tabadmin to Clean House and Free Storage. Using this script you can leverage the power of tabadmin cleanup by pipping a highly verbose output into a daily log file as part of regular Tableau server maintenance.

Feb 10 · T-SQL · 2 min

Using T-SQL To Validate and Convert a FLOAT to DATETIME

You don't always get to choose your production software. Anytime a professional software product stores a date as a float it seems like someone should get a good scolding. There are rare occasions where a float is a necessary design decision, but that doesn't make it mean you need to enjoy working with that database.

Feb 8 · Tableau Tips, Tableau · 1 min

Tableau Tips: Combine Strings to Create A Date Field

Connecting Tableau to data sources in Excel can introduce areas of inconsistencies in data formatting and validation. For example, when connecting to an Excel workbook …

Feb 2 · Tableau Tips, Tableau · 1 min

Tableau Tips: Exclude Current Month and Year

One frustration many Tableau users face on a regular basis is graphing transaction records as they occur by date. When comparing a graphical representation of …

Jan 25 · Tableau · 4 min

Sending PDF Tableau Dashboards Automatically Through Your Organization

Tableau natively supports sending dashboards to users through a subscription model. There are two downsides to this: (1) the recipient must have a Tableau license and (2) …

2016

Feb 1 · 1 min

Transmit: FTP Client for OS X

I’m taking a class this winter on web development. Things have changed a bit since I last did HTML work in 2004. One thing that hasn’t, is FileZilla. This was the …

2014

Oct 11 · 3 min

Programming Problems: Digits of an Integer

_Programming Problems is a recurring segment where I explain and explore assignments covered in introductory programming for C#. If I can explain it, then I know it. _ …

Sep 29 · 1 min

Shellshocked? Me too, try 1Password

Quick note out there: Shellshock is serious. Heartbleed was serious. Take the time to invest in your online life and check out 1Password. “This week, a very dangerous …

Sep 28 · 6 min

Programming Problems: Get and Set with C#

This was the first question and first program homework for C#. No background in code. Trying to wrap my head around privative variables, class, using constructors, and …

2013

Nov 27 · 1 min

What's In Your Bag?

I open my bag and heart to show my everyday gadgets and accoutrements View fullsize What’s In Your Bag, Jared Duquette? What’s In Your Bag, Jared Duquette? I carry my bag …

Sep 9 · 2 min

Classic

What’s in my bag? There’s a myriad of treasures. Some large, some small, some expensive, and some serve more of a purpose than others. Of this collection of dear-and-near …