Introduction to Loading Data into Teradata
Loading data into Teradata can be done quickly and fairly easily using the Teradata FastLoad utility, but the utility isn’t exactly friendly to new users. This article provides a quick introduction into the FastLoad utility, which is included in the free Teradata Tools & Utilities (TTU) package downloadable from teradata.com. FastLoad can do many more […]
Tableau Tip: Exploring the Built-In Geocoding System
Fresh off a West Coast swing that took me from the Central Valley to Silicon Valley and into San Francisco, I’m back in Oklahoma for Independence Day. This quick blog post explores a question that always comes up during Tableau Training sessions – “What locations can Tableau geocode using the built-in system?” We’re going to […]
Tableau Tip: Using Parameters & Table Calculations to Allow Users to Hide/Show Reference Lines
While in Chicago conducting a training last week a client asked me whether you can offer a hide/show option for reference lines on a published dashboard. My immediate thought was Tableau doesn’t have a native option to support this, but quickly my mind turned to how we can leverage parameters and table calculations to implement […]
Tableau Tip: How to Build a Combination Area Fill & Symbol Map Part 1
Last week, a client in Washington D.C. (and several clients before) have asked me about building combination maps that combine the new filled map style with the symbol map. This is not a Show Me option but is pretty easy to do once you understand the technique. We will be using the Superstore Sales Excel […]
Server Manager.lnk Not Found Windows 2008 R2
The Problem I recently ran into an issue where I was receiving the following error as soon as I logged on to a Windows 2008 R2 server: Windows cannot find ‘C:ProgramDataMicrosoftWindowsStart MenuProgramsAdministrative ToolsServer Manager.lnk’ After navigating to the directory, it was discovered that all the Administrative Tools were missing. Even after navigating to: My […]
Our Basecamp Primer
Basecamp is a project management and collaboration tool that allows all project information to be stored in a single location. Basecamp allows all members of the project, regardless of location, to stay completely connected to the project. This post is meant to serve as a basic primer for our clients (or others interested) on how […]
Self-Service Security in Tableau Server via Outlook Groups
Managing Tableau Server security can be a lot of work, especially when you’re dealing with tons of users from all over the enterprise. Fortunately, Tableau has an easy way to set this up once and let users manage it themselves using Active Directory Groups (aka Outlook Groups). Pre-requisites Tableau Server with Active Directory integration Exchange […]
Multi-Measure Dual Axis Charts
At 27,000ft on the way home from the Big Apple (New York City) with another quick blog post. No mud, barbed wire, or fire pits here, sorry to disappoint. I had a question come in about Multi-Measure Dual Axis Charts and I thought this might make a fun blog post. Before I get to the […]
Seeing Information via Tableau Software
I’m confident the sudden, all-encompassing change in pace for ‘data’ over the last few years has been fueled by our need to want more information out of our world. The immediacy and sheer speed with which it arrives is faster than most of us have been accustomed. This is not to say that the information […]
LTRIM and RTRIM not removing white space
I was writing a query today and came across a set of data with an annoying leading space. Or what I thought was a leading space. My first instinct was to throw this around my field: LTRIM(RTRIM([SKU])) But the space was still there. OMGWTFBBQ! After a bit of googling, I started to wonder if this […]