Advertisement ยท 728 ร— 90

Posts by Andy Nelson

That's awesome ๐Ÿ˜Ž

10 months ago 1 0 0 0

Why can't you test against the current schedule vs a delayed schedule?

1 year ago 0 0 1 0

Who's your favorite philosopher?๐Ÿ˜‚

1 year ago 1 0 1 0

Sorry to be 10 year late on the discussion

1 year ago 1 0 0 0

I'm reading there's controversy on putting satellites on links in data vault. Curious if #databs has any opinions on the matter.

1 year ago 1 0 3 0

Thanks Shane

1 year ago 1 0 0 0

Looking for data vault 2.0 training recommendations. Gotta be pre-recorded or remote. #databs

1 year ago 0 0 1 0
Advertisement

Never give up, never surrender ๐Ÿ’ช

1 year ago 1 0 0 0

Bet that baby could possibly handle my 25 left joins I write.

1 year ago 1 0 0 0

Paradime has AI tools for dbt. I haven't used them, sorry.

1 year ago 0 0 0 0

Although one of the best, probably also the most boring exercise machine ever produced by Man

1 year ago 0 0 0 0

I think I'm your target demographic Timo. Our team is trying to put sunset clauses on new adhoc pipelines and dashboards so at least we don't support things indefinitely.

1 year ago 2 0 1 0

Honestly I think accumulating snapshots are underutilized. #databs

1 year ago 1 0 0 0

Thanks for the reply Shane. But that's where I disagree with the author. I feel like I the data warehouse we can apply transformations for analytical purposes only. If there are 200 transaction codes and we put them in 5 buckets that aren't represented in the application layer, what's wrong with it?

1 year ago 0 0 0 0
Preview
Data Engineering, Redefined How data engineering is practiced today and why we should redefine it

Not sure I understand this article. I wish the author gave examples of antipaterns of Data Engineers building business Logic in the data warehouse. I assumed unless if your doing reverse ETL the application layer needs to maintain their own business Logic. towardsdatascience.com/data-enginee...

1 year ago 1 0 1 0

Yeah I enjoyed his book. He uses some patterns from data vault without the complexity of full blown data vault.

1 year ago 1 0 0 0
Advertisement

I've been influenced by Roberto Zagni's pragmatic data platform approach. I like the patterns he uses. youtu.be/OYrbg5q-CHo?...

1 year ago 3 0 1 0

sadly I have to agree with you Matt. Not sure why Inmon is framing Kimball's approach as just data marts.

1 year ago 1 0 0 0
Post image

Chapter 2 of Adamson's Star Schema covers this well. Both authors are pragmatic and allowed flexibility in their approaches. Lots of misconceptions in this space.

1 year ago 2 0 0 0

Nobody doing data contracts lol

1 year ago 0 0 0 0

I really am falling in love with array_agg(). I'm scared to think that my end game is me flattening and reconstructing json objects. #databs

1 year ago 7 0 0 0
Post image

Reading this now. #databs

1 year ago 4 0 0 0

Agreed Joe. More so than reading books (which I highly recommend). I think we need repetitive practice in our industry. I take inspiration from web developers who can build simple websites over a weekend. Many data professionals are not getting their reps in. My $.02.

1 year ago 1 0 0 0

Ultimately, I provide dopamine to executives. They like seeing numbers on a screen.

1 year ago 0 0 0 0
Post image

Finished these two. Really enjoyed Star Schema. Data Modeling Storytelling has some good advice too #bsdata

1 year ago 2 0 0 0
Advertisement

I'm interested. I work in finance reporting. We take scd2 and date explode them and build periodic snapshot tables. Curious how others deal with them.

1 year ago 0 0 0 0

Really like it's ability to be a "glue" database. Read directly from postgres, s3, parquet, csv , json, pandas dataframes, http urls. As a data engineer I like to sample data before building automated pipelines.

1 year ago 6 0 1 0

Big fan or buying discarded corporate laptops, install SSD drive, and installing Ubuntu or Fedora. Give old tech new life.

1 year ago 1 0 0 0
Post image

In data warehousing, edit, publish, but don't manufacture. #databs

1 year ago 1 0 0 0
Post image

Thanks for uploading so much material. Learning a ton. @eczachly.bsky.social

1 year ago 2 1 0 0