What is the Power Platform?

The Microsoft Power Platform is a collection of tools – a suite of ‘low-code’ solutions – designed to support your business in different ways. The platform is made up of three Microsoft products which will be discussed further within this piece: 

  • Power BI: for detailed analytics and reporting 
  • Power Apps: for building bespoke business and mobile applications
  • Power Automate (previously Microsoft Flow): for automating business tasks  
Microsoft Power Platform Icons

The beauty of these tools, is that each of them is designed to integrate with hundreds of data sources (including the Common Data Service), allowing you to leverage your data across multiple third-party and other Microsoft applications.  

Within this blog we will cover the following areas – if you want to skip to that section, just click on the name:

What is the Common Data Service? 

Throughout this article we will refer to the Common Data Service so let’s clear up what that means. The Common Data Service is the secure storage service for data held within the Power Platform, as well as the data from online versions of Microsoft Dynamics 365. This means that you can pull data between applications easily and leverage it as desired, so no need to worry about different data in various places. 

Overview of the power platform

Power BI

Microsoft Power BI is a data and analytics reporting tool which essentially brings together disparate data – anything from basic Excel spreadsheets to databases, including both cloud-based and on-premise apps. This is then presented in dashboards & reports with visual, easy-to-read graphs and charts, allowing businesses to drill down and gain valuable insights.

Power BI Dashboard shown on Microsoft Surface

Why use Power BI?

One of the main uses of Power BI is to create dashboards demonstrating business performance, however there are multiple ways organisations can use the tool. Here are just a few examples: 

  • Visualising the appropriate data to track and manage IT assets within your business, such as devices, software licenses, equipment, etc. 
  • In the sales department, you may have a view which shows each team members performance against their monthly targets, encouraging a bit of friendly competition 
  • It’s crucial that department managers have a full view of team performance throughout the month, so Power BI can be used to generate dashboards which show this data quickly and visually; this will save time having to manually pull these metrics together from various sources 
  • View revenue and financials figures and make more strategic decisions   

Visualistions in Power BI

As you can see from the image above, there are plenty of ways to visualise your data within Power BI. The most popular ways are: 

  • Bar charts: Standard for looking at a specific value across different categories 
  • Combo Charts: Combines a line chart and a column chart allowing you to make a quicker comparison of data 
  • Doughnut Charts: Similar to pie charts, these are best used for making comparisons between categories 
  • Maps: Used to show geographical locations of data points on a map. The ‘Basic Map’ visual can show precise geographical locations of data points, or the ‘Shape Map’ is used to show comparisons of regions on a map by using different colours 

We’ve written a blog post about how to visualise data in Power BI, so check that out here. 

Bar Charts

power bi visualisation chart

Standard for looking at a specific value across different categories 

Combo Charts

power bi visualisation clustered combo

Combines a line chart and a column chart allowing you to make a quicker comparison of data

Doughnut Charts

power bi visualisation doughnut chart

Similar to pie charts, these are best used for making comparisons between categories 

Maps

power bi map visualisation

This visualisation is used to show geographical locations of data points on a map

Power BI Data Sources

There are hundreds of data sources that Power BI can connect toway too many to list, so check them out here – Power BI Data Sources (Microsoft). Some of the most popular connectors include: 

  • Common Data Service 
  • SharePoint/OneDrive 
  • Microsoft Office Apps (Outlook, Excel, etc) 
  • SQL Server 
  • Mailchimp 
  • Google Analytics 

These are Microsoft Certified Connectors, but there are also options to use third-party connectors, or if you can’t find what you are looking for, then custom connectors are also an option. It is also worth noting that some of the connectors are premium and require a different licensing plan (see licensing plans). 

Download Power BI eBook

Find out how your business can get more from your data

Claim eBook Now!

Power Apps

Power Apps allows businesses to create bespoke applications, which can be accessed via mobile/tablet devices or browser (where they are published as a web site). These apps can be built for a range of processes, which we will review down below, but they can solve a range of business problems where you can’t find a suitable off-the-shelf solution.  

Microsoft Power Apps shown across devices

What sets Power Apps apart from other offerings is the ‘low-code approach to app development’ so essentially anyone can build an app, even without technical experience. Although it’s worth noting that there’s actually quite a learning curve for those who want to build their own apps, so unless you’re a developer you should ideally work with your Microsoft partner to design and build anything but the simplest applications. 

Microsoft categorise Power Apps into 3 different types: 

  • Canvas Apps: Like working from a blank canvas, users start with the data source, add workflows and then finally create the design. This approach offers more flexibility than model-driven apps. 
  • Model-driven Apps: With model-driven apps, much of the layout is controlled by the data connected and information entered into the app – what you feed in generally decides the outcome. This approach is more commonly used if the app you’re designing requires complex business logic.  
  • Portals: for creating web portals (websites) that can be shared both internally and externally, allowing users to interact securely with data stored in the Common Data Service 

How can my business use Power Apps? 

Apps can be created for pretty much any business case and the possibilities are endless, but here are a few examples of apps that you could create:  

Holiday App

Create a holiday app for employees to input their holiday. Introduce an approval procedure from Power Automate to approve or reject requests  

Field Workers

Create a holiday app for employees to input their holiday. Introduce an approval procedure from Power Automate to approve or reject requests  

Customer Portal

A customer support portal, linked to Dynamics 365, that allows customers to submit and track support cases, view knowledge articles, etc.

Onboarding App

