Udemy - Top 101 Data Analyst Interview Questions - Concepts and KPIs

seeders: 7 leechers: 1 updated: 2 weeks ago
Added 5 months ago by freecoursewb in Other
Downloaded 52 times.
1337x.to
Udemy - Top 101 Data Analyst Interview Questions - Concepts and KPIs

Torrent Contents Size: 2.9 GB

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

Description

Related Torrents

Location

Trackers

Tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
udp://tracker.opentrackr.org:1337/announce
http://tracker.openbittorrent.com:80/announce
udp://opentracker.i2p.rocks:6969/announce
udp://tracker.internetwarriors.net:1337/announce
udp://tracker.leechers-paradise.org:6969/announce
udp://coppersurfer.tk:6969/announce
udp://tracker.zer0day.to:1337/announce
Torrent hash: