Data Warehouse Design, Migration & Support
We help organisations transition to a cloud hosted data warehouse environment. We provide support throughout the entire data warehouse journey including data mapping, design and implementation. Our development and test services support the delivery of ETL functions and BI interfaces.
Features
- Project initialisation, planning and delivery
- Architecture design and implementation.
- Data modelling, mapping and schema design
- Modern cloud based deployment
- ETL function design and implementation
- Test strategy, scripts and automation
Benefits
- Reduce deployment times using existing templates and skilled resource
- Single source for BI data and reporting services
- Scalable to meet demand
Pricing
£350 to £1,250 a unit a day
- Education pricing available
Service documents
Request an accessible format
Framework
G-Cloud 14
Service ID
4 0 2 0 1 4 8 5 4 0 9 6 2 4 7
Contact
OGEL IT LTD
Sam Newman
Telephone: 01438 300335
Email: gcloud@ogelit.com
Planning
- Planning service
- Yes
- How the planning service works
- We assist with understanding your existing data landscape and helping to develop a compelling business case for deploying a data warehouse environment. Once approved we produce an outline plan for the duration of the engagement beginning with the design and implementation of the core elements of the solution and then onto a more AGILE approach for delivery and testing of later development cycles.
- Planning service works with specific services
- No
Training
- Training service provided
- Yes
- How the training service works
- We provide customer workshops to assist internal staff with understanding new tools and services that are being introduced.
- Training is tied to specific services
- No
Setup and migration
- Setup or migration service available
- Yes
- How the setup or migration service works
- Assist with data analysis and mapping
- Setup or migration service is for specific cloud services
- No
Quality assurance and performance testing
- Quality assurance and performance testing service
- Yes
- How the quality assurance and performance testing works
- Our technicians are proficient with performance tuning of database services and our test teams are there to ensure data quality is maintained.
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
- We can provide access to our support services for the underlying infrastructure and services on a 8am to 6pm Monday to Friday basis via phone, email and online portal.
Service scope
- Service constraints
- Customers must have key systems owners assigned to understand source/system data and provide access to key stakeholders to determine BI outputs.
User support
- Email or online ticketing support
- Email or online ticketing
- Support response times
- Standard support hours are 9-5 Monday to Friday. Support outside these hours can be provided at additional cost.
- 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
- 9 to 5 (UK time), Monday to Friday
- Web chat support
- No
- Support levels
- //Level 1 - Initial response within 4 hours : Business critical incident that impacts all users // Level 2 - Initial response by end of next business day : Medium impact incident that affects a single business unit or group of users (>25) // Level 3 - Initial response within 5 working days : Minor impact incident that affects a single user, not business critical
Resellers
- Supplier type
- Reseller providing extra support
- Organisation whose services are being resold
- Microsoft, Fortinet
Staff security
- Staff security clearance
- Other security clearance
- Government security clearance
- Up to Developed Vetting (DV)
Standards and certifications
- ISO/IEC 27001 certification
- Yes
- Who accredited the ISO/IEC 27001
- Peers Quality Assurance Limited
- ISO/IEC 27001 accreditation date
- 26/04/2024
- What the ISO/IEC 27001 doesn’t cover
- Any development work within the customers environment is not within the scope of our ISO27001 certification.
- ISO 28000:2007 certification
- No
- CSA STAR certification
- No
- PCI certification
- No
- Cyber essentials
- Yes
- Cyber essentials plus
- No
- Other security certifications
- No
Social Value
- Social Value
-
Social Value
- Tackling economic inequality
- Equal opportunity
Tackling economic inequality
OGEL IT are an SME committed to developing a business within the local and surrounding community by creating employment and training opportunities. We utilise local hardware recycling services to ensure any decommissioned equipment is redeployed within the local community.Equal opportunity
All employees will be treated fairly and with respect. Selection for employment, promotion, training or any other benefit will be on the basis of aptitude and ability. The company is also committed to preventing discrimination of any type against its employees by third parties like suppliers, clients and the general public. Our SpeakUp policy and processes enable anonymous reporting by anyone should they have any concerns or issues with the company or any of its employees.
Pricing
- Price
- £350 to £1,250 a unit a day
- Discount for educational organisations
- Yes