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!
Microsoft Dynamics NAV module for PackagingG?
All users of the ERP system Microsoft Dynamics NAV who are affected by the Packaging Act (formerly Packaging Ordinance VerpackV) in Germany are now wondering how they can make the declarations to the central office in the first place. Often, packaging materials are not even recorded in the ERP system in the first place, and the logic around declarations of exemption from liability by creditors and debtors is not recorded either. [...]
What data on sales and products must a company record for the Packaging Act?
In order to be able to make the reports to the central office (verpackungsregister.org) correctly, companies must have a variety of data as a basis for calculation, which may not yet exist. Roughly, you need to know: What is the packaging of a product I sell? How many products of what size have I put on the market in Germany? [...]
Power BI with Navision: Which customers buy which items?
A really simple example of how to use Microsoft Dynamics NAV together with Power BI. Business Intelligence in a very simple way. What does it show? It shows which are the best customers, as the size in the ring chart corresponds to the accounts receivable turnover. In addition, it shows which items bring in the most revenue. These are shown in the bar chart [...]
Let there be light!
Let there be light! More transparency for producers using Microsoft Dynamics! Do you produce your own goods, or sell them to customers? Then you have a lot of complex processes from purchasing, production, warehouse, logistics, sales reporting, all mapped in NAV. Our job is to make this treasure trove of data transparent to your departments in such a way that your departments [...]
