Elliott Stam

Sharing knowledge and experiences while developing data products

[Elliott Stam @elliottstam]

Oh no, not another data engineer vs analytics engineer post... 😇https://t.co/XJhYUcOSBo
#dataengineering #data

[Elliott Stam @elliottstam]

Sometimes you butt heads with colleagues. Will it be a shit show, or can you squeeze something good out of it?

Navigating disagreement and miscommunication between engineers https://t.co/ihntpxXlgk

[Elliott Stam @elliottstam]

For the aspiring #SQL wizards, you've got to get your hands on common table expressions. They'll dramatically improve the long-term value your queries bring to the table.

Substack post: https://t.co/Hdmi4qvpvE

[Elliott Stam @elliottstam]

@ktfontnowagner Had a nightmare with Europcar Norway trying to gank over 1000 euros in damages from us. We ended up winning our dispute, but whoever you rent from take tons of pictures when you rent and definitely use your US credit card because they had our backs through the dispute process.

[Elliott Stam @elliottstam]

For fun, I built an automated trading system based on the Gemini Exchange (cryptocurrency).

The system got choked up during the latest market drop. Tune into this #devyx video if you want to see how I'm using #tableau to get ideas on future improvements!

https://t.co/rNGp6j70mk

[Elliott Stam @elliottstam]

@rlvanessagrant Piling on here, let's use a real-ish example.

Say I run a store. Whenever a customer buys from me, we save some data into a database: item name, price, etc.

My data describes the transactions, and metadata describes my data: how many rows, table name, column names, etc.

[Elliott Stam @elliottstam]

Curious what a scorecard dashboard in #tableau looks like with real world data? Stretch your legs and take a break from that "superstore" data.

Here's one I put together to help keep track of trades made by an automated trading system:

#devyx
https://t.co/rsMmZCt3Cr

[Elliott Stam @elliottstam]

Been cracking out hard for months building an automated trading system that buys and sells cryptocurrency.

Ever flirted with the idea? In this video we're diving into #tableau to visualize some real trading decisions the system has made. #devyx

https://t.co/SiSZ9pHtiL

[Tableau @tableau]

Learn and get inspired by all the work from the Tableau Community.

🎉 The latest #DataFam Roundup is now live! https://t.co/BI8KCG3QVE

[Elliott Stam @elliottstam]

No joke, this was a picture sent to me when I asked what justified the charges for damages. Since then they decided more damages exist and additional invoices have inflated to over 900 euros.

[Elliott Stam @elliottstam]

If anyone has experience handling wild charges from Europcar, please let me know. Two months after the rental they decided there are "new damages" and sent an invoice for over 900 euros. Other than never doing business with them again, any advice?

[Elliott Stam @elliottstam]

This week's progress on the automated crypto trading system:
1) automation around training buy and sell models
2) parameter tuning for XGBoost models
3) improved Tableau visuals (includes actual close price)

Come nerd out with me:
https://t.co/S4FyR8nht5

[Elliott Stam @elliottstam]

Building an automated trading system is one hell of a time-consuming hobby, and there's a ton of room for improvement in what I currently have.

This week's #devyx update is diving into initial simulation results for when the system would sell:
https://t.co/NZ37sTE1N8

[Elliott Stam @elliottstam]

In this video we're diving into the results of a model I've been working on to predict good entry points into the crypto markets.

If you like this stuff, more is coming... up next we'll be predicting attractive sell points. From there? Who knows. #devyx

https://t.co/j7KngUQZVn

[Elliott Stam @elliottstam]

For a while now I've been cracking out on developing an automated trading system. The first version was deployed to a cloud server and just ran 24/7 using crazy stupid rule-based logic.

Finally now a proper data pipeline is coming together!
https://t.co/eFizS02In0

[Elliott Stam @elliottstam]

If you're slipping into a Thanksgiving food coma, it's a perfect time to check out this #devyx tutorial video on saving time with formatting in Tableau.

This is for the #datafam pros out there duplicating worksheets for KPI indicators in their dashboards:
https://t.co/BotOfBKA6j

[Elliott Stam @elliottstam]

I was blending data IRL the other day and decided to spin it into a #devyx tutorial video on how to blend and join data in Tableau Desktop.

Tune in to see how you can define data relationships and joins! #DataDev

https://t.co/LTAQwSRvQT

[Elliott Stam @elliottstam]

@ZachBowders @SimonBeaumont04 I'm going to think of this as the "why the F not" plot.

[Elliott Stam @elliottstam]

Scratching your head on how to download the summary data for all visuals in a #Tableau dashboard?

Check out the latest #devyx tutorial to scratch that itch. We'll be using Python and the Tableau REST API to tackle this use-case #DataDev style.

https://t.co/b7BFuDc3nc

[Elliott Stam @elliottstam]

@illonage @_Lorna_Brown @vizsmart @tableau @OReillyMedia @AnnUJackson @lukestanke @andre347_ I haven't seen any, either. Plenty of dashboarding books, but can't say I've seen any touch on squeezing the most value from the Tableau APIs.