Magnetz

Title: Udemy - Top 101 Data Analyst Interview QuestionsGroup: NOGRPSource: Udemy

Info Hash

E1ECB35919C877F1C8462CEE34C8D414AEA2617D

Source

Unverified

Total Size

2.91 GB

Total Files

100

Seeders

3

Leechers

0

Health

3.00

Score

6

Type

Bookware

File List

File	Size
Get Bonus Downloads Here.url	180 B
~Get Your Files Here !/1 - 1. Data Analyst Interview Foundations/1. What does a Data Analyst do day-to-day.mp4	30.28 MB
~Get Your Files Here !/1 - 1. Data Analyst Interview Foundations/10. What is ETL and why does it matter to analysts.mp4	30.37 MB
~Get Your Files Here !/1 - 1. Data Analyst Interview Foundations/2. How do you clarify vague business questions.mp4	31.58 MB
~Get Your Files Here !/1 - 1. Data Analyst Interview Foundations/3. How do you prioritize multiple analysis requests.mp4	27.81 MB
~Get Your Files Here !/1 - 1. Data Analyst Interview Foundations/4. What is the difference between a metric and a KPI.mp4	28.23 MB
~Get Your Files Here !/1 - 1. Data Analyst Interview Foundations/5. How do you ensure data quality before analysis.mp4	29.76 MB
~Get Your Files Here !/1 - 1. Data Analyst Interview Foundations/6. How do you explain insights to non-technical stakeholders.mp4	28.27 MB
~Get Your Files Here !/1 - 1. Data Analyst Interview Foundations/7. What is a dataset, table, row, and column.mp4	26.89 MB
~Get Your Files Here !/1 - 1. Data Analyst Interview Foundations/8. What is data granularity and why is it important.mp4	27.29 MB
~Get Your Files Here !/1 - 1. Data Analyst Interview Foundations/9. What is a primary key and foreign key in analytics.mp4	27.31 MB
~Get Your Files Here !/2 - 2. SQL Basics for Data Analysts/11. How do you write a basic SELECT query.mp4	24.66 MB
~Get Your Files Here !/2 - 2. SQL Basics for Data Analysts/12. WHERE vs HAVING when to use each.mp4	27.88 MB
~Get Your Files Here !/2 - 2. SQL Basics for Data Analysts/13. GROUP BY and aggregation basics.mp4	26.62 MB
~Get Your Files Here !/2 - 2. SQL Basics for Data Analysts/14. INNER JOIN vs LEFT JOIN.mp4	27.6 MB
~Get Your Files Here !/2 - 2. SQL Basics for Data Analysts/15. Handling NULLs in SQL.mp4	27.08 MB
~Get Your Files Here !/2 - 2. SQL Basics for Data Analysts/16. COUNT( ) vs COUNT(DISTINCT).mp4	27.19 MB
~Get Your Files Here !/2 - 2. SQL Basics for Data Analysts/17. CASE WHEN for categorization.mp4	25.88 MB
~Get Your Files Here !/2 - 2. SQL Basics for Data Analysts/18. Filtering by date ranges.mp4	27.7 MB
~Get Your Files Here !/2 - 2. SQL Basics for Data Analysts/19. Debugging a SQL query that returns wrong counts.mp4	28.33 MB
~Get Your Files Here !/2 - 2. SQL Basics for Data Analysts/20. What is DISTINCT and when is it risky.mp4	25.15 MB
~Get Your Files Here !/2 - 2. SQL Basics for Data Analysts/21. Subquery vs CTE basics.mp4	26.27 MB
~Get Your Files Here !/2 - 2. SQL Basics for Data Analysts/22. UNION vs UNION ALL.mp4	27.76 MB
~Get Your Files Here !/3 - 3. Excel & Spreadsheet Skills/23. What Excel functions do analysts use most.mp4	27.24 MB
~Get Your Files Here !/3 - 3. Excel & Spreadsheet Skills/24. How do you build a Pivot Table for KPI reporting.mp4	26.71 MB
~Get Your Files Here !/3 - 3. Excel & Spreadsheet Skills/25. SUMIFS vs COUNTIFS when and why.mp4	27.82 MB
~Get Your Files Here !/3 - 3. Excel & Spreadsheet Skills/26. LOOKUPs in Excel XLOOKUP or INDEX-MATCH.mp4	26.42 MB
~Get Your Files Here !/3 - 3. Excel & Spreadsheet Skills/27. Data cleaning in Excel text to columns and trimming.mp4	27.65 MB
~Get Your Files Here !/3 - 3. Excel & Spreadsheet Skills/28. How do you create an effective chart in Excel.mp4	26.33 MB
~Get Your Files Here !/3 - 3. Excel & Spreadsheet Skills/29. How do you audit a spreadsheet for errors.mp4	29.6 MB
~Get Your Files Here !/3 - 3. Excel & Spreadsheet Skills/30. When to use Excel vs SQL vs BI tools.mp4	29.19 MB
~Get Your Files Here !/4 - 4. Data Cleaning & Data Types Basics/31. How do you handle missing data.mp4	30.02 MB
~Get Your Files Here !/4 - 4. Data Cleaning & Data Types Basics/32. How do you detect and remove duplicates correctly.mp4	28.6 MB
~Get Your Files Here !/4 - 4. Data Cleaning & Data Types Basics/33. How do you treat outliers in analysis.mp4	29.67 MB
~Get Your Files Here !/4 - 4. Data Cleaning & Data Types Basics/34. Categorical vs numerical data why it matters.mp4	29.75 MB
~Get Your Files Here !/4 - 4. Data Cleaning & Data Types Basics/35. How do you document assumptions and transformations.mp4	28.39 MB
~Get Your Files Here !/5 - 5. Descriptive Statistics & Probability/36. Mean vs median which would you report.mp4	28.16 MB
~Get Your Files Here !/5 - 5. Descriptive Statistics & Probability/37. Variance and standard deviation in plain English.mp4	29.8 MB
~Get Your Files Here !/5 - 5. Descriptive Statistics & Probability/38. Percentiles and quartiles for performance reporting.mp4	30.05 MB
~Get Your Files Here !/5 - 5. Descriptive Statistics & Probability/39. Correlation vs causation.mp4	29.1 MB
~Get Your Files Here !/5 - 5. Descriptive Statistics & Probability/40. When to use histogram vs box plot.mp4	28.1 MB
~Get Your Files Here !/5 - 5. Descriptive Statistics & Probability/41. Skewness and why it changes your metric choice.mp4	27.89 MB
~Get Your Files Here !/5 - 5. Descriptive Statistics & Probability/42. Sampling bias and representativeness.mp4	29.5 MB
~Get Your Files Here !/5 - 5. Descriptive Statistics & Probability/43. Central Limit Theorem in practical terms.mp4	29.29 MB
~Get Your Files Here !/5 - 5. Descriptive Statistics & Probability/44. What is a confidence interval and how do you interpret it.mp4	27.99 MB
~Get Your Files Here !/5 - 5. Descriptive Statistics & Probability/45. How do you choose the right summary statistic.mp4	28.4 MB
~Get Your Files Here !/5 - 5. Descriptive Statistics & Probability/46. Covariance and correlation what is the difference.mp4	28.81 MB
~Get Your Files Here !/5 - 5. Descriptive Statistics & Probability/47. What is a z-score and how do you use it.mp4	29.25 MB
~Get Your Files Here !/5 - 5. Descriptive Statistics & Probability/48. Type I and Type II errors in decisions.mp4	28.98 MB
~Get Your Files Here !/6 - 6. KPI Thinking & Business Metrics/49. How do you define a KPI clearly.mp4	28.92 MB
~Get Your Files Here !/6 - 6. KPI Thinking & Business Metrics/50. Leading vs lagging indicators.mp4	27.4 MB
~Get Your Files Here !/6 - 6. KPI Thinking & Business Metrics/51. Funnel metrics how do you analyze drop-off.mp4	27.99 MB
~Get Your Files Here !/6 - 6. KPI Thinking & Business Metrics/52. Retention metrics D1, D7, D30.mp4	29.32 MB
~Get Your Files Here !/6 - 6. KPI Thinking & Business Metrics/53. Churn definition and measurement choices.mp4	29 MB
~Get Your Files Here !/6 - 6. KPI Thinking & Business Metrics/54. ARPU and ARPA what do they mean.mp4	31.04 MB
~Get Your Files Here !/6 - 6. KPI Thinking & Business Metrics/55. Customer Lifetime Value basics.mp4	29.18 MB
~Get Your Files Here !/6 - 6. KPI Thinking & Business Metrics/56. CAC and payback period.mp4	29.08 MB
~Get Your Files Here !/6 - 6. KPI Thinking & Business Metrics/57. Metric trees breaking down a KPI.mp4	29.14 MB
~Get Your Files Here !/6 - 6. KPI Thinking & Business Metrics/58. North Star metric and supporting metrics.mp4	28.27 MB
~Get Your Files Here !/6 - 6. KPI Thinking & Business Metrics/59. Cohort analysis what it is and why it matters.mp4	31.17 MB
~Get Your Files Here !/6 - 6. KPI Thinking & Business Metrics/60. Setting KPI targets and thresholds.mp4	28.88 MB
~Get Your Files Here !/7 - 7. Visualization, Dashboards & Storytelling/61. How do you choose the right visualization.mp4	28.68 MB
~Get Your Files Here !/7 - 7. Visualization, Dashboards & Storytelling/62. What makes a dashboard trustworthy.mp4	30.62 MB
~Get Your Files Here !/7 - 7. Visualization, Dashboards & Storytelling/63. How do you tell a story with data.mp4	27.48 MB
~Get Your Files Here !/7 - 7. Visualization, Dashboards & Storytelling/64. Avoiding misleading charts and common visualization traps.mp4	29.8 MB
~Get Your Files Here !/7 - 7. Visualization, Dashboards & Storytelling/65. How do you design a KPI dashboard layout.mp4	29.79 MB
~Get Your Files Here !/7 - 7. Visualization, Dashboards & Storytelling/66. Explaining uncertainty and limitations.mp4	30.17 MB
~Get Your Files Here !/7 - 7. Visualization, Dashboards & Storytelling/67. How do you handle conflicting stakeholder interpretations.mp4	31.3 MB
~Get Your Files Here !/7 - 7. Visualization, Dashboards & Storytelling/68. Creating a one-slide executive summary.mp4	29.13 MB
~Get Your Files Here !/7 - 7. Visualization, Dashboards & Storytelling/69. Annotations and context when to add them.mp4	29.98 MB
~Get Your Files Here !/7 - 7. Visualization, Dashboards & Storytelling/70. Data storytelling with comparisons WoW, MoM, YoY.mp4	30.63 MB
~Get Your Files Here !/8 - 8. Experimentation & A B Testing/71. How do you design an A B test end-to-end.mp4	31.68 MB
~Get Your Files Here !/8 - 8. Experimentation & A B Testing/72. What does statistical significance mean in practice.mp4	30.85 MB
~Get Your Files Here !/8 - 8. Experimentation & A B Testing/73. P-value how do you explain it to a stakeholder.mp4	29.35 MB
~Get Your Files Here !/8 - 8. Experimentation & A B Testing/74. Power and sample size why tests fail.mp4	30.47 MB
~Get Your Files Here !/8 - 8. Experimentation & A B Testing/75. Guardrail metrics and unintended consequences.mp4	30.55 MB
~Get Your Files Here !/8 - 8. Experimentation & A B Testing/76. Case DAU dropped yesterday. What do you do.mp4	33.49 MB
~Get Your Files Here !/8 - 8. Experimentation & A B Testing/77. Case Conversion rate is down but traffic is up.mp4	31.36 MB
~Get Your Files Here !/8 - 8. Experimentation & A B Testing/78. Case Marketing wants ROI for a campaign.mp4	32.39 MB
~Get Your Files Here !/8 - 8. Experimentation & A B Testing/79. Case Dashboard numbers do not match Finance.mp4	35.07 MB
~Get Your Files Here !/8 - 8. Experimentation & A B Testing/80. Case You suspect a tracking bug.mp4	34 MB
~Get Your Files Here !/8 - 8. Experimentation & A B Testing/81. Case A B test is inconclusive.mp4	31.66 MB
~Get Your Files Here !/8 - 8. Experimentation & A B Testing/82. Case Build a report for weekly business review.mp4	31.63 MB
~Get Your Files Here !/8 - 8. Experimentation & A B Testing/83. Case Customer churn is increasing. Create an analysis plan.mp4	34.18 MB
~Get Your Files Here !/8 - 8. Experimentation & A B Testing/84. Case Marketplace imbalance between supply and demand.mp4	32.16 MB
~Get Your Files Here !/8 - 8. Experimentation & A B Testing/85. Case Pricing change impact analysis.mp4	35.86 MB
~Get Your Files Here !/9 - 10. Advanced SQL & Data Modeling/100. Anomaly detection in KPI monitoring.mp4	31.04 MB
~Get Your Files Here !/9 - 10. Advanced SQL & Data Modeling/101. Building an analytics project from question to impact.mp4	34.17 MB
~Get Your Files Here !/9 - 10. Advanced SQL & Data Modeling/86. Window functions why and how.mp4	32.3 MB
~Get Your Files Here !/9 - 10. Advanced SQL & Data Modeling/87. LAG and LEAD for behavioral analysis.mp4	29.94 MB
~Get Your Files Here !/9 - 10. Advanced SQL & Data Modeling/88. Slowly Changing Dimensions in analytics.mp4	31.62 MB
~Get Your Files Here !/9 - 10. Advanced SQL & Data Modeling/89. Star schema fact and dimension tables.mp4	31.12 MB
~Get Your Files Here !/9 - 10. Advanced SQL & Data Modeling/90. Normalizing vs denormalizing for analytics.mp4	31.09 MB
~Get Your Files Here !/9 - 10. Advanced SQL & Data Modeling/91. Query optimization making SQL faster.mp4	30.76 MB
~Get Your Files Here !/9 - 10. Advanced SQL & Data Modeling/92. Many-to-many joins and bridge tables.mp4	31.37 MB
~Get Your Files Here !/9 - 10. Advanced SQL & Data Modeling/93. Linear regression interpreting coefficients.mp4	30.85 MB
~Get Your Files Here !/9 - 10. Advanced SQL & Data Modeling/94. Logistic regression for conversion problems.mp4	31.21 MB
~Get Your Files Here !/9 - 10. Advanced SQL & Data Modeling/95. Overfitting and how to prevent it.mp4	28.98 MB
~Get Your Files Here !/9 - 10. Advanced SQL & Data Modeling/96. Feature leakage a common modeling trap.mp4	29.76 MB
~Get Your Files Here !/9 - 10. Advanced SQL & Data Modeling/97. Time series forecasting basics for analysts.mp4	31.93 MB

Trackers

No trackers found.