An onboarding app to streamline the onboarding experience for new team members. Track member profiles, relevant tasks, documents, etc. instead of managing this process manually 

Event Registration

Create an event reistration app which enables attendees to register, check-in and then automatically gather their details in your database

Employee Expenses

An employee expenses app, allowing your employees to enter details of any expenses and attach photographs of receipts for easy tracking 

There are a variety of templates available from Microsoft, such as the ones below, so users can easily build an app using their selected template, then tailor it to meet specific needs. 

Power Apps Template Gallery

Power Apps Data Sources

As with the Power BI data sources listed above, Power Apps can be connected with the same extensive list. See all options here – Power Apps Connections List (Microsoft). 

Download Power Apps eBook

Discover how custom-built applications can work for your business

Claim eBook Now!

Power Automate (previously Microsoft Flow) 

Power Automate allows businesses to create automated workflows across multiple applications. In simple terms, repetitive tasks can be automated which saves time and means your staff can focus on more important things.  

These automated workflows are called flows and trigger when a specific event occurs. Users can build flows by using pre-built automation templates (these can be found in the ‘Flow Gallery’) or create their own by connecting applications (E.g, Outlook, Dynamics 365, SharePoint, Twitter, Mailchimp, etc). 

Power Automate Workflow

Examples of Power Automate

As we said above, there are plenty of templates available of commonly created apps, which can be customised to fit your business. Here are a few of our favourite examples: 

  • Automatically save email attachments to SharePoint when they arrive to your inbox 
  • Retrieve details from Companies House API on request and store in Dynamics 365 
  • Introduce an approval procedure to approve or reject requests in a holiday Power App
  • If your business is using Microsoft Forms, you can set up a flow to automatically record form responses in SharePoint or Dynamics 365 
  • Get an email summary of all the events you have in your upcoming week, so you never miss a thing 
Power Automate Templates

As with all the Power Platform tools, there are so many possibilities with what you can create. We have written which details the benefits and uses of Power Automate, which you can read here.

Power Apps Data Sources

As with Power BI and data sources listed above, Power Apps can be connected with the same extensive list. See all options here – Power Apps Connectors (Microsoft). 

Download Power Automate eBook

Find out how your business can save time with Power Automate

Claim eBook Now!

Power Platform Licensing & Pricing 

Currently, there is not an option for a bundle plan which combines all three Power Platform products together, so you can either purchase each one individually (and mix and match these) or there are free versions available. 

Power Apps Pricing: 

There is a 30-day free trial available for Power Apps, allowing you to explore all Power Apps capabilities. Alternatively, there are several ways to license Power Apps: 

Single App Plan

£ 7.50

per user / app / month
  • Run applications for mobile and/or web around a single business scenario for an individual user. This also provides access rights to a single web portal (subject to portal service limits, see below) 

Unlimited App Plan

£ 30.20

per user / month
  • Run unlimited applications for multiple business scenarios 

Neither the Single or Unlimited App Plan is limited to a minimum or maximum number of licenses. The single plan does enable businesses to purchase multiple passes for users who need to access multiple apps, but not quite the level that where the Unlimited App Plan would be required. 

Power Automate / Microsoft Flow Pricing: 

There is a free trial available for Power Automate which is available for 90 days (for Power Apps this is 30 days). Alternatively, there are several ways to license Power Automate: 

Per User

£ 10

per user/month
  • Allows individual users to create unlimited flows based on their unique needs. 

Per Flow

£ 311

per month - minimum purchase of 5 flows
  • Implement flows with reserved capacity that serve unlimited users across an organisation 

Seeded Flow

£ Included

Office 365 / Dynamics 365 / Power Apps
  • Office 365: Using Power Automate within the context of Office 365 is included. Qualifying licenses for Power Automate: Business Premium, Business Essentials, F1 Plan, and the E1-E5 Enterprise Plans including when licensed in the Microsoft 365 Bundles. 
  • Dynamics 365: Using Power Automate within the context of Dynamics 365 is included. Qualifying licenses: Sales, Customer Service, Field Service, Retail, Talent, Business Central, and more.
  • Power Apps: A Power Automate flow that is created within the context of a PowerApp is included in the PowerApps licensing

You can find more information on Power Automate Licensing here: https://flow.microsoft.com/en-us/pricing/?currency=GBP 

Power BI Licensing:

There are three are pricing plans available for Power BI: 

Power BI Desktop

£ Free

for any single user
  • Consolidate data sources, create reports, conduct analysis, or just test the capabilities. There is a lot of functionality included i nthe free plan, however there are some limitations (eg. inability to share reports)

Power BI Pro

£ 7.50

per user / month
  • This is the full version of Power BI, complete with the functionality which is not available within the Desktop Plan; build dashboards and reports for unlimited viewing, share with others, embed visuals into other apps, etc.

Power BI Premium

£ 3,766.60

per month / per dedicated cloud compute
  • A capacity-based offering built for large organisations. This plan provides greater flexibility to allow users to access, collaborate upon, and distribute content 

What next?

Hopefully what you’ve read in this article has provided you with a good understanding of what the Power Platform is and the potential of what’s out there, giving you an insight into the exciting possibilities ahead. But, we understand that it can be difficult to know where to start and how it may work for your organisation. 

If you would like to learn more about any of the applications within the Power Platform, please get in touch with us. We’d be happy to talk you through further details and how this can fit in with your business, or you may have an idea you’d like to discuss. You can fill out the contact form below and a member of our team will be in touch shortly, or if you’d prefer, call us on 01908 038110.