A BI project starts with management questions, not charts
The classic mistake is to build a good-looking dashboard first and look for an audience later. A month on, nobody opens it, because it answers no real business question. Start the other way round: the owner writes down 10 to 15 questions they want answered every day or every week.
- how much money came in this month and how much is still in the pipeline
- which rep is behind plan, and why
- which sources bring clients who actually pay
- where deals get stuck the longest
- which clients have stopped buying
Each question becomes a metric with a precise definition. "Revenue" has to mean the same thing to sales and finance: paid invoices or won deals, gross or net of 5% VAT. Until that is agreed, every chart will be disputed.
Implementation runs in five stages
Each stage has a clear output, and the next one does not start without it.
| Stage | What happens | Output | Who is involved |
|---|---|---|---|
| 1. Questions and metrics | Collect management questions, define the metrics | Metric list with formulas | Owner, head of sales |
| 2. Sources | Map where the data lives, grant access | Source map | Data owner, IT |
| 3. Model and clean-up | Link tables, remove duplicates, align reference lists | Data you can trust | Contractor and data owner |
| 4. Dashboards | Build views by role: owner, sales head, marketing | Working screens on live data | Contractor, key users |
| 5. Adoption | Bring the screens into weekly meetings, set up alerts | Decisions made from the dashboard | Management |
MakeBiz Technologies stage plan. For a small company, stages 1 and 2 can fit into one meeting.
Your data sources set the scope of work
The more systems you connect, the more work there is and the higher the risk of mismatches. So sources go in one at a time, starting with the main one.
- CRM. Deals, leads, reps, tasks. In MakeBiz BI, Bitrix24 data and Bitrix24 telephony are included in the subscription
- Accounting. Invoices and payments from Zoho Books, QuickBooks or Odoo, connected on request for an extra fee
- Ads and web analytics. Spend and clicks for end-to-end analytics, also on request for an extra fee
- External telephony. If calls run through a separate provider rather than Bitrix24
- Spreadsheets. Plans and lists that live nowhere else. Move them into the CRM, or the report depends on whoever last edited the file
If accounting and the CRM are not yet linked, start with the integration: the invoice is raised from the deal, the payment flows back, and BI gets one chain instead of two. We integrate Bitrix24 with accounting from AED 10,000, see our integrations page. What to check with your phone provider is covered in our news on UAE telephony for your CRM.
