Search: "star schema"

#API testing #Postman #REST API

coding intermediate

API Testing with Postman: Collection Setup and Automation Guide

Help me set up a comprehensive Postman collection to test a [REST/GraphQL] API w...

#excel #power query #m code

excel Advanced

Power Query M Code Generator for Repeatable Data Transformation

Act as a Power Query (M language) developer. I will describe a messy raw export ...

#hr #interviewing #hiring

hr Intermediate

Behavioral Interview Loop Design for a Senior Engineer Hire

Design a 4-round behavioral interview loop for a senior software engineer role. ...

#writing #technical-documentation #api

writing intermediate

Technical Documentation for API Endpoints

Write clear technical documentation for the following API endpoint: [paste endpo...

#postgresql #indexing #performance

coding advanced

PostgreSQL Database Indexing Strategy for Slow Queries

Analyze and fix slow query performance in PostgreSQL for [describe your schema a...

#interview #hiring #behavioral

hr intermediate

Structured Interview Guide for Behavioral Competency Assessment

Build a structured interview guide for assessing [role] across competencies: [e....

#hr #competency-framework #career-development

hr advanced

Competency Framework Design for Job Levels Career Architecture

Build a complete organizational competency framework and career architecture. In...

customer-service intermediate

Customer Self-Service Knowledge Base Design and Writing Guide

Build a comprehensive self-service knowledge base strategy from architecture to ...

#customer-service #knowledge-base #self-service

coding Intermediate

Generate a SQL Migration With Safe Rollback

Act as a database engineer. Write a {{database: e.g., PostgreSQL 15}} migration ...

#coding #sql #migration

#hr #interview #behavioral

hr Advanced

Write Behavioral Interview Questions That Actually Predict Performance

Design 8 behavioral interview questions for the [role] role that map to the top ...

#data #warehouse #star schema

data Advanced

Data Warehouse Star Schema Design for Analytics Workloads

You are a senior data engineer. Design a star schema for [DOMAIN] analytics. Pr...

👁 15 views

coding Intermediate

Generate Realistic Test Fixtures from a Schema

I'll paste a database schema. Generate realistic test fixtures: 10-20 rows per t...

#coding #test-data #fixtures

👁 15 views

data Intermediate

Define KPIs for a Product Without Falling Into Vanity Metrics

Act as a product analyst. I'll describe a product. Help me define 5-7 KPIs that ...

#data #kpis #metrics

👁 15 views

coding Advanced

ChatGPT prompt for SQL migration plan with rollback safeguards

Act as a senior database engineer. I need a production-safe SQL migration plan, ...

#sql migration prompt #rollback safe deployment #database schema change

#Power BI #DAX #dashboard

data advanced

Power BI Dashboard Design Executive Sales Report

Help me design a Power BI executive sales dashboard. Data sources: [CRM data / S...

#excel #test-data #random

excel Beginner

Generate Realistic Test Data With Random Functions

I need to generate {{number, e.g., 500}} rows of realistic test data in Excel fo...

data Intermediate

Design a Minimal Data Model From a Vague Spec

Act as a data architect. From this rough description of what we need to track: {...

#data #schema #modeling

#rest api #pagination #filtering

coding Intermediate

Design REST API Schema with Pagination and Filtering

Design a complete REST API specification for a resource: [RESOURCE NAME] with at...