Search: "data modeling"

#microservices #architecture #design-patterns

coding advanced

Microservices Architecture: Design Patterns & Communication Strategies

Design a microservices architecture for my system. Context: System description:...

#data validation #error prevention #spreadsheet

Excel Data Validation Rules for Error-Free Spreadsheets

Create comprehensive Excel data validation rules for a spreadsheet used for [des...

#SQL optimization #query performance #database

data Advanced

SQL Query Optimization Guide for Slow Database Queries

Analyze and optimize the following slow SQL query that is causing performance is...

#dashboard design #KPI #data visualization

Data Dashboard Design Blueprint for Business KPI Reporting

Design a KPI dashboard blueprint for [department: sales / operations / marketing...

#dynamic arrays #filter #sort

Excel Dynamic Array FILTER SORT UNIQUE Modern Functions Guide

Act as a Microsoft 365 Excel trainer. Teach me the dynamic-array trio FILTER, SO...

#remote work #hybrid #hr policy

hr Advanced

Remote Work Policy Document Hybrid Distributed Team Guidelines

Act as an HR policy writer. Draft a remote work policy for [COMPANY] supporting ...

#saas contract #vendor agreement #legal review

legal Advanced

Software-as-a-Service Agreement SaaS Contract Key Clauses Review

Act as a SaaS contracts paralegal (not legal advice). Walk me through the key cl...

#compensation #leveling #hr

hr Advanced

ChatGPT Prompt: Compensation Band Design for Engineering Levels

Design compensation bands for engineering levels at [COMPANY]. Context: - Compa...

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

#excel #formula #duplicates

Excel Formula to Detect Duplicate Customer Records Across Multiple Columns

Act as an Excel expert. I need a formula that flags duplicate customer rows wher...

data Advanced

SQL Window Function to Find Customer Churn Cohort by First-Purchase Month

Write a Postgres query to produce a monthly cohort retention table. Source table...

#data #sql #postgres

design Intermediate

Empty State Design Specification for a SaaS Dashboard

Specify the empty state for [feature/dashboard]. Cover all 4 empty-state types s...

#design #empty-state #ux

#excel #reconciliation #vlookup

Reconcile Two Spreadsheets and Highlight Mismatched Rows

Act as a finance analyst. I need to reconcile two Excel sheets, {{Sheet A: e.g.,...

#data #documentation #metrics

Write a Data Definition Doc That Stops 'Wait, How Is This Calculated' Questions

Help me write a data definition doc for [METRIC NAME] that ends ambiguity foreve...

#pivot table #sales analysis #excel

Build Dynamic Pivot Table from Sales Data

Act as an Excel data analyst. I have a sales dataset with columns: [Date, Region...

#Google Analytics #GA4 #website analytics

Google Analytics Report Summary

Help me analyze and summarize my Google Analytics data for a stakeholder report....

#excel #shift schedule #data validation

excel Advanced

Dynamic Employee Shift Schedule with Drop-downs and Conflict Detection

Act as an Excel expert. Create a weekly employee shift schedule spreadsheet for ...

#excel inventory tracker #reorder point #stock management

ChatGPT prompt for Excel inventory reorder tracker with lead times

Act as an Excel operations specialist. I need an inventory reorder tracker for a...

#excel list reconciliation #duplicate matching #near match cleanup

ChatGPT prompt for reconciling two Excel lists with duplicates and near matches

I need to reconcile two Excel lists that should overlap, but the data is messy. ...

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

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

#conversion rate drop analysis #marketing analytics prompt #funnel diagnosis

data Advanced

ChatGPT prompt for diagnosing a sudden drop in conversion rate from mixed-source metrics

Act as a data analyst investigating a sudden conversion-rate drop. I need a stru...

#excel #scheduling #shift planning

excel Beginner

ChatGPT Prompt for Excel Shift Schedule Conflict Checker

Help me build an Excel shift scheduling sheet that automatically flags staffing ...

#scenario model #financial modeling #excel planning

excel Advanced

ChatGPT Prompt for Excel Scenario Model Comparing Best Base and Worst Cases

Help me build an Excel scenario model that compares best case, base case, and wo...