MHR

Microsoft Power BI Consultancy and Training

MHRAnalytics offer services centred around the market-leading Microsoft PowerBI and associated products in the Microsoft Power Stack, namely Power Query, Power Automate and Power Apps. These services extend from getting a client up to speed with products, specific dashboard and analytics deliverables and wider data projects specifically around data warehousing.

Features

• Review of current requirements and business problems.
• Workshops to discuss dashboard, visualisation and reporting requirements.
• Creation of content be this reports, dashboards or visualisations.
• Connectivity to wide range of data sources in a business.
• Assistance with automation and administration.
• Setup connectivity to on-premise data sources.
• Set-up of live connectivity, automatic/scheduled data refreshes, incremental refresh.
• Helping the customer use product features to their advantage
• User training sessions and skills transfer.
• Transition from reporting strategy to full cloud data strategy.

Benefits

• Enabling rapid adoption and exploitation of the software.
• Rapid delivery and best practice builds of reports, visualisations, dashboards.
• Ability to start on the ‘right foot’ with expert help.
• Correct implementation of administration and automation.
• Faster and easier access to business data.
• Trusted support and advice from experts.

£950 a unit a day

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 G-cloud@mhr.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

417988125372957

Contact

Mary Watkinson
0115 945 6000
G-cloud@mhr.co.uk

Planning

• Planning service: Yes
• How the planning service works: MHR Analytics consultancy services endeavour to implement the right solutions with proper planning and strategic implementation. This starts from engagement with high level strategic consultancy to define and understand the business problems. These problems are then addressed with the solution, through to a planned implementation of the software in an agile customer involved manner. The planning process takes into account stakeholder management, thorough UAT and handover, all important facets of a successful BI solution.
• Planning service works with specific services: Yes
• Hosting or software services the planning service works with:
  • MS Power BI
  • MS Azure Services (where appropriate)

Training

• Training service provided: Yes
• How the training service works: MHR’s Analytics Microsoft Accredited Training Team provide a number of courses including 1 day introduction to Power BI, for new users, this covers key BI topics as follows: Discuss/provide an overview of Business Analytics; Overview of BI, covering user Portal, Visualisations, Dashboards and explains differences between Power BI Desktop & Web Service; Introduction to Reporting interface and overview of workshops; Creation of basic reports and discussing various methods that can be used; Publishing reports/visualisations to the Web Server; Introduction to Data Sources & Creation of an App Workspace; Importing Excel data onto Power BI Server, extracting data for local reports, discussions/demonstrations regarding loading data from a SQL server database; Differences between DirectQuery and Importing Data; How to refresh data; Creating visualisations, filtering/formatting data; Using analytics and Fields panel/pane. Become familiar with aggregation methods; Utilising the Play axis and tooltips facilities; Working with maps; Creating Hierarchies/Drill-Through’s, adding tabs to your report; Creating Dashboards and familiarity with the interface; Discussions and overview/introduction to more complex tools within the reporting interface, e.g. DAX and basic formulas. Editing your query/creating groups. Introductions to joins/relationships; Using quick measures to create calculations, also offer an Advanced Power Bi course and an Introduction to the Power Platform.
• Training is tied to specific services: Yes
• Services the training service works with: Microsoft Power BI

Setup and migration

• Setup or migration service available: No

Quality assurance and performance testing

• Quality assurance and performance testing service: Yes
• How the quality assurance and performance testing works: Thorough QA is vital to the delivery of a Business Intelligence solution, with most deployments this takes place in 3 phases during each agile sprint. ; ; 1. Unit testing, whereby a deliverable is tested by the developer continuously while it is being built. Often during unit testing performance of the solution will also be tested at the unit or component level. ; ; 2. Each agile sprint will have a UAT component whereby a deliverable will be made available to the end users. This testing phase is vital as it provides valuable feedback during the development process and provides a feedback loop for further sprints. ; ; 3. Post release performance testing. Performance issues with BI solutions often happen when they are using production levels of data, or are scaled across larger user bases. To identify problems at this stage performance testing is done to make sure the solution meets the user requirements in terms of response times.

Security testing

• Security services: No

Ongoing support

• Ongoing support service: No

Service scope

• Service constraints: The service is consultancy based only, and as such, isn't constrained. Services can be delivered at the clients discretion and therefore can be on or off-site or a blend of both depending on the project needs.

User support

• Email or online ticketing support: Email or online ticketing
• Support response times: 9 to 5 (UK time), Monday to Friday; MHR Respond to questions based on severity, Level 1 first response in 1 hour, response frequency will be 4 hours and it will be escalated in 2 days. Level 2 first response in 4 hours, response frequency will be 2 days and it will be escalated in 10 days. Level 3 fist response in 8 working hours, response frequency will be 4 days and it will be escalated in 30 days. Level 4 first response will be in 16 working hours, response frequency will be 8 days and escalated as agreed/required.
• 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: No
• Support levels: MHR Respond to questions based on severity, Level 1 first response will be in 1 hour, response frequency will be 4 hours and it will be escalated in 2 days. Level 2 first response will be in 4 hours, response frequency will be 2 days and it will be escalated in 10 days. Level 3 fist response will be in 8 working hours, response frequency will be 4 days and it will be escalated in 30 days. Level 4 first response will be in 16 working hours, response frequency will be 8 days and it will be escalated as agreed/required.

