The Swyx Mixtape

The theme song of humanity.Audio sources:Baba Yetu at Cadogan HallOfficial music videoBaba Yetu at LlangollenLyrics“Baba Yetu” is essentially the Lord’s Prayer sung in Swahili. The title translated means “Our Father”.Baba yetu, yetu uliyeMbinguni yetu, yetu amina!Baba yetu yetu uliyeJina lako e litukuzwe.Utupe leo chakula chetuTunachohitaji, utusameheMakosa yetu, hey!Kama nasi tunavyowasameheWaliotukosea usitutieKatika majaribu, lakiniUtuokoe, na yule, muovu e milele!Ufalme wako ufike utakaloLifanyike duniani kama mbinguni.(Amina)Our Father, who artin Heaven. Amen!Our Father,Hallowed be thy name.Give us this day our daily bread,Forgive us ofour trespasses,As we forgive othersWho trespass against usLead us not into temptation, butdeliver us from the evil one forever.Thy kingdom come, thy will be doneOn Earth as it is in Heaven.(Amen)TranscriptOn Fridays we feature music on this podcast and today i'm sharing one of my favorite songs - Baba Yetu. If all of humanity ever had a theme song, this would be my pick.This first clip was from a performance with the Royal Philharmonic in London at Cadogan Hall.Baba Yetu was the theme song for the game Civilization 4 and it was the first video game song to ever win a Grammy award. If you watch the official music video that comes with the game, linked in the show notes, you can imagine how it celebrates the crowning achievements of civilization from the taming of fire all the way through to the space race and the information age. But the renditions I feature here are not from the game, they are live performances conducted by Christopher himself. I really prefer the live performances because you get to see how passionate Christopher is about this song, and how much it lifts up the entire chorus and orchestra. As one youtube commenter said, "this is a song composed by an asian guy in an african language sung by white people from a game about the rise of humanity. Now if that isn't awesome I don't know what is."Baba Yetu is the Lords Prayer in Swahili - so literally you are saying "give us this day our daily bread, forgive us of our trespasses as we forgive others" as you sing this song. To close out, here's another rendition I like with a more diverse cast and I love appreciating how a different soloist interprets it.If you have the time, I recommend watching both performances on youtube. 

5 tips to improve your writing:NoveltyIntrigueStoriesAnalogiesExamplesAudio source: https://www.indiehackers.com/podcast/196-david-perell (35 mins)

Everything is copied - although Apple didn't copy as much from Xerox as most people say.Audio source: https://www.youtube.com/watch?v=nJPERZDfyWc (the full 4 part documentary is an inspiring watch)

