{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Energy Bytes","title":"EP 51: Robert Stover from Enverus","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/c484c62e\"></iframe>","width":"100%","height":180,"duration":4992,"description":"Robert shares insights into how data analysis is revolutionizing the industry, emphasizing the critical role of efficient data queries and the tools that manage large volumes of information. He discusses the transition from relying on spreadsheets to adopting more organized and structured data systems. Tools like Snowflake and DBT are driving this shift, enhancing data processes and improving data quality within the oil and gas sector.\n00:00 - Intro\n01:34 - Distributed Compute Necessity\n07:05 - Enverus Role Overview\n10:51 - Transitioning from Spreadsheets\n17:12 - Data Quality Testing Techniques\n19:00 - Understanding DBT (Data Build Tool)\n21:15 - DBT Orchestration Explained\n24:35 - DBT Documentation Importance\n28:03 - Tech Stack Insights\n30:17 - Type 2 Slowly Changing Dimensions\n33:01 - FiveTran vs. Homegrown Pipelines\n36:00 - Rudderstack Overview\n38:20 - Snowflake's Semantic Layer\n40:40 - Hex Analytics Tool\n45:00 - Experience at Parsley\n47:43 - Journey from Planning to Engineering\n49:28 - Importance of Domain Experience\n54:55 - Changing Your Data Stack\n1:01:14 - ODBC Usage Today\n1:06:00 - Microsoft Power BI Overview\n1:07:40 - Lakehouses Explained\n1:11:50 - Speed Round\n1:14:20 - Exciting Open Source Packages\n1:19:41 - Favorite Roadside Stops\n1:21:52 - Podcast Wrap-Up\n1:22:34 - Where to Find Matt\nhttps://twitter.com/collide_iohttps://www.tiktok.com/@collide.iohttps://www.facebook.com/collide.iohttps://www.instagram.com/collide.iohttps://www.youtube.com/@collide_iohttps://bsky.app/profile/digitalwildcatters.bsky.socialhttps://www.linkedin.com/company/collide-digital-wildcatters","thumbnail_url":"https://img.transistorcdn.com/KU-rritAkNfd5EDWr8dy4miPzznveey9CXz1zVQDRXc/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS83ZGMz/NDQxNzEwNTFjZDU3/NmQ4ZmI3ZDU1ZTQ2/Y2U4Yi5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}