Resellers

• Supplier type: Not a reseller

Staff security

• Staff security clearance: Conforms to BS7858:2019
• Government security clearance: Up to Security Clearance (SC)

Standards and certifications

• ISO/IEC 27001 certification: Yes
• Who accredited the ISO/IEC 27001: Lloyd's Register Quality Assurance Limited
• ISO/IEC 27001 accreditation date: 25/06/2020
• What the ISO/IEC 27001 doesn’t cover: N/A.
• ISO 28000:2007 certification: No
• CSA STAR certification: No
• PCI certification: No
• Cyber essentials: No
• Cyber essentials plus: Yes
• Other security certifications: Yes
• Any other security certifications: SOC2

Social Value

• Social Value:

  Social Value

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

  Fighting climate change

  MHR know the impact our business has on the planet, and we’re committed to the actions we need to take to reduce our carbon footprint. https://mhrglobal.com/uk/en/about-us/sustainability. We have implemented an Environmental policy agreeing to:; • Become carbon neutral by 2028 scope 1/2 operations. ; • Reach net zero by 2050. ; • Encourage net-zero practices with suppliers. ; We’re striving to exceed energy standards having installed 400 solar panels. Double thermal insulation in roofing areas/external walls, triple glazed windows, LED lighting with occupancy sensors, centrally controlled heating/cooling systems. Our electricity is 100% REGO backed renewable sources we have reduced our carbon emissions by 38.4% in 2023. All servers in our data centres on a 5-year refresh programme, ensuring the latest technologies are used. Server virtualisation is used replacing physical servers, and run at 65/75% capacity, reducing under-utilisation. Additional measures in our data centres include: ; • Upgraded disaster recovery data centre to free air cooling, reducing energy consumption by £30,000 per annum. ; • Using disaster recovery hardware for test/development infrastructure, ensuring full utilisation of all hardware rather than systems sitting idle. ; • Use of metered power supplies throughout our data centres ; • Growing usage of cloud services ; We recycle 98% of waste and are eliminating single use plastic providing reusable BPA free water bottles, and biodegradable Vegware disposable cups/cutlery/food packaging. We introduced PlanetMark this year which will provide us with independent verified assurance of our carbon footprint including Scope 1, 2, and 3 emissions. MHR is working towards ISO14001 (May 2024).; MHR believe that high overall levels of employee education/interaction and facilitate an employee Sustainability Social Group. The group is an open forum for everyone to share/discuss our Sustainability Strategy including graphical data updates on progress. MHR environmentally screen new/existing suppliers allowing us to monitor direct/indirect emissions of suppliers, encouraging a sustainable supply chain.

  Covid-19 recovery

  Through our software and services, we have been able to support our customers (and their local communities) to adapt to the new ways of working imposed by COVID-19. The web-based nature of our solutions meant customers could still access the software remotely to pay employees accurately and on-time, and employees could be engaged through system communications.; Our product design team responded promptly, releasing functionality to assist customers with calculating and reclaiming payments under the Coronavirus Job Retention Scheme. All developments were completed and delivered at no charge to customers.; We also offered free-of-charge online advice and guidance sessions on key topics such as:; • the remote mobilisation of workforces; • changing government legislation; • furlough and holiday leave extension; Our Managed Payroll Service continued to operate as normal, delivering payrolls with normal high levels of accuracy, and emergency payroll services to support customers who needed it. ; All implementations were, and continue to be, conducted remotely, ensuring the safety of both our clients and our employees, and that crucial HR and payroll operations continued and employees were paid on-time. We have multiple technologies to support this including Microsoft Teams, Skype and WebEx, to ensure we can continue all communications with no delay to the project.; Internally at MHR, we operated as BAU, with no employees placed on the furlough scheme and instead creating new employment opportunities for our local community. ; We take the physical and mental wellbeing of our employees very seriously and implemented several initiatives and procedures to ensure they remained comfortable and happy during this challenging time. (E.g. MHR employees have access to 7 trained Mental Health First Aiders, an Employee Assistance Programme and the Smart Health GP App. We also kept in regular contact with our employees through our HR dashboard, promoting virtual baking clubs, competitions etc.)

  Tackling economic inequality

  MHR provides roles for over 850 people, hiring local talent and raising awareness of employment opportunities; we are constantly injecting income and support back into our local community. We work with local business, using local tradespeople/craftspeople for our building/restoration work of Ruddington Hall. MHR ensure that at least 60% of the suppliers we use are sourced within a 30-mile radius, creating a positive economic impact. ; Improving Lives is a registered charity, working with people with complex health/social needs. Our internal training team have completed several sessions with the volunteers, providing training on Microsoft Word, Excel and PowerPoint, designed to help the volunteers run internal workshops for service users, helping them apply for jobs, create budgets, CVs and presentations. Last year MHR dedicated over 67 hours on regional school visits, offering 31 work experience placements to pupils. We support Founders 4 Schools facilitating inspirational talks for young people, from less advantaged backgrounds, working with schools around STEM skills promoting careers paths within tech industries/emerging trends. ; MHR has a culture of employee development with a suite of over 200 free personal/professional development courses accessible to all staff. Over the past 5 years, 50 employees have completed their CIPP and CIPD qualifications, several employees have completed their CIM qualifications, Prince 2, ACCA, CIMA and Mental Health First Aid. ; MHR future-proof products/services through re-investing 22+% of annual revenue into research/development. iTrent’s cloud-based products/software are highly scalable with the ability to handle increased workloads, add/remove users with minimal cost/impact. Customers can streamline processes using workflow/employee and manager self-service. MHR’s managed service centre use state-of-the-art payroll automation, reducing manual processing time/eliminating human error, negating paper usage. Our professional services team operate a 100% remote delivery, reducing downtime/travel costs whilst maintaining the same level of service/communication (see case study at https://mhrglobal.com/sites/default/files/2021-03/Cherwell_Case_Study.pdf).

  Equal opportunity

  MHR ensures that its most important resource, its employees, are treated fairly and that diversity of employees' backgrounds and other characteristics are used to the advantage of the individual and the business. We do not treat applicants unfavourably based on their Protected Characteristics, ensuring that there are equal opportunities at all stages of the recruitment/promotion processes. We believe that an individual’s disability, ethnicity, sexual orientation, and gender identity should not affect whether they get a job, benefit from training, or get promoted. MHR believes that all employees should receive equal pay for the same or broadly similar work, https://www.mhr.co.uk/gpg-report/; At MHR we champion diversity and inclusion, making sure that everyone in the company feels welcome and at home. All staff participate in mandatory equality, diversity and inclusion training sessions including accessible e-learning material via our Learning Management System. Participation is monitored and recorded through our HR department with reminders sent to those who have not enrolled. MHR strive to bring everyone together and celebrate each other’s individuality through our staff community pages on our internal social feed. We have celebrated International Women’s Day with a breakfast event for all, including a chance for all staff to identify their inspirational women https://mhrglobal.com/uk/en/blog/mhrcelebrates-international-womens-day-2023?term=international+women%27s+day We utilise our employee platform to encourage all staff to celebrate their cultures and way of life and several staff have set up groups and events to celebrate this across the business.; We perform a regular audit of supplier’s policies/websites to monitor the risk of modern slavery. We strive to work with our partners to raise standards so that their employees are paid a living wage and are not subject to forced, compulsory, trafficked or child labour. Our Chief Officers have responsibility to ensure that organisations demonstrate these qualities. Our statement can be found on the website at https://mhrglobal.com/uk/en/modern-slavery-statement

  Wellbeing

  We recognise the importance of supporting the physical and mental wellbeing of our people. We have implemented several measures that supports and promotes employee wellbeing with visible, long-term commitments to mental/physical health including: ; • Supportive workplace where employees understand and can discuss mental health and wellbeing through our mental health first aid team, mentoring programme, and dedicated wellbeing platform on our employee community page. ; • Support for employees to manage their own mental health and wellbeing, encouraging them to achieve their wellbeing goals utilising our employee assistance programme or taking advantage of discounted healthcare options and gym memberships. ; • Home Working and Digital Solutions–using Online Communication, Webinars and Video Conferencing enabling a work-life balance for employees, contributing to clean air and reduction in carbon emissions in the community. ; • Our Smart GP offers employees unlimited access to a Virtual GP as well as health and wellbeing experts for employees enabling them to receive an immediate response. ; • Employees can access confidential support with mental, financial, physical, and emotional well-being though our LifeWorks programme. Supporting employees with questions about handling stress, parenting, and childcare, managing money, or health issues. ; • Actively contribute to raising awareness/understanding of health and wellbeing. With several initiatives throughout the year and regular mental health awareness workshops with our internal training team. ; • MHR support the nutritional/dietary needs of employees serving, gluten free, vegan, vegetarian, and healthy eating options within our subsidised restaurants. ; • Provide employees with the tools and knowledge to build and support each other in building personal resilience. ; • Our charitable work, in conjunction with employees, supporting local and national causes through volunteering hours to pick litter, create peace gardens for a hospice, running marathons, delivering training sessions for unemployed/disengaged young people, provides huge impact for our employees and community physically and mentally.

Pricing

• Price: £950 a unit a day
• Discount for educational organisations: 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 G-cloud@mhr.co.uk. Tell them what format you need. It will help if you say what assistive technology you use.