ANS Group

Power BI Accelerator

ANS' PowerBI Accelerator service delivers an interactive report for customers. Power BI is a set of services that allows users to bring together and share data from sources at scale easily, creating and sharing insights across organisations. This is achieve through analytical reports or dashboards which contain interactive analytic visuals.

Features

• Define UI requirements and business logic definitions.
• Map user stories and roles, defining data sources.
• Establish data connections and relationships.
• Design data models, align to business logic,
• Develop wireframe reports.
• Configure workspace and user roles.
• Develop data model and style report.
• QA and optimisation.
• Publish report to workspace.

Benefits

• Fully functioning interactive Power BI reports.
• Ready for data to be ingested and services.
• Can be for a bespoke assignment or POC.
• Can be adopted at enterprise scale.
• High value, low cost engagement.
• Can be delivered with rapid execution.
• Perfect for hitting tight deadlines.
• Perfect for accelerating your use of data.

£1,250 a unit

• Education pricing available

Service documents

• Pricing document

  PDF

• Skills Framework for the Information Age rate card

  PDF

• Service definition document

  PDF

• Terms and conditions

  PDF

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

Framework

G-Cloud 14

Service ID

294101706863591

Contact

Reece Whittaker
+44 (0) 1612271000
tenders@ansgroup.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: Data Strategy,; Data Analytics Navigator,; Data Platform Check; PowerBI Check.
• Cloud deployment model: Public cloud
• Service constraints: Creation of a single report.
• System requirements:
  • M365 tenant.
  • Cloud based identity provider.
  • Minimum cloud governance.
  • AD authentication.

User support

• Email or online ticketing support: Email or online ticketing
• Support response times: Customers will be able to take advantage of industry leading certified engineers and experts on the end of the phone 24x7x365.The service desk is backed by ITIL aligned process and provides comprehensive Response SLAs from P1 to P5:; ; P1 - 30 Mins ; P2 - 1 Hour ; P3 - 4 Hours ; P4 - 1 Day ; P5 - 2 Days; ; All incidents are recorded in ANS’ Service Desk ITSM system under the Incident Management workflow. ANS records the name of the person reporting the incident, call time and any pertinent information, along with resolution criteria ensuring that the workflow is initiated correctly.
• 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: 24 hours, 7 days a week
• Web chat support: No
• Onsite support: No
• Support levels: All ANS customers have access to ticket and telephone-based support, unless they choose to take an unmanaged service. Customers have access to a named Account Manager who takes overall responsibility for the customer's commercial, technical and support relationship with ANS. Customers are assigned a support "pod" based on the type of solution they have with ANS. This ensures customers will always be supported by the same core team of support engineers who are technical experts in their particular solution. Enterprise and public sector customers also have access to a named Customer Success Manager in addition to their Account Manager.; ; Standard support is provided 08:00 to 18:00 Monday to Friday and includes 1st line (User support) through to system management, monitoring and administration. Additional support is available to extend the service support to 24/7 at additional cost.
• Support available to third parties: No

Onboarding and offboarding

• Getting started: At ANS, we believe that helping our clients prepare for, implement and manage organisational change is paramount if they are to achieve long-term success. ANS are highly focussed on helping customers to achieve full user adoption and our implementation methodology has been proven to create an environment that makes success much more likely by focussing on ongoing knowledge transfer and training.
• Service documentation: Yes
• Documentation formats:
  • PDF
  • Other
