Data Analysis Tutorials

Merge two columns in Excel using the ampersand & operator or the CONCAT() function with a custom delimiter. Or use TEXTJOIN(), which lets you ignore blank cells.

Discover how to extract numbers from Excel strings using formulas. Master functions like RIGHT(), LEFT(), and TEXTJOIN() to target numeric data before, after, or anywhere in your text.

Read all about Tableau crosstabs so you can accurately display numerical data. Customize your Tableau crosstab with formatting, filters, parameters, indicator icons, and sparklines to reveal hidden insights.

Learn how to create a Power BI waterfall chart, including how to customize the chart to make it look nice. Follow best practices and avoid common mistakes.

Learn how to make the most of your Google Analytics integration with edge computing.

Examine the mathematical principles behind random walks and explore their forms, from one-dimensional paths to biased and Gaussian models. Use Python to discover how these stochastic processes inform real-world phenomena in biology, physics, and finance.

Explore simple subtraction for quick and effortless date calculations. Apply the DAYS() and DATEDIF() functions to achieve precise date intervals. Use NETWORKDAYS() and TODAY() to track working days and automatically exclude weekends and holidays.

Learn how to multiply in Excel, including how to multiply columns and rows. Learn to use simple formulas as well as functions like PRODUCT() and SUMPRODUCT().

Explore the differences between mean and median, learn their applications in data analysis, and know how to choose the right measure for different scenarios.

Discover the fundamentals of the exponential distribution and its applications in real-world scenarios. Learn how to calculate probabilities and understand its significance in various fields. Explore practical examples and visualizations.

Learn how to keep important rows and columns visible while you scroll in Excel. I’ve explained Freeze Panes step-by-step, with tips for solving everyday problems and improving your workflow.

Discover the importance of multilevel modeling in analyzing hierarchical data structures. Learn how to account for variability within and between groups using fixed and random effects. Apply these concepts to uncover deeper insights in fields like education, healthcare, and social sciences.