I spent over two years in data consulting for Fortune 500 clients. Then I became co-owner of a new nail salon, an industry I had never worked in.
These are the things I built there. Each one is written the same way: the gap I saw, what I used, what I built and what changed.
I work in Power BI, SQL and Python.
Sales analytics for a 16-technician salon
VSL Nail Spa opened to clients in Hendersonville, TN, at the end of January 2025. Every ticket went into the point-of-sale system, but its built-in reports could not answer an owner's questions.
- The gap
- Which services earn the most? Which days need more staff? How is each technician doing? The POS could not say.
- What I used
- The POS sales export (one row per service on each ticket), QuickBooks cost data, SQL, Python and AI coding tools.
- What I built
- A sales dashboard: average ticket, sales per technician per day, service mix, tips, demand by weekday and supply cost. It refreshes monthly from a new export.
- What changed
- I can answer those questions in minutes, from the data, like the four below.
The charts use the salon's real data: 71,283 sales lines from 26,036 tickets, Jan 2025 to Oct 2026. Dollar amounts are replaced by an index and technician names are removed.
Sales grew 4.7x in 20 months, and the growth came from more visits
View as table
| Month | Sales index | Visits index | Average ticket index |
|---|---|---|---|
| Feb 2025 | 100 | 100 | 100 |
| Mar 2025 | 190 | 166 | 114 |
| Apr 2025 | 227 | 207 | 110 |
| May 2025 | 345 | 311 | 111 |
| Jun 2025 | 342 | 318 | 107 |
| Jul 2025 | 353 | 311 | 113 |
| Aug 2025 | 380 | 322 | 118 |
| Sep 2025 | 332 | 291 | 114 |
| Oct 2025 | 342 | 303 | 113 |
| Nov 2025 | 328 | 296 | 111 |
| Dec 2025 | 396 | 331 | 120 |
| Jan 2026 | 319 | 278 | 115 |
| Feb 2026 | 379 | 330 | 115 |
| Mar 2026 | 441 | 385 | 115 |
| Apr 2026 | 454 | 409 | 111 |
| May 2026 | 561 | 488 | 115 |
| Jun 2026 | 528 | 453 | 117 |
| Jul 2026 | 488 | 444 | 110 |
| Aug 2026 | 526 | 477 | 110 |
| Sep 2026 | not in the export | ||
| Oct 2026 | 471 | 420 | 112 |
Friday and Saturday hold 37% of all tickets
- Mon10.9%77
- Tue11.4%79
- Wed12.8%90
- Thu14.5%102
- Fri18.2%125
- Sat18.5%129
- Sun13.6%97
Pedicures bring in 32% of service sales
- Pedicures32.1%
- Gel polish and gel manicures15.6%
- Acrylic and extensions12.3%
- Builder gel11.5%
- Dip powder10.9%
- Nail art and add-ons9.3%
- Seasonal specials4.2%
- Classic manicures2.2%
- Head spa0.8%
- Other0.6%
- Waxing0.5%
The top technician earns about 35% more per working day than the median
- Tech A137
- Tech B125
- Tech C118
- Tech D111
- Tech E107
- Tech F107
- Tech G106
- Tech H106
- Tech I100
- Tech J99
- Tech K93
- Tech L88
- Tech M78
- Tech N77
- Tech O75
- Tech P68
- Tech Q33
The unglamorous part
679service names as typed
11categories, after grouping
81staff spellings
36people, after merging
MaiMói, a marketplace for nail technicians and salon owners
In developmentRunning a salon showed me a gap in the whole industry. Other industries closed it years ago.
- The gap
- Vietnamese nail technicians and salon owners still find each other the way they did 20 years ago.
- What I use
- Expo and React Native, Next.js, Supabase (PostgreSQL), Stripe and AI coding tools.
- What I am building
- One place to post listings, browse them and talk to each other directly. The work is planned across eight milestones.
- Built in from the start
- Every salon's data is separated at the database level, and a pgTAP test suite checks those row-level security rules.
One listing, from post to tryout
- A salon owner posts
Vị tríThợ bột, full-time
Khu vựcNashville, TN
LươngBao lương
Đăng tinĐã đăng - A technician browses
Cần thợ bột, full-timeNashville, TN · bao lương
Cần thợ chân tay nướcFranklin, TN · part-time
Cần thợ dip, cuối tuầnMurfreesboro, TN
- They talk directly
Cần thợ bột, full-timeNashville, TN
Chị ơi, tiệm mình còn cần thợ bột không ạ?
Còn em. Thứ Bảy em ghé tiệm thử việc nhé.
Dạ, em cảm ơn chị.
An AI assistant that answers client messages
Clients message the salon on Instagram and Facebook at all hours. Many of the questions are about services and prices.
- The gap
- Replies waited until someone at the front desk was free. A client who waits may book somewhere else.
- What I used
- Python and FastAPI, Meta webhooks, and a language model that looks up answers in the salon's own documents (retrieval-augmented generation).
- What I built
- A service that receives each message, finds the matching part of the menu and price list, writes the answer and replies in the same thread.
- What changed
- Clients get an answer at any time of day. Staff stay with the client in the chair.
How one message is answered
- MessageA client writes on Instagram or Facebook
Hi! Do you do dip powder? How much is it?
- WebhookMeta sends the event to my FastAPI service
EventHandled
Same event againAlready handled
- Look upThe service finds the right part of the menu and prices
Gel polish
Dip powder
Builder gel
- AnswerThe model writes a reply from that text
Yes, we do dip powder. It is .
From the price list: Dip powder
- ReplyThe answer goes back in the same thread
Hi! Yes, we do dip powder. It is .
A Snowflake warehouse with Power BI on top
Warehouse built, Power BI report in progressThe dashboard above reads a monthly export. I rebuilt it on a cloud data warehouse. All 71,283 sales lines are loaded, and the totals match the point-of-sale system to the cent.
Three layers, from the raw export to reporting
- RawThe POS export, loaded exactly as it arrives
- CleanedOne row per sale, with 81 staff spellings mapped to 36 technicians
- ReportingViews for daily sales, monthly summary, technician performance and service mix
Data consulting, 2021 to 2023
As an associate consultant at Daugherty Business Solutions (now part of CGI), I worked on four client projects. Client names are confidential.
- Pet-food companyAutomated recurring reports on a legacy SQL Server Reporting Services system, so marketing and finance got their numbers on schedule.
- Home-improvement retailerAssessed a data warehouse before its move to the cloud: every table, how the tables connect, and which applications use each one.
- Financial-planning firmTagged personal data fields and wrote the masking rules for 20,000 customer records, then ran the pipeline that applied them.
- Electronics retailerBuilt pipelines for a central data warehouse and checked its totals against the old reports.