ERP and BI

Autor: selfservicebi

  • Excel – Geography Data Type

    —

    by

    selfservicebi
    in

    Durch diesen Link bin ich auf den neuen Datentyp „Geography“ in Excel 365 aufmerksam geworden: https://www.mrexcel.com/excel-tips/geography-data-types-in-excel/ Um das auszutesten, habe ich mir schnell eine Liste der Gemeinden in meinem Bundesland besorgt und den Datentyp eingesetzt. Bis auf zwei Ausnahmen hat er alle Orte korrekt gefunden, das finde ich mal schon beeindruckend. Das Resultat schnell in…

  • A few DAX functions

    —

    by

    selfservicebi
    in

    Ursprünglich veröffentlicht auf Data and AI: This query shows summarise, addcolumns, filter, union, row and format DAX functions: UNION ( ADDCOLUMNS ( SUMMARIZE ( FILTER ( financials, financials[Product] = „Montana“ ), financials[Country] ), „Sales“, FORMAT(CALCULATE(SUM(financials[ Sales])), „#,###“) ), ROW(„Total“, „Total“, „Sales“, FORMAT(SUM(financials[ Sales]), „#,###“)) ) The financials table is filtered on Product = Montana Display…

  • Solving Real World Scenarios with Microsoft PowerApps

    —

    by

    selfservicebi
    in

    This is an alternative approach to solve the problem described in my blog post here: https://selfservice-bi.com/2016/11/19/solving-real-world-scenarios-with-microsoft-flow/ This time I’m using PowerApps to „win“ the challenge. All of this is done in three easy steps: Step 1: For testing purposes, it is enough to sign up for a free plan here: https://vatlayer.com/ Step 2: Then you…

  • Manage CDS Entity Data – Microsoft PowerApps Office Add-In — Bansal Blogs – Dynamics 365, PowerApps, Microsoft Flows, Power BI

    —

    by

    selfservicebi
    in

    Microsoft PowerApps Office Add-In enables user to read, modify and insert data in CDS environment. Add-In is available for download here for free, or you will be prompted to install Add-In for first time when you open entity data in excel from PowerApps portal. Add-In establishes connection to PowerApps OData service. Note: Add-In is compatible […]…

  • Calling The Power BI REST API From Microsoft Flow, Part 3: Finding All Data Sources Used In A Power BI Tenant

    —

    by

    selfservicebi
    in

    Chris Webb's BI Blog [Part 1 of this series can be found here and part 2 here] The problem with self-service BI is that you never quite know what your users are up to. For example, what data sources are they using? Are there hundreds of Excel files being used as data sources for reports…

  • Keeping Big Data Big with Aggregations

    Keeping Big Data Big with Aggregations

    —

    by

    selfservicebi
    in

    Ursprünglich veröffentlicht auf PhantomDB: I have built several solutions over the years to enable business users to get at the data they need to do the analysis that is important to them. I would build cubes so that they could slice, dice and mold the data into the shape they need. They would use tools…

  • Power BI Dataflows

    —

    by

    selfservicebi
    in

    Die vielen Neuerungen in Power BI sind ja für mich kaum noch alle nachzuverfolgen. Darum versuche ich, die Informationen zu filtern. Dataflows sind mir schon seit einiger Zeit im Hinterkopf hängen geblieben, da es hier mehr um Design als um Visualisierung geht. Eine wirklich erschöpfende und trotzdem flüssig zu lesende Abhandlung dieses Themas gibt es…

  • Taking the Most Out of Linked Servers

    —

    by

    selfservicebi
    in

    Da ich gerade in einem Projekt mit dem Thema „Linked Server“ konfrontiert wurde, ist dieser Artikel ein guter Einstieg in die Thematik. Auch das erwähnte Video ist sehr empfehlenswert. Natürlich ist das Thema komplex, aber mit etwa Recherche im Internet kann beliebig in die Tiefe gegangen werden: https://prologika.com/taking-the-most-out-of-linked-servers/

  • Microsoft Flow – Business process flows from a traditional Flow perspective

    —

    by

    selfservicebi
    in

    SharePains Recently Microsoft added Business process flows to their Microsoft Flow platform. If you thought that this was just like Flow then you will very quickly find out that it is not. A bit of background first As part of Dynamics 365 there is the Process Center. Within the Process Center you can maintain processes…

  • Dynamics 365 Business central on-premise: why I can’t find my C/AL page on Search?

    Dynamics 365 Business central on-premise: why I can’t find my C/AL page on Search?

    —

    by

    selfservicebi
    in

    Ursprünglich veröffentlicht auf Stefano Demiliani: This seems to be a problem for many partners and developers that have start working with Dynamics 365 Business Central on-premise in these days and this is not actually well documented in my opinion. I think that you already know that when developing a page with the AL language extension…