For teams that run on SmartDok
SmartDok Power BI: project figures each morning
SmartDok shows project economics on its own dashboard and exports reports to a spreadsheet. Companies that want SmartDok figures in their own reports or in Power BI combine the exports by hand; a Power BI link is a card on SmartDok's idea board.
How it goes today
- Export the hour report, the machine hour report and the goods report from SmartDok.
- Paste them into one spreadsheet.
- Match project numbers and periods by hand.
- Refresh the report and repeat it next week.
How it can go
Hours, machines and materials per project sit next to your other figures.
Each morning the figures from SmartDok are refreshed in a table you own: hours per project and activity, machine hours, goods used and produced, transport and what was invoiced, per day. Your own report or Power BI reads from it, so you can put SmartDok next to your accounting and quotes. The calculated project result stays on SmartDok's dashboard.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. SmartDok first switches on access for your company when you ask them, which can take a few business days. After that you create the key yourself and paste it in the portal, never in the chat.
With Hypamoon, each morning, take from SmartDok the hours per project and activity, machine hours, goods used and produced, transport and invoiced amounts per day, and keep them in one table we own. Keep project numbers and dates so we can join them with our other figures, and tell me when a refresh does not go through.
SmartDok sales first switches on API access for your company, and asks who builds the connection and for which system. After that an administrator creates the key under Company settings, API administration, chooses which modules it may use, and it stays yours. The key is valid for a year and can be renewed.
More for teams on SmartDok
- Holiday requests come in by text message, and the office types them into SmartDok later.
- Our payroll system is not on SmartDok's list, so each pay period we download a file and hope it imports.
- The invoice basis is ready in SmartDok, but we type the invoice again in our accounting package.
- Filled-in forms and deviation reports have to go into the client's project folder, and we put them there ourselves.
- Who is working too long this week? We only see it when the week is over.
- Supplier invoices for a project we upload into SmartDok again, while they are already in our books.
- A won quote or a new job has to be created again in SmartDok as a project and a customer.
- Every new employee or hired worker we set up by hand in SmartDok, with group, department and role.
- Everything for SmartDok