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 [...]
Welcome Manuel!
Welcome aboard - Manuel John! We are pleased to introduce our new contributor, who joins us with an impressive background in computational linguistics. In his studies, he conducted a fascinating project training a ChatGPT model to generate plays in the style of Goethe and Schiller. His solid knowledge of [...]
BI Technologies in Transition: Today vs Tomorrow
Changing technologies for BI Microsoft technologies are constantly evolving. In the following, I would like to present various compilations of technical components that can be used to implement professional business intelligence projects today and in the future. Current technology stack for SQL Server On Premise Customers who already have a SQL Server in-house due to other projects (at least Standard Edition) come [...]
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 [...]
Using sort columns to define the category sort order in the "Fields" parameter of Power BI.
In Power BI, the correct sorting of categories is crucial to make sense of data in reports and visualizations. The Fields feature allows you to select fields and dimensions to use in a report. However, setting up an appropriate sort order for these categories can be challenging. Here we explain how the sort order of categories [...]
Field Switch in Power BI: Simplify your data analysis with dynamic column selection
Effective data analysis is critical for companies that use Microsoft Dynamics NAV, Navision and Business Central as their ERP systems. Power BI, Microsoft's powerful business intelligence tool, offers a feature called Field Switch that lets you dynamically select columns and simplify your data analysis. In this article, you will learn how to use the Field Switch [...]
Data-based color change of rows in Power BI tables or matrices
Visualizing data in table format is an effective way to present information and gain insights. In Microsoft Dynamics NAV, Navision and Business Central, popular ERP systems from Microsoft, data analysis plays a crucial role for businesses. In this article, you'll learn how to change the color of rows in Power BI tables or matrices based [...]
Chat GPT or AI consultant: Will business intelligence jobs be replaced?
In the rapidly evolving world of artificial intelligence and automated technologies, the question is whether chat GPT (Generative Pre-trained Transformer) or AI consultants pose a threat to traditional business intelligence jobs, especially those associated with Microsoft Dynamics NAV, Navision and Business Central. In this article, we explore how these technologies work and what impact they have on [...]
