Data Transformations
Connect and transform disparate data sources, get any system talking to another.
Store data in a variety of relational and non-relational ways, in the cloud or on-premises. Bespoke Development.
Output data using the latest visualisation tools and techniques or for other systems. We are Microsoft Power BI experts.
Features
- Remote Access
- Real Time Reporting
- Scheduled Reporting
- Fully Managed Platform for Data Transformations
- Store Data in a variety of relational or non-relational ways
- Display data in Dashboards or other reporting visualisations.
- Transform data for onward integration to other systems.
Benefits
- View and collaborate content online with only an internet connection.
- As managed or as non-managed as the customer requires
- Connect Disparate Data Sources together
- Secure Cloud Deployment using Microsoft Azure
- Scalable and resilient Cloud Deployment
- Consultancy Services
- Architecture and Design Services
Pricing
£499 to £1,999 a unit a month
- Education pricing available
- Free trial available
Service documents
Request an accessible format
Framework
G-Cloud 13
Service ID
5 0 0 0 0 1 2 2 6 6 7 0 5 7 0
Contact
DATAUNOMY LIMITED
Zohaib Rehman
Telephone: +447940480009
Email: zohaib@dataunomy.co.uk
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
- Microsoft Power BI
- Cloud deployment model
-
- Public cloud
- Private cloud
- Community cloud
- Hybrid cloud
- Service constraints
- Viewing Visualisations and Dashboards requires only an internet connection and a modern browser.
- System requirements
-
- Modern Browser
- Internet Connection
User support
- Email or online ticketing support
- Email or online ticketing
- Support response times
-
P1 response - within 4 hours;
P2 response - within 8 hours;
P3 response - within 12 hours. - User can manage status and priority of support tickets
- No
- Phone support
- Yes
- Phone support availability
- 24 hours, 7 days a week
- Web chat support
- Web chat
- Web chat support availability
- 24 hours, 7 days a week
- Web chat support accessibility standard
- WCAG 2.1 AAA
- Web chat accessibility testing
- JAWS testing
- Onsite support
- Onsite support
- Support levels
-
1. Microsoft Power BI Support only. Support limited to this product only.
2. Silver. Limited support across the whole of Data transformations (Data Integration, Data Engines, Visualisations and Dashboards)
3. Gold. Comprehensive support across the whole of Data transformations including standard working hours telephone, email and webchat support.
4. Platinum. Comprehensive support across the whole of Data transformations including 24/7 telephone, email and webchat support.
All packages have a support manager. - Support available to third parties
- Yes
Onboarding and offboarding
- Getting started
- We provide onsite or offsite (remote) training. We always spend time inducting our users with our services as we see this as very important and part of the Dataunomy service. We also have User Documentation
- Service documentation
- Yes
- Documentation formats
-
- HTML
- Other
- Other documentation formats
- Microsoft Word
- End-of-contract data extraction
- We provide full and transferable database backups free of charge.
- End-of-contract process
-
1. Consultancy. We work with you to determine the right strategy/approach for your data. Here we will take the requirements. Again depending on the client, an Agile approach may be employed.
2. Full development services. Depending on requirements we will develop services in Data Transformation, Data Engines and/or Business Intelligence.
3. Support. Minor change requests are also included free of charge and we provide office hours support which can be increased depending on the contract.
Using the service
- Web browser interface
- Yes
- Supported browsers
-
- Internet Explorer 11
- Microsoft Edge
- Firefox
- Chrome
- Safari
- Opera
- Application to install
- No
- Designed for use on mobile devices
- Yes
- Differences between the mobile and desktop service
- Service detects the screen size of the client and automatically optimised. Using Bootstrap technology to achieve this.
- Service interface
- No
- User support accessibility
- WCAG 2.1 AAA
- API
- Yes
- What users can and can't do using the API
- Setup is done through us. Changes are coordinated by us.
- API documentation
- Yes
- API documentation formats
-
- Open API (also known as Swagger)
- HTML
- ODF
- Other
- API sandbox or test environment
- Yes
- Customisation available
- Yes
- Description of customisation
- On the visualisation, dashboard and reporting side, users can set certain visual and accessibility preferences.
Scaling
- Independence of resources
- We monitor all services and our cloud provider has built-in tools including on-demand suggestions. We can simply throttle up or down the hardware architecture almost instantaneously when demand requires it.
Analytics
- Service usage metrics
- Yes
- Metrics types
- Yes if for example using Microsoft Power BI, then service usage metrics are built in and available. One project recently completed required user usage metrics to be reported via a real-time dashboard. If for example, the front end is a web page then we can monitor and report on usage metrics similarly. This can be on a scheduled basis where the report is delivered to a user's inbox frequently for example or real-time. We are full stack developers so the possibilities are almost endless.
- Reporting types
-
- API access
- Real-time dashboards
- Regular reports
- Reports on request
Resellers
- Supplier type
- Not a reseller
Staff security
- Staff security clearance
- Conforms to BS7858:2019
- Government security clearance
- Up to Developed Vetting (DV)
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 once a year
- Penetration testing approach
- ‘IT Health Check’ performed by a CHECK service provider
- Protecting data at rest
-
- Physical access control, complying with CSA CCM v3.0
- 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
- Equipment disposal approach
- A third-party destruction service
Data importing and exporting
- Data export approach
- The most common way to export data is through a visualisation tool such as Microsoft Power BI, Tableau or Microsoft SSRS. Data transformations may also require an output for another system so exports are almost unlimited with popular formats including seperated values, tab delimited, XML, JSON etc. If Data Engines are required, then database snapshots are also available.
- Data export formats
-
- CSV
- ODF
- Other
- Other data export formats
-
- XML
- JSON
- Seperated Values eg. CSV, PSV
- Delimited Values eg. Tab
- Excel
- Word
- Data import formats
-
- CSV
- ODF
- Other
- Other data import formats
-
- XML
- JSON
- Seperated Values eg. CSV, PSV
- Delimited Values eg. Tab
- Excel
Data-in-transit protection
- Data protection between buyer and supplier networks
-
- Private network or public sector network
- TLS (version 1.2 or above)
- Data protection within supplier network
-
- TLS (version 1.2 or above)
- IPsec or TLS VPN gateway
Availability and resilience
- Guaranteed availability
- We use third-party providers Microsoft Azure or AWS. We would be more than happy to complete the refund process if availability does not match the SLA.
- Approach to resilience
- Our databases can be clustered or replicated. In addition, a full operating system backup via our cloud provider is available if a catastrophe was to happen. Additionally, we employ load balancing technology, and also hot-swap database servers are available.
- Outage reporting
- Our server provider has built-in software such as SCOM alerts or SPLUNK. We also use a third-party provider PAESSLER to provide data and metrics on availability and outages. Email-alerts can be set up for any interested parties and access to the PAESSLER public dashboard can be configured.
Identity and authentication
- User authentication needed
- Yes
- User authentication
-
- 2-factor authentication
- Identity federation with existing provider (for example Google Apps)
- Username or password
- Access restrictions in management interfaces and support channels
-
We restrict access by roles. Users can be assigned roles that give access to more or fewer features.
Again when raising tickets users can be assigned this role if for example, the client wants to gatekeeper tickets before they come to the supplier. Again we work with you to ascertain the exact processes. - Access restriction testing frequency
- At least once a year
- Management access authentication
-
- 2-factor authentication
- Identity federation with existing provider (for example Google Apps)
- Username or password
Audit information for users
- Access to user activity audit information
- You control when users can access audit information
- How long user audit data is stored for
- User-defined
- Access to supplier activity audit information
- Users contact the support team to get 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
- No
- ISO 28000:2007 certification
- No
- CSA STAR certification
- No
- PCI certification
- No
- Cyber essentials
- No
- Cyber essentials plus
- No
- Other security certifications
- No
Security governance
- Named board-level person responsible for service security
- Yes
- Security governance certified
- No
- Security governance approach
- We employ the common security governance principles to control and direct our organisation's approach to security governance.
- Information security policies and processes
- We follow the common information security policies such as: Remote access, Password creation, Password management, Portable media and Acceptable use.
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
-
We use a tool such as VSTS as well as others to track changes related to the product scope (configuration management). We also use version control such as TFS or GIT to derive a baseline and then track subsequent versions. We regularly review change management through our retrospectives tackling our plans, audits, processes and baselines.
Our project manager will raise these tickets and ensure they are properly reviewed. - Vulnerability management type
- Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
- Vulnerability management approach
-
We employ third parties to undergo penetration testing and vulnerability scanning
Firstly we need to know our infrastructure and estate. Therefore a log is kept of all tools, services and technologies - asset management. Then we regularly ensure all patches are deployed and undergo a program of software modernisation and new versioning monthly.
Being a microsoft house we use WSUS software updates.
This is delivered regularly via Tracking, metrics and reporting. - Protective monitoring type
- Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
- Protective monitoring approach
- We use third-party providers such as PAESSLER or built-in tools such as Microsoft SCOM alerts or SPLUNK to monitor unusual activity. Furthermore, the latest anti-virus is installed at all times and our cloud provider - Microsoft Azure or AWS has firewall securities built in.
- 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
-
Users can raise a ticket via email or a web portal on defects or change requests. Defects will be graded with collaboration from the user to P1, P2 or P3. P1 has a 4-hour response, P2 an 8-hour response, and a P3 - 24-hour response.
Reports on no and type of tickets against the time taken/outstanding can be provided by email.
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
- Fighting climate change
-
Fighting climate change
All workers are encouraged to commute by public transport where possible. We have financial incentives for this. We have a car-sharing calculator too so that workers can hook up with others on likely car sharing routes.
We are a paperless office, indeed we do not own a printer. Printing involves a walk to a printing service in the city.
Being a cloud provider allows us to leverage the availability of our tools, technologies, and infrastructure only when needed (eg. office hours and rest of time shutdown). - Covid-19 recovery
-
Covid-19 recovery
We have always advocated remote working. This continues as we recover from COVID-19 and we have no plans to change this.
We find the most ideal situation is a hybrid approach with some day in the office and the rest working remotely. - Tackling economic inequality
-
Tackling economic inequality
From day 1 our company has been about giving new entrants to the technology industry chances perhaps we never got. We are passionate about enthusiastic people joining who may not have the qualifications or experience. - Equal opportunity
-
Equal opportunity
Having worked in the public sector for many years we have been fortunate to have been involved in many seminars and group sessions on equal opportunities. We understand the difficulties that some of our colleagues, suppliers, and customers encounter. We embrace and adopt a themed month where a particular issue or group is highlighted and adopt seminars and group sessions for our business. Additionally, being a flexible and modern business where staff morale and happiness is paramount we are sensitive and understand the different needs of our staff and provide a range of incentives to tackle this. - Wellbeing
-
Wellbeing
Our business has always been about working hard and playing hard. We enjoy regular social events and this is interwoven into our work culture. We love to try new things during our themed months. Additionally, our benefits include well-being incentives.
Pricing
- Price
- £499 to £1,999 a unit a month
- Discount for educational organisations
- Yes
- Free trial available
- Yes
- Description of free trial
- We have demo versions for prospective customers. This includes all stages of data transformations - Data Integration, Data Engines and Business Intelligence.