dbt is taking the data eng world by storm. this is the best 10 minutes i've heard on it, from Fishtown Analytics cofounder Drew Banin.Fun fact: Fishtown is a town in Philadelphia!Audio source: https://www.dataengineeringpodcast.com/dbt-data-analytics-episode-81/ (14 mins in)Fivetran CEO geeking out on dbt: https://medium.com/hashmapinc/the-origins-and-future-of-fivetran-with-george-fraser-1af8e7cb90aa (17 mins in)TranscriptTobias Macey: And also, we don't have this version repository of queries and reports and the ability to collaborate on it fairly easily, then you end up leaving everyone to write their own sequel, usually ad hoc, and they might have their own assumptions as to what an order is or what a customer is, or how to structure the query to join across different tables. And so everybody's going to have slightly different views of the data or slightly different outputs. And so definitely having the ability to have one location that everybody can look to. And one interface for everybody to collaborate on makes it much easier and more scalable to have more people working on building and interacting with these Analytics reports and these analytics pipelines.Drew Bannon: Absolutely, I think it's a great point, what we find is that in the process of building up these data models, what you're actually doing is generating knowledge about your organization. And you're saying here's exactly what an order is, or here's exactly how we calculate MRR. And to that end, dbt ships with auto generated documentation about your project, you can run dbt docs generate, to generate this single page app, have all of your models with all the tests on the columns and descriptions that you can populate for these different models. And so if you do have some consumer of the data that isn't using GBT, they have a great place that can go and see all the models that exist and all the columns and your pros about all of it. And so in that way, it's sort of a catalog of all the data that your organization commands and serve instructions for us toTobias Macey: Yeah, and I think that that is definitely very powerful, because particularly having the documentation be generated as part of the code as opposed to something that someone does after the fact or alongside the work that they're doing means that it's much more likely to stay fresh and actually be up David periodically, rather than somebody putting in the time and effort to write some prose once when they first build the overall reporting pipeline. And then it quickly grows stale and useless over time as new modifications are made. Yeah, that's absolutely right. And another interesting capability that dbt has is the idea of packaging, and being able to package up these different subsets or reports or transformations so that they're reusable across different teams and across different code bases. So can you talk a bit about how those packages are set up and implemented, and also maybe talk a bit about who the sort of primary drivers are for the different packages that are currently available? Sure.Drew Bannon: So when dbt runs, it will look in a couple different places for we will call it resources. And so an example of a resource is a model or a test of a model, or things like documentation, snippets, etc. And so one of the places that looks is your models directory, which are the models that you've created, but the other place it looks is a folder called dbt modules, which is sort of note inspired. And so what you can do is just drop whole dbt projects into that dbt modules folder. And they get picked up as though they're a natural part of your project. And all of these resources become available in the compilation context the dbt provides. And so there are basically two types of packages that that are produced. One is data set specific packages, and the other is sort of macro or utility packages. An example of a data set package is something like snowplow. And so we're huge fans of the snowplow event tracking system at Fishtown analytics, the big idea is that you can track events from all your different clients. And they flow directly into a big events table in your warehouse. And so this event table is like an immutable event log, it has the full history of you know, every interaction that you cared about to track in a single table, which is phenomenal. It's a great resource. But the problem is, it's difficult to plug a BI tool right into that, either because it's too much data or because the things you really care about are hard to analyze, like how many people had two different events in a single session. And so what we frequently find ourselves doing is rolling up these events into sessions using some code that was actually originally produced by the snow pub team called their web data model. And so what we can do is we can make a package of these transformations that go from bra events, to page views to sessions, all the way up to users. And then we encode these things as dbt models. And if you include this package into your dbt project, when you take dbt run, these models will automatically run you can also reference them from your own models. So if you want to do marketing attribution on top of session ization, that was provided by the snowplow package, you can absolutely do that. The other broad type of package that we make is maybe more focused on macros. And so the Jinja template engine supports something called macros, which are kind of functions that return text basically, in most cases, texts, we've actually been Kak them. So they return other things, which is pretty wild how we do it. And and so what you can do is if you find yourself writing the same type of code over and over again, what you can do is make a macro that accepts arguments and spits back out, usually the sequel that you need to encode that particular piece of logic. So here's a really good example that shows the full like force of the dbt compilation engine, we wrote a Actually, let me grab it, somebody contributed a pivot macro, that you could point to a table and a specific column. And you can say, pivot out the values into this column using this aggregate function. So you say, look at the Orders table, look at the, you know, have this better example. Look at the products table, look at the products color, and then pivot that pivot that out to like color red color blue color green, with a one if that's true, or zero, if it's not. And so this is probably something that a lot of people have written manually many times over. But when macros and the ability to sort of encapsulate logic plus packages, which is a distribution mechanism, we can write that thing once, and many, many people can benefit from it. So this is one example of a macro that was contributed by member of the dbt community. But really this this dbt utility package that contains the pivot macro has dozens of macros, many of which were contributed by dbt users. And the really cool thing is a lot of these people are in engineers by trade their analysts. And so for a lot of them, it's their first time contributing to an open source repository. And that's a pretty cool experience to be the benefactor of the the code that they wrote.

Audio source: https://www.3books.co/chapters/15 (14 mins in)Tuesdays with Morrie wikipedia entry

