DNA Business Analytics — Team Portal

Connect Your Database

Set up Supabase once. Your whole team accesses dnabusinessanalytics.in/team with their own login.

1. supabase.com → Create free account → New project
2. Project Settings → API → Copy Project URL + anon public key
3. SQL Editor → Paste script below → Click Run
4. Enter credentials below → Connect
5. Default admin login: admin@dna.in / Admin@123

Project URL

Anon Key

SQL Setup Script

Revenue vs Expenses monthly

Today's Tasks

Upcoming Deliverables

Team Attendance Today

Add New Client

Client saved!

Client Name

Industry

Contact Person

Email

Phone

Retainer ₹/mo

Services

Status

All Clients

Client	Industry	Services	Retainer	Status

Add Team Member

Saved!

Full Name

Role

Department

Login Email

Password

Salary ₹/mo

Type

Join Date

Status

Team Directory

Name	Role	Dept	Type	Salary	Status

Add Project — Map Client → Team → Deliverables

Saved!

Project Name

Client

Start Date

End Date

Budget ₹

Project Lead

Status

Map Team Members (hold Ctrl for multiple)

All Projects

Project	Client	Lead	Members	Budget	Deadline	Status

Assign Daily Task to Member

Task assigned!

Date

Team Member

Client

Project

Deliverable (optional)

Task Title

Target Hours

Category

Priority

Instructions

Assigned Tasks

Member	Task	Client	Project	Cat	Target	Logged	Priority	Status

My Tasks —

Log Hours

Hours logged!

Task

Hours Worked

Status

Date

Work Notes

Attendance Heatmap —

Team Summary

Member	Days Active	Total Hours	Avg/Day	Tasks Done

Deliverable Task Deadline

Upcoming — Next 14 Days

Add Deliverable — Map Client → Project → Member

Saved!

Title

Client

Project

Assigned To

Category

Due Date

Frequency

Status

All Deliverables

Title	Client	Project	Assigned	Due	Freq	Status

Log Revenue

Saved!

Date

Client

Amount ₹

Type

Invoice #

Status

Revenue Ledger

Date	Client	Type	Amount	Invoice	Status

Log Expense

Saved!

Date

Category

Amount ₹

Vendor

Paid By

Receipt #

Expense Ledger

Date	Category	Vendor	Amount	Paid By	Receipt

Quarterly Revenue Targets

Saved!

Q1 Target ₹

Q2 Target ₹

Q3 Target ₹

Q4 Target ₹

Revenue vs Target

Client KPI Goals

Saved!

Client

Goal Type

Period

Target

Current

Unit

Revenue Trend

Expense Breakdown

Top Clients by Revenue

Team Hours (all time)