Unveiling the Power of dbt and DuckDB - Hype vs Reality
Explore the practical applications and limitations of combining dbt and DuckDB for data transformations, examining real-world use cases and performance considerations.
The Real Modern Data Stack - Building ETL Pipelines with Open Source Tools
Discover how to build powerful, cost-effective ETL data stacks using open-source tools like sling, dbt, duckdb, and dagster - transforming months of implementation into rapid deployment.
Jupyter for First-Time Users - Introduction to Notebooks and Code Execution
Learn to use Jupyter notebooks for coding projects, including markdown, LaTeX, code execution, and debugging. Ideal for beginners in scientific computing and data analysis.
SQL You Need as a Data Scientist
Learn essential SQL skills for data science, including SELECT, JOIN, aggregations, CTEs, and window functions. Apply these techniques to time series forecasting and fraud prediction.
How a Data Scientist Fights Fraud - With Code!
Explore data science techniques for fraud detection, including feature engineering, SQL querying, model creation, evaluation, and interpretation, with hands-on coding examples.
Make a Beautiful Ggplot2 Bar Chart from Basic to Powerful Themes
Learn to create stunning ggplot2 bar charts in R, from basic techniques to advanced theming. Master data cleaning, chart customization, and professional visualization using real-world crime data.
Pseudo-Bulk Analysis for Single-Cell RNA-Seq Data - Detailed Workflow Tutorial
Comprehensive tutorial on pseudo-bulk analysis for single-cell RNA-Seq data, covering the what, why, and how. Includes data manipulation, aggregation, and differential expression analysis using R, Seurat, and DESeq2.
Integrate Single-Cell RNA-Seq Datasets in R Using Seurat - Detailed Seurat Workflow Tutorial
Comprehensive tutorial on integrating single-cell RNA-Seq datasets using Seurat in R, covering data merging, batch effect correction, and visualization techniques for improved analysis.
How to Analyze Single-Cell RNA-Seq Data in R - Detailed Seurat Workflow Tutorial
Comprehensive tutorial on analyzing single-cell RNA-Seq data using Seurat in R, covering data processing, quality control, normalization, dimensionality reduction, and clustering for genomics research.
Visualize Gene Expression Data in R Using Ggplot2 - Bioinformatics for Beginners
Learn to visualize gene expression data using R and ggplot2. Create barplots, density plots, boxplots, scatterplots, and heatmaps from RNA-Seq data. Hands-on tutorial for beginners in bioinformatics.
How to Manipulate Gene Expression Data from NCBI GEO in R Using Dplyr - Bioinformatics for Beginners
Learn to manipulate gene expression data from NCBI GEO using R and dplyr. Covers data reading, metadata retrieval, and essential dplyr functions for effective bioinformatics analysis.
Real-Time Analytics and Built-In Machine Learning Models With a Single Database
Explore real-time analytics and machine learning with HTAP databases. Learn to leverage SQL for model building and discover tools for efficient data infrastructure in this hands-on webinar.
Prepping Data for Analysis in R
Comprehensive workshop on data preparation for analysis in R, covering common issues, automated solutions, and practical demonstrations using open-source tools and packages.
ODSC West 2015 - Marc Joffe "Collecting and Analyzing Open Local Government Data"
Explore efforts to collect, analyze, and share US local government data, enhancing democratic accountability through open platforms like GovWiki and key resources such as EMMA.
R for Data Scientists and Data Analysts
Master essential R skills for data analysis and science, covering variables, vectors, functions, and control structures in a comprehensive tutorial.
Beginner's Excel Tutorial - Data Science-Analysis and Beyond
Learn essential Excel skills for data analysis, including functions, lookups, formatting, and advanced features like pivot tables and macros. Gain practical knowledge for data-driven decision-making.
Data Analyst Setup for Productivity - Python, R, SQL
Explore a data analyst's productivity setup, including Miniconda, Python environments, VSCode, R Studio, and essential hardware recommendations for efficient data analysis workflows.
Detecting Price and Volume Patterns with SQL and TimescaleDB
Learn to detect stock price patterns using SQL and TimescaleDB. Explore PostgreSQL functions, TimescaleDB features, and analyze real-world examples to identify bullish engulfing and three-bar breakout patterns.
Learn Data Science Full Course - 2020
Comprehensive introduction to data science, covering key concepts, tools, and methodologies. Ideal for beginners seeking to understand the field's fundamentals and career prospects.
Funnel Analysis with Apache Spark and Druid for Advertising Campaign Effectiveness
Learn to perform funnel analysis at scale using Apache Spark, Druid, and DataSketches. Discover techniques for measuring campaign effectiveness and analyzing user behavior in chronological order for large-scale advertising campaigns.
Introduction, Principles and Origin of Dagster
Introduction to Dagster: A data orchestrator for the entire application lifecycle. Covers principles, development, deployment, and monitoring. Includes demo and code snippets showcasing Dagit UI and Dagster programming model.