Power BI dashboards
Dashboards built around one business decision, with a clean model, tested numbers and a handover your team can run.
Business intelligence →Control roomPower BI · AI agents · AutomationWorking with teams worldwide
Data you can trust. Agents that do the work.
I'm Smit Chandarana. I build Power BI systems, AI agents and workflow automation for businesses, and I run my own company on the same agents. This page shows how they work, with real numbers.
78Tasks completed by the agent teamsince 5 Oct 2026
372Sourced research notes savedread before anything is written
288Searches tracked every dayranked from Google Search Console
29Posts and articles publishedeach one approved by a person
Source: my own agent hub, counted from its databaseSnapshot 23 Oct 2026
How the work moves
Every task goes through the same six steps
This is the pipeline my own team of AI agents runs. Click a step, or watch it play. I build the same kind of pipeline for clients.
- 09:00:02requestWeekly sales report, 4 regions
- 09:00:19research4 sources read, 12 facts cited
- 09:01:40buildDraft v1 and refresh logic ready
- 09:02:05check2 issues found, sent back, then passed
- 09:03:12approvalWaiting for a person
- 09:07:44livePublished, result logged
The one hard rule: nothing publishes, sends or contacts a person without a human approving it first.
What I build
Reports, automation and AI agents that work together
Six things I'm hired for. Typical timelines come from real projects, and every project starts with a data review.
Data modelling and speed
One version of the truth. Slow reports, failed refreshes and oversized files fixed at the model, not hidden.
Data modelling →Reporting automation
Month-end reports that used to take days run themselves, with reconciliation rules and checks built in.
Reporting automation →AI agents on your data
Agents that read your company data, answer questions, research leads and prepare drafts, with a person approving the output.
AI solutions →Workflow automation
The repeat work between your tools, joined up: CRM follow-ups, approvals, notifications and data refreshes.
Workflow automation →ERP and SAP integration
SAP, Oracle and Microsoft Dynamics data brought into one model your reports can trust.
ERP integration →Results
What changed for the teams I worked with
Figures come from delivered projects. Your result depends on your data.
85%
Less reporting time, at best.
70%
Less manual reporting for a finance team, saving 15+ hours every week.
100+
Prospects a day from an AI lead-generation engine built with the Claude API and Python.
3 → 1
Excel files replaced by a single live sales-performance dashboard.
Enterprise experience: contract work for Microsoft, General Motors and Honda, plus delivery inside Honda R&D and General Motors reporting environments. Never employment, always contract engagements.
Try it
What could automation give back to your team?
Move the sliders. This applies the 70% cut one finance team saw to your own numbers. It is an illustration, not a quote.
Hours given back each month
0
Value over a year
–
Calculated as hours × people × 70% × 52 weeks. Every project starts with a free call, and a data review before any price.
Background
7+ years in data, now building agents
- 2024 – NOWFounder, Phoenix SolutionsA specialist team for Power BI, analytics and AI automation, working remotely with clients worldwide.
- 2022 – 2024Embedded consultant, Solize USAEmbedded consultant serving Honda R&D and General Motors.
- 2021Microsoft-stack contract work, TopEdge IncContract work on the Microsoft data stack.
- 2020 – 2021Data Analyst, DreamingCodeData analyst role.
- 2018 – 2020MS, Northeastern University, Boston
- 2014 – 2018BE, Gujarat Technological University
Tools
The stack I work in
- Power BI
- DAX
- Power Query
- SQL Server
- Azure SQL
- PostgreSQL
- MySQL
- Azure Data Factory
- Python
- Pandas
- PySpark
- FastAPI
- Playwright
- Claude API
- Multi-agent pipelines
- n8n
- Zapier
- Make
- Power Automate
- REST APIs
- Odoo CRM
- SAP HANA
- Tableau
- MongoDB
- AWS
Languages: English, Gujarati, Hindi. Upwork: AI Automation Engineer and Power BI Developer, 100% Job Success Score.
Questions
Straight answers
Who is Smit Chandarana?
Founder of Phoenix Solutions and a data and AI automation consultant with 7+ years of experience. He builds Power BI systems, AI agents and workflow automation for businesses worldwide, and has done contract work for Microsoft, General Motors and Honda.
What is an AI agent and what can it do for a business?
An AI agent is software that takes a task, gathers information, drafts the result and hands it to a person to approve. Typical jobs are building recurring reports, researching leads, preparing drafts and keeping dashboards fresh.
Do the AI agents publish or send things on their own?
No. In the systems I build, agents research, draft and check. A person approves anything that publishes, sends, contacts someone or spends money.
How long does a Power BI project take?
Delivery timelines depend on the project: scope decides the delivery plan, and it is agreed with you before work starts.
What does a Power BI dashboard cost?
For direct clients, focused dashboards are typically ₹1.5 lakh to ₹3 lakh, and full BI ecosystems with ERP integration ₹5 lakh to ₹15 lakh. Prices are fixed, and 30 days of post-launch support is included. Licences and infrastructure are listed separately.
How do I start?
Book the free 30-minute call, or email smit@phoenixsolution.in. Replies come within 24 business hours.
Next step
Tell me which report or task eats your week.
Thirty minutes, direct with me, no sales team. You leave with a plain answer on what is worth automating first.