Butterfly Projects Ltd

Data Transformation

Raw data requires preparation before it can be used to derive valuable, trustworthy insights. "Data lakes” quickly turn into “data swamps”, and transformation skills are key to providing filtered, quality data that can be used for modelling and reporting. Butterfly has expertise preparing structured and unstructured data for exploitation.

Features

  • On-site consultants, with data transformation, quality and migration experience
  • Tailored transformation service which is technology and system agnostic
  • Data architecture modelling, and best practice data management
  • Development of data quality standards and metrics
  • Insights using intuitive visualisation tools, e.g. SAS, Tableau
  • Expertise in Hadoop, SPARK, R, SQL, SAS and Python

Benefits

  • Defined data standards, driving continuous improvement
  • Industry best practice, coding standards, version controls, and documentation
  • Realisation of outcomes from cloud technology investment
  • Competitive advantage through use of innovative emerging technology
  • Reduced data duplication, fewer silos, enhanced matching
  • Consistent, single view of entity data across the organisation

Pricing

£500 to £1,350 a person a day

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 ccs@butterflydata.co.uk. Tell them what format you need. It will help if you say what assistive technology you use.

Framework

G-Cloud 13

Service ID

5 6 7 5 6 9 1 4 8 0 4 0 2 7 0

Contact

Butterfly Projects Ltd CCS Engagement Team
Telephone: 029 212 00140
Email: ccs@butterflydata.co.uk

Planning

Planning service
Yes
How the planning service works
Planning a data transformation project requires detailed understanding of the consumers are their needs. Some data structures optimise for usability, whilst others are more efficient; knowing which to use (in the right scenarios) can ensure the success of a cloud service.
To provide analysts and users with meaningful datasets and reports, requires that data is properly prepared, filtered, and segmented. It is also important that lineage and any transformations are accurately captured for auditability and transparency.
Butterfly’s planning service builds on the trusted CRISP-DM methodology, to provide our clients with practical business analysis and cloud architecture support.
We offer tailorable support to most effectively assist you in planning your project using cloud technologies, including:
1) Defining your objectives, capabilities, and refining your business case;
2) Assessing the challenge, identifying needs, dependencies, and options;
3) Preparing for change, engaging users, and managing stakeholders;
4) Developing effective solutions, proof of concepts, and viable products;
5) Evaluating options for optimal suitability and effectiveness;
6) Deploying change efficiently, migrating data and models;
7) Monitoring results and decommissioning legacy solutions;
We are practiced in Agile project delivery, and recognise the need to balance value and control with flexibility, without compromising on our Service Standards.
Planning service works with specific services
No

Training

Training service provided
Yes
How the training service works
As part of our engagement we always seek to transfer knowledge and experience to our clients’ teams to develop their capability and promoting industry best practices.
We can produce content in a variety of formats (such as courses, videos, or presentations), which can be delivered via one-to-one sessions or workshops on-site, or at suitable venues.
Ultimately, we want to ensure that our clients are able to realise the benefits of their investments. Subsequently, most engagements require some form of coaching or training, such as:
1) Project team training:
We encourage our employees to share their knowledge and experience with other project team members (through peer support and on-the-job mentoring), to ensure best outcomes are achieved.
2) Stakeholder training:
We find it is often necessary to impart some specialist knowledge and skills on our stakeholders, to facilitate better understanding of our services, adopt common terminology and avoid any miscommunication.
3) End-user training:
We have experience developing and delivering bespoke training content to facilitate user adoption of new analytical tools and platforms (such as SAS Viya). We like to trail-blaze new solutions, identifying and ironing out issues, and detailing any configuration requirements or onboarding procedures to enhance the users’ first impressions.
Training is tied to specific services
No

Setup and migration

Setup or migration service available
Yes
How the setup or migration service works
Butterfly’s migration service builds on our extensive experience of migrating sensitive data, models, and processes from legacy systems to cloud platforms, including secure Government data centres using AWS, HPC Wales, and Fujitsu's FAST cloud.
We offer tailorable support to effectively navigate the challenges associated with transitioning services to the cloud and between cloud service providers. We have supported many clients in migrating functionality embedded in inflexible legacy systems to scalable, commodity infrastructure, using cloud-first, open-source (and proprietary) technologies.
Supported by our planning service, we will develop a migration plan which mitigates the risks associated with decoupling legacy systems, and proposes appropriate solutions which help achieve the many benefits of cloud platforms.
We can support migration to providers such as AWS, Azure or Google Cloud, and assist with architecture design, infrastructure, and environmental configuration.
Setup or migration service is for specific cloud services
No

Quality assurance and performance testing

Quality assurance and performance testing service
No

Security testing

Security services
No

Ongoing support

Ongoing support service
Yes
Types of service supported
Buyer hosting or software
How the support service works
Butterfly Data currently has Security Cleared consultants and developers deployed in multiple projects across several Public Sector clients. We can recruit and train to flexibly support and cover specialist data management resource needs, such as:
SAS & Linux Administrators, SAS, R & Python Developers, Data Analysts & Data Scientists, Agile Project Managers, Cloud Solution Architects, Business & Test Analysts.
We can provision support for a range of data management services and ongoing project activities, including:
1) Consultancy:
Feasibility Studies, Business Processing Modelling, Testing Strategy and Execution;
2) Development:
Requirements Specification, Logical Data Modelling, Interface Design, Functional Specification, Bespoke Tools, Prototyping, Code Review;
3) Provisioning:
Cloud Architecture Design, Cloud Infrastructure as a Service, Migration Strategies, Tool Selection, Data & Model Migration;
4) Training:
Training Strategies, Learning Pathways, Training Delivery;

