Trustmarque Solutions Limited

TRUSTMARQUE MICROSOFT POWER BI

Power BI is a suite of business analytics tools and services that enables anyone to connect to, visualize, and analyse data with greater speed, efficiency, and understanding. It connects users to a broad range of data through easy-to-use reports/dashboards. Makes your data work for you. Trustmarque's a Microsoft Gold Partner.

Features

  • Business intelligence (BI) and Management Information (MI)
  • Share interactive reports published to the web
  • Interactive dashboards
  • Data model publication with a data catalog
  • Mobile apps for iOS, Windows and Android
  • Natural Language exploration
  • Curate CRM Dynamics, Salesforce and Google Analytics
  • Auto refresh capability
  • Governance, compliance and Security
  • Microsoft Gold Partner

Benefits

  • Monitor your important data using a live dashboard
  • Create stunning interactive reports
  • Access data with native mobile apps for iOS, Windows, Android
  • Analyse data and share insights
  • Get answers quickly with rich dashboards on every device
  • Share personal dashboards and reports in seconds with other users
  • Build robust, reusable data models provides report consistency
  • Import data and reports
  • Alerts, Subscriptions and Automation
  • Self service analytics with security and governance and compliance wrapper

Pricing

£6.00 to £8.00 a user a month

  • Education pricing available
  • Free trial available

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

Framework

G-Cloud 13

Service ID

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

Contact

Trustmarque Solutions Limited Darren Moyes
Telephone: 01904 934435
Email: tenders@trustmarque.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
We can extend the functionality of Power Bi with custom data connectors and visualisations as well as embedded Power Bi solutions for custom portals, web pages or your own software.
Cloud deployment model
  • Public cloud
  • Private cloud
  • Community cloud
  • Hybrid cloud
Service constraints
Our Service Descriptions are available at https://technet.microsoft.com/en-us/library/office-365-service-descriptions.aspx and https://docs.microsoft.com/en-gb/microsoft-365/enterprise/services-overview
System requirements
See https://products.office.com/en-GB/office-system-requirements

User support

Email or online ticketing support
Email or online ticketing
Support response times
Subject to an agreed SLA.
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
Web chat
Web chat support availability
24 hours, 7 days a week
Web chat support accessibility standard
WCAG 2.1 AA or EN 301 549
Web chat accessibility testing
None
Onsite support
Yes, at extra cost
Support levels
Premier Support is available at further cost. https://www.microsoft.com/en-us/microsoftservices/support.aspx
Support available to third parties
No

Onboarding and offboarding

Getting started
The FastTrack service from Microsoft includes scenarios which help users adopt new, more productive ways of working. See http://fasttrack.microsoft.com/
Service documentation
Yes
Documentation formats
HTML
End-of-contract data extraction
Please see https://products.office.com/en-us/business/office-365-online-data-portability
End-of-contract process
Upon expiration or termination of your subscription or contract, Microsoft will provide you, by default, additional limited access for 90 days to export your data. As part of our Online Service Terms we specify that the customer always own its date. Microsoft acts as Data Processor. For more see http://www.microsoftvolumelicensing.com/Downloader.aspx?DocumentId=13655 and http://trustoffice365.com/

Using the service

Web browser interface
Yes
Supported browsers
  • Internet Explorer 11
  • Microsoft Edge
  • Firefox
  • Chrome
  • Safari
Application to install
Yes
Compatible operating systems
  • Android
  • IOS
  • Linux or Unix
  • MacOS
  • Windows
  • Windows Phone
Designed for use on mobile devices
Yes
Differences between the mobile and desktop service
The service is optimised for mobile, desktop and tablet use and there are differences. Core functionality is available across all platforms. See https://support.office.com/en-us/article/Office-Online-browser-support-AD1303E0-A318-47AA-B409-D3A5EB44E452
Service interface
No
User support accessibility
WCAG 2.1 AA or EN 301 549
API
Yes
What users can and can't do using the API
The full API details are avilable online at dev.office.com
API documentation
Yes
API documentation formats
HTML
API sandbox or test environment
Yes
Customisation available
Yes
Description of customisation
Please see https://technet.microsoft.com/en-us/office/dn788774.aspx

Scaling

Independence of resources
Please see http://www.microsoft.com/en-us/download/details.aspx?id=54249

Analytics

Service usage metrics
Yes
Metrics types
Please see the Business admins section found here https://support.office.com/en-gb
Reporting types
  • API access
  • Real-time dashboards

Resellers

Supplier type
Reseller providing extra support
Organisation whose services are being resold
Microsoft

Staff security

