Search: "data-modeling"

#JavaScript #async await #error handling

coding intermediate

JavaScript Async/Await: Error Handling Patterns and Best Practices

Explain and demonstrate best practices for async/await error handling in JavaScr...

customer-service Intermediate

Customer Feedback Analysis: Categorization and Insight Framework

Help me build a systematic process for analyzing customer feedback and extractin...

#customer feedback #voice of customer #NPS

excel intermediate

Excel VBA Macro Generator for Repetitive Tasks

I need to automate a repetitive task in Excel. Here is what I do manually every ...

#excel #vba #macro

#coding #database #schema

coding intermediate

Database Schema Designer for Web Application

Design an optimized database schema for my web application. Requirements: Appli...

#microservices #architecture #design-patterns

coding advanced

Microservices Architecture: Design Patterns & Communication Strategies

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

coding intermediate

Vue.js 3 Component Design: State Management with Pinia & Composables

Help me build well-structured Vue.js 3 components with proper state management. ...

#vuejs #vue3 #pinia

#excel #conditional formatting #dashboard

Excel Conditional Formatting Heatmap Project Status Dashboard

You are an Excel dashboard designer. Build a conditional-formatting heatmap for ...

#sql #optimization #performance

data Advanced

SQL Query Optimizer with Explain-Plan Reading

Act as a database performance engineer. I will paste a slow SQL query and its EX...

ChatGPT Prompt: Excel Macro VBA Generator for Repetitive Data Cleanup Tasks

You are a VBA developer. I want a macro that automates a repetitive cleanup task...

#excel #vba #macro

#customer persona #user research #marketing strategy

marketing Intermediate

ChatGPT Prompt: Customer Persona Development from User Interview Notes

Synthesize user interview transcripts into actionable customer personas. Here ar...

#excel #text-functions #parsing

Convert Messy Text Column Into Clean Structured Fields

I have a single column in Excel containing messy entries like "{{example raw ent...

#data #root-cause #analysis

data Advanced

Investigate an Unexpected Drop in a Key Metric

You are a data detective. A key metric dropped 18% week-over-week with no obviou...

#JWT #authentication #refresh tokens

coding Advanced

Authentication System with JWT and Refresh Tokens

Build a complete authentication system with JWT access tokens and refresh tokens...

#excel cash flow forecast #13 week cash flow #excel formulas

excel Advanced

ChatGPT prompt for Excel cash flow forecast from messy exports

You are an Excel analyst helping me build a 13-week cash flow forecast from mess...

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

#excel #cohort analysis #retention

excel Advanced

ChatGPT Prompt for Excel Cohort Retention Tracker from Raw Transactions

I have raw transaction data in Excel with columns for customer_id, first_purchas...

#Excel #analysis #reporting

Excel Intermediate

Data Analysis Report Template

Design a data analysis report template in Excel for [DATA TYPE]. Include: execut...

#data cleaning #csv #pandas

data Intermediate

ChatGPT prompt for creating a data cleaning pipeline for messy CSV files

Act as a senior data engineer who specializes in data quality and ETL pipelines....

#coding #sql #stored-procedure

coding advanced

SQL Stored Procedure for Data Transformation

Write a SQL stored procedure in [MySQL / PostgreSQL / SQL Server] for the follow...

#finance #expense #cost-reduction

finance intermediate

Expense Report Analysis for Cost Reduction

Analyze the following company expense data to identify cost reduction opportunit...

#legal #privacy policy #gdpr

legal Intermediate

Privacy Policy Generator for SaaS Application

Draft a privacy policy for a SaaS web application with the following characteris...

#database design #SQL #schema

coding advanced

Database Schema Design E-Commerce Platform

Design a normalized relational database schema for a multi-vendor e-commerce pla...

#excel #data-validation #dropdown

excel beginner

Excel Data Validation: Drop-down Lists and Input Controls

Act as an Excel data integrity specialist. I need to set up data validation with...