Microsoft Power Platform Services

PROCESS AUTOMATION

Intelligent automation with the Microsoft Power Platform 700+ connectors brings the dream of quick integration into reality

BUSINESS INTELLIGENCE

Business intelligence and high-quality data visualizations with Power BI turns business data into business facts

PRODUCTIVITY ACCELERATION

With a painless drag-and-drop screen building experience, Power Apps turns data into a usable, interactive interface

SMALL-SCALE APPLICATIONS

Over 65% of organizations have an unserved software development backlog. Low-code solutions can fill this gap.

As software demand explodes, today’s rapidly changing business needs require lightweight, low-code solutions. Power Platform brings a middle ground between off-the-shelf solutions that don’t fit your needs and large full-code software projects. Leveraging 700+ connected experiences (including Salesforce, DocuSign and SAP) and the Microsoft collaboration suite, MercuryWorks staff can rapidly construct custom automation solutions for business applications.

Business process automation provides a way for staff to get work done in a consistent way – automate tasks and business processes, speed up repetitive tasks and bring consistency to complicated business operations. Their streamlined user experiences enable users to simply “get their job done”.

EASE OF USE OF LISTS + THE POWER OF SQL SERVER

Microsoft created Microsoft Lists as a full Microsoft 365 citizen with a primary target being a highly-approachable creation experience for business users. However, there are definite limits to the practical use of Lists for enterprise applications, capacity being one of the primary limitations. Enter Dataverse.

Data modeling and management in Dataverse looks and feels VERY similar to Microsoft Lists. However, Dataverse’s underpinnings are in fact SQL Server; Dataverse won’t run you into the performance problems and limits that you may have experienced with Lists.

DECLARATIVE BUSINESS RULES

With Dataverse, you can basically “draw” the business rules and relationships between tables (including if..then…else logic) and then everything you build atop Dataverse inherits and imposes those rules (no hand-rolling custom validation in a Canvas Power App). The development reduction and increased consistency in business function from this architecture is immense.

MODEL-DRIVEN POWER APPS

Dataverse has added another kind of Power App – the Model-driven App. Model-driven Apps generally require less coding than Canvas Apps and stand upon the built-in Dataverse relationships and business rules that connect tables together and impose them in the resulting user interface.

Model-driven apps are especially well suited to process-driven apps that are data dense and make it easy for users to move between related records in a business process (such as onboarding a new employee).

BUILT-IN AUDITING AND COMPLIANCE

Data auditing and compliance is traditionally an area of large IT budget spend and also a major time sink during the development of full-code solutions. Either third-party auditing systems are put in place or teams commit extensive development time creating auditing routines and reporting.

With Dataverse, data auditing and compliance is built into your Power Platform solution. The date, time, identity, “before” and “after” value of each change in data is tracked in each Dataverse data record’s Audit History tab.