Search: "FILTER function"

SQL Query - Complex Joins and Aggregation

Write SQL queries for a database with tables: orders (id, customer_id, order_dat...

#coding #SQL #joins

👁 10 views

#excel #pivot table #sales analysis

React Component with Hooks

Build a React component for a searchable, filterable product list. Features: 1) ...

#coding #React #hooks

👁 10 views

excel Intermediate

Sales Analysis Pivot Table

Guide me step by step to create a pivot table in Excel for sales analysis. My da...

👁 9 views

productivity Intermediate

Notion Database System for Project and Task Management

Act as a Notion power user and productivity systems designer. Create a complete ...

#productivity #Notion #project management

#hr #interview #screening questions

hr Intermediate

ChatGPT prompt for screening interview questions based on a real role

Act as a practical hiring manager. I need screening interview questions for a c...

#refactor duplicate code #clean code #software design

ChatGPT prompt for refactoring duplicated business logic safely

Act as a senior software engineer reviewing duplicated business logic across mul...

#python #unit tests #pytest

ChatGPT prompt for generating Python unit tests for an existing function

Act as a senior Python test engineer who follows best practices for pytest. I h...

#coding #code-review #pull-request

coding intermediate

Code Review Checklist for Pull Requests

Generate a comprehensive code review checklist for pull requests in a [language/...

#lambda #custom-functions #excel

excel advanced

Excel LAMBDA Custom Functions for Business Calculations

Create Excel LAMBDA functions for: 1) CAGR given start value, end value, and yea...

#data #Google Sheets #dashboard

data Intermediate

Google Sheets Dashboard with Automated Data Import

Act as a Google Sheets expert. Create a complete marketing dashboard in Google S...

👁 6 views

creative intermediate

Character Development Arc: Transformation Story Template

Act as a story development coach and narrative structure expert. Help me design ...

#creative #character #development

👁 6 views

Excel Intermediate

Excel Formula Generator

Create Excel formulas for: [DESCRIBE TASK]. Include: the formula, explanation of...

#Excel #formulas #automation

👁 5 views

coding advanced

AWS Lambda Serverless Function Deployment Complete Guide

You are an AWS serverless architect. I need to build and deploy a serverless app...

#coding #aws #lambda

👁 5 views

coding intermediate

JavaScript TypeScript Generic Utility Functions Library

Create a TypeScript utility functions library with these categories: 1) Array ut...

#TypeScript #utility functions #JavaScript

#songwriting #lyrics #song structure

creative intermediate

Songwriting Lyrics Structure Hook Bridge Development

Help me write and structure a song. Genre: [pop / country / R&B / folk / rock]. ...

#coding #sql #window-functions

coding advanced

SQL Window Functions: Advanced Analytics Query Guide

Act as a senior data engineer and SQL expert. Help me master SQL window function...

#code review #security #performance

coding intermediate

Code Review Checklist: Security, Performance, and Maintainability

Create a comprehensive code review checklist for [language: Python/JavaScript/Ty...

#dynamic arrays #FILTER #SORT

excel Intermediate

Excel Dynamic Arrays: FILTER, SORT, and UNIQUE Functions Mastery

Help me master Excel dynamic array functions to replace my manual filtering and ...

#dynamic array #FILTER #SORT

excel intermediate

Excel Dynamic Array FILTER SORT UNIQUE Formula Guide

Teach me how to use Excel dynamic array functions (FILTER, SORT, UNIQUE, SEQUENC...

#SQL #window functions #analytics

data advanced

SQL Window Functions Advanced Analytics Queries

Teach me SQL window functions with practical business analytics examples. Cover:...

#Power BI #DAX #dashboard

data advanced

Power BI Dashboard Design Executive Sales Report

Help me design a Power BI executive sales dashboard. Data sources: [CRM data / S...

#kpi #scorecard #dashboard

excel intermediate

Excel Dashboard KPI Scorecard with Traffic Lights

Design an Excel KPI scorecard dashboard for [department] with: 1) KPI table with...

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