Data Warehouse Services
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
£300 to £1,190 a person a day
- Education pricing available
Service documents
Request an accessible format
Framework
G-Cloud 13
Service ID
4 3 5 1 0 6 4 3 1 9 5 5 9 1 4
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
- No
- 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
- Covid-19 recovery
-
Covid-19 recovery
The business has adjusted to allow all staff to work from home during the pandemic by providing them with appropriate equipment and remote access. All staff have completed home DSE assessments and been provided with equipment to ensure their comfort. We have worked with all our customers to look at amending processes to minmise requirements for onsite resources. As customer staff have returned to sites weve worked with them to minimise occupancy onsite. All onsite engineers are provide with PPE, cleaning products and gloves to ensure they andthe customer feel confortable and are able to maintain space and minimise any contact. - Equal opportunity
-
Equal opportunity
We perform regular feedback and development sessions with our staff. We ensure all staff development areas are identified and addressed with internal and external training.
Alll of our recruitment processes ensure a fair and open assessment of candidates where feedback is provided.
We have recently publicised a SpeakUp policy and implemented and anonymous submission preocess to enable customers, staff and the public to have their say and raise anything they believe should be brought to our attention.
Pricing
- Price
- £300 to £1,190 a person a day
- Discount for educational organisations
- Yes