Selling price = costs + margin? Better give your money away for Christmas!
In the world of sales, and particularly in the world of business software such as Microsoft Dynamics NAV, Navision and Business Central, it's tempting to calculate the price of a product simply as the sum of the cost and a fixed margin. But what if your customers were willing to pay more for your product? Then you may be giving away [...]
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 [...]
Power BI with as little data as possible in the cloud
The "normal" Power BI variant (everything in the cloud) would be to upload large Power BI files containing all the raw data to the cloud. This creates a so-called "semantic model" in the cloud, which the report itself can consume in the same way as other reports. This "semantic model" is technically nothing more than the SQL Server Analysis Services Engine, with which [...]
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 [...]
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 [...]
Display animated GIFs in Power BI
In today's business world, data visualization and business intelligence play an increasingly important role. Companies are looking for ways to present data in an engaging and easy-to-understand way. One popular solution for this requirement is to use Power BI, a business intelligence tool from Microsoft. In this article, we will focus on how to use animated GIFs in [...]
Handling multiple date values in Power BI with DAX-Measure and a single date dimension table
When analyzing data in Power BI, you may need to work with multiple date dimensions. In some cases, you may want to use only a single date dimension table and associate the different date types such as sales date, delivery date, and due date with it. In this blog article, you will learn how to use a single date dimension table and the USERELATIONSHIP [...]
Welcome aboard!
We are proud to welcome our new employee Ms. Thu Trang Tran! With her years of experience in #BusinessIntelligence projects and her passion for #dataanalytics, she will add significant value to our customers. #PowerBI and #SQL programming are part of her portfolio as well as #Tableau and SAP Analytics Cloud. Welcome on board!
