Telegram RegisterThe public register of Telegram

Channel

Аня - аналитик данных👩‍🌾

@anna_data

On this record: Growth · Engagement · What this channel posts · Reactions · Posts · Polls · Citations · Cite this entry

96subscribers

+0 since we began measuring on 7 August 2026

Risers and fallers across the register · movement among entries of Under 1,000.

Register entry

Telegram ID-1001754716469
TypeChannel
Username@anna_data
DescriptionЗаписки начинающего аналитика данных @Mrs_logunova Аня Делаю заметки для себя. Пишу просто. Здесь не будет сложных специализированных терминов. И мутных исследований. Нет и не будет простыней текста, 100500 ссылок. Коротко, один пост - одна мысль.
CreatedBetween 1 December 2021 and 19 June 2022— estimated from Telegram’s id allocation, not measured. How this range is calculated.
First recorded9 August 2026
Last confirmed live9 August 2026
Measurements held2
On Telegramt.me/anna_data

Growth

967 August 2026 — 96 subscribers9 August 2026 — 96 subscribers7 August 20269 August 2026
2 measurements spanning 2 days. Dots are measurements; the straight line between them is drawn to join them, not to claim we know the path taken in between — snapshots are recorded only when a count changes, so gaps mean “no change observed”, never “interpolated”. The vertical axis spans 95–97 and does not start at zero.
Measurement log — every subscribers count we have recorded
Measured (UTC)SubscribersChange
9 Aug 2026, 12:0296no change
7 Aug 2026, 05:0696first reading

Engagement

20 posts held, back to 19 June 2022the reader has not yet reached the start of this channel’s public history, so older posts may sit further back, unread. Read across 1 pageof Telegram’s post history, 20 posts per page.

Nothing published in the last 30 days. ERR and ER are rolling 30-day measures, so there is nothing to compute — we hold 20 posts for this entry, the most recent from 20 August 2022. An engagement rate over an empty window would be a number about nothing.

What this channel posts

Photos
3
Links
12

Lifetime counters from Telegram’s own channel header, read 9 August 2026 — not the date at the top of this page, which is when the subscriber count was last read. Below Telegram’s rounding threshold, so these counts are exact.

Reaction mix

41 reactions across 11 posts, in 5 distinct kinds. The most used accounts for 63.4% of them.

Every reaction kind recorded on the sample, most used first
ReactionCountShareShare, drawn
👍2663.4%
922.0%
🔥37.32%
🤔24.88%
🤩12.44%

No sentiment is inferred, and none should be read in. This table is ordered by count and by nothing else. Emoji do not carry stable meaning across languages or communities — 🙏 is thanks in one channel and mourning in another — so we publish which ones were pressed and how often, and pass no judgement on what an audience meant by them.

Precision. Telegram publishes reaction counts per emoji and short-forms each one — 4.34K, 1.2M — so any single kind at or above 1,000 reaches us at three significant figures, and only counts below 1,000 are exact. The shares above are ratios of those figures and carry the same error. This is also why the total here can differ slightly from a reaction total printed elsewhere on the page: both are sums of the same rounded parts, taken over samples with different edges.

Coverage. Reactions were read on 11 of the 20 sampled posts in this sample. Summed by Telegram’s own count on each post — not by adding up the per-emoji breakdown above — those same posts carry 41reactions in total: the kind of figure the paragraph above means by “a reaction total printed elsewhere on the page”.

Measured over the 20 most recent posts we hold, published 19 June 2022 to 20 August 2022, using the newest reading held for each. Telegram Stars are excluded: they are a payment, not a reaction, and they have their own section.

Recent posts

20 Aug 2022, 19:46 UTC≈1,170 viewsread 9 August 2026
Poll

Необходимо предсказать выручку отдельной точки сети магазинов по нескольким известным параметрам. Что будем использовать?

  1. Линейную регрессию75%
  2. Логистическую регрессию25%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

20 Aug 2022, 19:37 UTC≈1,170 viewsread 9 August 2026

A/B- тест Для двух несвязанных выборок есть два основных метода поиска различий: - параметрический - критерий t-стьюдента -непараметрический - критерий Манна Уитни. Уже от свойств выборок выбираем, какой критерий будем считать.

20 Aug 2022, 19:31 UTC≈1,090 viewsread 9 August 2026

A/B - тест Для использования параметрического теста необходимо, чтобы выборки не имели выбросов, имели более 30 измерений и распределение значений соответствовало нормальному. Вопрос: будет ли распределение автоматически нормальным, если количество значений в выборке, например, 1000?

17 Aug 2022, 18:32 UTC684 views2 reactionsread 9 August 2026

Какой запрос вы попросите написать, чтобы понять, с какой СУБД вы имеете дело? Я бы попросила обработать столбец с датами. Но возможно я не права. Ориентируюсь только на то, что в postgree и my sql по разному вытаскиваются части даты.

🤔2

17 Aug 2022, 18:32 UTC825 views2 reactionsread 9 August 2026
Forwarded from @sql_wiki

Разбор тестового задания в Тиньков [SQL] Источник

👍2

4 Aug 2022, 17:55 UTC701 views1 reactionsread 9 August 2026
Forwarded from @cryptovalerii

Мой близкий друг Саша Сахнов - человек который на мой взгляд лучше всех разбирается в а/б тестах Еще в далеком 2018 году мы с ним и рядом других людей начали писать на Хабр про А/Б. Сейчас он запустил цикл статей про А/Б, где каждая статья будет сложнее предыдущей - первая довольно базовая статья про Бутстрап (Обратите внимание на центральный доверительный интервал) Также интересен небольшой разбор стратификации дл

🔥1

1 Aug 2022, 11:27 UTC634 viewsread 9 August 2026

