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 451 obunachidan iborat bo'lib, Taʼlim toifasida 4 731-o'rinni va Hindiston mintaqasida 9 509-o'rinni egallagan.
📊 Auditoriya ko‘rsatkichlari va dinamika
невідомо sanasidan buyon loyiha tez o‘sib, 39 451 obunachiga ega bo‘ldi.
15 Noyabr, 2026 dagi oxirgi ma’lumotlarga ko‘ra kanal barqaror faollikka ega. Oxirgi 30 kunda obunachilar soni -234 ga, so‘nggi 24 soatda esa -11 ga o‘zgardi va umumiy qamrov yuqori darajada qolmoqda.
- Tasdiqlash holati: Tasdiqlanmagan
- Jalb etish (ER): Auditoriya o‘rtacha 2.13% darajada jalb etiladi. Nashrdan keyingi dastlabki 24 soatda kontent odatda umumiy obunachilar sonining 0.62% ini tashkil etuvchi reaksiyalarni to‘playdi.
- Post qamrovi: Har bir post o‘rtacha 839 marta ko‘riladi; birinchi sutkada odatda 246 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 16 Noyabr, 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.
CREATE DATABASE hr_analytics_db;
USE hr_analytics_db;
📂 Step 2: Create Departments Table
CREATE TABLE departments (
department_id INT PRIMARY KEY,
department_name VARCHAR(100)
);
📂 Step 3: Create Employees Table
CREATE TABLE employees (
employee_id INT PRIMARY KEY,
employee_name VARCHAR(100),
gender VARCHAR(10),
age INT,
department_id INT,
designation VARCHAR(100),
salary DECIMAL(10,2),
hire_date DATE,
city VARCHAR(50),
employment_status VARCHAR(20),
FOREIGN KEY (department_id)
REFERENCES departments(department_id)
);
📂 Step 4: Create Attendance Table
CREATE TABLE attendance (
attendance_id INT PRIMARY KEY,
employee_id INT,
attendance_date DATE,
status VARCHAR(20),
FOREIGN KEY (employee_id)
REFERENCES employees(employee_id)
);
📂 Step 5: Create Performance Table
CREATE TABLE performance (
review_id INT PRIMARY KEY,
employee_id INT,
review_year INT,
performance_rating DECIMAL(3,2),
bonus DECIMAL(10,2),
FOREIGN KEY (employee_id)
REFERENCES employees(employee_id)
);
📂 Step 6: Insert Sample Departments
INSERT INTO departments VALUES
(1,'Engineering'),
(2,'Human Resources'),
(3,'Finance'),
(4,'Sales'),
(5,'Marketing');
📂 Step 7: Insert Sample Employees
INSERT INTO employees VALUES
(101,'Rahul Sharma','Male',30,1,'Software Engineer',85000,'2022-01-15','Mumbai','Active'),
(102,'Priya Verma','Female',28,4,'Sales Executive',65000,'2023-03-10','Delhi','Active'),
(103,'Amit Patel','Male',35,3,'Financial Analyst',92000,'2021-06-20','Pune','Active'),
(104,'Sneha Joshi','Female',31,2,'HR Manager',78000,'2020-11-12','Bangalore','Active'),
(105,'Rohan Gupta','Male',29,5,'Marketing Specialist',70000,'2024-02-01','Hyderabad','Resigned');
📂 Step 8: Insert Sample Attendance
INSERT INTO attendance VALUES
(1,101,'2025-01-01','Present'),
(2,102,'2025-01-01','Present'),
(3,103,'2025-01-01','Absent'),
(4,104,'2025-01-01','Present'),
(5,105,'2025-01-01','Leave');
📂 Step 9: Insert Sample Performance Data
INSERT INTO performance VALUES
(1,101,2024,4.8,20000),
(2,102,2024,4.3,12000),
(3,103,2024,4.9,25000),
(4,104,2024,4.5,18000),
(5,105,2024,3.9,10000);