ENTERPRISE BUSINESS INTELLIGENCE LIMITED
Data Warehouse
Best practice methodology for creating a cloud based data warehouse
Features
- Proven methodology for implementing cloud based data warehouse
- Fast query responses for user satisfaction
- Simple reporting layer to understand for end users
- Conformed dimensions to enable rapid deployment
- Single version of the truth for users to avoid confusion
- Capture historic data that source systems cannot
- Restructure data to make sense to end users
- Consistent data types for reliability
- Iterative approach via agile methodology
- Cleansed data to improve data quality
Benefits
- Methodology removes confusion
- Methodology encourages adoption by users
- Fast performance ensures user satisfaction
- Simple reporting layer encourages adoption and self service
- Rich data history for users
- Clean data to avoid confusion
- Data ready to be used by reporting tools
- Best practice for quality assurance
- Agile methodology for cost control and reduced risk
- Data lake storage of data reduces cost
Pricing
£900 a unit a day
- Education pricing available
Service documents
Request an accessible format
If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format,
email the supplier at richard.allan@enterprisebi.com.
Tell them what format you need. It will help if you say what assistive technology you use.
Framework
G-Cloud 14
Service ID
4 3 6 7 5 9 9 7 6 4 3 6 5 4 8
Contact
ENTERPRISE BUSINESS INTELLIGENCE LIMITED
Richard Allan
Telephone: +447854965198
Email: richard.allan@enterprisebi.com
Planning
- Planning service
- Yes
- How the planning service works
- EnterpriseBI provides end to end solution for cloud data warehouse. A thorough understanding of requirement is conducted first via workshops and interviews. Then a design document is drawn up from the requirements. A sizing exercise will be conducted before a discussion with IT on preferred platform. Following the above, a project plan is created with all necessary resources.
- Planning service works with specific services
- Yes
- Hosting or software services the planning service works with
-
- Microsoft Azure
- Microsoft Fabric
Training
- Training service provided
- Yes
- How the training service works
- EnterpriseBI provide training of the applications developed for end users. EnterpriseBI provide training for power users to get the most out of the system. EnterpriseBI provide training for developers to ensure self-sufficiency with cloud data warehouses.
- Training is tied to specific services
- Yes
- Services the training service works with
-
- Microsoft Azure
- Microsoft Fabric
- IBM Cloud
Setup and migration
- Setup or migration service available
- Yes
- How the setup or migration service works
- We identify key reports currently in use and then break down the data sources used to create those reports. We then work out how to satisfy the reporting requirement by a series of sprints. The project begins by connecting to source data required and storing it in a data lake. As the project progresses, more and more of the data is already in the data lake (eg. conformed dimensions). This approach brings a client along the journey of creating a data warehouse in the cloud. Best practice methodology ensures understanding by all users and most efficient use of cloud resources for both performance and cost.
- Setup or migration service is for specific cloud services
- Yes
- List of supported services
-
- Microsoft Azure
- Microsoft Fabric
- IBM Cloud
Quality assurance and performance testing
- Quality assurance and performance testing service
- Yes
- How the quality assurance and performance testing works
- Data quality is key with data warehousing. Data quality, along with user understanding and query performances are the main reasons for a data warehouse. During development, ongoing unit testing is performed to ensure performance from the start. The methodology is proven and has been enhanced over the decades and fits very nicely in the cloud services on offer now. Once the solution is developed, EnterpriseBI will work with buyers to develop exhaustive test scripts to test the solution. Usually these test scripts are related to the requirements drawn up during the requirements gathering phase. Performance is also tested early and often. Best practice is adhered to to ensure no issues later on. Initial unit testing will show that the calculations are performing as they should. Unit testing is then repeated against typical live data volumes to ensure performance. Performance testing is also built into the testing scripts following development.
Security testing
- Security services
- No
Ongoing support
- Ongoing support service
- Yes
- Types of service supported
-
- Buyer hosting or software
- Hosting or software provided by your organisation
- Hosting or software provided by a third-party organisation
- How the support service works
- EnterpriseBI offer support for the applications developed on the cloud and this can range from full help desk support for all users to token based support for key nominated contacts.
Service scope
- Service constraints
- Support can be provided remotely or on-site. Support is 24 hours per day, 7 days per week.
User support
- Email or online ticketing support
- Email or online ticketing
- Support response times
- Response time is under 2 hours at all times.
- User can manage status and priority of support tickets
- Yes
- Online ticketing support accessibility
- None or don’t know
- Phone support
- Yes
- Phone support availability
- 24 hours, 7 days a week
- Web chat support
- No
- Support levels
- Issues will be responded to in under 2 hours. Issues with environment are covered in the cloud agreement. Application support provided by EnterpriseBI costs 200 GBP per hour. Support technicians are familiar with the applications that have been developed and can fix directly.
Resellers
- Supplier type
- Reseller providing extra support
- Organisation whose services are being resold
- Microsoft, IBM
Staff security
- Staff security clearance
- Other security clearance
- Government security clearance
- None
Standards and certifications
- ISO/IEC 27001 certification
- No
- ISO 28000:2007 certification
- No
- CSA STAR certification
- No
- PCI certification
- No
- Cyber essentials
- Yes
- Cyber essentials plus
- Yes
- Other security certifications
- No
Social Value
- Social Value
-
Social Value
- Fighting climate change
- Tackling economic inequality
- Equal opportunity
- Wellbeing
Fighting climate change
An effective data warehouse via a cloud system reduces the need for travel and encourages cooperation and engagement remotely. The use of cloud data centres and cloud computing benefits the environment by negating the need for on-premise computing.Tackling economic inequality
Well built data warehouse solutions on the cloud ensure all users are engaged in working with up to data, accurate information. This allows organisations to focus on what they need to focus on without the hassle of complicated multiple versions of the truth. Key clients of ours are social housing providers. By building effective data warehouses for these care providers, they can focus on reducing economic inequality.Equal opportunity
Democratising the task of creating a data warehouse engages all users in the process. This reveals makes the goals of the organisation transparent and opens up opportunity. The flexible nature of the solution we will develop will allow end users to suggest ideas and become involved with the process. Certain parts of an application require certain skills and the appropriate people will take on these tasks immaterial of barrier, the skill of the user is what's required.Wellbeing
Data warehouse projects can be tedious, never ending and frustrating. Creating data warehouse solutions that are accurate, performant and pleasant to interact with will make the lives of end users easier. The fact that end users are under pressure to produce accurate and meaningful results means a high quality data warehouse alleviates this pressure..
Pricing
- Price
- £900 a unit a day
- Discount for educational organisations
- Yes
Service documents
Request an accessible format
If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format,
email the supplier at richard.allan@enterprisebi.com.
Tell them what format you need. It will help if you say what assistive technology you use.