• Other documentation formats: MS Word
• End-of-contract data extraction: All data delivered vai the platform is held within the customers' own Azure tenant. With regards to any Managed Service that might also be taken alongside this services, ANS will need to assess what steps need to be followed to ensure data is extracted efficiently.
• End-of-contract process: This scenario will need to be discussed on a case by case basis. Access to the support service will end when the contract does.

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: Power BI Mobile apps provide mobile access to Power BI for various devices like smartphones and tablets, including iOS, Android, and Windows, with an Apple Watch version available. They facilitate data connection, viewing reports, extracting insights, remote collaboration, and receiving change notifications. However, they lack report creation and editing functionalities, necessitating the use of Power BI Desktop or Service for these tasks. Like Power BI Service, they offer easy navigation through workspaces, reports, and dashboards via tabs, enabling interaction with visuals and data filtering on the go.
• Service interface: Yes
• User support accessibility: None or don’t know
• Description of service interface: The Power BI Service interface is a cloud-based platform for creating, sharing, and analysing data visualisations. It provides tools for building interactive reports and dashboards, accessing data from various sources, and collaborating with team members. With its user-friendly interface and robust features, users can easily create and share insights, enabling data-driven decision-making across organisations.
• Accessibility standards: WCAG 2.1 AA or EN 301 549
• Accessibility testing: Via a web browser and URL.
• API: Yes
• What users can and can't do using the API: Microsoft Azure APIs offer a diverse array of capabilities catering to cloud computing needs. They empower developers with services for AI, machine learning, data analytics, storage, networking, and more. These APIs enable seamless integration and automation, facilitating scalable solutions across various industries.; ; Azure Management APIs provide robust control over Azure resources, streamlining management tasks. Additionally, Azure's vast ecosystem ensures support for diverse programming languages and frameworks, fostering innovation and agility in application development and deployment, all underpinned by Microsoft's commitment to security and reliability.
• API documentation: Yes
• API documentation formats: HTML
• API sandbox or test environment: No
• Customisation available: Yes
• Description of customisation: Microsoft services can be fully configured to suit the customer's specific requirements. As part of our implementation process, ANS can teach your core team how to manage and configure the solution moving forward.

Scaling

• Independence of resources: All services are hosted by Microsoft. This service includes platform monitoring allowing you to see in real-time if there are any performance issues.

Analytics

• Service usage metrics: Yes
• Metrics types: Bespoke to customer requirements.
• Reporting types:
  • API access
  • Real-time dashboards
  • Regular reports
  • Reports on request

Resellers

• Supplier type: Reseller providing extra features and support
• Organisation whose services are being resold: Microsoft Azure & Power BI.

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
• 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
  • Physical access control, complying with SSAE-16 / ISAE 3402
  • Physical access control, complying with another standard
  • 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: Exporting is aligned to the services able to export.
• Data export formats:
  • CSV
  • ODF
• Data import formats:
  • CSV
  • ODF

Data-in-transit protection

• Data protection between buyer and supplier networks:
  • Private network or public sector network
  • TLS (version 1.2 or above)
  • IPsec or TLS VPN gateway
  • Other
• Other protection between networks: ANS architects its solutions to industry baselines such as the CAF, WAF, Secure By Design. All access into customer solutions is conducted via ANS devices which are protected and monitored by our SOC and have full XDR. During design phase and architecture, firewall designs ensure that only required ACLs are in place to restrict network connectivity and segmentation.
• Data protection within supplier network:
  • TLS (version 1.2 or above)
  • IPsec or TLS VPN gateway
  • Legacy SSL and TLS (under version 1.2)

Availability and resilience

• Guaranteed availability: Microsoft maintain service availability. The admin portal allows you to see any potential downtime or issues that may have caused the system issues for any given reason.
• Approach to resilience: Multiple data centres around the world.; Multiple data centres within each Azure region creating local availability zones.
• Outage reporting: Microsoft gives you access to the admin portal where users can monitor the availability of applications in real-time.

Identity and authentication

• User authentication needed: Yes
• User authentication:
  • 2-factor authentication
  • Username or password
  • Other
• Other user authentication: Azure based authentication and authorisation.
• Access restrictions in management interfaces and support channels: Azure AD governance portal: Management groups, RBAC etc. using Entra ID
• Access restriction testing frequency: At least every 6 months
• Management access authentication:
  • 2-factor authentication
  • Username or password
  • Other
