Search: "case-study"

#XLOOKUP #VLOOKUP #Excel formulas

excel Intermediate

Excel VLOOKUP to XLOOKUP Migration: Formula Modernization Guide

I have existing Excel spreadsheets that use VLOOKUP formulas and I want to moder...

#SaaS onboarding #email sequence #user activation

email Advanced

SaaS Onboarding Email Sequence: User Activation and Retention Guide

Create a complete SaaS onboarding email sequence to guide new users from signup ...

#ETL #data warehouse #data pipeline

data Advanced

ETL Pipeline Design: Best Practices for Data Warehouse Architecture

Help me design a production-grade ETL (Extract, Transform, Load) pipeline for a ...

data Intermediate

Pandas Cleanup Pipeline for a Messy Real-World CSV

Below is a sample of a messy CSV (10 rows shown). Build a pandas cleaning pipeli...

#data #pandas #csv

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

#excel #scenario-manager #what-if

excel advanced

Excel Scenario Manager and What-If Analysis Business Planning

You are a financial modeling expert using Excel. I need to build a what-if analy...

#data #looker-studio #dashboard

data intermediate

Looker Studio Dashboard Design Best Practices Business Reporting

Create a complete guide for designing professional Looker Studio dashboards for ...

data advanced

Database Indexing Strategy & Query Performance Optimization Guide

Help me optimize my database performance through indexing. My context: Database...

#database #indexing #sql

customer-service Intermediate

ChatGPT prompt for building canned replies for refund policy questions

Act as a support operations manager. I need a reusable set of canned replies for...

#refund policy response #canned replies #customer support macros

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

#business #proposal #client

business Intermediate

ChatGPT prompt for writing a business proposal for a potential client

Act as a business development consultant who writes winning proposals. Draft a ...

productivity Intermediate

Notion Workspace Setup for Second Brain System

Design a complete Notion workspace structure to implement a "Second Brain" perso...

#productivity #notion #second brain

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

#data #looker-studio #dashboard

data intermediate

Google Looker Studio Dashboard Design for Business Intelligence

You are a BI analyst and data visualization expert. I need to build a profession...

#scenario manager #goal seek #sensitivity analysis

excel advanced

Excel Financial Modeling: Scenario Manager and Goal Seek Analysis

I'm building a financial model in Excel for [project/business type]. Help me set...

customer-service intermediate

Escalation Protocol Design: Multi-Tier Support Framework

Design an escalation protocol for [company type] customer support team with [tea...

#escalation #customer support #support operations

#cash flow forecast #financial planning #business finance

finance Intermediate

Cash Flow Forecast: 12-Month Projection Template and Guide

Help me build a comprehensive 12-month cash flow forecast for my business. I nee...

#data cleaning #CSV #pandas

data Intermediate

Data Cleaning Checklist for Messy CSV and Excel Datasets

Create a systematic data cleaning checklist and workflow for a messy dataset in ...

#data #forecasting #time series

data Advanced

Time Series Forecasting Framework for Monthly Demand Planning

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

#coding #testing #property-based

coding Advanced

Generate Property-Based Tests with Hypothesis or fast-check

I have a function `[paste signature + 1-paragraph spec]` and I want property-bas...

#data #chart #visualization

data Beginner

Choose the Right Chart for Your Dataset

Given my dataset and what I'm trying to communicate, help me pick the right char...