ERP and BI

Autor: selfservicebi

  • PowerApps and Flow – Learn from the experts

    —

    by

    selfservicebi
    in

    Great video and walk-through showing the capabilities of PowerApps together with Flow: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/help-desk-install?utm_source=twitter&utm_source=t.co&utm_medium=doc&utm_medium=referral&utm_campaign=2018_04_19 Another great article here shows how to generate pdf documents: http://johnliu.net/blog/2017/10/generate-any-pdf-documents-from-html-with-flow  

  • Using WinSCP in SSIS

    —

    by

    selfservicebi
    in

    Use Code as described here: https://winscp.net/forum/viewtopic.php?t=11146 Use Script Task to register WinSCP.dll in case gacutil is missing: https://www.techmanyu.com/register-an-assembly-in-gac-without-using-gacutil-exe/  

  • PowerApps – My learning journey

    —

    by

    selfservicebi
    in

    I really can recommend this course to everbody who is interested in PowerApps: https://courses.edx.org/courses/course-v1:Microsoft+DAT227x+1T2018a/course/ And I’m really looking forward to the App-in-A-Day Workshop taking place in Zurich beginning of May    

  • PowerBI und GdPdU

    —

    by

    selfservicebi
    in

    Hier ein interessanter Beitrag zu diesem Thema im Kontext von PowerBI: https://powerbi.microsoft.com/en-us/blog/power-bi-gdpr-whitepaper-is-now-available/  

  • NAV Business Central – Think different

    —

    by

    selfservicebi
    in

    Upgrading software is hard. Not because merging software is hard. It’s hard because people are creatures of habits. Let me give you an example. We recently upgraded from NAV 2016 to NAV2018. This means big changes to the Customer Card. I’m fine with that. While in the process I moved my customizations to a Page […]…

  • Dynamics 365 Business Central – Table trigger events, events, events ….

    —

    by

    selfservicebi
    in

    All this old and new table trigger events mentioned  here: http://www.kauffmann.nl/2018/03/24/table-trigger-events-in-dynamics-365-business-central/   … really remind me of the good old form trigger concept in MS Access. It goes a bit like this: „Where am I going to put my code today?“  

  • Integrate NAV with an Azure Machine Learning Model

    —

    by

    selfservicebi
    in

    Ich denke, alleine diese Artikel zeigen anschaulich, dass Microsoft Dynamics NAV nicht mehr länger ein isoliertes ERP-System ist, sondern sich in nahtlos mit anderen MS-Technologien verbinden lässt. https://blogs.msdn.microsoft.com/nav/2018/02/15/smart-solutions-4-integrate-nav-with-an-azure-machine-learning-model-in-less-than-10-steps/ https://blogs.msdn.microsoft.com/nav/2018/02/27/smart-solutions-5-basic-integration-nav-azure-machine-learning-web-service/ https://blogs.msdn.microsoft.com/nav/2018/03/19/smart-solutions-6-income-predictor-for-dynamics-nav/

  • Excel ist böse…

    —

    by

    selfservicebi
    in

    Interessanter (Werbe-)Artikel, der wohl bekannte Probleme mit Excel as Reporting Tool aufzeigt. Wobei man muss natürlich sagen, meiner Meinung nach vergleicht man hier wirklich Äpfel mit Birnen. Wie auch ersten Kommentar erwähnt, wenn ich Excel + Power Query + Power Pivot + Power BI (Service) herannehme, dann sind wir hier schon eher bei einem fairen…

  • Microsoft Dynamics NAV and GDPR: what’s next?

    —

    by

    selfservicebi
    in

    Ursprünglich veröffentlicht auf Stefano Demiliani: The General Data Protection Regulation (GDPR) comes into force on May 25, 2018 and represents a significant overhaul of data protection legislation; the accountability principle will mean that businesses will need to examine how they hold and use data and take steps to demonstrate compliance with the data protection principles.…

  • SSIS Tutorial

    —

    by

    selfservicebi
    in

    Einfach und gut aufgemachte Seite zu vielen Standardkomponenten in SSIS: https://www.tutorialgateway.org/ssis/ Hatte gerade wieder einen klassischen Fall in SSIS zu lösen: + prüfen, ob Dateien auf dem ftp-Server abholbereit liegen + Falls ja, diese Dateien runterladen + prüfen, ob Download erfolgreich, dann die files vom ftp löschen + Dateien vom lokalen Downloadverzeichnis in ein Arbeitsverzeichnis…