Search: "data modeling"

#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 formulas #dynamic arrays #dashboard

excel Intermediate

ChatGPT Prompt: Excel Dynamic Array Formulas for Reporting Dashboards

Build a reporting dashboard using Excel 365 dynamic array formulas (FILTER, SORT...

#writing #op-ed #thought leadership

writing Advanced

Op-Ed Article Framework for Thought Leadership Submissions

Act as an op-ed editor for a major publication. Help me draft a 750-word op-ed. ...

#coding #tech spec #architecture

coding Advanced

Tech Spec Template for a Greenfield Backend Service

Act as a staff engineer writing a tech spec for a new service. I will give you t...

#data #ab testing #statistics

A/B Test Power Analysis and Sample Size Calculator Walkthrough

Act as a statistics tutor for product analysts. Walk me through a complete power...

#data #forecasting #time series

Time Series Forecasting Framework for Monthly Demand Planning

You are a forecasting specialist. Help me build a monthly demand forecast for [P...

#legal #contracts #vendor

legal Advanced

Vendor Contract Redline Checklist with Risk Tiers

You are an in-house contracts attorney. I will paste a vendor contract. Run it t...

coding Intermediate

Refactor a Tangled React Component Into Custom Hooks

Refactor the React component below by extracting state and side effects into cus...

#coding #react #hooks

#finance #cash-flow #forecasting

finance Advanced

Build a 13-Week Cash Flow Forecast With Scenario Toggles

Walk me through building a 13-week cash flow forecast for a small business. Outp...

#business #strategy #memo

business Advanced

Build a One-Page Strategy Memo Using the McKinsey Pyramid Principle

Convert my rough strategic thinking below into a one-page memo using Barbara Min...

#data #sql #window-functions

Write Window Functions That Replace a Subquery Loop

Act as a senior SQL engineer. I need to compute {{describe: e.g., 7-day rolling ...

#data #quality #validation

data Intermediate

Write a Data Quality Checklist for a New Pipeline

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

#legal #contracts #negotiation

legal Advanced

Review a Vendor Contract for Hidden Risk

Act as in-house counsel. I'll paste a vendor contract. Flag clauses that need ne...

#sql #cohort analysis #retention

SQL Query to Find User Cohort Retention by Month

Write a SQL query to compute monthly cohort retention. Tables: - users(id, signu...

#buyer persona #customer research #marketing

marketing Intermediate

Build a Buyer Persona from Customer Interview Data

Synthesize a buyer persona from these [N] customer interview notes: [PASTE NOTE...

#data #outliers #cleaning

Identify Outliers Without Throwing Away Real Signal

Help me detect outliers in my dataset and decide what to do with them. Compare m...

#react #performance #virtualization

coding advanced

React Performance Optimization Techniques for Large Lists

Optimize a React application that renders a large list of [data type, e.g., 10,0...

excel intermediate

Excel XLOOKUP Advanced Techniques Guide

You are an Excel expert. I need to use XLOOKUP for complex data retrieval tasks....

#excel #xlookup #lookup

excel advanced

Excel VBA Macro: Automate Repetitive Report Generation

Act as an Excel VBA expert. I need to automate a repetitive report generation ta...

#excel #vba #macro

#legal #terms-of-service #saas

legal advanced

Terms of Service Template for SaaS Platform User Agreements

Act as a technology attorney advisor specializing in SaaS agreements. Help me dr...

#code review #pull request #quality assurance

coding Intermediate

Code Review Checklist for Pull Request Quality Assurance

Create a comprehensive code review checklist for [programming language/framework...

#UX design #design brief #product redesign

design Intermediate

UI/UX Design Brief Template for Product Redesign Projects

Create a comprehensive UI/UX design brief for redesigning [product/feature, e.g....

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