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.
Finally, you will write the justification for the established causal relationships.
Once the company-level Balanced Scorecard (BSC) is defined, each functional area develops its own BSC aligned with the overall strategy.
At the departmental level, leading indicators are more common than lagging indicators, since managers need timely signals to act.
Not all strategic themes or BSC perspectives must appear in every functional area; relevance depends on the area’s role in achieving company outcomes.
Functional managers must clearly understand how their indicators contribute to organization-level outcomes.
The person responsible for BSC deployment must ensure alignment and coherence across functional BSCs, avoiding conflicting signals.
Some organization-level lagging indicators are obtained by aggregating or consolidating 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