Nathan

Data Engineer - @infolabuk | @alteryx ACE, London UG leader & community top contributor | @Databasyx co-founder

[Nathan @DataNath]

Recently put a couple of new #dataengineering blogs on @Databasyx - feel free to check them out and let me know your thoughts!

Different types of materialization in @dbt_labs: https://t.co/1RXUxAOtxg

Creating @databricks secrets with the Databricks CLI: https://t.co/ZwlzHSZ3Oe

[Nathan @DataNath]

Great set up in the Covent Garden Odeon for the @databricks Data & AI summit! Free popcorn and swag? Yes please! #LiveFromTheLakehouse

[Nathan @DataNath]

Posting week 5 separately due to the 4 photo upload limit!

[Nathan @DataNath]

Finished the beginner month (weeks 1-5) of #PreppinData yesterday using #Python. Another great opportunity to get some practice in and starting to feel more comfortable/familiar with syntax and the available functions!

Solutions on my @github: https://t.co/8nYGNvBK9C

[Nathan @DataNath]

Just published my first @Databasyx blog of 2024! This time detailing how you can create grouped record IDs and/or (nominal) ranks in @alteryx Designer.

Feel free to check it out at the following link: https://t.co/lI3EHtX2rB

Here's to more building and blogging this year! 🚀

[Nathan @DataNath]

Slowed right up on the #adventofcode2023 but was great to go back over and complete Day 15!

(Spoilers added to hide workflow).

[Nathan @DataNath]

Caught up with #adventofcode2023 day 10 in @alteryx Designer! Really loving these grid challenges but boy are they a mental workout.

(Spoiler added to hide workflows).

[Nathan @DataNath]

#adventofcode2023 Day 11 completed, once again using @alteryx Designer! These are starting to get pretty spicy now... Need to catch up on yesterday's still!

(Spoiler added to hide workflow).

[Nathan @DataNath]

Day 9 macros.

[Nathan @DataNath]

Forgot to upload but managed to get days 8 & 9 of the #adventofcode2023 completed in @alteryx Designer! Probably going to slow up/fall behind a bit from now as things get busy before Christmas!

(Spoilers added to hide workflows).

[Nathan @DataNath]

Day 8 macros.

[Nathan @DataNath]

Day 7 of the #adventofcode2023 done and dusted in @alteryx Designer! A fun challenge, part 2 was interesting to think about!

(Spoiler added to hide workflow.)

[Nathan @DataNath]

I released a new @alteryx tool yesterday that allows you to apply the functionality of the Text To Columns tool to multiple fields simultaneously. Feel free to check it out here! As usual, any feedback, criticism or requests are very welcome!

https://t.co/KDwlZP8TIB

[Nathan @DataNath]

Day 6 of #adventofcode2023 completed using @alteryx Designer and boy was this a welcome 'break'! Only managed part 1 yesterday so haven't posted that - will give it another crack at some point.

(Spoiler added to hide workflow).

[Nathan @DataNath]

Day 4 of #adventofcode2023 completed in @alteryx Designer! Didn't expect to be cracking out the macros so soon but it looks like this year is already getting fairly spicy. Another nice challenge!

(Spoilers added for obvious reasons).

[Nathan @DataNath]

Days 2 & 3 of #adventofcode2023 done using @alteryx Designer! Some fun workflows to get these done - definitely didn't expect the co-ordinate/grid challenges to be coming out already but it's all fun and games!

(Spoiler tag added so as not to ruin it for anyone!).

[Nathan @DataNath]

Day 1 of the #adventofcode2023 completed using @alteryx Designer! Part 2 threw a bit of a curveball but we do love the challenge!

Spoiler tag added to hide the workflow if you've yet to try!

[Databasyx @Databasyx]

🚨 NEW BLOG LIVE! 🚨

Last week we published a new blog, outlining the inner workings of the SQL Join tool, recently released by @DataNath!

Check out the blog: https://t.co/g7nyH9pU5q
Get the macro: https://t.co/jRCuR1dCmB
Check out the additional info: https://t.co/oEKiFeJodc

[Nathan @DataNath]

@joshuaburkhow Thanks for the love Josh!

[Nathan @DataNath]

@Datajedininja Thanks, Carl! Was a fun one to build out 🙌