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 standout 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.
2. 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
Trend Reports (Advanced)
Trend Reports (Advanced) Under the Reports menu in TransVirtual there are 4 different pages that provide useful reporting data: This article will detail what each page does and can be used for. Driver Data (Mobile Stats) This page in TransVirtual is ...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 things. The below runs ...Report Designer Templates
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 ...Report Designer Templates
Introduction The report designer allows you to edit the template to show information in the way you require. Report Template List The report template list provides you a list of templates. There are 2 lists avaliable when working with reports. The ...Consignments Reports
This consignment report provides many useful reports that can be further filtered for specific requirements Reports>General Reports>Consignments (Legacy) There is a base set of reports that cover the consignment states; Bookings Deliveries Scanned in ...