First freelance clients as a data analyst: a scoped offer

Choose one offer, not a menu

Beginners often list every skill. Clients buy a result. Pick one offer you can deliver well, with a fixed boundary:

The "what you do not do" column prevents scope creep, the main reason first projects lose money.

Find the first client

Start with people who already trust you:

1. 1Former employers or managers. Ask whether there is a report they wish was automated.
2. 2Family and local businesses. Many small businesses run on Excel and a billing tool's export.
3. 3Your professional network. A short post describing one concrete offer, with a sample screenshot built on dummy data.

A message to a warm contact:

Hi Sanjay ji, I have been building sales dashboards in Power BI. If your team
still prepares the monthly sales summary by hand from the billing exports, I
could build a dashboard that updates from the same files in a few clicks. I can
show you a sample built on dummy data. Would a 20-minute call next week suit you?

The one-page proposal

After the call, send a proposal the same day. A filled example with hypothetical figures:

Proposal: Monthly sales dashboard - Sharma Distributors

Problem
The monthly sales summary takes about two days to prepare by hand from billing
exports, and product-wise margins are not visible.

What I will deliver
1. A Power BI dashboard with sales by month, product, region and salesperson.
2. A refresh process from the existing monthly Excel export (no software change).
3. A two-page guide and one 30-minute handover session.

Not included
Changes to the billing software; daily data entry; reports beyond the four views above.

Timeline
Two weeks from receiving three months of sample exports.

Price
₹25,000 fixed. 50% on acceptance, 50% on delivery.
One round of changes within 7 days of delivery included.

Data
Files shared by Google Drive; I will delete copies on completion unless asked to
keep them.

A pricing worksheet

Price by the project, not by the hour, but calculate from hours so you do not undercharge.

Estimated hours
  Understanding data and requirements     4
  Cleaning and modelling                  8
  Building dashboard                      8
  Testing with client's real files        3
  Guide and handover                      3
  Buffer for surprises (30%)              8
  Total                                  34 hours

Target hourly rate (hypothetical)        ₹700
Project price                            34 x 700 = ₹23,800 -> quote ₹25,000

Your hourly figure is your choice; this is only an illustration of the arithmetic. If the client's budget is lower, reduce the scope, not the rate.

Payment and paperwork

• Take an advance. Half upfront is common for first projects and filters out non-serious clients.
• Invoice properly. Include your name, the client's name, the scope, amount, and payment details. Whether you need GST registration depends on your turnover and the nature of your supplies; check the rules on the official GST portal or with a tax professional rather than guessing.
• Keep records of every invoice and payment for your income tax return.
• Do not start work on a verbal yes. A reply email saying "Approved" to your proposal is enough.

Handling the client's data

Small businesses share customer names, phone numbers and sales figures. Treat them carefully: use only the files you need, do not upload them to public tools, and delete copies at the end as promised in the proposal.

After the first project

Ask for two things: a short written testimonial you may quote with their permission, and whether anyone they know has the same problem. A good first project, done on time and within scope, is how the second one arrives.

The same finished dashboard, with client details removed or rebuilt on dummy data, can also go into your portfolio; see whether you need a portfolio website. The Excel, SQL and Power BI work behind offers like these is what the Data Analyst programme teaches across its 3–4 months.