I am a mentor for the Notion Advanced track of Tiago Forte's Building a Second Brain, Cohort 12. You can catch Weeks 1, 2, 3, and 4 in the previous weekend episodes. This is the cleaned up audio of the last of 5 mentorship sessions with Q&A at the end. Video version: https://youtu.be/emUfFWixQwETimestampsRecap of Last 4 Weeks [00:02:08]Shifting Perception to Sharing [00:03:07]IP's Personal Progress [00:09:38]How to Solve the Cold Start Problem [00:10:57] The Invisible Pipeline and the 1% Rule [00:14:00]Peer Group Progress [00:15:48]Course Recap: Convergence vs Divergence, CO vs DE [00:20:41] Your First Brain vs Your Second Brain [00:22:43] Project Kickoff Checklist [00:24:06]Favorite Quotes [00:25:26] Q&A: Denys on Learning in Public in YouTube [00:32:47] Q&A: Meryl Johnston on Learning in Public [00:43:34] The Resistance and Gratitude Journaling [00:46:04]Don't Just Write Essays: Remove Resistance [00:48:37]Three Strikes Rule [00:52:51]Guy Margalith on Fear and Your Second Brain [00:53:40]Organizing Files on your Mac [01:00:59]Swyx Twitter Journey [01:04:18]Tropical MBA and Balaji Srinivasan [01:09:05] Closing Remarks [01:10:20]Transcriptswyx: [00:00:00] Okay, so we're in week five. I didn't know what to call it. So I just called it finale week. I, at this point I feel like everyone knows each other even.But feel free to say hi, if you're new you're still totally woke up and to jump around and visit the each other's sessions. I'm also going to blast through the housekeeping just because there's not that much more housekeeping left to do. And I will also want it to shout out what I did for last week's.Events which well that's Swyx week app, which was essentially right up my own experience of intermediate packets. And I broke my own journey down into eight intermediate packets. So that's tweet, tweet, livestream, blog posts, conference, conference conference, a job interview. And this took place over the course of a year.So it, it shocked me because even though I went through it, you don't, you never really think about intermediate packets dripping out over a year. And the thing that I really wanted to get across was that I think the way that immediate packets, which was presented last time was very much of a top-down thing.Like I want to do something big, let me work backwards and break it down into intranet, small things that can ship. But it also equally works for bottom up where you have no idea what the end goal is, but you're just like. That's just ship of small things, and try to build up to something big if the interest is there. Glen G says, paddle reminds me of bubbling off events. Yep. That's a very WebDev analogy and that's fully true there. The two directions of bubbling. I forget what the opposite of bubbling is in the dumb, but that's beside the point anyway. I wanted to offer that as my own perspective on intermediate packets.Oh, yeah. Dave says he is bubbling up NIST insider today. Yeah, totally. Yeah. We are bubbling ideas. That's great. That title doesn't resonate with me. So I just went with bottom up, but feel free to write your own policy. And I think that's something that we should talk about as well.Who's written stuff as a result of this course. And what post ideas do you have to share? You can feel free to throw that in the chat as well. Housekeeping, we've covered this plenty of times, but stupid questions are welcome. Often beats. Perfect. And then this is the discussion and not a lecture.Recap of Last 4 Weeks [00:02:08]All right. So we've covered all these 12. I think it actually works out without the 12. So it's cohort 12 with 12 items. I think so. I grabbed this, I went back to lecture one and grab this slide. And actually  the last week changed quite a bit, I think, but  the first 3 have been relatively stable.And it's quite a bit of content if you walk back and think about it. So I just wanted to acknowledge and pause for a bit and say I think the last five weeks have been a real blast in terms of flights and just a lot of ideas, especially if you're new to them for the first time. But even for me going through them the second time I felt like I just had a lot more to think about each on each in each time, because I've lived through it and I've had a year to really sit with it. I think it'd be interesting to hear from you in in, in the chat or if you wanna, if you want to speak up, I'm just going to pause here and it's just go was there, was there a particular idea that really stuck out to you during this these this whole curriculum w what's your favorite sort of takeaway that you really liked?Shifting Perception to Sharing [00:03:07]Speaker 2: [00:03:07] The one thing that I found which wasn't actually to deal with lessons wasn't to do with systems and processes. It was his perception for me. It's just been a shift in perception, but that's been the benefit of building a second brain, but I've taken that and I've applied that to everything. And I'm looking at, whether it be a task or whether it be something I want to do, what is the perception that motivates me most?And I've realized from second brain that all I came in, they wanted to share more and I wanted an output and I think it came from a selfish point of view of, I just want to share, I want to share, I'm going to attract more people, get more business, be a thought leader, et cetera. What I realized when I was sharing that circle and sharing, and here I'm not having that going a backwards and forwards.I like helping people and I look at even day-to-day friendships. I have conversations, anything that goes to the people I'm interested in they're gold as well. And I've realized that the perception was wrong for me to just look at output in isolation and say, oh, you just want to help her instead of, Hey, how do we respond most positively to actually get output?And for me now, I realized that for helping other people I'm building connections, like even the last week I've been really lucky people that they messaging me, ask them to connect. I've had zoom calls with people. I'm emailing people and we're all having backwards and forwards dialogue, but that wouldn't have happened unless I output in the first place to share my opinion, to actually attract those like-minded people as well.So that's where I say now to perception is going to help me. And I'm going to look at any future problem rather than just looking at like it's a task or a project on big into kind of alleviate and willpower and not having this battle that you have to get up every day and you have to do something against your will to finally get to the end of a journey.And for me, if there's that kind of, if there's those breadcrumbs of emotion for me and breadcrumbs of connection with people, I'll get more addicted to it. I'll enjoy it more. It will be easier for me all the time. And I think it will become more and more natural to do. s...

I just watched the new In The Heights movie and had to mixtape my favorite moments!Samples from:Benny's Dispatch (Corey Hawkins)Paciencia y Fe (Olga Merediz)Breathe (Leslie Grace)96,000 (Cast)In The Heights on Wikipedia

How people unintentionally obstruct progress by asking for perfectly reasonable thingsAudio source: https://artofproductpodcast.com/episode-17310 Tricks to Appear Smart During MeetingsShreyas Twitter thread on Apple Pie PositionsJohn Cutler's response with more

Listen to Cloudflare's pitch when it was just 3 people at TechCrunch Disrupt. Would you have invested?Audio Source: https://www.youtube.com/watch?v=XeKWeBw1R5AQwiki, winners of Disrupt that year: https://techcrunch.com/2010/09/29/qwiki-techcrunch-disrupt-winner/

The extremes people go to in order to reinforce a personal brand.Audio Source: https://www.listennotes.com/podcasts/my-first-million/182-how-an-astrology-app-mplvUweDHMA/My How To Market Yourself essay: https://www.swyx.io/marketing-yourself/#personal-branding