Introduction
At Bud, we understand the power of data providing our users with:
- A full suite of standard out-the-box reports for quick and easy access to key information
- Access to a secure data warehouse environment providing the flexibility to create customised reports
Bud continually adds to its data warehouse, as new functionality is introduced to the platform, ensuring you have the latest data at your fingertips.
How to: Understand Your Data
There are multiple options available to you in terms of how you can consume data from Bud's Data Warehouse:
- By using the embedded reports feature. To support and streamline your reporting we have provided a number of embedded, readily available reports within the platform. Visit our articles on embedded reports to find out more.
- To explore your data further, outside of the embedded reports, Bud recommends using the business intelligence platform, Power BI. Click here to find out more about reporting options outside of Bud.
Note: other Business Intelligence platforms can be used such as Tableau. However, Bud supplies a Pre-built model with relationships and report suites for Power BI.
Alternative option:
ETL into your own Data Warehouse via SSIS/ADF/Data Bricks etc
- Useful for those who have existing data warehouses, who want to pull Bud data in via a direct feed.
- If you wish to leverage this option, please speak with your Customer Success Manager who can assist with your request
What is a Data Warehouse?
Key information:
- A Date Warehouse is a database designed for business intelligence and analysis
- Typically this is used to read data in large volumes
- Holds operational and analytical data
-
Holds historic data enabling trend analysis
Data Warehouse Refresh Schedule
- Bud's Data Warehouse delta refresh is run every 2 hours from 6 am to 10 pm GMT all year, and takes approximately 50 minutes to complete. The refresh is started on the even hour GMT all year. While in winter this is 06:00, 08:00, 10:00 etc., during the summer this equates to 07:00, 09:00, 11:00 etc. BST.
- On Saturdays the refresh schedule is 06:00, 12:00 and 16:00 GMT all year.
- We also run a full refresh on Sunday mornings, starting at 07:00 GMT and taking around 5 hours. This is followed by a normal delta refresh at 17:00 GMT.
- Additionally there are various overnight jobs which are initiated at 01:30 GMT and run for around 80 mins. The principle job of interest here is the processing of the ILRs into the Data Warehouse.