Search: "data-questions"

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

👁 19 views

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

#data #root-cause #analysis

👁 19 views

coding Advanced

Authentication System with JWT and Refresh Tokens

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

#JWT #authentication #refresh tokens

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

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

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

legal intermediate

NDA Key Clauses Guide for Startups and SMBs

Act as a business attorney advisor specializing in startup and SMB contracts. He...

#legal #nda #clauses

design intermediate

Figma Design Handoff: Specification Documentation for Developers

Act as a product designer and design systems expert with experience in Figma-to-...

#design #figma #handoff

#data visualization #chart design #business intelligence

data beginner

Data Visualization Best Practices: Chart Selection and Design Guide

I have the following data and need to visualize it effectively: Data type: [desc...

#XLOOKUP #VLOOKUP #Excel formulas

Excel VLOOKUP to XLOOKUP Migration: Formula Modernization Guide

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

#excel #dashboard #visualization

excel intermediate

Excel Dashboard Builder from Raw Data

I have raw data in Excel and want to create a professional dashboard. My data in...

#nextjs #app-router #server-components

coding intermediate

Next.js App Router: Server Components & Data Fetching Patterns

Help me master Next.js 14+ App Router with Server Components. My situation: Pro...

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

#excel #data-validation #dropdown

ChatGPT Prompt: Excel Data Validation Drop-Down with Dependent Lists

You are an Excel expert. Build me a cascading drop-down where the second list de...

#power query #excel #web scraping

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

Executive KPI Dashboard Template Build in Excel

Design a one-page executive KPI dashboard in Excel for a [INDUSTRY] company. The...

#excel #dashboard #kpi