The topic of planning is often left out of the definition of a data strategy. Planning is perceived as "too special" because it is strongly departmental, existing concepts can only be applied to a limited extent for planning, and the employed BI tools are often unsuitable for planning. As a result, potential remains untapped. This blog shows how you can fix this, even retroactively.
Power BI from Microsoft is a versatile, intuitive, and therefore widely used data visualization tool. But other software manufacturers are also making a name for themselves in the data evaluation market. One of them is Tableau. As an experienced Power BI developer, I was recently able to try my luck with Tableau for a customer. I would like to share the results with you in the following blog post.
Do you want to prepare a Power BI report, but the data quantity is too large to even start creating visuals? Or you've actually managed to prepare the report based on such data, but Power BI desktop keeps seizing up? Or the report takes forever to be published? You're not alone here. We will therefore next provide a few tips which are easy to implement.
arcplan offers a number of possibilities to set up a classic V-Lookup, as it is often used in Excel. One of these possibilities can be found under the blog entry Tips & Tricks: The Repeat Loop as Performance Killer.
The method described here works via the cross product of two tables and, as bulk operation, constitutes a “Left Outer Join”, while the intersection constitutes an “Inner Join”.
Increasingly frequently, Power BI is used not only as a self-service tool, but also forms the basis of operationalized analytics applications at many internationally active companies and even in the B2B sector. This, in particular, requires Power BI reports to be displayed in multiple languages. Here you have to decide: Do I create one report per language or try to make my report filterable by language? This article considers the latter approach.
An important building block for a planning system comprises dealing with intercompany (IC) issues. IC comes into play whenever different economic entities of a group of enterprises exchange goods or services with each other. The resulting expenditures and earnings, as well as receivables and payables must be transparent and definable with respect to each other. Because planning is performed by numerous participants, IC coordination and subsequent IC elimination are not trivial.
For specific use cases such as the contribution margin schema, it makes sense to display key figures in a dimension table instead of the classic fact table. This article describes characteristic features and a method of implementation in Power BI.
arcplan applications frequently offer the possibility for a user to rewrite by means of inputs into the application and/or the underlying database. This is particularly the case with forecasting applications, but in simplified form also with comment inputs.
arcplan facilitates the creation of standardized reports, which support (and thus make more efficient) the daily work of the employees of a business. In particular, this is the case if reports present the included data in a meaningful, concise and user-friendly manner. Large volumes of information are thus often structured and presented in the form of tables. In order to illustrate relations and/or hierarchies of data within the table and avoid redundancies, it is required to choose columns and line headings which, in addition, are supposed to be placed expediently.