Staff security clearance
Other security clearance
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)
  • Other locations
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 Tigerscheme qualified provider or a CREST-approved service provider
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
  • Other
Other data at rest protection approach
For data at rest, Microsoft deploys BitLocker with AES 256-bit encryption on servers that hold all messaging data, including email and IM conversations, as well as content stored in SharePoint Online and OneDrive for Business. BitLocker volume encryption addresses the threats of data theft or exposure from lost, stolen, or inappropriately decommissioned computers and disks. Your organization’s files are distributed across multiple Azure Storage containers, each with separate credentials, rather than storing them in a single database.
Data sanitisation process
Yes
Data sanitisation type
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
Please see https://products.office.com/en-us/business/office-365-online-data-portability
Data export formats
  • CSV
  • ODF
  • Other
Other data export formats
See https://products.office.com/en-us/business/office-365-online-data-portability
Data import formats
  • CSV
  • ODF
  • Other
Other data import formats
  • Please see http://fasttrack.microsoft.com/office/onboard/50
  • https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

Data-in-transit protection

Data protection between buyer and supplier networks
  • TLS (version 1.2 or above)
  • Legacy SSL and TLS (under version 1.2)
  • Other
Other protection between networks
For data in transit, all customer-facing servers negotiate a secure session by using TLS/SSL with client machines to secure the customer data. This applies to protocols on any device used by clients, such as Skype for Business Online, Outlook, and Outlook on the web. See also http://aka.ms/Office365CE
Data protection within supplier network
  • TLS (version 1.2 or above)
  • IPsec or TLS VPN gateway
  • Other
Other protection within supplier network
Please see http://aka.ms/Office365TI and http://aka.ms/Office365CE

Availability and resilience

Guaranteed availability
http://www.microsoftvolumelicensing.com/Downloader.aspx?DocumentId=13655
Approach to resilience
Please see http://aka.ms/Office365DR
Outage reporting
Via the service status portal

Identity and authentication

User authentication needed
Yes
User authentication
  • 2-factor authentication
  • Identity federation with existing provider (for example Google Apps)
  • Username or password
  • Other
Other user authentication
Modern authentication Modern authentication brings Active Directory Authentication Library (ADAL)-based sign-in to Office client apps across platforms, enabling sign-in features such as Multi-Factor Authentication (MFA), SAML-based third-party identity providers with Office client applications, and smart card and certificate-based authentication.

Cloud identity authentication - Users with cloud identities are authenticated using traditional challenge/response.

Federated identity authentication - Users with federated identities are authenticated using Active Directory Federation Services 2.0 or other Security Token Services.

MFA for Office 365 - users are required to acknowledge a phone call, text, or an app notification on their smartphone after correctly entering their password.

https://technet.microsoft.com/en-us/library/office-365-user-account-management.aspx
Access restrictions in management interfaces and support channels
Office 365 comes with a set of administrator roles that you can assign to users in your organization. Each admin role maps to common business functions, and gives those people permissions to do specific tasks the Office 365 admin center.

https://support.office.com/en-gb/article/About-Office-365-admin-roles-da585eea-f576-4f55-a1e0-87090b6aaa9d?ui=en-US&rs=en-GB&ad=GB

https://support.office.com/en-gb/article/Assign-admin-roles-in-Office-365-eac4d046-1afd-4f1a-85fc-8219c79e1504?ui=en-US&rs=en-GB&ad=GB
Access restriction testing frequency
At least once a year
Management access authentication
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
Between 6 months and 12 months
Access to supplier activity audit information
Users receive audit information on a regular basis
How long supplier audit data is stored for
Between 6 months and 12 months
How long system logs are stored for
Between 6 months and 12 months

Standards and certifications

