Prepare me for a data analyst interview at [company type]. Give me 5 SQL questions with sample tables, 5 statistics concept questions, 2 business case questions, and model answers. Quiz me one at a time if I say 'start'.
Results for “data analyst”
All tools
ChatGPT
Claude
Gemini
Midjourney
DALL·E
Stable Diffusion
Flux
Copilot
Runway
Sora
Veo
Kling
Suno
Udio
ElevenLabs
Other
3 prompts
Act as a data analyst. Database: [PostgreSQL / BigQuery / Snowflake / MySQL] Tables: [users(id, created_at), events(user_id, event_name, created_at), orders(...)] Questions: [monthly cohort retention, weekly active users, sign-up to purchase funnel] Write the queries with CTEs and comments, explain each step, and desc…
Coding & Development
SQL for retention and cohort analysis
Write analytics SQL for cohort retention, funnels and active users.
Act as a data analyst using Python and pandas. Data: [file type and columns with example values] Questions I want answered: [list] Issues I know about: [missing values, inconsistent formats] Write a script or notebook steps to: 1. Load and inspect the data 2. Clean it (types, missing values, duplicates, outliers) 3. A…
Coding & Development
Data analysis with pandas
Load, clean, analyse and chart your data with pandas, with explanations for each step.