{"id":18424,"date":"2019-12-11T10:48:02","date_gmt":"2019-12-11T09:48:02","guid":{"rendered":"https:\/\/next-step.es\/?p=18424"},"modified":"2019-12-11T10:48:02","modified_gmt":"2019-12-11T09:48:02","slug":"power-platform-sme-success-stories","status":"publish","type":"post","link":"https:\/\/next-step.es\/en\/power-platform-casos-exito-pymes\/","title":{"rendered":"Success Stories: Power Platform revolutionises SMEs"},"content":{"rendered":"<div id=\"attachment_17294\" style=\"width: 1034px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-17294\" class=\"size-large wp-image-17294\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2019\/09\/Microsoft-Power-Platform-1024x576.png\" alt=\"Microsoft Power Platform\" width=\"1024\" height=\"576\" srcset=\"https:\/\/next-step.es\/wp-content\/uploads\/2019\/09\/Microsoft-Power-Platform-980x552.png 980w, https:\/\/next-step.es\/wp-content\/uploads\/2019\/09\/Microsoft-Power-Platform-480x270.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) and (max-width: 980px) 980px, (min-width: 981px) 1024px, 100vw\" \/><p id=\"caption-attachment-17294\" class=\"wp-caption-text\">Image source: https:\/\/powerplatform.microsoft.com\/<\/p><\/div>\n<p><\/BR> <\/BR><\/p>\n<p>Last month, Madrid hosted the major international event for the\u00a0<strong>Microsoft: Power Platform World Tour 2019<\/strong>\u00a0and <strong>Next-Step Consultores, <\/strong>\u00a0we participated by making a presentation on :<strong>\u00a0\"Power BI: Digital Transformation in the Enterprise\".<\/strong><\/p>\n<p><\/BR> <\/BR><\/p>\n<p>In this talk, we analyse the experience of customers who, starting from an initial need with Power BI, initiated projects that have revolutionised the traditional way of doing things, improving productivity and efficiency. In addition, we present <strong>demos <\/strong>and\u00a0<strong>case studies of success with Power Platform in large companies and SMEs. <\/strong><\/p>\n<p><\/BR> <\/BR><\/p>\n<h2>What's new in Microsoft Power Platform<\/h2>\n<p><\/BR> <\/BR><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18444\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/11-2019_powerplatform.jpg\" alt=\"Microsoft Power Platform\" width=\"577\" height=\"253\" srcset=\"https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/11-2019_powerplatform.jpg 577w, https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/11-2019_powerplatform-480x210.jpg 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 577px, 100vw\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><\/BR> <\/BR><\/p>\n<p>We told you all about <strong>Microsoft Power Platform<\/strong> in our previous article: <\/p>\n<p><\/BR><\/p>\n<p><strong><a href=\"https:\/\/next-step.es\/en\/power-platform-artificial-intelligence\/\">https:\/\/next-step.es\/power-platform-inteligencia-artificial\/<\/a><\/strong><\/p>\n<p><\/BR> <\/BR> <\/p>\n<p>However, in<strong> Power Platform World Tour announced many new features, <\/strong>which had already been presented a few weeks earlier in <strong>Microsoft Ignite 2019:<\/strong><\/p>\n<p><\/BR> <\/BR><\/p>\n<p><strong>Power Platform<\/strong> is a suite of enterprise products that includes several of Microsoft's flagship solutions for businesses:<\/p>\n<p><\/BR> <\/BR><\/p>\n<ul>\n<li><strong>Power BI:<\/strong> The leading business intelligence tool on the market. As a novelty, many improvements in security, Artificial Intelligence and natural language have been incorporated.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>Power APPs<\/strong>Power Apps: The tool for generating applications quickly and almost without programming. The novelty of Power Apps is the new function of <strong>Portals<\/strong>which allows the construction of web portals, displaying the data stored in the Common Data Service.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>Microsoft Flow<\/strong>the tool that allows you to create automated workflows, has been transformed into a <strong>Power Automate, <\/strong> adding new robotic process automation functionalities.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>Power Virtual Agents, <\/strong>the former Virtual Agent for Customer Service of Dynamics 365, one of the biggest news, as it has recently joined Power Platform. This service allows us to create virtual agents in a simple way, almost without programming.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Finally, further integration has been achieved with <strong>Microsoft Teams<\/strong>Officce 365's teamwork tool, which incorporates chat rooms, video conferencing, and more. <\/li>\n<\/ul>\n<p>&nbsp;<br \/>\n<\/BR> <\/BR><\/p>\n<p><strong>Microsoft Power Platform <\/strong> is seamlessly integrated with the rest of Microsoft's products, connects seamlessly with the <strong>Azure<\/strong>the ERP <strong>Dynamics<\/strong>,\u00a0<strong>Office 365<\/strong>or the document manager <strong>Sharepoint, <\/strong>for example.<\/p>\n<p>In addition, of course, it must be ready to connect and exchange data with third-party solutions. <\/p>\n<p><\/BR><\/BR><\/p>\n<p>The Power Platform represents a digital transformation in companies, but not only in large, innovative companies, it is also being successfully implemented by many small and medium-sized enterprises.<\/p>\n<p><\/BR> <\/BR><br \/>\n<\/BR> <\/BR><\/p>\n<h2>SUCCESS CASE: Power Platform optimises the performance of an SME<\/h2>\n<p><\/BR> <\/BR><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18514\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-reto.png\" alt=\"Microsoft Power Platform 1 Demo\" width=\"565\" height=\"268\" srcset=\"https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-reto.png 565w, https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-reto-480x228.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 565px, 100vw\" \/><\/p>\n<p><\/BR> <\/BR><\/p>\n<p>We are going to tell you about a successful case of the implementation of Power Platform in a medium-sized company in the Distribution Sector.<\/p>\n<p><\/BR> <\/BR><\/p>\n<p>This company received the orders by email and they were handled manually by a worker. From Monday to Thursday, everything worked perfectly and orders were delivered within 48 hours at the latest. The problem was at weekends, when the company was closed. Orders that came in by email from Friday onwards could not be dealt with until Monday. The person responsible for dealing with orders on Monday was overwhelmed and orders were often not delivered until Tuesday or Wednesday, which led to complaints from some customers, as they did not meet the 48-hour delivery commitment.<\/p>\n<p><\/BR> <\/BR><\/p>\n<p>Following an analysis of the situation, it was decided to implement the <strong>Microsoft Power Platform<\/strong>to automate some processes and tasks within the company.<\/p>\n<p><\/BR> <\/BR><\/p>\n<p>With the tool<strong>\u00a0Power Automate (Microsoft Flow) <\/strong> we manage to automate and standardise the process of receiving and dispatching customer orders. Let's take a closer look at this process:<br \/>\n<\/BR> <\/BR><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18524\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-esquema.png\" alt=\"Microsoft Power Platform 2 Demo\" width=\"565\" height=\"313\" srcset=\"https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-esquema.png 565w, https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-esquema-480x266.png 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 565px, 100vw\" \/><\/p>\n<p><\/BR> <\/BR><\/p>\n<p>This company worked with <strong>Microsoft Office 365 and Outlook<\/strong> as an e-mail tool. The following Microsoft technologies were implemented<strong>: <\/strong><\/p>\n<p><\/BR> <\/BR><\/p>\n<ul>\n<li><strong>Microsoft Power BI, <\/strong>for data analysis and visualisation<\/li>\n<p><\/BR> <\/p>\n<li><strong>Power Automate (Flow), <\/strong>to automate tasks<\/li>\n<p><\/BR> <\/p>\n<li><strong>SSIS: Integration Services<\/strong>. The Microsoft Business Intelligence ETL program. A program that takes data from one source, transforms it, and moves and stores it to another destination.<\/li>\n<\/ul>\n<p><\/BR> <\/BR><\/p>\n<p><strong>Power Automate (Microsoft Flow) automates order management process with Excel<\/strong>. We have created an automatic order so that every time a new email arrives with an order:<\/p>\n<p><\/BR> <\/BR><\/p>\n<ul>\n<li>A rule is applied when a new email arrives from certain senders, with an Excel sheet attached and where the \"Subject\" field of the email contains \"Order\". In this case, Power Automate extracts the information from the email and the attached Excel sheet. The information is extracted, processed and cleaned by Integration Services and stored in a SQL Server database. Once the data and information about the order are in the database, I can consume them from Power BI, the business intelligence tool, with an analysis of the data in real time, to start with the automatic management of the order. <strong>\u00a0<\/strong><\/li>\n<\/ul>\n<p><\/BR> <\/BR><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18534\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-gestion-pedidos.jpg\" alt=\"Microsoft Power Automate Demo\" width=\"638\" height=\"326\" srcset=\"https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-gestion-pedidos.jpg 638w, https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-gestion-pedidos-480x245.jpg 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 638px, 100vw\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18544\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-gestion-pedidos2.jpg\" alt=\"Microsoft Power Automate Demo\" width=\"565\" height=\"242\" srcset=\"https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-gestion-pedidos2.jpg 565w, https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-gestion-pedidos2-480x206.jpg 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 565px, 100vw\" \/><\/p>\n<p><\/BR> <\/BR><\/p>\n<p>Example of automatic order: When a new mail arrives in the inbox, from certain senders (customers), with an Excel attachment and that the word \"Order\" is included in the text of the Subject, extract, debug and file it in this database. Afterwards, proceed to generate and send it.<\/p>\n<p><\/BR> <\/BR><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18554\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-gestion-pedidos3.jpg\" alt=\"Microsoft Power Automate Demo\" width=\"634\" height=\"331\" srcset=\"https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-gestion-pedidos3.jpg 634w, https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-gestion-pedidos3-480x251.jpg 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 634px, 100vw\" \/><\/p>\n<p><\/BR> <\/BR><\/p>\n<p><\/BR> <\/BR><\/p>\n<p><strong>The importance of Power APPs: <\/strong><\/p>\n<p>Thanks to Power APP we have developed an application for the entire order management. In addition, within the Power BI report we have been able to insert controls from Power APPs, such as \"block a customer\". <\/p>\n<p><\/BR> <\/BR><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-18564\" src=\"https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-beneficios.jpg\" alt=\"Microsoft Power Platform Case Study\" width=\"563\" height=\"301\" srcset=\"https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-beneficios.jpg 563w, https:\/\/next-step.es\/wp-content\/uploads\/2019\/12\/demo-power-platorm-pyme-sector-distribucion-beneficios-480x257.jpg 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 563px, 100vw\" \/><\/p>\n<p>The result has been a success. Previously, orders generated at the weekend were handled by a single person on Mondays, who was swamped, and were not delivered until Tuesday or Wednesday.<\/p>\n<p><\/BR> <\/BR><\/p>\n<p>Now, thanks to the implementation of the various Power Platform solutions, and Power Automate in particular, the process is automatic. The person responsible for the ordering area only has to supervise and weekend orders are delivered on Monday morning, which generates greater customer satisfaction and loyalty.<\/p>\n<p><\/BR> <\/BR><\/p>\n<p>Thanks to the implementation of the powerful suite of solutions from <strong>Microsoft Power Platform (Power BI, Power Automate and Power Apps)<\/strong>In the last few years, we have successfully advanced in the digital transformation of the company, the standardisation and automation of processes and the optimisation of management, improving productivity and customer satisfaction.<\/p>\n<p><\/BR> <\/BR><\/p>\n<p><\/BR> <\/BR><\/p>\n<h2>Find out how Power Platform can transform your business<\/h2>\n<p><\/BR> <\/BR><\/p>\n<p><strong>Next-Step Consultores,<\/strong> we are Microsoft Partner and experts in Power BI and Power Platform. If you want to improve the efficiency of your company, contact us and we will advise you without obligation on how to transform your business thanks to the technology of <strong>Microsoft Power Platform:<\/strong><\/p>\n<p><\/BR> <\/BR><\/p>\n<p><a href=\"https:\/\/next-step.es\/en\/contact\/\">https:\/\/next-step.es\/contacto\/<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>El mes pasado se celebr\u00f3 en Madrid el gran evento internacional de\u00a0Microsoft: Power Platform World Tour 2019\u00a0y Next-Step Consultores \u00a0participamos haciendo una presentaci\u00f3n sobre :\u00a0\u201cPower BI: La Transformaci\u00f3n Digital en la Empresa\u201d. En esta charla, analizamos la experiencia de clientes que, partiendo de una necesidad inicial con Power BI, iniciaron proyectos que han revolucionado la [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17294,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[12,17,19,20,23],"tags":[78,79,97,100,101,102,111,112,115,132,134,138,142,143,144],"class_list":["post-18424","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-eventos","category-power-bi-es","category-power-bi-casos-de-exito","category-power-platform","category-power-platform-world-tour","tag-demo","tag-demo-power-platform","tag-microsoft-flow","tag-microsoft-power-automate","tag-microsoft-power-bi","tag-microsoft-power-platform","tag-next-step-consultores","tag-novedades-power-platform","tag-power-automate","tag-power-platform","tag-power-platform-demo","tag-powerapps","tag-que-es-power-automate","tag-que-es-power-bi","tag-que-es-power-platform"],"_links":{"self":[{"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/posts\/18424","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/comments?post=18424"}],"version-history":[{"count":0,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/posts\/18424\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/media\/17294"}],"wp:attachment":[{"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/media?parent=18424"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/categories?post=18424"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/next-step.es\/en\/wp-json\/wp\/v2\/tags?post=18424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}