Data Science Tutorials

Learn about the various tests possible in dbt to check and ensure data quality.

Discover how to create a MongoDB database from the shell or with a script, plus common pitfalls to avoid.

Learn how to use the c() function in R to combine values into vectors efficiently.

Round down with precision using Excel’s FLOOR() function. Perfect for pricing, scheduling, and more.

Master the basics of the Excel SQRT() function. Learn how to use SQRT() for quick square root calculations and address common errors.

Learn to work with Excel’s AVERAGE() function, including conditional and logical variations.

Learn how to use Snowflake's DATEADD function for date manipulation with real-world examples. Master time calculations, handle edge cases, and optimize performance in your SQL queries.

Learn about Python automation, including fundamental concepts, key libraries, working with data, using AI enhancements, and best practices. Includes real-world examples.

This tutorial shows you how to use Terraform with Azure to automate infrastructure, improve consistency, and implement best practices for secure, scalable deployments.

Learn how to use Python's filter() function to extract items from lists or other iterables. Understand the key differences between filter and similar Python tools.

Learn how to simplify your spreadsheets with LAMBDA(). Write once, reuse anywhere, and combine with other modern Excel functions.

Learn how to install and use the Google Gemini CLI to streamline your coding workflow and fix bugs faster with AI.