Results for “analytics”

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'.

Turn these weekly social media stats into a short report for [client]: [metrics]. Include highlights, top-performing post and why it worked, what underperformed, audience insights and 3 actions for next week. Keep it under 300 words.

Create a launch checklist for an online store selling [products] on [platform]. Cover legal and admin, product pages, payments, shipping and returns, analytics, email capture, SEO basics, launch marketing and post-launch tasks, ordered by week.

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…

Act as a senior product manager. Feature: [name] Problem and evidence: [details] Target users: [who] Goals: [outcomes] Write a PRD: background, problem statement, goals and non-goals, user stories with acceptance criteria, functional requirements, UX notes, edge cases, analytics/success metrics, launch plan, and open…

Act as a social media analyst. Platforms: [list] Month: [month] Goals: [targets] Data: [followers, reach, engagement rate, top posts, link clicks, conversions per platform] Write a report: 1. Highlights in 5 bullets 2. Platform-by-platform performance vs last month 3. Top 3 posts and why they worked 4. Underperformers…