Data
Skills
Data Engineering
- Defining Data Intuition
Ryan proposes the following definition for data intuition: a resilience to misleading data and analyses.
- Quick Guide: Calculate Cohort Retention Analysis with SQL
Huy provides a step-by-step walk-through of how to generate cohort retention by month using two source tables - users and activities.
- Practical SQL for Data Analysis
Haki provides an in-depth guide to using SQL for fast and efficient data analysis. He dives into specific tactics including descriptive statistics, subtotals, pivot tables, running and cumulative aggregation, linear regressions, interpolations, and binning.
- Analytical Excellence Is All about Speed
Cassie provides a nuanced take on the value of speed in data analytics. She also links to other articles in this multi-article series on what it takes to be a professional analyst, which cover: software skills; handling lots of data with ease; immunity to data science bias; understanding the career; refusing to be a data charlatan; resistance to confirmation bias; realistic expectations of data; knowing how to add value; and thinking differently about time.
- Kickstarter's Engineering & Data Science Career Ladders
Kickstarter's approach has fewer levels and uses textual descriptions rather than a matrix of skills.
- The Startup Founder’s Guide to Analytics
Tristan walks you through how your startup should be doing analytics at five different stages: Founding Stage (0 to 10 employees) Very Early Stage (10 to 20 employees) Early Stage (20 to 50 employees) Mid-Stage (50 to 150 employees) Growth Stage (150 to 500 employees)
- The SQL Tutorial for Data Analysis
This SQL tutorial explains what SQL is and will take you through the basic functions, including SELECT, LIMIT, WHERE, etc.