• Description of management access authentication: Azure based authentication and authorisation

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: LRQA
• ISO/IEC 27001 accreditation date: 18/08/2023
• What the ISO/IEC 27001 doesn’t cover: N/A
• ISO 28000:2007 certification: No
• CSA STAR certification: No
• PCI certification: Yes
• Who accredited the PCI DSS certification: Blackfoot UK Limited
• PCI DSS accreditation date: 10/08/2023
• What the PCI DSS doesn’t cover: N/A
• Cyber essentials: Yes
• Cyber essentials plus: Yes
• Other security certifications: Yes
• Any other security certifications:
  • ISO27017.
  • ISO27018.
  • NCSC Certified.
  • SOC 2 Type 2 Report.

Security governance

• Named board-level person responsible for service security: Yes
• Security governance certified: Yes
• Security governance standards:
  • ISO/IEC 27001
  • Other
• Other security governance standards: ISO27017, 27018, NIS CAF, PCI DSS Level 1 SP, HSCN, PSN, PASF
• Information security policies and processes: ANS have a fully documented ISMS in line with ISO 27001 with policies covering all elements of the control set listed within our SoA. All published on our internal intranet which is updated regularly with ongoing training conducted to ensure user awareness of all policy and procedure. notifications are sent when any changes are made to policy and procedure.

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: Internal ANS Change is managed through the application of standard project management process with all projects progressing through approval, CAB review and sign off by stage. All ANS Business Change includes the following managed stages (whether these are deployed on a formal or informal basis is determined by the size of the project, by cost, resource application and risk):; ; • Executive or Higher Management sponsor; • Business Case and Success Criteria; • Scope definition; • Documentation; • Risk & Opportunity assessment; • Milestone or stage review; • Stage sign off; • Final Review; • Testing; • Deployment; • Lessons Learned
• Vulnerability management type: Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
• Vulnerability management approach: ANS has a vulnerability management process which is certified against all of our security certifications. Vulnerability management is conducted at host level for internal scans, as well as external scans being ran against all public facing services. ANS uses EASM across its whole business estate, includes threat intelligence notifications against breaches relevant to technologies ANS uses, relevant APTS, dark web monitoring and VIP monitoring. ANS patches inline with industry standards, where all CVEs are risk assessed in their relevance and potential impact to the affected assets. For critical and high vulnerabilities, that risk to ANS assets, patching is conducted immediately.
• Protective monitoring type: Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
• Protective monitoring approach: ANS has implemented an Information Security Management System (ISMS) that has been verified by our external accreditor to be compliant with the international standard for Information Security Management, ISO/IEC 27001. This system is supported by the ISMS manual, detailed policies and procedures, and underpinned by the pragmatic application of industry best practice. The ISMS defines ANS’ approach to its key protective security functions, corresponding in turn to the requirement of the standard (ISO/IEC 27001:2013).; ; We use the ISMS to develop a Protective Security environment, focusing on the Physical, Personnel and Information assets.
• 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: ANS has developed and documented pre-defined processes for common events that may affect the confidentiality, integrity, or availability of its information assets. These are based on best practices and guidelines from ISO 27001.; Examples includes:; • malware infection; • denial-of-service attack; • unauthorized access; • data breach; • data loss; ; For each event, ANS has defined:; ; • the roles and responsibilities of the incident response team; • the incident classification and escalation criteria; • the incident response procedures and steps; • the incident communication and notification channels; • the incident recovery and closure actions

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: Yes
• Connected networks:
  • Public Services Network (PSN)
  • Police National Network (PNN)
  • NHS Network (N3)
  • Joint Academic Network (JANET)
  • Scottish Wide Area Network (SWAN)
  • Health and Social Care Network (HSCN)

Social Value

