ENTERPRISE DATA WAREHOUSE AND ANALYTICS SERVICE (EDW+AS)
Multiple standalone services combine an orchestrated data pipeline for EDW+AS including: Master Data Management; ETL via Python or SQL transformation rules to create an Operational Data Store; analytical reporting via columnar database (Redshift) and QuickSight or PowerBI; advanced analytics with Python notebook; and machine learning via SageMaker.
Features
- Proprietary system data migration to cloud-based workloads.
- Extend secure local network into virtual private cloud VPC
- Integrated pipeline covering ODS, MDM, EDW, BI
- Data pipeline includes Mirror, Staging and Reporting schema
- Dashboard, OLAP, reporting interfaces to major BI Analytics tools
- Elasticsearch Logstash Kibana (ELK) for processing unstructured web system logs
- Set up high performance, high availability EDW cluster nodes
- GDPR compliance: obfuscation and/or encryption at rest and in transit
- Data Vault ELT to capture structured and unstructured data
- Virtual Kimball star schema to simplify data mart reporting joins
Benefits
- Simplify embedded analytics into your own portals and mobile apps
- Build inhouse analysis skills, outsource ETL and Data Warehouse complexity
- Star schema simplifies complex data for business users
- Data Vault 2.0 satellite and hub schema preserves data relationships
- Containerised infrastrucure, keeping your data in your ownership
- Fully managed service with helpdesk and enterprise support optional add-ons
- Uni-ready EDW with Data Futures, analysis dimensions and data marts.
- Native support for HESA Returns/DLHE, Unistats, OfS NSS, UCAS J
- Learner Analytics data, focus on outcomes and Student Experience
- Understand and target retention, progression and achievement with early intervention
Pricing
£1,000 to £5,000 a unit a month
Service documents
Request an accessible format
Framework
G-Cloud 14
Service ID
2 5 7 5 2 6 3 5 6 7 8 6 0 2 8
Contact
Texuna
Raquel Borges
Telephone: 44 (0) 203 393 4670
Email: tender@texunatech.com
Service scope
- Software add-on or extension
- Yes, but can also be used as a standalone service
- What software services is the service an extension to
- The Texuna software services on G-Cloud can all be implemented to work either with each other, or with other applications that are installed at our customers site. Texuna is able to provide assistance and configuration services using our Cloud Support services to ensure that any implementation project is accomplished successfully.
- Cloud deployment model
-
- Public cloud
- Private cloud
- Community cloud
- Hybrid cloud
- Service constraints
-
Texuna applications may be subject to routine maintenance and this will be agreed in advance with our client so that disruption is minimized. Routine maintenance is never scheduled during the normal working day and does not typically result in noticeable downtime.
Customisation can be achieved via our Cloud Support services. No features will be deprecated without advance agreement with the customer. New features may become available from time to time. - System requirements
-
- Deployed in any public/private/community/hybrid cloud environments
- Also possible to do in-house deployment with assistance
User support
- Email or online ticketing support
- Email or online ticketing
- Support response times
-
Texuna provide basic, Premium and Enterprise Support options with different response times. The initial response is always within one day. Resolution targets are: within 5 working days (Basic), 2 working days (Premium) or less than 1 working day (Enterprise).
System downtime / critical issues resolution target is under 4 hours within business hours. - User can manage status and priority of support tickets
- Yes
- Online ticketing support accessibility
- WCAG 2.1 AA or EN 301 549
- Phone support
- Yes
- Phone support availability
- 9 to 5 (UK time), Monday to Friday
- Web chat support
- Web chat
- Web chat support availability
- 9 to 5 (UK time), Monday to Friday
- Web chat support accessibility standard
- WCAG 2.1 AA or EN 301 549
- Web chat accessibility testing
-
Texuna performed web chat testing using the following tools:
• ZoomText - a screen magnifier for Windows
• NVDA - a screen reader for Windows
• VoiceOver - a screen reader for Mac/iOS - Onsite support
- Yes, at extra cost
- Support levels
-
Support SLA (business days):
• Enterprise - 1 day (GBP5,000 per month);
• Premium - 2 days (GBP2,500 per month);
• Basic - 5 days (GBP 1,000 per month).
Support can be via phone, chat, email or on-site.
Normal support is Monday to Friday excluding holidays, and service is monitored 24X7X365 for outage incident response. Inbound support requests outside normal hours will only be responded to in case of emergency. Talk to us to customise the level and extent of coverage you need to include weekends, holidays and/or 24 hours. Extra charges will apply. - Support available to third parties
- Yes
Onboarding and offboarding
- Getting started
-
Implementation services may be purchased using our Cloud Support service and pricing.
Customers typically ask for full support to review their plans and help them establish a migration from in-house systems to various cloud options. This often includes building custom templates that meet their full stack bespoke requirements. Texuna can provide a fully managed service so that on-boarding includes setup of security services, virtual private networks and disaster recovery and backup.
Texuna can provide documentation and online training webinars to assist users to begin using the service. Specialised training can be provided to meet individual needs and reflect any customisations implemented. - Service documentation
- Yes
- Documentation formats
-
- HTML
- End-of-contract data extraction
- Texuna will export data in an agreed format and make it available. Typically this is either in a relational database format and/or CSV files. These can be encrypted and downloaded from a secure site accessible via HTTPS or via sFTP.
- End-of-contract process
- Any bespoke requirements for end of the contract may be accommodated. Note that there may be an additional time and materials cost where the customer requests help from Texuna to meet their specific migration requirements that are not met via the handover of data.
Using the service
- Web browser interface
- Yes
- Supported browsers
-
- Microsoft Edge
- Firefox
- Chrome
- Safari
- Opera
- Application to install
- No
- Designed for use on mobile devices
- Yes
- Differences between the mobile and desktop service
- All applications are based on responsive web technology and are mobile-ready. Some application workflows may not be appropriate for small mobile-only screens.
- Service interface
- Yes
- User support accessibility
- WCAG 2.1 AA or EN 301 549
- Description of service interface
- The interface is developed with thoughtful UX/UI research and testing. It provides a complete set of functions to achieve the result in user-friendly and easy to use way.
- Accessibility standards
- WCAG 2.1 AA or EN 301 549
- Accessibility testing
-
A web UI can be used to provision services, manage templates, and migrate data and server workloads via containers between remote cloud locations. Texuna provide some predefined templates and can help you customise your own templates for your own bespoke full stack control.
Users will not be able to modify the interface to the cloud management console. - API
- Yes
- What users can and can't do using the API
-
Application supports basic API integration, and can be customised to expose further functionality. Open standards for integration are supported. Basic functionality requires security credentials to be set up.
Please contact us to discuss your API requirements. - API documentation
- Yes
- API documentation formats
-
- Open API (also known as Swagger)
- HTML
- API sandbox or test environment
- Yes
- Customisation available
- Yes
- Description of customisation
- Applications are modular and can be combined with other applications. Texuna offer customization and integration services. Back office administrators can setup advanced business rules, configure master data and dictionaries and can amend some onscreen text.
Scaling
- Independence of resources
- Servers are monitored and system resources can be incrementally added(subject to plan purchased)if load / response times exceed set thresholds frequently. All Texuna applications are stress tested and performance tuned to ensure good client experience.
Analytics
- Service usage metrics
- Yes
- Metrics types
-
CPU
Disk
Memory
Network - Reporting types
- Reports on request
Resellers
- Supplier type
- Not a reseller
Staff security
- Staff security clearance
- Conforms to BS7858:2019
- Government security clearance
- Up to Security Clearance (SC)
Asset protection
- Knowledge of data storage and processing locations
- Yes
- Data storage and processing locations
-
- United Kingdom
- European Economic Area (EEA)
- User control over data storage and processing locations
- Yes
- Datacentre security standards
- Complies with a recognised standard (for example CSA CCM version 3.0)
- Penetration testing frequency
- At least every 6 months
- Penetration testing approach
- In-house
- Protecting data at rest
-
- Physical access control, complying with CSA CCM v3.0
- Physical access control, complying with SSAE-16 / ISAE 3402
- Encryption of all physical media
- Scale, obfuscating techniques, or data storage sharding
- Data sanitisation process
- Yes
- Data sanitisation type
-
- Explicit overwriting of storage before reallocation
- Deleted data can’t be directly accessed
- Equipment disposal approach
- Complying with a recognised standard, for example CSA CCM v.30, CAS (Sanitisation) or ISO/IEC 27001
Data importing and exporting
- Data export approach
- By default Texuna operate an open platform and make it easy for data to be downloaded in a variety of formats through the User Interface.
- Data export formats
-
- CSV
- Other
- Other data export formats
-
- MS Excel
- JPG
- Data import formats
-
- CSV
- Other
- Other data import formats
-
- MS Excel
- JPG
Data-in-transit protection
- Data protection between buyer and supplier networks
-
- TLS (version 1.2 or above)
- IPsec or TLS VPN gateway
- Other
- Other protection between networks
- Where we are satisfied with the security of the Customer and their preferred transmission application then we will usually transmit data using Customer preferred tools.
- Data protection within supplier network
-
- TLS (version 1.2 or above)
- IPsec or TLS VPN gateway
- Other
- Other protection within supplier network
- Data can be configured to be encrypted at rest as well as in transit.
Availability and resilience
- Guaranteed availability
-
Service level commitment is 99.95% availability excluding planned maintenance downtime which is arranged in advance by negotiation.
Services provided regularly exceed this threshold and typically a 99.99% uptime is achieved in most service periods.
Bespoke arrangements are available by negotiation and service credits if required can be included in any negotiation. - Approach to resilience
- Resilience is a function of the cloud hosting approach taken by the customer. Texuna can deploy to public or private clouds and in-house - and resilience required can be varied depending on the selected approach. Texuna can offer a fully managed service with performance testing and penetration testing to assure high levels of resilience, with auto-scaling and elastic resources if required. It may also be possible to relocate services to alternative cloud zones, regions or other cloud hosting providers in an unusual event. Texuna can provide full Business Continuity and Disaster Recovery options, with data, virtual machine instances and encrypted backups being moved off protected cloud networks on to alternative networks. Please contact Texuna to discuss your exact requirements.
- Outage reporting
-
Texuna provide a Zabbix-based monitoring service from an independent cloud location and can configure a host of events and actions to assure the service availability on a component by component basis.
Texuna also work with cloud hosting providers tools such as CloudWatch for AWS to set up a range of monitoring actions against a suite of different AWS tools and services. On Azure hosting we use the Azure Monitor.
Unusual events can be communicated via email or SMS by default.
Identity and authentication
- User authentication needed
- Yes
- User authentication
-
- 2-factor authentication
- Public key authentication (including by TLS client certificate)
- Identity federation with existing provider (for example Google Apps)
- Dedicated link (for example VPN)
- Username or password
- Access restrictions in management interfaces and support channels
-
Texuna can provide Fido Alliance U2F devices to allow customers to securely authenticate without the security risks associated with shared secrets like passwords. Alternatively, 2FA such as TOTP can be used.
Texuna can also establish a secure VPN and/or IP range restrictions on access to the service.
For electronic or telephone support, an agreement can be put in place to ensure that Texuna will not take instruction from unsolicited communications, but will call back and ask for confirmation for such instruction. - Access restriction testing frequency
- At least every 6 months
- Management access authentication
-
- 2-factor authentication
- Public key authentication (including by TLS client certificate)
- Identity federation with existing provider (for example Google Apps)
- Dedicated link (for example VPN)
- Username or password
Audit information for users
- Access to user activity audit information
- Users have access to real-time audit information
- How long user audit data is stored for
- User-defined
- Access to supplier activity audit information
- Users have access to real-time audit information
- How long supplier audit data is stored for
- User-defined
- How long system logs are stored for
- User-defined
Standards and certifications
- ISO/IEC 27001 certification
- Yes
- Who accredited the ISO/IEC 27001
- BSI
- ISO/IEC 27001 accreditation date
- 18/12/2023
- What the ISO/IEC 27001 doesn’t cover
- All of Texuna's operations are covered, there are no exclusions.
- ISO 28000:2007 certification
- No
- CSA STAR certification
- No
- PCI certification
- No
- Cyber essentials
- Yes
- Cyber essentials plus
- No
- Other security certifications
- Yes
- Any other security certifications
- IASME Cyber Assurance Level 1
Security governance
- Named board-level person responsible for service security
- Yes
- Security governance certified
- Yes
- Security governance standards
-
- CSA CCM version 3.0
- ISO/IEC 27001
- Information security policies and processes
- Texuna is certified to ISO 27001:2013 by our auditors BSI for all of our operations. Our security policies include named individuals with overall responsibility for ensuring that our policies and processes are followed. All staff are trained and actively report potential non-conformities. Reported non-conformities are investigated for root cause and our preventive action process is leveraged to ensure that all reasonable steps are taken to prevent reoccurrence. Our security officers oversee the process and regularly report the performance of our systems to Senior Management. Texuna has mature security processes, our certification was initially obtained in 2009 and has been maintained and improved since then.
Operational security
- Configuration and change management standard
- Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
- Configuration and change management approach
- Texuna is aligned to ISO 20000-1:2011 throughout our operations. Our change control processes are audited by our external auditors BSI. We operate a configuration management system and apply a strict, documented, change control process that is managed through a software-defined pipeline. All artefacts (code and documentation), are subject to change control with formal procedures applied to code and technical documentation. Continuous integration and continuous deployment with regression testing are essential to assure quality and standard tools such as GIT hub help structure the change management process
- Vulnerability management type
- Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
- Vulnerability management approach
- Texuna maintains a schedule of penetration testing as well as automated regression testing against known vulnerabilities. Releases are governed by the configuration and change control process, and all updates are outlined in release notes. Any 3rd party open source library dependencies are kept up to date via continuous integration. Texuna DevOps engineer monitor the entire software stack for published vulnerabilities and new patch updates to determine if and when such patches are pushed to production systems in an automated process with tools such as Puppet and Ansible.
- Protective monitoring type
- Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
- Protective monitoring approach
- Texuna maintains a number of protective monitoring processes to keep services and applications free from attack or errant behaviour. This includes keeping anti-virus software up to date across the estate of IT machines in use, as well as cloud monitoring tools and web/system log collection and monitoring for unusual behaviours and access. Logs are checked at regular intervals and when unusual system or performance events or bugs are raised. Specialist tools such as Cloudflare can also be configured for especially sensitive applications that need protection from DDOS attacks.
- Incident management type
- Conforms to a recognised standard, for example, CSA CCM v3.0 or ISO/IEC 27035:2011 or SSAE-16 / ISAE 3402
- Incident management approach
- Texuna's incident management is governed by ISO9001:2008 and ISO 27001:2013 and all incidents are tracked. Compromises are identified either via automated testing or can be raised by customers and staff based on vulnerability assessment and Preventive Actions. Incidents are assigned a person responsible for resolution and tracked until closed. Major incidents are escalated and resolved immediately where possible. Minor incidents are programmed into normal workload and resolved on an ongoing basis or as part of the regular release cycle.
Secure development
- Approach to secure software development best practice
- Independent review of processes (for example CESG CPA Build Standard, ISO/IEC 27034, ISO/IEC 27001 or CSA CCM v3.0)
Public sector networks
- Connection to public sector networks
- No
Social Value
- Social Value
-
Social Value
- Equal opportunity
- Wellbeing
Equal opportunity
We are adamant that a diverse workforce in non-discriminatory workspace is the only fair state of a company as a unit of society. Moreover it is the most efficient state, as it reduces the pressure of stereotypes and prejudice regarding working matters, promotes innovation and creativity.
In order to stay just and efficient regarding our workers we implemented following measures:
- All our job advertisements explicitly say that we encourage people of all genders, races, sexual orientations to work for Texuna.
We have developed an Equal Opportunities policy and all job applicants are given a copy of this policy to create a more inclusive environment and encourage them to apply if they are of a minority.
All job applicants are made aware that they have a right of appeal should they consider their application to have been unsuccessful due to discrimination of any form. Such appeals can use interviewers’ notes which they take in relation to each point on the personnel specification as justification for their decision to appoint or not appoint.
Applicants will be assessed only against the contents of the personnel specification. Interviewers are required to ask questions of applicants, which are directed solely to obtaining evidence of the applicant’s ability to meet the requirement of the personnel specification.
During job interviews, interviewers may not ask any questions that could be construed as discriminatory e.g. questions in relation to a female's intentions with regard to marriage, children etc or unnecessary questions regarding disabilities.
Texuna also recognises sexual harassment as a serious problem in the workplace and can protect its victims: Any employee wishing to bring a complaint of sexual harassment may do so via any Manager whom they feel confident will be sympathetic to their complaint and the Company will ensure that the employee is protected against victimisation.Wellbeing
Wellbeing
We believe the single most important factor in upholding the mental wellbeing of our employees is to create an communicative culture where discussion is encouraged. We operate a virtual open door policy to create an environment where our employees feel comfortable discussing their health. This transparency encourages our employees to talk and therefore allows us to change our behaviours to further protect their wellbeing.
Pricing
- Price
- £1,000 to £5,000 a unit a month
- Discount for educational organisations
- No
- Free trial available
- No