Search: "schema"

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

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

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

#coding #test-data #fixtures

coding Intermediate

Generate Realistic Test Fixtures from a Schema

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

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

#technical documentation #API docs #developer guide

writing Advanced

Technical Documentation Writing Guide: Developer API Docs Template

Help me write professional technical documentation for [software/API/system]. I ...

customer-service Beginner

Self-Service Help Center Article Template SEO Search Friendly

You are a knowledge-base writer. Write a help-center article for [QUESTION / ISS...

#help center #knowledge base #self service

#power query #excel #web scraping

excel Advanced

ChatGPT Prompt: Excel Power Query M Code for Web Data Scraping

Write Power Query M code to scrape and transform data from [URL OR DESCRIBE WEBP...

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

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

#data pipeline #monitoring #data quality

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

👁 10 views

data advanced

Data Pipeline Monitoring Alerting Strategy Production

Design a monitoring and alerting strategy for a production data pipeline. My pip...

👁 9 views

data Advanced

Design a Star Schema for an E-commerce Warehouse

Act as a data architect. Design a star schema for an e-commerce warehouse on [DB...

#data #data modeling #star schema

👁 9 views

marketing Intermediate

SEO Content Brief for Pillar Page

Act as a senior SEO strategist. Build a content brief for a pillar page targetin...

#seo #pillar-page #content-brief

Build a Pandas Data Quality Report for a Raw CSV Drop

Write a Python script using pandas that takes a CSV path and produces a one-page...

#data #pandas #python

#data #data-quality #monitoring

data Advanced

Data Quality Monitoring Rules for a Production Table

I need to monitor data quality on a production table loaded daily from upstream ...

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

customer-service Beginner

Knowledge Base Article Template for Common Issue

Write a knowledge base article for the support issue: [ISSUE]. Product: [PRODUCT...

#knowledge base #documentation #support

#power query #excel #data combine

excel Intermediate

Excel Power Query Combine Multiple Sheets Into Master Table

You are an Excel Power Query specialist. Walk me step-by-step through combining ...

#data-quality #audit #validation

Data Quality Audit Framework for New Source

Act as a data quality lead. I am onboarding a new data source: [SOURCE NAME], fo...

#exit-interview #attrition #retention

hr Intermediate

Exit Interview Guide and Theme Synthesizer

Act as a head of people analytics. Build an exit interview guide and a quarterly...

#marketing #seo #content-brief

marketing Advanced

SEO Content Brief for a Bottom-of-Funnel Comparison Article

Write a complete SEO content brief for an article targeting '[Brand A] vs [Brand...

#data #quality #validation

Write a Data Quality Checklist for a New Pipeline

Act as a data reliability engineer. I'm shipping a new pipeline that loads {{sou...