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 494 obunachidan iborat bo'lib, Taสผlim toifasida 4 752-o'rinni va Hindiston mintaqasida 10 399-o'rinni egallagan.
๐ Auditoriya koโrsatkichlari va dinamika
ะฝะตะฒัะดะพะผะพ sanasidan buyon loyiha tez oโsib, 39 494 obunachiga ega boโldi.
10 Iyun, 2026 dagi oxirgi maโlumotlarga koโra kanal barqaror faollikka ega. Oxirgi 30 kunda obunachilar soni 198 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 2.80% darajada jalb etiladi. Nashrdan keyingi dastlabki 24 soatda kontent odatda umumiy obunachilar sonining 1.00% ini tashkil etuvchi reaksiyalarni toโplaydi.
- Post qamrovi: Har bir post oโrtacha 1 107 marta koโriladi; birinchi sutkada odatda 393 ta koโrish yigโiladi.
- Reaksiyalar va oโzaro taโsir: Auditoriya faol: har bir postga oโrtacha 3 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 11 Iyun, 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.
import pandas as pd
df = pd.read_csv('sales_data.csv')
df.drop_duplicates(inplace=True) # Remove duplicate rows
df.fillna(0, inplace=True) # Fill missing values with 0
print(df.head())
๐ก Tip: Always check for inconsistent spellings and incorrect date formats!
๐ Task 2: Analyzing Sales Trends
A company wants to know which months have the highest sales.
โ
Solution (Using SQL):
SELECT MONTH(SaleDate) AS Month, SUM(Quantity * Price) AS Total_Revenue
FROM Sales
GROUP BY MONTH(SaleDate)
ORDER BY Total_Revenue DESC;
๐ก Tip: Try adding YEAR(SaleDate) to compare yearly trends!
๐ Task 3: Creating a Business Dashboard
Your manager asks you to create a dashboard showing revenue by region, top-selling products, and monthly growth.
โ
Solution (Using Power BI / Tableau):
๐ Add KPI Cards to show total sales & profit
๐ Use a Line Chart for monthly trends
๐ Create a Bar Chart for top-selling products
๐ Use Filters/Slicers for better interactivity
๐ก Tip: Keep your dashboards clean, interactive, and easy to interpret!
Like this post for more content like this โฅ๏ธ
Share with credits: https://t.me/sqlspecialist
Hope it helps :)SELECT *
FROM (
SELECT p.product_id, p.category, SUM(o.revenue) AS total_revenue,
RANK() OVER(PARTITION BY p.category ORDER BY SUM(o.revenue) DESC) AS rnk
FROM products p
JOIN orders o ON p.product_id = o.product_id
GROUP BY p.product_id, p.category
) ranked
WHERE rnk <= 3;
Q2. Find users who purchased in January but not in February
SELECT DISTINCT user_id
FROM orders
WHERE MONTH(order_date) = 1
AND user_id NOT IN (
SELECT user_id FROM orders WHERE MONTH(order_date) = 2
);
Q3. Avg. ride time by city + peak hours
SELECT city, AVG(DATEDIFF(MINUTE, start_time, end_time)) AS avg_ride_mins
FROM trips
GROUP BY city;
-- For peak hour detection (example logic)
SELECT DATEPART(HOUR, start_time) AS ride_hour, COUNT(*) AS ride_count
FROM trips
GROUP BY DATEPART(HOUR, start_time)
ORDER BY ride_count DESC;
โธป
๐น Round 2: Python + Data Cleaning
Q1. Clean messy CSV with pandas
import pandas as pd
df = pd.read_csv('data.csv')
df.columns = df.columns.str.strip().str.lower()
df.drop_duplicates(inplace=True)
df['date'] = pd.to_datetime(df['date'], errors='coerce')
df.fillna(method='ffill', inplace=True)
Q2. Extract domain names from email IDs
emails = ['abc@gmail.com', 'xyz@outlook.com']
domains = [email.split('@')[1] for email in emails]
Q3. Difference: .loc[] vs .iloc[]
โข .loc[] โ label-based selection
โข .iloc[] โ index-based selection
Q4. Handle outliers using IQR
Q1 = df['column'].quantile(0.25)
Q3 = df['column'].quantile(0.75)
IQR = Q3 - Q1
filtered_df = df[(df['column'] >= Q1 - 1.5*IQR) & (df['column'] <= Q3 + 1.5*IQR)]
โธป
๐น Round 3: Power BI / Dashboarding
Tasks you should know:
โข Create a dashboard with weekly trends, margins, churn %
โข Use bookmarks/slicers for KPI toggles
โข Apply filters to show top 5 items dynamically
โข Exclude visuals from slicer using โEdit Interactionsโ โ turn off filter icon on card visual
๐ Try replicating dashboards from Power BI Gallery
โธป
๐น Round 4: Business Case + Logic-Based Thinking
Q1. Sales dropped last quarter โ what to check?
โข Compare YoY/QoQ data
โข Identify categories/geos with the biggest drop
โข Analyze order volume vs. avg. order value
โข Check marketing spend, discounts, stockouts
Q2. App downloads โฌ๏ธ, activity โฌ๏ธ โ whatโs wrong?
โข Check Day 1/7/30 retention
โข Is onboarding working?
โข UI bugs or crashes?
โข Compare install โ sign-up โ usage funnel
Q3. Returns increasing โ how to investigate?
โข Analyze return % by brand, category, SKU
โข Check return reasons (defects, sizing, etc.)
โข Compare returnersโ order history
โข Seasonal impact?
โธป
๐ฐ Free Practice Tools:
โข ๐น SQL on LeetCode
โข ๐น Python on Hackerrank
โข ๐น Power BI Gallery
Endi mavjud! Telegram Tadqiqoti 2025 โ yilning asosiy insaytlari 
