Учебные материалы по анализу данных

Learn to count unique values in Excel using basic and advanced formulas. See the difference between unique and distinct values.

There are multiple ways to generate random numbers in Excel, such as the `RAND(),` `RANDBETWEEN(),` and `RANDARRAY()` functions.

Python inheritance allows you to build new classes by reusing and extending the functionality of existing ones. Learn how to design parent-child class relationships, implement inheritance patterns, and apply techniques such as method overriding.

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.