Detailed analysis of customers and articles: Maximize your potential with Power BI
In today's business world, it is essential to have a clear overview of item sales and customer trends. Unfortunately, many ERP (Enterprise Resource Planning) systems do not provide the necessary graphical reports to effectively analyze this data. This is exactly where our new, customized report comes in, which we would like to present to you today. A look at [...]
Difference between zero values and empty values
Many customers ask us why " " and "(empty)" are displayed in the Power BI Slicer. What does this mean? In the world of Power BI and other data analysis tools such as Microsoft Dynamics NAV (Navision) and Business Central, null values and empty values are common terms that are often confused. However, it is important to understand the difference [...]
More time at last! How Power BI for controllers handles all recurring tasks
Do you work in finance or controlling? Then today we'd like to show you how to make the transition from the world of Excel to the fully automated reporting world. In other words, you'll finally have time to go on vacation and focus on your actual job. Many controllers still live in a world where big [...]
Summer party 2024: A day full of surprises and team spirit
On Sunday, June 23, 2024, data4success GmbH held its annual summer party, and it was a day we all won't soon forget. With bright sunshine and good humor, our teams and their families met for a special event: the Surprise Tour by SharingPlate. A culinary adventure in Frankfurt To [...]
How to sort date hierarchies in descending order in a hierarchical slicer in Power BI
In the world of business intelligence, the ability to efficiently analyze data from complex systems such as Microsoft Dynamics NAV (also known as Navision) and Business Central is critical. In Power BI, hierarchical slicers are a powerful tool to effectively filter and analyze data. A common challenge is to analyze all levels of a date hierarchy (such as year [...]).
Introduction to the Power BI Report Builder for Microsoft Dynamics NAV and Business Central users
Introduction The Power BI Report Builder is a Microsoft tool designed for the creation of paginated reports. These reports are particularly suitable for printing or exporting to formats such as PDF. The Report Builder is part of the Power BI ecosystem and offers tight integration with Microsoft Dynamics NAV (Navision) and Business [...]
How to quickly add a date table in Power BI
If you use data from systems such as Microsoft Dynamics NAV, its predecessor Navision or the newer Business Central in Power BI, the integration of a date table is often indispensable. It enables deep time-based analysis of your business data. In this article we will show you how to implement this efficiently. 1. why a data table is important: Before we start [...]
Customized evaluation of categories with the DAX function RANKX
In Microsoft Dynamics NAV, also known as Navision or Business Central, the ability to effectively analyze and organize data is critical to the success of a business. A common question asked is: How can you rank categories or items according to a specific metric such as revenue? This is where RANKX comes in, a powerful [...]
Fix Many-to-Many Relationships in Power BI: The Power of Bridge Tables and Bidirectional Cross Filtering
In the world of data analysis and business intelligence, Power BI has established itself as an indispensable tool for turning data into meaningful insights. But Power BI users often encounter a particular challenge: many-to-many relationships. In this article, we'll explore how to solve this problem using a bridge table and implementing Bi-Directional Cross Filtering [...]
