Search: "data modeling"

data Intermediate

Design a Minimal Data Model From a Vague Spec

Act as a data architect. From this rough description of what we need to track: {...

#data #schema #modeling

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

#finance #cap-table #startup

finance Advanced

Build a Cap Table You Can Actually Read

Act as a startup CFO. Help me build a clean cap table that survives 3 funding ro...

#pivot table #sales analysis #excel

Build Dynamic Pivot Table from Sales Data

Act as an Excel data analyst. I have a sales dataset with columns: [Date, Region...

#excel #amortization #financial modeling

Build a Loan Amortization Schedule in Excel

Act as a financial analyst. Create a step-by-step Excel guide to build a loan am...

#excel #dashboard #slicers

Excel Dashboard with Dynamic Slicers

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

#data #outliers #cleaning

data Advanced

Identify Outliers Without Throwing Away Real Signal

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

#excel #forecasting #revenue

Forecast Monthly Revenue With Excel's FORECAST.ETS

I have 36 months of revenue data (column A: month-end dates, column B: revenue)....

#data #visualization #charts

data Beginner

Choose the Right Chart Type for the Question You're Asking

I have [DATA DESCRIPTION] and I'm trying to answer [QUESTION] for [AUDIENCE]. Wa...

#template #data-validation #conditional-formatting

Build a Reusable Excel Template With Input Validation Built In

Help me design a reusable Excel template for [USE CASE: e.g. expense report, pro...

#data #visualization #charts

data Intermediate

Data: Choose the Right Chart for the Question I'm Trying to Answer

I have a dataset and a question I want to answer. Don't just suggest a chart — i...

#excel #capacity-planning #modeling

excel Advanced

Excel: Build a Capacity Model That Doesn't Pretend Everyone Works 40 Hours

I'm modeling team capacity in Excel for the next quarter: [TEAM, ROLES, HOLIDAYS...

#excel #formulas #xlookup

Replace nested IFs with a lookup table you can actually maintain

I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...

data Advanced

Validate a survey result that contradicts your hypothesis

My survey of 400 users says they want [feature X], but everything else I know (s...

#data #research #survey

#excel #power-query #unpivot

Turn a wide budget sheet into a flexible pivot-ready long format

I have a budget spreadsheet in wide format: one row per account, then 12 columns...

#data quality #anomaly detection #data monitoring

data Advanced

Automated Data Quality Report with Anomaly Detection

Create a data quality monitoring report for my dataset: - Data source: [e.g., '...

#excel #pivot-table #sales

excel intermediate

Excel Pivot Table Sales Trend Analysis

I have a sales dataset with columns: [Date, Region, Sales Rep, Product, Units So...

#education #lesson plan #stem

education Beginner

Lesson Plan for Interactive STEM Class Activity

Create a detailed lesson plan for a [duration]-minute STEM class activity for [g...

#terms and conditions #mobile app #legal document

legal intermediate

Terms and Conditions Mobile App Template

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

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

#tableau #churn #analytics

data intermediate

Tableau Dashboard Design for Customer Churn Analysis

Design a Tableau dashboard to analyze customer churn. Include: 1) Overall churn ...

#Docker #Docker Compose #containers

coding Intermediate

Docker Compose: Multi-Service Application Setup and Configuration Guide

Help me set up a Docker Compose configuration for a multi-service application. I...

#privacy policy #GDPR #CCPA

legal Intermediate

Privacy Policy Generator: GDPR and CCPA Compliance Template

Help me create a comprehensive privacy policy that complies with GDPR (EU) and C...