В базе данных PostgreeSQL для связи таблиц по принципу "многие ко многим" - например, клиент может прочитать несколько книг, одна книга может быть прочитана несколькими клиентами, используется таблица связка, которая объединяет клиентов и книги. Получается для реализации связи "многие ко многим" используется не две, а три таблицы. Две основные и одна связующая с двумя внешними ключами. #postgreesql

24 Jul 2022, 20:01 UTC722 viewsread 9 August 2026

В PosgreeSQL для обновления строк по условию после SET ставим WHERE. UPDATE таблицы, участвующие в обновлении SET выражение, по которому обновляем значение WHERE условие, при котором происходит обновление

22 Jul 2022, 19:04 UTC725 viewsread 9 August 2026

Мне срочно надо запомнить команды для управления таблицей с данными в PostgreeSQL: - CREATE TABLE - создать таблицу - INSERT INTO VALUES- добавление строк в таблицу - UPDATE SET - обновление данных в таблице

22 Jul 2022, 18:56 UTC633 viewsread 9 August 2026

Попробуйте объяснить своими словами, что такое база данных и зачем она нужна? Отвечу прям никуда не заглядывая) База данных - совокупность данных, например, в виде таблиц, о работе сервиса, продукта, приложения. Данные связаны между собой с помощью схемы, которая позволяет их удобно хранить и использовать. Может включать в себя данные о произошедших событиях, ценах на товары, услуги и т. д. Нужна для работы продук

19 Jul 2022, 19:12 UTC540 views10 reactionsread 9 August 2026

Запомните раз и навсегда в каком порядке выполняются запросы в SQL. Говорят на собеседованиях спрашивают) FROM WHERE GROUP BY HAVING SELECT ORDER BY

👍10

19 Jul 2022, 19:10 UTC474 views1 reactionsread 9 August 2026

Интересное исследование подкинул Юра https://t.me/People_Analytics. Табло вышло на первый уровень, а статистика, которой я так много уделяю внимания вообще вылетела. Ну, хоть питон с SQL на месте. https://t.me/People_Analytics/250

👍1

Showing the 12 most recent of 20 posts we hold for @anna_data. View and reaction counts are the latest single reading for each post, not a live figure, and a recent post is still accumulating both. A view count marked was rounded by Telegram before we ever saw it — t.me prints views in full below 1,000 and to three significant figures above, so ≈1,200,000 means somewhere between 1,150,000 and 1,249,999. Unmarked counts are exact. Text is reproduced from the public post preview and truncated for length.

Polls

The 3 polls we hold for this entry, as Telegram rendered them when we read the post. A poll’s figures keep moving after that, so each one is dated.

20 Aug 2022, 19:46 UTCAnonymous Quiz79 voters

Необходимо предсказать выручку отдельной точки сети магазинов по нескольким известным параметрам. Что будем использовать?

  1. Линейную регрессию75%
  2. Логистическую регрессию25%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

1 Jul 2022, 18:53 UTCAnonymous Poll28 voters

Как интерпретировать мощность критерия?

  1. Вероятность найти различия, когда эти различия есть68%
  2. Вероятность не найти различия, когда различий нет0%
  3. Вероятность найти различия, когда различий нет18%
  4. Вероятность не найти различия, когда они различия есть14%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

1 Jul 2022, 18:47 UTCAnonymous Quiz22 voters

Какая связь между ошибкой второго рода и мощностью критерия?

  1. Мощность = Ошибка*1005%
  2. Мощность = 1 - Ошибка77%
  3. Ошибка = Мощность -118%
  4. Мощность = Ошибка -10%

Shares as published. No per-option vote count is published by Telegram, so none is shown.

Percentages only — there are no per-option vote counts here, because Telegram publishes none.The public post preview gives each option’s share and a single voter total, and nothing else. Multiplying one by the other would produce a per-option tally that looks measured and is not: the shares are rounded to whole numbers before we ever see them. We print what was published and leave the column that does not exist empty.

The shares need not add up to 100.Rounding alone puts many polls at 99 or 101. A poll that allows more than one answer per voter runs well past 100 by design, and several here do. The bars are drawn against a fixed 100% track at each option’s own percentage rather than normalised to the total, so a poll that exceeds it shows that it does instead of being quietly rescaled.

Read from the 20 most recent posts we hold, published 19 June 2022 to 20 August 2022. Telegram labels each poll by kind — an anonymous poll, a quiz, a closed set of final results — and that label is reproduced rather than paraphrased.

Forward network

Built only from forwarded posts we have actually read, on both sides. Coverage is early and deliberately incomplete: a missing link means we have not read the post that would prove it, never that the relationship does not exist. Counts are distinct forwarded posts observed, so they only ever go up as we read more.

Mentions

A mention is a weaker signal than a forward and is counted separately for that reason — naming a channel is not republishing it, and a handle in a post body is easy to place deliberately. The post counts beside each row below are distinct posts in which the handle appeared, from posts we have read on both sides — the “Named by N registered channels” figure above is a different count, of distinct NAMING CHANNELS rather than posts, and is not the sum of the rows under it.

Cite this entry

A live page changes as we take new readings, so a citation should name the measurement it is based on, not just the URL. The line below cites the subscriber count as measured 9 August 2026 — this entry's latest reading, not the date you are reading this.

“Аня - аналитик данных👩‍🌾” (@anna_data), 96 subscribers as measured 9 August 2026. Telegram Register, tgregister.com/channel/anna_data.

Full measurement history, CC BY 4.0. Every reading this register holds for this entry, not just the latest one, as a dated, downloadable record: CSV · JSON. Free to use with attribution to tgregister.com. Each file carries its own generation timestamp, which is the figure to cite for exactly when the data was retrieved.