Data Analyst Interview Resources
Join our telegram channel to learn how data analysis can reveal fascinating patterns, trends, and stories hidden within the numbers! ð For ads & suggestions: @love_data
Ko'proq ko'rsatishð Telegram kanali Data Analyst Interview Resources analitikasi
Data Analyst Interview Resources (@dataanalystinterview) Ingliz til segmentidagi kanali faol ishtirokchi. Hozirda hamjamiyat 52 634 obunachidan iborat bo'lib, TaÊŒlim toifasida 3 245-o'rinni va Hindiston mintaqasida 6 679-o'rinni egallagan.
ð Auditoriya koârsatkichlari va dinamika
МевÑЎПЌП sanasidan buyon loyiha tez oâsib, 52 634 obunachiga ega boâldi.
30 Avgust, 2026 dagi oxirgi maâlumotlarga koâra kanal barqaror faollikka ega. Oxirgi 30 kunda obunachilar soni 9 ga, soânggi 24 soatda esa 5 ga oâzgardi va umumiy qamrov yuqori darajada qolmoqda.
- Tasdiqlash holati: Tasdiqlanmagan
- Jalb etish (ER): Auditoriya oârtacha 1.84% darajada jalb etiladi. Nashrdan keyingi dastlabki 24 soatda kontent odatda umumiy obunachilar sonining 0.82% ini tashkil etuvchi reaksiyalarni toâplaydi.
- Post qamrovi: Har bir post oârtacha 970 marta koâriladi; birinchi sutkada odatda 433 ta koârish yigâiladi.
- Reaksiyalar va oâzaro taâsir: Auditoriya faol: har bir postga oârtacha 2 ta reaksiya keladi.
- Tematik yoânalishlar: Kontent sql, row, |--, dataset, visualization kabi asosiy mavzularga jamlangan.
ð Tavsif va kontent siyosati
Muallif resursni shaxsiy fikrni ifoda etish maydoni sifatida taâriflaydi:
âJoin our telegram channel to learn how data analysis can reveal fascinating patterns, trends, and stories hidden within the numbers! ð
For ads & suggestions: @love_dataâ
Yuqori yangilanish chastotasi (oxirgi maâlumot 31 Avgust, 2026 da olingan) sababli kanal doimo dolzarb va katta qamrovli boâlib qoladi. Analitika auditoriya kontent bilan faol hamkorlik qilishini, uni TaÊŒlim toifasidagi muhim taâsir nuqtasiga aylantirishini koârsatadi.
SELECT department_id, AVG(salary) AS avg_salary
FROM employees
GROUP BY department_id;
2. What does Filter context in DAX mean?
Answer - Filter context in DAX refers to the subset of data that is actively being used in the calculation of a measure or in the evaluation of an expression. This context is determined by filters on the dashboard items like slicers, visuals, and filters pane which restrict the data being processed.
3. Explain how to implement Row-Level Security (RLS) in Power BI.
Answer - Row-Level Security (RLS) in Power BI can be implemented by:
- Creating roles within the Power BI service.
- Defining DAX expressions that specify the data each role can access.
- Assigning users to these roles either in Power BI or dynamically through AD group membership.
4. Create a dictionary, add elements to it, modify an element, and then print the dictionary in alphabetical order of keys.
Answer -
d = {'apple': 2, 'banana': 5}
d['orange'] = 3 # Add element
d['apple'] = 4 # Modify element
sorted_d = dict(sorted(d.items())) # Sort dictionary
print(sorted_d)
5. Find and print duplicate values in a list of assorted numbers, along with the number of times each value is repeated.
Answer -
from collections import Counter
numbers = [1, 2, 2, 3, 4, 5, 1, 6, 7, 3, 8, 1]
count = Counter(numbers)
duplicates = {k: v for k, v in count.items() if v > 1}
print(duplicates)