Welcome to my Blog on data-insights.de!
Providing both English and German content, this blog is aimed at employees of
specialist departments who analyze data in their daily business with Microsoft products such as Excel or Power BI and are constantly looking for new solutions and opportunities to
It is also aimed at anyone who has discovered his passion for data analysis with Power BI, Excel Power Add-ins and related technologies such as SSAS Tabular or third-party tools.
This blog is meant to be a casual place where we can exchange ideas and learn from each other.
I hope you'll have lot of fun with my blog!
Complex decisions are constantly being taken within organisations, with increasing frequency. Often these decisions rely on data. Organisations that still bet solely on the classic approach of centralized Corporate BI often struggle supporting decisions due to long delivery times of their BI solutions and a lack of balance between IT knowledge and Business knowledge introduced into the solution...
Power BI is a versatile Business Intelligence platform that offers an endless range of options, features and technical skills to master. In addition Power BI can be enhanced by various extensions such as Python or R. These languages open a wide range of capabilities to use in your data analysis process. This series is about using the R-language in Power BI.
One of the many aspects I love about Power BI is that you can achieve the same goal in many different ways. This will allow you to choose the path that best suits your personal preferences, technical skills or specific restrictions...
Die Analyse von Daten nach Zeiträumen und Vergleichsperioden ist eine wesentliche Anforderung an die Reporting- und BI-Lösungen vieler Unternehmen. Zum Glück bietet DAX mit den sog. Time-Intelligence Funktionen eine Vielzahl an Möglichkeiten, solche Analysen schnell und effizient durchzuführen.
Allerdings werden Time-Intelligence Funktionen, zumindest zum jetzigen Zeitpunkt, nicht in allen Einsatzszenarien von Power BI unterstützt. Eines dieser Szenarien ist der Datenzugriff via DirectQuery...
Since November 2016 the IN-operator is also available in DAX and extends your possibilities to filter table expressions in Power BI, Excel 2016 (from version 1701) or SSAS Tabular 2017. In this article we take a look at how and where you can use the IN-operator in DAX.
In the last part of the series about programming loops in M, I want to show you a way to create the "For-Next"-loop type in Power Query. For this we take a closer look at the function List.Accumulate()…
POPULAR ARTICLE SERIES
RSS-FEED BI BLOG