Udemy - Top 101 Data Analyst Interview Questions - Concepts and K...

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - 1. Data Analyst Interview Foundations
• 1. What does a Data Analyst do day-to-day.mp4 (30.3 MB)
• 10. What is ETL and why does it matter to analysts.mp4 (30.4 MB)
• 2. How do you clarify vague business questions.mp4 (31.6 MB)
• 3. How do you prioritize multiple analysis requests.mp4 (27.8 MB)
• 4. What is the difference between a metric and a KPI.mp4 (28.2 MB)
• 5. How do you ensure data quality before analysis.mp4 (29.8 MB)
• 6. How do you explain insights to non-technical stakeholders.mp4 (28.3 MB)
• 7. What is a dataset, table, row, and column.mp4 (26.9 MB)
• 8. What is data granularity and why is it important.mp4 (27.3 MB)
• 9. What is a primary key and foreign key in analytics.mp4 (27.3 MB)
2 - 2. SQL Basics for Data Analysts
• 11. How do you write a basic SELECT query.mp4 (24.7 MB)
• 12. WHERE vs HAVING when to use each.mp4 (27.9 MB)
• 13. GROUP BY and aggregation basics.mp4 (26.6 MB)
• 14. INNER JOIN vs LEFT JOIN.mp4 (27.6 MB)
• 15. Handling NULLs in SQL.mp4 (27.1 MB)
• 16. COUNT( ) vs COUNT(DISTINCT).mp4 (27.2 MB)
• 17. CASE WHEN for categorization.mp4 (25.9 MB)
• 18. Filtering by date ranges.mp4 (27.7 MB)
• 19. Debugging a SQL query that returns wrong counts.mp4 (28.3 MB)
• 20. What is DISTINCT and when is it risky.mp4 (25.1 MB)
• 21. Subquery vs CTE basics.mp4 (26.3 MB)
• 22. UNION vs UNION ALL.mp4 (27.8 MB)
3 - 3. Excel & Spreadsheet Skills
• 23. What Excel functions do analysts use most.mp4 (27.2 MB)
• 24. How do you build a Pivot Table for KPI reporting.mp4 (26.7 MB)
• 25. SUMIFS vs COUNTIFS when and why.mp4 (27.8 MB)
• 26. LOOKUPs in Excel XLOOKUP or INDEX-MATCH.mp4 (26.4 MB)
• 27. Data cleaning in Excel text to columns and trimming.mp4 (27.6 MB)
• 28. How do you create an effective chart in Excel.mp4 (26.3 MB)
• 29. How do you audit a spreadsheet for errors.mp4 (29.6 MB)
• 30. When to use Excel vs SQL vs BI tools.mp4 (29.2 MB)
4 - 4. Data Cleaning & Data Types Basics
• 31. How do you handle missing data.mp4 (30.0 MB)
• 32. How do you detect and remove duplicates correctly.mp4 (28.6 MB)
• 33. How do you treat outliers in analysis.mp4 (29.7 MB)
• 34. Categorical vs numerical data why it matters.mp4 (29.7 MB)
• 35. How do you document assumptions and transformations.mp4 (28.4 MB)
5 - 5. Descriptive Statistics & Probability
• 36. Mean vs median which would you report.mp4 (28.2 MB)
• 37. Variance and standard deviation in plain English.mp4 (29.8 MB)
• 38. Percentiles and quartiles for performance reporting.mp4 (30.0 MB)
• 39. Correlation vs causation.mp4 (29.1 MB)
• 40. When to use histogram vs box plot.mp4 (28.1 MB)
• 41. Skewness and why it changes your metric choice.mp4 (27.9 MB)
• 42. Sampling bias and representativeness.mp4 (29.5 MB)
• 43. Central Limit Theorem in practical terms.mp4 (29.3 MB)
• 44. What is a confidence interval and how do you interpret it.mp4 (28.0 MB)
• 45. How do you choose the right summary statistic.mp4 (28.4 MB)
• 46. Covariance and correlation what is the difference.mp4 (28.8 MB)
• 47. What is a z-score and how do you use it.mp4 (29.2 MB)
• 48. Type I and Type II errors in decisions.mp4 (29.0 MB)
6 - 6. KPI Thinking & Business Metrics
• 49. How do you define a KPI clearly.mp4 (28.9 MB)
• 50. Leading vs lagging indicators.mp4 (27.4 MB)
• 51. Funnel metrics how do you analyze drop-off.mp4 (28.0 MB)
• 52. Retention metrics D1, D7, D30.mp4 (29.3 MB)
• 53. Churn definition and measurement choices.mp4 (29.0 MB)
• 54. ARPU and ARPA what do they mean.mp4 (31.0 MB)
• 55. Customer Lifetime Value basics.mp4 (29.2 MB)
• 56. CAC and payback period.mp4 (29.1 MB)
• 57. Metric trees breaking down a KPI.mp4 (29.1 MB)
• 58. North Star metric and supporting metrics.mp4 (28.3 MB)
• 59. Cohort analysis what it is and why it matters.mp4 (31.2 MB)
• 60. Setting KPI targets and thresholds.mp4 (28.9 MB)
7 - 7. Visualization, Dashboards & Storytelling
• 61. How do you choose the right visualization.mp4 (28.7 MB)
• 62. What makes a dashboard trustworthy.mp4 (30.6 MB)
• 63. How do you tell a story with data.mp4 (27.5 MB)
• 64. Avoiding misleading charts and common visualization traps.mp4 (29.8 MB)
• 65. How do you design a KPI dashboard layout.mp4 (29.8 MB)
• 66. Explaining uncertainty and limitations.mp4 (30.2 MB)
• 67. How do you handle conflicting stakeholder interpretations.mp4 (31.3 MB)
• 68. Creating a one-slide executive summary.mp4 (29.1 MB)
• 69. Annotations and context when to add them.mp4 (30.0 MB)
• 70. Data storytelling with comparisons WoW, MoM, YoY.mp4 (30.6 MB)
8 - 8. Experimentation & A B Testing
• 71. How do you design an A B test end-to-end.mp4 (31.7 MB)
• 72. What does statistical significance mean in practice.mp4 (30.9 MB)
• 73. P-value how do you explain it to a stakeholder.mp4 (29.4 MB)
• 74. Power and sample size why tests fail.mp4 (30.5 MB)
• 75. Guardrail metrics and unintended consequences.mp4 (30.6 MB)
• 76. Case DAU dropped yesterday. What do you do.mp4 (33.5 MB)
• 77. Case Conversion rate is down but traffic is up.mp4 (31.4 MB)
• 78. Case Marketing wants ROI for a campaign.mp4 (32.4 MB)
• 79. Case Dashboard numbers do not match Finance.mp4 (35.1 MB)
• 80. Case You suspect a tracking bug.mp4 (34.0 MB)
• 81. Case A B test is inconclusive.mp4 (31.7 MB)
• 82. Case Build a report for weekly business review.mp4 (31.6 MB)
• 83. Case Customer churn is increasing. Create an analysis plan.mp4 (34.2 MB)
• 84. Case Marketplace imbalance between supply and demand.mp4 (32.2 MB)
• 85. Case Pricing change impact analysis.mp4 (35.9 MB)
9 - 10. Advanced SQL & Data Modeling
• 100. Anomaly detection in KPI monitoring.mp4 (31.0 MB)
• 101. Building an analytics project from question to impact.mp4 (34.2 MB)
• 86. Window functions why and how.mp4 (32.3 MB)
• 87. LAG and LEAD for behavioral analysis.mp4 (29.9 MB)
• 88. Slowly Changing Dimensions in analytics.mp4 (31.6 MB)
• 89. Star schema fact and dimension tables.mp4 (31.1 MB)
• 90. Normalizing vs denormalizing for analytics.mp4 (31.1 MB)
• 91. Query optimization making SQL faster.mp4 (30.8 MB)
• 92. Many-to-many joins and bridge tables.mp4 (31.4 MB)
• 93. Linear regression interpreting coefficients.mp4 (30.9 MB)
• 94. Logistic regression for conversion problems.mp4 (31.2 MB)
• 95. Overfitting and how to prevent it.mp4 (29.0 MB)
• 96. Feature leakage a common modeling trap.mp4 (29.8 MB)
• 97. Time series forecasting basics for analysts.mp4 (31.9 MB)
• 98. Difference-in-differences for causal questions.mp4 (31.3 MB)
• 99. Clustering for segmentation.mp4 (30.3 MB)
• Bonus Resources.txt (0.1 KB)