Data Analytics Projects - SQL, Excel, Tableau, Python & Power BI Interview Resources
Covering all technical and popular stuff about anything related to Data Science: AI, Big Data, Machine Learning, Statistics, general Math and the applications of former. Ads/ Promo: @love_data
Ko'proq ko'rsatishð Telegram kanali Data Analytics Projects - SQL, Excel, Tableau, Python & Power BI Interview Resources analitikasi
Data Analytics Projects - SQL, Excel, Tableau, Python & Power BI Interview Resources (@sqlproject) Ingliz til segmentidagi kanali faol ishtirokchi. Hozirda hamjamiyat 39 684 obunachidan iborat bo'lib, TaÊŒlim toifasida 4 606-o'rinni va Hindiston mintaqasida 9 819-o'rinni egallagan.
ð Auditoriya koârsatkichlari va dinamika
МевÑЎПЌП sanasidan buyon loyiha tez oâsib, 39 684 obunachiga ega boâldi.
26 Avgust, 2026 dagi oxirgi maâlumotlarga koâra kanal barqaror faollikka ega. Oxirgi 30 kunda obunachilar soni 56 ga, soânggi 24 soatda esa 3 ga oâzgardi va umumiy qamrov yuqori darajada qolmoqda.
- Tasdiqlash holati: Tasdiqlanmagan
- Jalb etish (ER): Auditoriya oârtacha 1.80% darajada jalb etiladi. Nashrdan keyingi dastlabki 24 soatda kontent odatda umumiy obunachilar sonining 0.73% ini tashkil etuvchi reaksiyalarni toâplaydi.
- Post qamrovi: Har bir post oârtacha 715 marta koâriladi; birinchi sutkada odatda 291 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 analytic, dataset, visualization, sql, learning kabi asosiy mavzularga jamlangan.
ð Tavsif va kontent siyosati
Muallif resursni shaxsiy fikrni ifoda etish maydoni sifatida taâriflaydi:
âCovering all technical and popular stuff about anything related to Data Science: AI, Big Data, Machine Learning, Statistics, general Math and the applications of former.
Ads/ Promo: @love_dataâ
Yuqori yangilanish chastotasi (oxirgi maâlumot 27 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 name, email FROM users;
This fetches only the name and email columns from the users table.
âïž Used when you donât want all columns from a table.
2ïžâ£ Filter Records with WHERE
SELECT * FROM users WHERE age > 30;
The WHERE clause filters rows where age is greater than 30.
âïž Used for applying conditions on data.
3ïžâ£ ORDER BY Clause
SELECT * FROM users ORDER BY registered_at DESC;
Sorts all users based on registered_at in descending order.
âïž Helpful to get latest data first.
4ïžâ£ Aggregate Functions (COUNT, AVG)
SELECT COUNT(*) AS total_users, AVG(age) AS avg_age FROM users;
Explanation:
- COUNT(*) counts total rows (users).
- AVG(age) calculates the average age.
âïž Used for quick stats from tables.
5ïžâ£ GROUP BY Usage
SELECT city, COUNT(*) AS user_count FROM users GROUP BY city;
Groups data by city and counts users in each group.
âïž Use when you want grouped summaries.
6ïžâ£ JOIN Tables
SELECT users.name, orders.amount
FROM users
JOIN orders ON users.id = orders.user_id;
Fetches user names along with order amounts by joining users and orders on matching IDs.
âïž Essential when combining data from multiple tables.
7ïžâ£ Use of HAVING
SELECT city, COUNT(*) AS total
FROM users
GROUP BY city
HAVING COUNT(*) > 5;
Like WHERE, but used with aggregates. This filters cities with more than 5 users.
âïž **Use HAVING after GROUP BY.**
8ïžâ£ Subqueries
SELECT * FROM users
WHERE salary > (SELECT AVG(salary) FROM users);
Finds users whose salary is above the average. The subquery calculates the average salary first.
âïž Nested queries for dynamic filtering9ïžâ£ CASE Statementnt**
SELECT name,
CASE
WHEN age < 18 THEN 'Teen'
WHEN age <= 40 THEN 'Adult'
ELSE 'Senior'
END AS age_group
FROM users;
Adds a new column that classifies users into categories based on age.
âïž Powerful for conditional logic.
ð Window Functions (Advanced)
SELECT name, city, score,
RANK() OVER (PARTITION BY city ORDER BY score DESC) AS rank
FROM users;
Ranks users by score *within each city*.
SQL Learning Series: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v/1075