Search: "data-questions"

#excel #pivot tables #data cleaning

Convert Messy Sales Data into a Pivot Table Report

You are an Excel expert. I will paste a messy sales dataset with columns for dat...

#data #data modeling #star schema

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

Write a SQL Query for Cohort Retention Analysis

Write a portable SQL query (works on PostgreSQL and BigQuery) that produces a mo...

#data #sql #cohort

#terms and conditions #mobile app #legal document

Terms and Conditions Mobile App Template

Draft Terms and Conditions for a mobile application. App details: App name: [nam...

#vendor-agreement #procurement #legal

Vendor Agreement Review Checklist for Procurement Teams

Create a vendor agreement review checklist for [company type]. Categories: 1) Pr...

#budget tracker #personal finance #Excel template

excel Beginner

Excel Personal Budget Tracker: Monthly and Annual Template

Help me build a comprehensive personal budget tracker in Excel from scratch. I n...

#legal #privacy-policy #gdpr

Privacy Policy Generator for Websites and Apps

Generate a comprehensive privacy policy for my website/app. Details: Business n...

#legal #terms-of-service #saas

Terms of Service Generator for SaaS Products

Generate comprehensive Terms of Service for my SaaS product. Product details: P...

#privacy-policy #gdpr #ccpa

legal Advanced

Privacy Policy Section Drafting Prompt

Act as a data protection lawyer. Draft the privacy policy section for [COMPANY],...

#terms-of-service #risk #review

legal Advanced

Terms of Service Risk Review Checklist

Act as a SaaS commercial lawyer. Review the following Terms of Service [PASTE TO...

#press-release #pr #launch

writing Beginner

Press Release Writer for Product Launch

Act as a PR writer. Write a press release for the launch of [PRODUCT] from [COMP...

writing Intermediate

ChatGPT Prompt: Long-Form Blog Post Outline From a Single Idea or Question

You are a content strategist. Turn one rough idea into a structured long-form bl...

#writing #blog #content

#pivot tables #excel #data analysis

ChatGPT Prompt: Excel Pivot Table with Calculated Fields and Slicers Setup

Help me build a comprehensive pivot table report for [DATA TYPE]. Data context:...

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

excel Advanced

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl

data Intermediate

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 Quality Monitoring Rules for a Production Table

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

#terms of service #saas #legal

legal Advanced

Terms of Service Outline for SaaS Product

Outline a Terms of Service agreement for a B2B SaaS product. Product: [DESCRIPTI...

#data #communication #forecasting

data Intermediate

Explain a Forecasting Model to Non-Technical Stakeholders

I built a [MODEL_TYPE] forecasting model with MAPE [MAPE_VALUE]. Write a 1-page ...

#excel #dashboard #slicers

Excel Dashboard with Dynamic Slicers

Help me design a single-page Excel dashboard for KPIs (revenue, orders, conversi...

business Advanced

Write a Crisp Business Memo in the Amazon Style

Help me draft a 6-page narrative memo (Amazon-style) for [topic / proposal]. Str...

#business #memo #amazon

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

#excel #burn-down #project management

Build a Dynamic Project Burn-Down Chart in Excel

Act as an Excel expert. I need to build a project burn-down chart that automatic...