Brian Roepkedbt: Codify and Automate Transformation of Data in Your Data Warehousedbt helps transform data in your warehouse all through SQL following software engineering best practices.·8 min read·Oct 14, 2023--1--1
Brian RoepkeinTowards Data ScienceFive Powerful Prioritization Techniques from Product ManagementHow Data Scientists can learn from how a Product Manager builds a product, thinks about customer-centricity, and ensures that the product…·8 min read·Apr 2, 2023----
Brian RoepkeGetting Started with Prefect: Powerful Orchestration for Your DataLearn how to leverage Prefect to build cloud-based orchestrations for your data engineering projects·10 min read·Mar 4, 2023----
Brian RoepkeinTowards Data ScienceA Quick Start to Connecting to PostgreSQL and Pulling Data into PandasGet you on your way to data analysis and model building quickly by pulling PostgreSQL data into Pandas·4 min read·Feb 5, 2023----
Brian RoepkeinTowards Data ScienceHow to Set Up a Simple ETL Pipeline with AWS Lambda for Data ScienceHow to setup a simple ETL pipeline with AWS Lambda that can be triggered via an API Endpoint or Schedule and write the results to an S3…·10 min read·Feb 4, 2023----
Brian RoepkeA Real-World Approach with XGBoost on Marketing Attribution DataLeverage Triafire for ML-ready marketing data to predict which users will convert to paid. From feature engineering to model building, and…·13 min read·Feb 3, 2023----
Brian RoepkeHow to Normalize MongoDB Data in Snowflake for Data Science WorkflowsLeverage the Power of MongoDB and Snowflake to Create a Data Warehouse built for Data Science and Analytics Workflows.·8 min read·Dec 3, 2022----
Brian RoepkeGetting Started with Snowflake and the Rise of ELT Workflows in the CloudModern Data Warehouses like Snowflake are changing how we load and transform data in our warehouse with no extra tooling or external…·8 min read·Dec 2, 2022----
Brian RoepkeinTowards Data ScienceGetting Started with Astronomer Airflow: The Data Engineering WorkhorseBuild powerful and scalable data pipelines with Astronomer, the managed Airflow service powered by Python·9 min read·Nov 13, 2022----
Brian RoepkeinTowards Data ScienceA Quick Guide on How to Safely Store and Retrieve Sensitive Data When Developing LocallyNever put user names, passwords, or API keys/secrets in your code. Leverage Environment Variables to keep your data safe.·4 min read·Oct 30, 2022--2--2