Search: "star schema"

#data #governance #data dictionary

Data Dictionary Template for Analytics and BI Teams

Act as a data governance lead. Build a data dictionary entry template plus a wor...

👁 9 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

data advanced

ETL Pipeline Design for Data Warehouse

Design an ETL (Extract, Transform, Load) pipeline for loading data from [source ...

#data #etl #pipeline

#data pipeline #monitoring #data quality

data advanced

Data Pipeline Monitoring Alerting Strategy Production

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

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

#data #power-bi #dashboard

data intermediate

Power BI Dashboard Design: Sales Performance Metrics

Act as a Power BI specialist and data visualization expert. Help me design a sal...

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

#writing #technical-blog #developer-content

writing intermediate

Technical Blog Post Writing Guide Developer Audience Engagement

Create a guide for writing technical blog posts that developers actually read an...

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

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

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

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

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

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

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

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

#interview #behavioral #recruiting

hr Intermediate

Design Behavioral Interview Question Bank

Design a behavioral interview question bank for the role of [ROLE]. Required com...

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

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

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