Forwarded from Data Analyst Interview Resources
SQL Interview Questions with Answers
Like for more β€οΈ
Like for more β€οΈ
π1
ML interview Question π
What is Quantization in machine learning?
Quantization the process of reducing the precision of the numbers used to represent a model's parameters, such as weights and activations. This is often done by converting 32-bit floating-point numbers (commonly used in training) to lower precision formats, like 16-bit or 8-bit integers.
Quantization is primarily used during model inference to:
1. Reduce model size: Lower precision numbers require less memory.
2. Improve computational efficiency: Operations on lower-precision data types are faster and require less power.
3. Speed up inference: Smaller models can be loaded faster, improving performance on edge devices like smartphones or IoT devices.
Quantization can lead to a small loss in model accuracy, as reducing precision can introduce rounding errors. But in many cases, the trade-off between accuracy and efficiency is worthwhile, especially for deployment on resource-constrained devices.
There are different types of quantization:
1. Post-training quantization: Applied after the model has been trained.
2.Quantization-aware training (QAT): Takes quantization into account during the training process to minimize the accuracy drop.
Best Data Science & Machine Learning Resources:
https://topmate.io/sumit_kumar80/1151675
ENJOY LEARNING ππ
What is Quantization in machine learning?
Quantization the process of reducing the precision of the numbers used to represent a model's parameters, such as weights and activations. This is often done by converting 32-bit floating-point numbers (commonly used in training) to lower precision formats, like 16-bit or 8-bit integers.
Quantization is primarily used during model inference to:
1. Reduce model size: Lower precision numbers require less memory.
2. Improve computational efficiency: Operations on lower-precision data types are faster and require less power.
3. Speed up inference: Smaller models can be loaded faster, improving performance on edge devices like smartphones or IoT devices.
Quantization can lead to a small loss in model accuracy, as reducing precision can introduce rounding errors. But in many cases, the trade-off between accuracy and efficiency is worthwhile, especially for deployment on resource-constrained devices.
There are different types of quantization:
1. Post-training quantization: Applied after the model has been trained.
2.Quantization-aware training (QAT): Takes quantization into account during the training process to minimize the accuracy drop.
Best Data Science & Machine Learning Resources:
https://topmate.io/sumit_kumar80/1151675
ENJOY LEARNING ππ
topmate.io
Data science Job + Placement with Sumit Kumar
For College and Working Professional
π οΈ Must-Know SQL Commands & Functions β
1. SELECT β Retrieve data
βΊ SELECT * FROM customers;
2. WHERE β Filter rows
βΊ SELECT * FROM orders WHERE amount > 500;
3. ORDER BY β Sort results
βΊ SELECT name FROM users ORDER BY age DESC;
4. GROUP BY β Aggregate data
βΊ SELECT department, COUNT(*) FROM employees GROUP BY department;
5. JOIN β Combine tables
βΊ SELECT a.name, b.salary FROM employees a JOIN salaries b ON a.id = b.emp_id;
6. INSERT INTO β Add new data
βΊ INSERT INTO users (name, age) VALUES ('John', 30);
7. UPDATE β Modify existing data
βΊ UPDATE products SET price = 100 WHERE id = 1;
8. DELETE β Remove data
βΊ DELETE FROM logs WHERE date < '2023-01-01';
9. LIKE β Pattern matching
βΊ SELECT * FROM customers WHERE name LIKE 'A%';
10. LIMIT β Restrict result rows
βΊ SELECT * FROM sales LIMIT 10;
π‘ Tip: Practice on real datasets. Learn JOIN and GROUP BY earlyβtheyβre game changers!
SQL Resources:
https://topmate.io/sumit_kumar80/1151675
Placement Resources:
https://topmate.io/sumit_kumar80/1148833
β¨ Tap β€οΈ if this helped you!
1. SELECT β Retrieve data
βΊ SELECT * FROM customers;
2. WHERE β Filter rows
βΊ SELECT * FROM orders WHERE amount > 500;
3. ORDER BY β Sort results
βΊ SELECT name FROM users ORDER BY age DESC;
4. GROUP BY β Aggregate data
βΊ SELECT department, COUNT(*) FROM employees GROUP BY department;
5. JOIN β Combine tables
βΊ SELECT a.name, b.salary FROM employees a JOIN salaries b ON a.id = b.emp_id;
6. INSERT INTO β Add new data
βΊ INSERT INTO users (name, age) VALUES ('John', 30);
7. UPDATE β Modify existing data
βΊ UPDATE products SET price = 100 WHERE id = 1;
8. DELETE β Remove data
βΊ DELETE FROM logs WHERE date < '2023-01-01';
9. LIKE β Pattern matching
βΊ SELECT * FROM customers WHERE name LIKE 'A%';
10. LIMIT β Restrict result rows
βΊ SELECT * FROM sales LIMIT 10;
π‘ Tip: Practice on real datasets. Learn JOIN and GROUP BY earlyβtheyβre game changers!
SQL Resources:
https://topmate.io/sumit_kumar80/1151675
Placement Resources:
https://topmate.io/sumit_kumar80/1148833
β¨ Tap β€οΈ if this helped you!
Data Analyst Interview Resources
SQL Interview Questions with Answers Like for more β€οΈ
In live session we will discuss these questions
You can join me Fast 8:45 pm
You can join me Fast 8:45 pm
Thank you for joining guys.
Tomorrow at same time will discuss next chapter
Tomorrow at same time will discuss next chapter
β
Statistics & Probability Cheatsheet ππ§
π Descriptive Statistics:
β¦ Mean = (Ξ£x) / n
β¦ Median = Middle value
β¦ Mode = Most frequent value
β¦ Variance (ΟΒ²) = Ξ£(x - ΞΌ)Β² / n
β¦ Std Dev (Ο) = βVariance
β¦ Range = Max - Min
β¦ IQR = Q3 - Q1
π Probability Basics:
β¦ P(A) = Outcomes A / Total Outcomes
β¦ P(A β© B) = P(A) Γ P(B) (if independent)
β¦ P(A βͺ B) = P(A) + P(B) - P(A β© B)
β¦ Conditional: P(A|B) = P(A β© B) / P(B)
β¦ Bayesβ Theorem: P(A|B) = [P(B|A) Γ P(A)] / P(B)
π Common Distributions:
β¦ Binomial (fixed trials)
β¦ Normal (bell curve)
β¦ Poisson (rare events over time)
β¦ Uniform (equal probability)
π Inferential Stats:
β¦ Z-score = (x - ΞΌ) / Ο
β¦ Central Limit Theorem: sampling dist β Normal
β¦ Confidence Interval: CI = xβ Β± z*(Ο/βn)
π Hypothesis Testing:
β¦ Hβ = No effect; Hβ = Effect present
β¦ p-value < Ξ± β Reject Hβ
β¦ Tests: t-test (small samples), z-test (known Ο), chi-square (categorical data)
π Correlation:
β¦ Pearson: linear relation (β1 to 1)
β¦ Spearman: rank-based correlation
π§ͺ Tools to Practice:
Python packages: scipy.stats, statsmodels, pandas
Visualization: seaborn, matplotlib
π‘ Quick tip: Use these formulas to crush interviews and build solid ML foundations!
π¬ Tap β€οΈ for more
https://topmate.io/sumit_kumar80/1151675
π Descriptive Statistics:
β¦ Mean = (Ξ£x) / n
β¦ Median = Middle value
β¦ Mode = Most frequent value
β¦ Variance (ΟΒ²) = Ξ£(x - ΞΌ)Β² / n
β¦ Std Dev (Ο) = βVariance
β¦ Range = Max - Min
β¦ IQR = Q3 - Q1
π Probability Basics:
β¦ P(A) = Outcomes A / Total Outcomes
β¦ P(A β© B) = P(A) Γ P(B) (if independent)
β¦ P(A βͺ B) = P(A) + P(B) - P(A β© B)
β¦ Conditional: P(A|B) = P(A β© B) / P(B)
β¦ Bayesβ Theorem: P(A|B) = [P(B|A) Γ P(A)] / P(B)
π Common Distributions:
β¦ Binomial (fixed trials)
β¦ Normal (bell curve)
β¦ Poisson (rare events over time)
β¦ Uniform (equal probability)
π Inferential Stats:
β¦ Z-score = (x - ΞΌ) / Ο
β¦ Central Limit Theorem: sampling dist β Normal
β¦ Confidence Interval: CI = xβ Β± z*(Ο/βn)
π Hypothesis Testing:
β¦ Hβ = No effect; Hβ = Effect present
β¦ p-value < Ξ± β Reject Hβ
β¦ Tests: t-test (small samples), z-test (known Ο), chi-square (categorical data)
π Correlation:
β¦ Pearson: linear relation (β1 to 1)
β¦ Spearman: rank-based correlation
π§ͺ Tools to Practice:
Python packages: scipy.stats, statsmodels, pandas
Visualization: seaborn, matplotlib
π‘ Quick tip: Use these formulas to crush interviews and build solid ML foundations!
π¬ Tap β€οΈ for more
https://topmate.io/sumit_kumar80/1151675
topmate.io
Data science Job + Placement with Sumit Kumar
For College and Working Professional
π Data Analytics β Key Concepts for Beginners π
1οΈβ£ What is Data Analytics?
β The process of examining data sets to draw conclusions using tools, techniques, and statistical models.
2οΈβ£ Types of Data Analytics:
- Descriptive: What happened?
- Diagnostic: Why did it happen?
- Predictive: What could happen?
- Prescriptive: What should we do?
3οΈβ£ Common Tools:
- Excel
- SQL
- Python (Pandas, NumPy)
- R
- Tableau / Power BI
- Google Data Studio
4οΈβ£ Basic Skills Required:
- Data cleaning & preprocessing
- Data visualization
- Statistical analysis
- Querying databases
- Business understanding
5οΈβ£ Key Concepts:
- Data types (numerical, categorical)
- Mean, median, mode
- Correlation vs causation
- Outliers & missing values
- Data normalization
6οΈβ£ Important Libraries (Python):
- Pandas (data manipulation)
- Matplotlib / Seaborn (visualization)
- Scikit-learn (machine learning)
- Statsmodels (statistical modeling)
7οΈβ£ Typical Workflow:
Data Collection β Cleaning β Analysis β Visualization β Reporting
π‘ Tip: Always ask the right business question before jumping into analysis.
π¬ Tap β€οΈ for more!
1οΈβ£ What is Data Analytics?
β The process of examining data sets to draw conclusions using tools, techniques, and statistical models.
2οΈβ£ Types of Data Analytics:
- Descriptive: What happened?
- Diagnostic: Why did it happen?
- Predictive: What could happen?
- Prescriptive: What should we do?
3οΈβ£ Common Tools:
- Excel
- SQL
- Python (Pandas, NumPy)
- R
- Tableau / Power BI
- Google Data Studio
4οΈβ£ Basic Skills Required:
- Data cleaning & preprocessing
- Data visualization
- Statistical analysis
- Querying databases
- Business understanding
5οΈβ£ Key Concepts:
- Data types (numerical, categorical)
- Mean, median, mode
- Correlation vs causation
- Outliers & missing values
- Data normalization
6οΈβ£ Important Libraries (Python):
- Pandas (data manipulation)
- Matplotlib / Seaborn (visualization)
- Scikit-learn (machine learning)
- Statsmodels (statistical modeling)
7οΈβ£ Typical Workflow:
Data Collection β Cleaning β Analysis β Visualization β Reporting
π‘ Tip: Always ask the right business question before jumping into analysis.
π¬ Tap β€οΈ for more!
πΉ Top 10 SQL Functions/Commands Commonly Used in Data Analysis π
1οΈβ£ SELECT
β Used to retrieve specific columns from a table.
SELECT name, age FROM users;
2οΈβ£ WHERE
β Filters rows based on a condition.
SELECT Γ FROM sales WHERE region = 'North';
3οΈβ£ GROUP BY
β Groups rows that have the same values into summary rows.
SELECT region, SUM(sales) FROM sales GROUP BY region;
4οΈβ£ ORDER BY
β Sorts the result by one or more columns.
SELECT * FROM customers ORDER BY created_at DESC;
5οΈβ£ JOIN
β Combines rows from two or more tables based on a related column.
SELECT a.name, b.salary
FROM employees a
JOIN salaries b ON a.id = b.emp_id;
6οΈβ£ COUNT() / SUM() / AVG() / MIN() / MAX()
β Common aggregate functions for metrics and summaries.
SELECT COUNT(Γ) FROM orders WHERE status = 'completed';
7οΈβ£ HAVING
β Filters after a GROUP BY (unlike WHERE, which filters before).
SELECT department, COUNT() FROM employees GROUP BY department HAVING COUNT() > 10;
8οΈβ£ LIMIT
β Restricts number of rows returned.
SELECT * FROM products LIMIT 5;
9οΈβ£ CASE
β Implements conditional logic in queries.
SELECT name,
CASE
WHEN score >= 90 THEN 'A'
WHEN score >= 75 THEN 'B'
ELSE 'C'
END AS grade
FROM students;
π DATE functions (NOW(), DATE_PART(), DATEDIFF(), etc.)
β Handle and extract info from dates.
SELECT DATE_PART('year', order_date) FROM orders;
π¬ Tap β€οΈ for more!
1οΈβ£ SELECT
β Used to retrieve specific columns from a table.
SELECT name, age FROM users;
2οΈβ£ WHERE
β Filters rows based on a condition.
SELECT Γ FROM sales WHERE region = 'North';
3οΈβ£ GROUP BY
β Groups rows that have the same values into summary rows.
SELECT region, SUM(sales) FROM sales GROUP BY region;
4οΈβ£ ORDER BY
β Sorts the result by one or more columns.
SELECT * FROM customers ORDER BY created_at DESC;
5οΈβ£ JOIN
β Combines rows from two or more tables based on a related column.
SELECT a.name, b.salary
FROM employees a
JOIN salaries b ON a.id = b.emp_id;
6οΈβ£ COUNT() / SUM() / AVG() / MIN() / MAX()
β Common aggregate functions for metrics and summaries.
SELECT COUNT(Γ) FROM orders WHERE status = 'completed';
7οΈβ£ HAVING
β Filters after a GROUP BY (unlike WHERE, which filters before).
SELECT department, COUNT() FROM employees GROUP BY department HAVING COUNT() > 10;
8οΈβ£ LIMIT
β Restricts number of rows returned.
SELECT * FROM products LIMIT 5;
9οΈβ£ CASE
β Implements conditional logic in queries.
SELECT name,
CASE
WHEN score >= 90 THEN 'A'
WHEN score >= 75 THEN 'B'
ELSE 'C'
END AS grade
FROM students;
π DATE functions (NOW(), DATE_PART(), DATEDIFF(), etc.)
β Handle and extract info from dates.
SELECT DATE_PART('year', order_date) FROM orders;
π¬ Tap β€οΈ for more!