{"id":22541,"date":"2023-12-29T12:26:28","date_gmt":"2023-12-29T12:26:28","guid":{"rendered":"http:\/\/myclouddoor.com\/portfolio-item\/philips-copy-copy\/"},"modified":"2024-08-12T12:18:11","modified_gmt":"2024-08-12T11:18:11","slug":"food-data-on-cloud","status":"publish","type":"portfolio","link":"https:\/\/myclouddoor.es\/en\/portfolio-item\/food-data-on-cloud\/","title":{"rendered":"Food &#8211; Data on Cloud"},"content":{"rendered":"\n<p>THE CHALLENGE &#8211; REQUIREMENTS<br>Automate the daily and end of month financial reconciliation processes between the\u00a0Point Of Selling data and the bank data. Up until now, the client has been using manual excel based processed, but it is a tedious and time-consuming process with no room for scalability.<\/p>\n\n\n\n<p>THE SOLUTION &#8211; BENEFITS<br>MyCloudDoor has developed an end-to-end solution based on Synapse and Power BI. The data coming from both systems is integrated, cleaned and filtered using Synapse pipelines into a dedicated SQL Pool. Afterwards, the data is modeled in Power BI where the stakeholders can easily review the reconciliation process.<\/p>\n\n\n\n<p>THE RESULT <br>Our costumer now has an automatic, scalable and resilient financial reconciliation process, freeing time for the finance team to dedicate on innovation of solutions. The architecture of the solution allows for data to increase over time without it being a bottleneck, as well as add further reconciliation processes based on the same or different data<br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>THE CHALLENGE &#8211; REQUIREMENTSAutomate the daily and end of month financial reconciliation processes between the\u00a0Point Of Selling data and the bank data. Up until now, the<span class=\"excerpt-hellip\"> [\u2026]<\/span><\/p>\n","protected":false},"author":5,"featured_media":22536,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"portfolio-types":[233],"class_list":["post-22541","portfolio","type-portfolio","status-publish","has-post-thumbnail","hentry","portfolio-types-use-cases"],"_links":{"self":[{"href":"https:\/\/myclouddoor.es\/en\/wp-json\/wp\/v2\/portfolio\/22541","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myclouddoor.es\/en\/wp-json\/wp\/v2\/portfolio"}],"about":[{"href":"https:\/\/myclouddoor.es\/en\/wp-json\/wp\/v2\/types\/portfolio"}],"author":[{"embeddable":true,"href":"https:\/\/myclouddoor.es\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/myclouddoor.es\/en\/wp-json\/wp\/v2\/comments?post=22541"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/myclouddoor.es\/en\/wp-json\/wp\/v2\/media\/22536"}],"wp:attachment":[{"href":"https:\/\/myclouddoor.es\/en\/wp-json\/wp\/v2\/media?parent=22541"}],"wp:term":[{"taxonomy":"portfolio-types","embeddable":true,"href":"https:\/\/myclouddoor.es\/en\/wp-json\/wp\/v2\/portfolio-types?post=22541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}