Post by account_disabled on Feb 20, 2024 6:02:42 GMT -6
Often, when talking about Business Intelligence solutions , business intelligence tools and systems, it does not take long to think about complex and expensive solutions, only within the reach of large companies and organizations. However, as we will see, we have at our disposal a good assortment of applications and tools that allow us, if not for free but at very reduced prices, to begin building our BI system from solid foundations. Today, then, we will see how to design a Balanced Scorecard in Excel , a resource that any organization can currently afford. Designing a Balanced Scorecard, Excel Before starting, it is worth remembering two important aspects that precede any project of this nature: The design of a CMI must be carried out based on a previously defined strategic plan . Specialized professional advice , in most cases, is not an option but a necessity when trying to get the most out of the CMI.
Therefore, despite the information provided in this post, we recommend professional supervision of projects as critical and sensitive for the organization as the design of a BSC. excel balanced scorecard That said, let's get into the matter by refreshing our memory on a key aspect, which we must take into account when starting to configure our Excel Dashboard : the 4 perspectives of the USA Student Phone Number List Balanced Scorecard (customer, financial, internal processes, and Learning and growth). Either using a standard spreadsheet, configured with the appropriate macros and extensions (you must have the macros option enabled and have the Excel CMI extension, available online for all users of the software), or Using the cloud instances that many specialized BI consultancies put at the service of their clients (already fully configured for this purpose), the first task to be faced will be to select and specify the most appropriate key performance indicators (or KPIs) for each objective. established strategic, and in turn for each of the 4 perspectives of the WCC. The new release of Cognos Analytics , 11.0.5, continues to add new functionality that allows users to quickly collect responses to their needs.
New data maps, graphical visualizations that give new perspectives and clarity to analyze the results. A tool to highlight for the use of Business Intelligence in the era of business Digital Transformation . There is abundant literature on the perspectives of the BSC and how to select the most appropriate KPIs based on the strategic objectives set; As an example, we recommend the free guide 12 keys to defining a Balanced Scorecard , a more than relevant resource to introduce us and deepen our knowledge of BSCs. The indicators that will have to be entered in the section corresponding to each perspective will each have a column and each column, in turn, will have a set of fields (rows) that will include, at least, the name of the indicator , 3 value fields (minimum, average and maximum, represented respectively with the colors red, yellow and green), an objective field (where the strategic objective to be achieved will be expressed) and finally the field corresponding to the actual result obtained . Once this step is completed with each indicator and in each of the 4 perspectives, the Excel sheet will be configured and will automatically transform into a Balanced Scorecard, allowing you to generate, for example, graphic reports with always updated data and information. that is considered appropriate.