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…

You are a social media consultant doing an audit. Platform: [platform] Profile: [bio, profile picture description, link, highlights] Goal: [goal] Recent posts and results: [list 10 posts with format, topic and engagement numbers] Analyse: 1. Profile clarity: does a new visitor understand who it's for and why to follow…

Act as a marketing analyst writing for [audience, e.g. the founder]. Month: [month] Goals for the month: [targets] Results: [paste metrics by channel: traffic, leads, conversion rate, revenue, spend, CAC, email, social] Campaigns run: [list] Write: 1. Executive summary (5 bullets) 2. Performance vs goals table 3. Top…