I'm transitioning our data warehouse from on-premise SQL Server to Snowflake. I have a GIS team that uses Esri products and we needed to be able to ensure that ArcGIS could connect to Snowflake. So this is just a quick little How To. Within your Snowflake instance, you'll need to go the Help menu and... Continue Reading →
Morning People vs Night People
I'm that annoying morning person who pops out of bed, ready to take on the day. My husband needs to hit the snooze button over and over again until I literally pull him out of bed. I'm happy, he's groggy. The day becomes night and we reverse. I need to go to bed early while... Continue Reading →
Tableau join with calculated field
I recently ran into a problem with a join: I had two tables with "customer class" IDs in them, but I needed the description - which was only available for the customer subclass. In a rush, I joined the tables on customer class and filtered the subclass descriptions to one description per customer class. I... Continue Reading →
Perspective
Today, President Trump tweeted out an image of a map with county shapes that looked Republican red. I was curious where this map originated from. There was an article back in 2016 by the Washington Post that provided some perspective. This was by county, the 2016 election results. However, the FLAT red county level map doesn't... Continue Reading →
Tableau Quick Tip: Show ALL Labels
I was trying to play with the hex map concept. But I noticed my state abbreviations were only showing up on a handful of my marks. I discovered that you can simply click on Label in the Marks card and select "Allow labels to overlap other marks": And boom! All labels are now on display.
Trends in Data Management: The Increasing Demand for Product Management
If you had asked me five years ago what direction I wanted to take my career, I am absolutely certain I would not have said product management. Yet here I am, managing a data products team and loving it. Product management wasn’t much of a thing in data five years ago – there were product... Continue Reading →
Trends in Data Management: The Evolution of the Data Producer
I’ve been having discussions lately about data strategies. And, living in London, these conversations often end up in a pub over beer and evolve into philosophical debates on trends in data management, data warehousing, business intelligence, etc. So I thought I’d start a series on the topic and see where it leads. One area that... Continue Reading →
Looking for a…platypus?
Everyone understands the phrase “looking for a unicorn.” Are you that BI engineer with great people skills? “You’re a unicorn!” Are you a data scientist with a talent for visualization? “You’re a unicorn!” But everyone’s really looking for a platypus, that odd combination of duck, beaver, and otter. While looking for a new position last... Continue Reading →
Road Trip with Google Maps
My daughter got accepted to a summer program at MIT for women in engineering. So we thought since we'll already be on the east coast, why not extend the trip into exploring colleges in the Northeast. Now, being from the Pacific Northwest, my geography skills for anything east of the Rockies starts to get a... Continue Reading →
Fill in the Blank
I've climbed Rainier a couple of times and there were a few crevasses we had to cross. Some were just a mere jump, others were wider and had to be crossed with a ladder. Got me thinking about crevasses in data and how you might want to fill in those crevasses with the last known... Continue Reading →