Service scope

Service constraints
At present support is available remotely (via email), or onsite by arrangement.

User support

Email or online ticketing support
Email or online ticketing
Support response times
Standard support is provided remotely (via email) and is available during standard UK working hours (Monday to Friday 0900-1700). By prior arrangement, we can provide support for critical deadlines, system maintenance, or other project activities outside standard working hours remotely, or on site (at extra cost).
User can manage status and priority of support tickets
No
Phone support
No
Web chat support
No
Support levels
We aspire to total customer satisfaction, and therefore, as part of our standard service provision, key stakeholders will receive dedicated support from our ‘Accountable Executive’ and the assigned ‘Project Lead’.
All support emails received during standard working hours will be acknowledged and triaged (or resolved) within 4 working hours.
Complex issues requiring longer than 4 working hours to resolve, will be assigned to the Project Lead who will liaise with stakeholders to classify and prioritise issues as appropriate:
CRITICAL issues, affecting the integrity or availability of the service, are our top priority and will be resolved at the earliest point possible.
MAJOR issues, which mildly affect either the entire user community or affect a few users severely, will be investigated and resolved after any critical issues.
MINOR issues, where few users are substantially affected, will be investigated and resolved after any major issues.
INFORMATION requests (no user or service impacts) will be provided when other issues have been resolved, or priorities allow.
Our triage system is vital to providing immediate support in critical situations, allocating resources efficiently, and answering any queries in a timely manner.

Resellers

Supplier type
Not a reseller

Staff security

Staff security clearance
Conforms to BS7858:2019
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
Yes
Other security certifications
No

Social Value

Fighting climate change

Fighting climate change

Please refer to our Carbon Reduction plan found on our website: https://www.butterflydata.co.uk/carbon-reduction-plan
Tackling economic inequality

Tackling economic inequality

Butterfly Data is a small employee-owned company that does not currently use sub-contractors but we are committed to employing and upskilling a diverse workforce. The company founder & leader is female, 29% of our employees are female & 17% are BAME.
The ongoing growth of the company is leading to job creation across the country. Our 100% virtual configuration allows us great flexibility in recruitment. Butterfly Data are collaborating with a local University providing synthetic projects for students to work on; we take on summer internships, usually resulting in employment.
We have had work placements for veterans through the Amazon Re:Start scheme that have led to permanent positions as well as employment of injured veterans. This enables us to transfer our knowledge base, expertise and upskilling these individuals, addressing key skill gaps.
Butterfly has a Reservists Policy in place which allows an additional extra 10 days paid leave for training. A reservist staff member was mobilised for 6 months during the pandemic. We have been awarded the Gold Employer Recognition Scheme Award for our support to Defence.
In order to support and encourage employment for priority groups, our benefits package and Company Culture policy includes: flexible / part-time working arrangements for all roles from day 1 (25% of staff currently work part-time flexible hours), remote working arrangements for all staff, enhanced maternity pay (full pay for 6 months), private healthcare plan for all staff and their immediate family. We offer consistent remuneration across all (including support) staff, funded training arrangements including pay rises for key skills acquisition.
Equal opportunity

Equal opportunity

Our Company Culture Policy outlines our ethics and values as a whole; in summary: Be respectful. Although opinions may differ, it is important to remain civil and respectful. Work together to foster a productive environment where everyone is allowed to have an opinion without repercussions. Be inclusive. We are welcoming of people from all backgrounds on our team, including members of any race, ethnicity, culture, class, orientation, education, age, size, family status, political or religious beliefs and mental and physical ability. Be considerate. Treat others how you would like to be treated in the workplace. Each person on this team is important and essential, and each person’s decisions and actions affect our outcomes and morale. Be professional. Conducting yourself professionally includes being kind to others. Maintain professional interactions when communicating with others at all times. Be understanding. Our team believes in strength in diversity. Every person has a different perspective and valuable input to offer, whether it’s solving a problem or contributing new ideas. Not understanding someone’s perspective does not mean that their view is incorrect. Remember to keep the focus on creative resolutions and continuous learning. Reliably Different: We work openly with client teams and suppliers, embracing their cultures. We behave professionally and flexibly, raising standards wherever possible. We listen, using feedback to continually deliver a better service. We proactively step outside our prescribed role if it helps to progress things along. We are signed up to the Prompt Payment Code. Making a Difference: We take on projects which serve the best interests of society. We strive to make our industry inclusive, fair and respectful. We are signed up to the 1% Pledge & donate 1% of our profits to Charity. We also have a Modern Slavery & Human Trafficking Statement.
Wellbeing

Wellbeing

Butterfly Data have signed up to the ‘Mental Health at Work Commitment’. This enables us to demonstrate our dedication to employee mental health and wellbeing, we hope to influence other companies in joining us by uploading the MHWC Logo onto our website and social media posts. Our MHWC welcome pack includes the following.
Internal communications templates, including templates for intranet news items, staff emails, a PowerPoint for staff briefings/meetings and guidance for producing blogs. External communications templates, including templates for media releases, recruitment web page copy and guidance for social media posts. This will help greatly towards the implementation of mental health awareness within Butterfly Data.
Alongside the above we have a buddy system in place for new recruits and allocate a career mentor for all staff with monthly 121’s and self-appraisals. Allowing us to motivate and monitor our staff when it comes to staff well-being.

Pricing

Price
£500 to £1,350 a person a day
Discount for educational organisations
No

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 ccs@butterflydata.co.uk. Tell them what format you need. It will help if you say what assistive technology you use.