• Social Value:

  Social Value

  • Fighting climate change
  • Covid-19 recovery
  • Tackling economic inequality
  • Equal opportunity
  • Wellbeing

  Fighting climate change

  We are a company built on our culture and values, with a strong committing to protecting the world and demonstrating our social responsibility. ANS are PAS2060 Carbon Neutral Certified and compliant for a number of years and are aiming to be net zero by 2050. Furthermore, we have and extensive variety of processes and procedures in place to support our commitment, which include: ; • Recycled 10 Tonnes of old servers with all profits going to charity. ; • Relocated data centre cooling equipment in 2022 to reduce the solar gains and save energy. ; • Removed old, inefficient computers so all staff PCs are now modern efficient laptops. ; • Recycle 100% of our WEEE waste using appropriate 3rd party providers.; • PAS2060 certified and compliant. We appointed Carbon Footprint Ltd, a leading carbon and energy management company, to independently assess our Greenhouse Gas (GHG) emissions in accordance with the UK Government’s ‘Environmental Reporting Guidelines: Including Streamlined Energy and Carbon Reporting Guidance’.; • In 2023 we offset 1265 tons of Carbon Dioxide by supporting numerous projects. ; • Cycle to Work scheme available to all employees including great bike sorage facilities on site.; • Introduced a salary-sacrifice electric car scheme.; In addition to the above, we believe environmental awareness is something which needs to be considered further, at home and at work. We provide environmental internal training and communication, which includes:; • Environmental Aspects and Impacts ; • Employees’ responsibilities ; • Environmental Policy ; • Waste Disposal ; • Travel and Transport ; • How ANS helps employees reduce their carbon footprint ; • CSR; • Our Certification

  Covid-19 recovery

  ANS is a proud Manchester based organisation and supports the local community, businesses and charity’s which has helped in the recovery from COVID-19. ANS continued to operate throughout Covid, with measures in place and allowing for remote working.; Creating Employment for those affected by COVID; ANS worked on numerous projects in the lockdowns to assist frontline organisations. One example was a council, to quickly and easily coordinate requests for support and volunteering in the community in response to the Covid.; Furthermore, ANS worked alongside universities to enable students to resume studying, in addition to working with NHS Trust to assist with the tracking and coordination of the Royal Free Hospital’s 15,000 staff during the pandemic.; This meant ANS was able to recruit and provide opportunities.; Support organisations to recover and a new way of working; ANS worked with a council to build a mobile-friendly application using the Microsoft Power Platform which works by pulling together data on individuals who are considered to be vulnerable, from a range of sources and formats, along with a request service.; Furthermore, ANS worked with a university to enable remote working for students.; A council worked with ANS to launch a complex case management system for coronavirus contact tracing which helped contain and manage Covid-19 outbreaks across their population of over 300,000 residents.; ANS had controls in place which included social distancing, we also operated a remote service where this was possible alongside ensuring measures were in place for those unable to work from home, including:; Social Distancing; Covid testing; Workspaces sanitised daily; Adequate ventilation is the building; ANS have numerous flexible working policies in place, including remote and hybrid working which has allowed a large majority of the company to remain working from home post-Covid, however, some roles do require being in the facility.

  Tackling economic inequality

  ANS has a strong commitment to tackling economic inequality, and this is demonstrated through our employees and companies we work alongside.; Our people; ANS have continued to grow as a business and are now a team of over 700 employees.; ANS take Continual Professional Development (CPD) seriously, from skills development to apprenticeships. ANS are committed to giving every employee 12 days per year to devote to professional self-development or business innovation.; ANS have a strong commitment to apprenticeships and have the ANS Academy. Upskilling the local workforce, we invest heavily into our junior staff giving them the best development opportunities. The ANS Academy provides industry-leading training and hands-on experience for the next generation of passionate tech leaders. We were recently rated ‘Outstanding’ by Ofsted.; We engage with schools and colleges based in Manchester, ANS has direct access to the rich and diverse mix of cultures. This ensures that all groups have access to the information on our apprenticeships. In 2022, this resulted in 45% of Apprentices hired identifying as BAME.; We partner with 2 girls’ schools in our community by running immersive days at our office where groups of students can speak with women from at ANS.; Fostering an inclusive workspace, our diversity groups represent various communities, including LGBTQ+, BAME, disability groups and gender.; Increase supply chain resilience and capacity; We also take into consideration the standards and qualification level of those in the supply chain that we choose to work with and/or recommend. At a practical level, we maintain relationships with local businesses, we value our position as a key contributor to the ‘Northern Powerhouse’. For our own on-site operation, we have contracted with many SMEs and VCSEs.; Demonstrating the value of these partnerships, advantages include:; Fewer overheads; Local employment growth opportunities; Innovation; Reduced carbon footprint; Less bureaucracy

  Equal opportunity

  ANS are proud to be a Disability Confident Employer. The scheme, set up by the Department for Work and Pensions, is designed to help employers recruit and retain disabled people and people with health conditions for their skills and talent. As a Disability Confident committed employer, ANS is providing inclusive and flexible recruitment processes such as offering video interviews and supporting flexible working patterns where possible. We also ensure our workplace is suitable to support any employee that may have a disability.; ; ANS recognises equity and fairness throughout the business and that discrimination in any form is unacceptable. Equal opportunities has long been a feature of our employment practices and procedure, that’s why we have an equal opportunities policy in place. Breaches of the policy will lead to disciplinary proceedings and, if appropriate, disciplinary action.; ; The aim of the policy is to ensure no job applicant, employee or worker is discriminated against. We ensure the policy is circulated to any agencies responsible for our recruitment and a copy of the policy will be made available for all employees and made known to all applicants for employment.; ; ANS have a strong commitment to equality in the workplace. We have a full modern slavery policy, but in addition to policies, we have internal iniatives in place to tackle workplace inequality such as having internal EDI groups:; ; • Women in ANS; • Diversity and Beyond (DAB); • The Rainbow Alliance; • The Association for Better Living and Education (ABLE) Group; • ANS Squirrel Club (Neurodiversity); • Parents in ANS; • Let’s Talk About Mental Health; ; ANS also has a strong commitment to equality in the workforce through being a living wage employer, alongside a disability confident employer.

  Wellbeing

  ANS is committed to the wellbeing of our employees and this extends to the wider community, we are strongly committed to the wellbeing of our teams, and provide numerous benefits to help with physical and mental health, which include but are not limited to:; ; • An extra day’s holiday on birthdays and an extra 5 days for tying the knot ; • ‘Celebration Day’ - staff can use for any occasion that is meaningful to them; • Hybrid, flexible and remote working ; • Free onsite gym ; • Private healthcare ; ; Furthermore, we emphasise the importance of mental wellbeing. Internally, we obtained a group of volunteers so that we could provide training to become Mental Health First Aiders (MHFA), accredited by MHFA England. They provide online drop-in and in-person sessions, which is accessible for both staff who work in our office and those who work remotely. The sessions continue to support our employees with their personal issues. In addition to health benefits, ANS are committed to ensuring our employees are able to develop in their careers, and therefore, we provide numerous measures, which include but are not limited to 12 development days per year. These days can be used for courses, examinations, partner training and many other reasons. Additionally, we provide regular PDR’s which enable ANS employees to reflect and set future goals on their career. ; ; ANS have a strong commitment to the local community, this is demonstrated through our community outreach in recruitment for the academy alongside our local community when selecting local suppliers. ANS look to use local suppliers where this is possible, and is demonstrated through the selection of local food vendors for our events, local event management specialists, our active support to local charities, such as the Manchester Youth Zone and using local waste service companies.

Pricing

• Price: £1,250 a unit
• Discount for educational organisations: Yes
• Free trial available: No

Service documents

• Pricing document

  PDF

• Skills Framework for the Information Age rate card

  PDF

• Service definition document

  PDF

• Terms and conditions

  PDF

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