tayloramurphy Profile Banner
Taylor A Murphy Profile
Taylor A Murphy

@tayloramurphy

Followers
7K
Following
26K
Media
2K
Statuses
13K

Founder & CEO @archdotdev | maintainer: @meltanodata | prev: Data @GitLab @ConcertGenetics| PhD @VanderbiltU | Paid Data Actor/Influencer | Husband and Dad(x2)

DFW, Texas, USA
Joined April 2011
Don't wanna be here? Send us removal request.
@tayloramurphy
Taylor A Murphy
2 years
dashboards are astrology for execs.
34
375
3K
@tayloramurphy
Taylor A Murphy
5 years
Sure, machine learning is fun, but have you ever written a function that delivers business value, is well tested, and can be iterated on by your colleagues?.
28
102
873
@tayloramurphy
Taylor A Murphy
4 years
How is it 2020 and I can't do. SELECT *.EXCEPT column1, column2.FROM table. 😤.
21
46
706
@tayloramurphy
Taylor A Murphy
4 years
Let's just say, for a moment, let's just say, @benshapiro should watch this.
@SomeMoreNews
Some More News
4 years
Hi. Here is the latest episode of #SomeMoreNews with @drmistercody. Link: Produced by @katystoll. Written and Directed by @will_gordh. Edited by @greggmeller.
Tweet media one
8
54
599
@tayloramurphy
Taylor A Murphy
5 years
Talked with a buddy of mine about doing a consultancy where we just convince people they don't need machine learning. Massive market.
20
68
608
@tayloramurphy
Taylor A Murphy
4 years
give someone a dashboard and you'll disappoint them for a day. teach someone SQL and they'll disappoint themselves for a lifetime.
5
59
471
@tayloramurphy
Taylor A Murphy
5 years
Dear data, what's preventing you from looking like this?
Tweet media one
24
53
451
@tayloramurphy
Taylor A Murphy
4 years
got some new stickers! thanks @SomeMoreNews 🔥
Tweet media one
0
25
375
@tayloramurphy
Taylor A Murphy
4 years
This is .10% bash,.20% SQL,.15% manual editing in Excel,.5% Python,.50% Stack Overflow,.and 100% reason to just hire a data engineer.
5
47
389
@tayloramurphy
Taylor A Murphy
2 years
data analysts when they deliver a dashboard and the stakeholder says "how come these numbers don't match my excel??"
Tweet media one
7
26
306
@tayloramurphy
Taylor A Murphy
2 years
oh boy do I have a candidate in mind: @ryxcommar
Tweet media one
2
5
286
@tayloramurphy
Taylor A Murphy
4 years
@MNateShyamalan @deadeyebrakeman 👆👆👇👆👈👉👆👆. tHiS.
1
1
256
@tayloramurphy
Taylor A Murphy
2 years
working in data is great. any question can be met with one of these:. - it's complicated. - it depends. - we don't have that data.
9
16
259
@tayloramurphy
Taylor A Murphy
2 years
sure your data tool has export to csv, but does it have this??
Tweet media one
16
13
265
@tayloramurphy
Taylor A Murphy
3 years
the only way you're getting a date is if you cast it from a varchar.
5
13
237
@tayloramurphy
Taylor A Murphy
3 years
welcome to the data team!. we report up to the cfo. sorry, IT says no to this "dbt" package. all the data is in excel. ask Dave for access
Tweet media one
7
15
237
@tayloramurphy
Taylor A Murphy
4 years
BREAKING: All my data pipelines.
1
17
210
@tayloramurphy
Taylor A Murphy
4 years
you'll never convince me that data engineering isn't just digital plumbing. nobody cares until it breaks, it's expected to just work, it literally gives you a critical resource and removes shit from your life, it's a huge pain in the ass, and everyone balks at the pricetag.
9
18
200
@tayloramurphy
Taylor A Murphy
3 years
SELECT *???. in this economy??.
4
18
195
@tayloramurphy
Taylor A Murphy
3 years
can you even say you've worked in data if you haven't rapidly moved your eyes back and forth between two tables to find the difference so you didn't have to write the sql?.
8
11
199
@tayloramurphy
Taylor A Murphy
3 months
@drvolts I'm reminded of this article
5
20
181
@tayloramurphy
Taylor A Murphy
3 years
ah yes, the well-known fact that having clean data is both quick to do and useless.
@frasergeorgew
George Fraser
3 years
If you don’t laugh you’ll cry: this company decided they need data visualization and BI, but none of that “data warehousing” malarkey.
Tweet media one
15
26
180
@tayloramurphy
Taylor A Murphy
3 years
I'm going to start a data consulting firm and call it "No Code Data". we just talk you out of your bad data ideas. literally no code.
10
15
174
@tayloramurphy
Taylor A Murphy
4 years
my data superpower is doing the shit grunt work necessary to make things look really good. my tolerance for doing tedious manual cleaning is higher than it should be, but it gets results.
5
7
170
@tayloramurphy
Taylor A Murphy
2 years
I want some data demotivational posters. JSON - When you're too lazy to actually think about your data model. Snowflake - When you want to screw over your future CFO. Data Science - When you make a basic chart in Excel but want to be paid more. 😈.
12
9
170
@tayloramurphy
Taylor A Murphy
3 years
are you really struggling to learn SQL OR are you just HAVING trouble knowing FROM WHERE to SELECT the best resource?.
9
7
158
@tayloramurphy
Taylor A Murphy
3 years
I need to they need the.clean the data dashboard now. ( •_•) (•_• ). ( ง )ง ୧( ୧ ). /︶\ /︶\.
2
12
156
@tayloramurphy
Taylor A Murphy
3 years
machine learning idea: give it stock market data and have it tell me when to buy and sell. can't believe no one has done this.
7
9
155
@tayloramurphy
Taylor A Murphy
3 years
it's not Excel, it's "artisanal analytics done the old fashioned way".
6
29
144
@tayloramurphy
Taylor A Murphy
4 years
me: no data ever enters the same warehouse twice, for it is not the same warehouse and it not the same data. them: sooo is the dashboard up to date or what?.
2
15
144
@tayloramurphy
Taylor A Murphy
4 years
we're all just rows in a database.
16
11
139
@tayloramurphy
Taylor A Murphy
3 years
this year I will be taking part in Novimber (pronounced "No-vim-ber") where I will not be using Vim, which will then continue for the next month and every month thereafter.
8
9
129
@tayloramurphy
Taylor A Murphy
4 years
It's not a data warehouse, it's a data 𝘤𝘢𝘳𝘦house.
4
8
119
@tayloramurphy
Taylor A Murphy
3 years
Tweet media one
1
6
120
@tayloramurphy
Taylor A Murphy
6 months
we are so back
Tweet media one
5
0
127
@tayloramurphy
Taylor A Murphy
4 years
CEO: We're data-driven. The Data:
4
19
121
@tayloramurphy
Taylor A Murphy
3 years
data activation. my brother in christ you are replicating data from one table to another.
5
9
114
@tayloramurphy
Taylor A Murphy
2 years
@pdrmnvd @dril you must live with your shame 🔔🔔🔔.
0
0
107
@tayloramurphy
Taylor A Murphy
2 years
this is pretty evil from databricks
Tweet media one
11
4
109
@tayloramurphy
Taylor A Murphy
4 years
Excel is just chaos engineering for data teams.
4
17
108
@tayloramurphy
Taylor A Murphy
4 years
SQL is poetry you write for your data.
7
14
102
@tayloramurphy
Taylor A Murphy
4 years
.@emilieschario and I finally published our follow-on blog post to the @coalesceconf talk we gave last year! Thanks @LocalOptimistic for having us! We're pretty proud of this one.
2
18
109
@tayloramurphy
Taylor A Murphy
4 years
The future of "no code" are tools that make it easy to do something w/o writing code but then allow you to punch through to the actual code when you need to.
15
7
107
@tayloramurphy
Taylor A Murphy
3 years
as a data engineer, i want to click "Request a Demo" to learn more about your product, so that I can create an entry in your Leads object.
6
3
106
@tayloramurphy
Taylor A Murphy
3 years
I still maintain that the best data diff method is a combination of rapidly moving your eyes between datasets and alt tabbing between windows.
5
6
102
@tayloramurphy
Taylor A Murphy
4 years
SQL Clause is coming to town! 🎅🎄
Tweet media one
4
8
91
@tayloramurphy
Taylor A Murphy
4 years
me about to run "select count(*)" using a 4XL warehouse on a table with < 1M rows
Tweet media one
4
2
95
@tayloramurphy
Taylor A Murphy
4 years
I'm beyond excited to announce that I will be joining @meltanodata! . I believe Meltano is on a fantastic path right now and I'm eager to join and help drive the project. A couple of reasons why I'm excited. short 🧵👇.
16
4
92
@tayloramurphy
Taylor A Murphy
3 years
dbt stands for data boi taylor
Tweet media one
8
1
91
@tayloramurphy
Taylor A Murphy
3 years
you need DataOps so you don't make a DataOops.
3
7
86
@tayloramurphy
Taylor A Murphy
4 years
The "Head of Data" role implies the "Body of Data" role 🧐.
8
7
96
@tayloramurphy
Taylor A Murphy
4 years
"you have to respect other people's opinions". their opinion:
Tweet media one
6
4
91
@tayloramurphy
Taylor A Murphy
2 years
forget dbt vs sql mesh. this is the real battle
Tweet media one
9
5
94
@tayloramurphy
Taylor A Murphy
4 years
😍
Tweet media one
2
15
93
@tayloramurphy
Taylor A Murphy
4 years
@meltanodata
Meltano: the data integration engine
4 years
Today we're excited to announce that Meltano is an independent startup and we've raised a $4.2M Seed round to enable us to bring data integration into the DataOps era! 🎉 Check out our blog post for more details on what this means for us and the community
6
3
88
@tayloramurphy
Taylor A Murphy
4 years
Tinder for Data Analysts - only show your latest sql queries and dashboards. Swipe right if you're interested in a JOIN. We'll call it Analyzr.
3
6
86
@tayloramurphy
Taylor A Murphy
4 years
I figured out a way to make working in data warehouses more like data science:. rows/columns are now vectors,. tables are matrices,. olap cubes are tensors. let me know how much this increases your salary!.
2
8
88
@tayloramurphy
Taylor A Murphy
4 years
me: it's ironic, those who least want power are precisely the ones who should have the most, while those who seek power are not to be trusted. them: what the fu- what are you talking about?! can I edit the sql behind this chart or not??.
1
4
87
@tayloramurphy
Taylor A Murphy
3 years
BREAKING: the trust your execs have in that dashboard.
0
6
81
@tayloramurphy
Taylor A Murphy
4 years
this is you, data scientists. 🕯. 🕯 🕯. 🕯 🕯. 🕯 INSIGHTS 🕯. 🕯 🕯. 🕯 🕯. 🕯.
4
7
87
@tayloramurphy
Taylor A Murphy
4 years
OK that's enough well written data articles. I don't have time to read them all. you can stop writing everyone. let's execute on all this advice in our respective orgs for the next ~2 years and regroup then.
3
5
85
@tayloramurphy
Taylor A Murphy
3 years
well fuck you too business insider
11
4
79
@tayloramurphy
Taylor A Murphy
3 years
feels like a real risk that a data conference in 2022 will be 500 vendors courting 20 practitioners (who happen to be interviewing at 10 of the vendors each) 🤪.
5
4
83
@tayloramurphy
Taylor A Murphy
2 years
me as a data engineer telling the data analyst that the pipeline broke and the dashboard they built for the CEO is broken
Tweet media one
1
6
83
@tayloramurphy
Taylor A Murphy
2 years
you should be doing everything in your power to avoid injecting machine learning into a process. invest in operational efficiency in whatever ways you can and exhaust those avenues *before* you reach for ML.
6
6
78
@tayloramurphy
Taylor A Murphy
4 years
I love being a data professional, but sometimes it's terrifying when there's an entry in a database outside your control that you *know* is wrong and you have to go through layers of bureaucracy to get it fixed. I'm sure DB errors ruin people's lives. 😟.
6
5
75
@tayloramurphy
Taylor A Murphy
3 years
it's just CSVs on an FTP server all the way down.
8
8
76
@tayloramurphy
Taylor A Murphy
4 years
"this dashboard is definitely real time!"
Tweet media one
1
4
74
@tayloramurphy
Taylor A Murphy
2 years
SQL NFL. 🤝 . too many CTEs.
2
3
73
@tayloramurphy
Taylor A Murphy
3 years
Happy Christmas y'all! . Hopefully your pipelines are all. 🟩🟩🟩🟩🟩. and not. 🟩🟥🟩🟥🟩. even though it's more Christmas-y.
2
5
76
@tayloramurphy
Taylor A Murphy
3 years
"How do you have time for this??". I neglect critical areas of my life, obviously. .
2
2
72
@tayloramurphy
Taylor A Murphy
4 years
Should commas in SQL be trailing?. Yes Yes Yes.👇 👇 👇.
13
3
70
@tayloramurphy
Taylor A Murphy
3 years
Tweet media one
5
4
73
@tayloramurphy
Taylor A Murphy
4 years
As an analyst grows and matures, it is only natural for them to question if they want to be a data engineer. It's called dbt curious.
2
4
74
@tayloramurphy
Taylor A Murphy
2 years
data professionals handling data and dashboard requests
1
11
66
@tayloramurphy
Taylor A Murphy
3 years
I printed out my data and hung it on the wall. my wife said it was missing something so I put a decorative border around it. guess you could say I added a dataframe.
5
4
69
@tayloramurphy
Taylor A Murphy
2 years
we had to say goodbye to this sweet girl today. her wounds were just too bad and she was suffering. she's at peace now. we enjoyed the outdoors with some ice cream together before she passed. goodbye Luna. thank you for 10 years. you are missed 💔
Tweet media one
Tweet media two
14
0
67
@tayloramurphy
Taylor A Murphy
4 years
pure sql sql+jinja+yaml
Tweet media one
Tweet media two
3
3
71
@tayloramurphy
Taylor A Murphy
3 years
I owe my career to many amazing women. My wife being the most important as we've made explicit choices as a family to prioritize my career. She does most of the glue work for our family of 6 (2 kids / 2 dogs) and I literally wouldn't be in the position I'm in today without her.
1
1
66
@tayloramurphy
Taylor A Murphy
4 years
databases dinner parties. 🤝. joining tables.
1
4
69
@tayloramurphy
Taylor A Murphy
5 years
@scalzi This would give me anxiety even if we weren't in a pandemic 😬.
0
2
57
@tayloramurphy
Taylor A Murphy
4 years
A large SQL query the size of a small SQL query is blocking the warehouse used to populate the dashboards. Expect delays.
2
5
67
@tayloramurphy
Taylor A Murphy
4 years
new favorite shirt
Tweet media one
5
7
64
@tayloramurphy
Taylor A Murphy
2 years
finally
Tweet media one
4
1
63
@tayloramurphy
Taylor A Murphy
3 years
is there anything worse than staring at your own tired, haggard face for 2 minutes waiting for someone in the zoom room.
2
1
60
@tayloramurphy
Taylor A Murphy
4 years
everybody is going to hate on yaml for the next 5 years and then y'all will have an epiphany that it's totally fine and does its job well, kinda like how good data people feel about sql now.
7
3
63
@tayloramurphy
Taylor A Murphy
4 years
@ambernoelle They're looking for a lightning strike and miss out on the fireflies.
1
2
61
@tayloramurphy
Taylor A Murphy
3 years
them: can you explain the gaps in the data?. me: I exported it from the database as a csv and you imported it into excel and it converted half of it to dates.
0
3
62
@tayloramurphy
Taylor A Murphy
3 years
did it hurt? when you had to sign another contract for your modern data stack.
6
2
64
@tayloramurphy
Taylor A Murphy
3 years
Been noodling in the back of my mind how, for most orgs, the data isn't "The Work" of the org. Data can be an accelerant, a vehicle for optimization, and an ever present opportunity - but it's generally one step removed from the main thing.
13
6
61
@tayloramurphy
Taylor A Murphy
5 years
Business: this chart shows the sky is falling!. Data team: well actually this chart is showing current month data and it shouldn't plus it's updated via a manual process biweekly and it also seems the query is filtered for some reason (who changed this?!) but really this is the.
2
4
57
@tayloramurphy
Taylor A Murphy
3 years
cold take: data was a mistake. should've kept with a purely oral tradition.
5
4
56
@tayloramurphy
Taylor A Murphy
2 years
@sethrosen coming up with AWS puns is so EC2 do.
3
6
61
@tayloramurphy
Taylor A Murphy
3 years
whatever hot takes will come, data council was a good event with wonderful people. smart, kind, funny, earnest, and caring folks that love data and the community and are all doing their best. this is just a moment and we're all working to make it all better 💟.
4
1
58
@tayloramurphy
Taylor A Murphy
4 years
Foiled by the emoji trick again! 😂
Tweet media one
4
1
56
@tayloramurphy
Taylor A Murphy
3 years
due to inflation you must now use.WHERE 1.23 = 1.23.
5
11
60
@tayloramurphy
Taylor A Murphy
3 years
@thebmbennett Useful real-time dashboards.
1
0
56
@tayloramurphy
Taylor A Murphy
1 year
We Abandoned Data Warehouses and Saved Hundreds of Engineering Hours a Month. In the post below I will explain how you can directly query your code using Excel. No warehouse, no cloud, no SQL.
Tweet media one
6
1
60
@tayloramurphy
Taylor A Murphy
4 years
What's something ~< $2k that you bought and absolutely love?. Serious question, but I will block you if you mention Peloton.
54
4
53
@tayloramurphy
Taylor A Murphy
4 years
me realizing I've been deleting data in production
Tweet media one
2
1
50