BI (Business Intelligence) Database
BI Reporting
When you need the ultimate level of flexibility and customisation with your reporting to drive your analysis and effective decision making processes, a BI reporting option is the stand out choice.
What do you get?
Your own private read only MySQL database that's hosted within our existing network infrastructure and managed and maintained by us.
Reporting Tools
You're free to choose your own BI reporting tool. You can manage this in-house or source specialist BI reporting contractors to setup and manage your requirements.
Synchronisation
1. Every 5 minutes, we'll complete a full sync of changes to your highest priority data. This includes the last 7 days of consignments and associated information.
A range of different data sets are used, so these values may vary slightly.
2. Each evening (every 24 hours) we'll also sync changes to lower priority data going back up to 6 months.
Costs
1. An initial once off setup cost.
2. Ongoing weekly hosting and maintenance charge.
3. There is no ongoing obligation or contract required. At any time, if this option isn't working for you, let us know and we'll shut it down and stop charging you.
Considerations
This BI option is only available when hosted within our server infrastructure. Hosting on alternative options such as your own, or other 3rd party infrastructure is not supported. The main reasons for this are:
1. Performance - There is a huge amount of data being synced so the performance of both our internal infrastructure and your BI database needs to be closely monitored and regularly reviewed and optimised.
2. Access - We require 24x7 access to the BI database to carry out our monitoring, maintenance and updates. As with everything in TransVirtual, we never stop growing and improving so you will receive periodic updates to increase the scope of data available for use.
3. Updates - In order to keep our platform consistent and our development and overheads under control, every BI database has the same structure. Requests for additional data will be considered for roll out across all our BI databases. Customisation and changes to individual databases creates another layer of complexity that requires management so won't be considered.
Related Articles
PDF/Excel Reports
PDF/Excel Reports Overview TransVirtual offers a series of default reports that can be used to extract valuable information from your account. These reports offer information on things like costs, profit/loss, driver job activity, amongst other ...PDF/Excel Report Template
Transvirtual uses a series of report templates that are used to generate the labels, consignment note PDFs, Invoice PDFs, etc. that you see when using Transvirtual. These report templates can be customized from the default version if required. A ...Mobile (CoR) Forms
Mobile Forms Reports (Do a Report) The form reports module is a module that is used to put custom forms onto the mobile application to collect the applicable data from the users. User can fill these reports manually, or you can even make them appear ...Global Setup
Global Setup General General Field Descriptions This section allows you to define default general settings for mobile devices. Auto Updates Enabled: As updates to the mobile application are rolled out, notifications will be automatically sent to the ...DIFOT Reviews
DIFOT Reviews In Transvirtual there is the ability to report on consignments as Delivered In Full On Time (DIFOT). The system does this automatically by using the listed Transit Time on a consignment and comparing that to when the consignment has ...