ISO/IEC 27001 certification
Yes
Who accredited the ISO/IEC 27001
BSI
ISO/IEC 27001 accreditation date
30-Mar-17
What the ISO/IEC 27001 doesn’t cover
Service scope for office 365 is described in this document: http://download.microsoft.com/download/1/4/3/1434ABAB-B8E9-412D-8C3A-187B5FCB7A2F/Compliance%20Framework%20document.pdf
ISO 28000:2007 certification
No
CSA STAR certification
Yes
CSA STAR accreditation date
02-Dec-11
CSA STAR certification level
Level 1: CSA STAR Self-Assessment
What the CSA STAR doesn’t cover
Service scope is described in this document: http://download.microsoft.com/download/1/4/3/1434ABAB-B8E9-412D-8C3A-187B5FCB7A2F/Compliance%20Framework%20document.pdf
PCI certification
No
Cyber essentials
Yes
Cyber essentials plus
No
Other security certifications
Yes
Any other security certifications
  • ENISA IAF
  • EU Model Clauses
  • EU-U.S. Privacy Shield
  • ISO 27018
  • SOC 1, SOC 2
  • FEDRAMP
  • FIPS 140-2
  • NIST 800-171
  • HIPAA/HITECH. ISB 1596
  • HIPAA/HITECH. ISB 1596

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
FISMA/FedRamp, EU Model Clauses, HIPAA/HITECH, ISB 1596, ISO 27018, SASE16 SOC1 & SOC 2
Information security policies and processes
The Microsoft Cloud Security Policy is available via the Service Trust Platform aka.ms/stp

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
Microsoft has developed formal standard operating procedures (SOPs) governing the change management process. These SOPs cover both software development and hardware change and release management, and are consistent with established regulatory guidelines including ISO 27001, SOC 1/SOC 2, NIST 800-53, and others.
Microsoft also uses Operational Security Assurance (OSA), a framework that incorporates the knowledge gained through a variety of capabilities that are unique to Microsoft. OSA combines this knowledge with the experience of running hundreds of thousands of servers in datacenters around the world.
Vulnerability management type
Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
Vulnerability management approach
In support of the Information Security Policy, Microsoft runs multiple layers of antivirus software to ensure protection from common malicious software. Servers within the environment run anti-virus software that scans files uploaded and downloaded from the service for viruses or other malware. Additionally, all mails coming into the service run through the Exchange Online Protection engine, which uses multiple antivirus and antispam engines to capture known and new threats against the system. Microsoft has its own Security Response Center (MSRC) that also supplies information to all our customers covering the whole range Microsoft products.
Protective monitoring type
Conforms to a recognised standard, for example CSA CCM v3.0 or SSAE-16 / ISAE 3402
Protective monitoring approach
Office 365 employs sophisticated software-defined service instrumentation and monitoring that integrates at the component or server level, the datacenter edge, our network backbone, Internet exchange sites, and at the real or simulated user level, providing visibility when a service disruption is occurring and pinpointing its cause.

Proactive monitoring continuously measures the performance of key subsystems of the Office 365 services platform against the established boundaries for acceptable service performance and availability. When a threshold is reached or an irregular event occurs, the monitoring system generates warnings so that operations staff can address the threshold or event.
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
Please see http://aka.ms/Office365SIM

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

Trustmarque's Environmental Policy and Carbon Reduction Plan include delivering and supporting actions on reducing our carbon footprint and our impact on climate change. Our policies include 'Virtual First 'meetings, energy reduction plans, flexible working. Please contact Trustmarque to discuss the provision of Social Value. Any Social Value deliverable must be agreed with Trustmarque and be proportionate to the contract value and deliverables.
Covid-19 recovery

Covid-19 recovery

Trustmarque can provide re-training for those left unemployed by Covid-19 through skills training, CV and interview workshops. Please contact Trustmarque to discuss the provision of Social Value. Any Social Value deliverable must be agreed with Trustmarque and be proportionate to the contract value and deliverables.
Tackling economic inequality

Tackling economic inequality

Trustmarque tackles economic inequality through operating a diverse supply chain including a large number of SMEs and micro businesses. Our access to a broad range of suppliers ensures both resilience and capacity. Trustmarque is also continuously refining our supply chain to meet the ever-changing needs of our customers and to ensure we can always offer the best solution through capability, capacity and resilience at the best price. Our vendor agnostic approach among suppliers allows us to support innovation and disruptive technologies to deliver lower cost and/or higher quality goods and services to customers. Please contact Trustmarque to discuss the provision of Social Value. Any Social Value deliverable must be agreed with Trustmarque and be proportionate to the contract value and deliverables.
Equal opportunity

Equal opportunity

Trustmarque operates an Equal Opportunities policy that outlines our commitments including creating a workforce that reflects the diversity of our communities. Other initiatives include supporting disabled people to develop skills and supporting in-work progression. Please contact Trustmarque to discuss the provision of Social Value. Any Social Value deliverable must be agreed with Trustmarque and be proportionate to the contract value and deliverables.
Wellbeing

Wellbeing

We align our approach to mental wellbeing to the six standards in the Mental Health at Work commitment, including staff work and wellbeing sessions, flexible working, speak-up policy, etc. Please contact Trustmarque to discuss the provision of Social Value. Any Social Value deliverable must be agreed with Trustmarque and be proportionate to the contract value and deliverables.

Pricing

Price
£6.00 to £8.00 a user a month
Discount for educational organisations
Yes
Free trial available
Yes
Description of free trial
30 Day Trial of Office 365

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