IN2004B: Generation of Value with Data Analytics
Department of Industrial Engineering
Once we know what indicators are, their role in the management process, and the types of indicators that exist, we ask ourselves:
Which indicators should we use?
How many indicators should we have?
What is an appropriate set of indicators?
How do we document and share them?
Although there are some indicators that could be generally applied to any company, each company has its own strategy, its own priorities, and its particular competitive environment
Therefore, the most appropriate set of indicators depends on each organization.
Here we describe models for finding the appropriate number and set of indicators.
The models for defining indicators depend on the type of strategic planning.
Three strategic planning frameworks are:
The models for defining indicators depend on the type of strategic planning.
Three strategic planning frameworks are:
It’s a model that helps organizations translate strategy into operational (measurable) objectives, resulting in actions, behaviors, and performance.
The BSC includes all critical success factors in a measurement system, giving organizations a better chance of achieving their goals.

Translate the strategy into measurable objectives.
Align the strategy components: objectives, indicators, and initiatives.
Communicate the strategy to the organization.
Create the basis for strategic management.
BSC transforms strategy into an integrated system defined through four perspectives:





For each perspective, the following should be defined:
A small set of strategic objectives
For each objective, one (or more if necessary) metric as a performance indicator
For each indicator, establish long- and short-term goals
Initiatives (programs, projects, actions) to close the gaps between current and desired performance according to the goals.
The strategy map displays the strategic objectives within each perspective using a matrix.
Possible causal relationships between objectives are also shown using arrows.
If the organization’s strategic charter (Vision and Mission) is reviewed, Strategic Themes can be included to show whether the organization is explicitly addressing these themes in its planning.
Once you have placed the objectives on the map, link them to each other, establishing cause-and-effect relationships between them.
You are also asked to select three of the objectives and propose at least one suggested metric for each.
Finally, you will write the justification for the established causal relationships.
Once the BSC model has been designed for the company, specific models are developed by functional area.
In the functional areas, work is based on the strategic objectives, identifying objectives specific to the functional area.
It is more common to use performance indicators than impact indicators at the departmental level.
Not all strategic themes are necessarily maintained across functional areas, nor do all areas necessarily have objectives from all BSC perspectives.
It is essential that functional managers fully understand the company’s BSC and their area’s contribution to the overall objectives.
The person responsible for BSC deployment must ensure the consistency and alignment of the functional BSCs.
Some organizational-level indicators are simply aggregations of departmental indicators.
When selecting and/or designing indicators, it is necessary to formally document the definition of each indicator.
Documentation is very useful because:
It helps clarify the meaning of the indicators.
It facilitates communication between users and indicator creators.
It serves as a future reference when revising the system.
Once the indicators are defined using the Balanced Scorecard (BSC) and the documentation format, we design dashboards with:
This applies to both the overall organizational level and the functional BSCs.
Various strategies can be followed to implement the dashboards, for example:
Development on a specialized platform for indicator systems (https://www.predictiveanalyticstoday.com/open-source-balanced-scorecard-software/)
Development with generic OLAP Online Analytical Processing tools (https://www.softwaretestinghelp.com/best-olap-tools/)
Short-term, isolated implementations in spreadsheets.
Free online tool by Google for building interactive dashboards and reports. Works directly in the web browser and it connects to many data sources:


The variables in the dataset.

The graphics available.

The dataset “McDonalds Financial Statements.xlsx” includes McDonald’s annual financial data over two decades, offering insights into its economic performance. The dataset contains records of the following indicators:
Let’s load the data into looker studio

We rename the report.

Let’s insert our first table

We can place the table anywhere in the dashboard canvas.

We change the graphic type by going to its properties.




We can change the layout of the table by changing the metrics in the style of the table


Change it to bars.

Show the number too.




We can edit the properties or layout of the number.








Tecnologico de Monterrey