SQL & Excel make formular and Support
Budget: $10 – $30 USD
Short work, just 10 questions:
I have a set of customer data that I need to interrogate quickly and accurately. I’m comfortable defining the business questions, but I want a specialist to translate those questions into tight SQL queries and elegant Excel formulas so I can draw clear insights without manual workarounds.
Here’s what I’m after:
For file: 01_SQL formula
• Write and optimise SQL code that pulls the exact customer fields I specify in the question, using the file: SQL Dataset
For file: 02_Excel formula
• Build (or improve) Excel formulas—think lookups, SUMIFS, conditional logic, dynamic arrays or whatever you deem best for each answer.
• Deliver a brief walkthrough so I understand how the queries and formulas hang together and can tweak them in the future.
I’ll supply a sample dataset, table structure, and my key questions as soon as we start. If you’re quick with both SQL and Excel and enjoy turning raw customer records into actionable insights, let’s get this moving.
I have a set of customer data that I need to interrogate quickly and accurately. I’m comfortable defining the business questions, but I want a specialist to translate those questions into tight SQL queries and elegant Excel formulas so I can draw clear insights without manual workarounds.
Here’s what I’m after:
For file: 01_SQL formula
• Write and optimise SQL code that pulls the exact customer fields I specify in the question, using the file: SQL Dataset
For file: 02_Excel formula
• Build (or improve) Excel formulas—think lookups, SUMIFS, conditional logic, dynamic arrays or whatever you deem best for each answer.
• Deliver a brief walkthrough so I understand how the queries and formulas hang together and can tweak them in the future.
I’ll supply a sample dataset, table structure, and my key questions as soon as we start. If you’re quick with both SQL and Excel and enjoy turning raw customer records into actionable insights, let’s get this moving.