Data Analysis Tutorials

Learn how to use VLOOKUP() in Google Sheets to search, find, and pull data from large datasets in seconds.

Learn how to create and use pivot tables in Google Sheets to summarize, analyze, and explore your data.

Spin up a no-cost BigQuery environment, practice real-world SQL on public and private data, and build dashboards while staying within generous free-tier limits.

Accuracy isn't enough. Learn the difference between precision and recall, understand the trade-off, and choose the right metric for your model.

Master Gurobi optimization from setup to real-world applications. Learn to build models, configure solvers, and tackle linear, integer, and nonlinear programming problems efficiently.

Learn to analyze categorical relationships when your sample sizes are small.

Learn the mathematical foundations of z-scores, explore practical calculation methods, and discover applications across statistics and data science.

Learn how to calculate and interpret the likelihood of multiple events occurring simultaneously. Discover practical applications in predictive modeling, risk assessment, and machine learning that solve complex data science challenges.

Learn the mathematical foundations, discover multiple types and their applications, and explore how standard error enhances statistical inference and decision-making.

Explore the concept of central tendency in statistics, including specialized measures such as mean, median, and mode. Learn how to select the most appropriate measure based on your data characteristics and distribution.

Find the most common value in your data. Learn to use MODE() function in Excel for quick statistical insights. Master basic and advanced use cases with clear examples.

Analyze the strength and direction of relationships between variables using built-in Excel tools.