Dashboards

Dashboard
• A dashboard can be defined as

“a data visualization tool that displays the current status of metrics

and key performance indicators (KPIs) simplifying complex data sets
to provide users with at a glance awareness of current performance”

Dashboards are a collection of widgets that give you an overview of the

reports and metrics you care about most.
Key Performance Indicators (KPI)
• KPI, or Key Performance Indicator, is a quantifiable metric that measures
the performance or progress of specific business goals and objectives.
• Definition:
A KPI is a measurable value that demonstrates how effectively a
company is achieving its objectives.
• Purpose:
KPIs help businesses set goals, track progress, and identify areas for
improvement.
• Examples:
Common KPIs include revenue, customer satisfaction, customer
lifetime value (CLV), conversion rate, and return on ad spend (ROAS).
Key Performance Indicators (KPI)
• Types:
• Financial KPIs: Track the financial health and performance of a
company, such as revenue, expenses, profit margins, and cash flow.
• Operational KPIs: Evaluate the efficiency of day-to-day operations,
from production to customer service.
• Marketing KPIs: Measure the effectiveness of marketing campaigns
and activities.
• Social Media KPIs: Track the performance of social media channels
and engagement.
• Importance:
KPIs are essential for monitoring performance, making data-
driven decisions, and ensuring that strategies are effective.
Examples of KPIs in different areas:
Sales: Number of leads generated, sales revenue, customer acquisition
cost.
Marketing: Website traffic, conversion rate, customer lifetime value.
Customer Service: Customer satisfaction score, customer retention
rate, average resolution time.
Operations: Production output, efficiency, lead time.
Types Of Dashboard
Types Of Dashboard
• Strategic - focused on long-term strategies and high-level metrics
• Operational - shows shorter time frames and operational processes.
• Analytical - contains vast amounts of data created by analysts.
• Tactical - used by mid-management to track performance.
Strategic Dashboard
• Purpose:
Strategic dashboards focus on long-term objectives and trends, rather
than real-time operational details.
• Audience:
They are typically designed for executives and other high-level
decision-makers who need a broad understanding of the company's
performance.
• Content:
Strategic dashboards present key performance indicators (KPIs) and
other relevant data in a concise and easily digestible format, often using
charts, graphs, and other visual representations.
Strategic Dashboard
• Functionality:
They allow users to quickly identify areas where the organization
is performing well or where improvements are needed, enabling them
to make informed strategic decisions.
• Examples:
A strategic dashboard might show trends in market share,
financial health, customer satisfaction, or innovation performance.
Strategic Dashboard
• Benefits:
• Strategic dashboards can help organizations:
• Improve strategic planning and decision-making.
• Monitor progress towards long-term goals.
• Identify potential risks and opportunities.
• Communicate performance to stakeholders.
Strategic Dashboard
Operational Dashboard
• An operational dashboard is a tool used to monitor and optimize
business operations in real-time, providing a snapshot of current
performance and enabling data-driven decision-making for day-to-day
activities.
• Purpose:
Operational dashboards are designed to help employees and managers monitor
key metrics and KPIs related to specific departments, products, processes, or
operations.
Operational Dashboard
• Key Features:
• Real-time data: They display up-to-the-minute information, allowing for
immediate insights into performance.
• Visualizations: Data is presented in a clear and concise manner through
charts, graphs, and other visual formats.
• Customization: Dashboards can be tailored to specific needs and roles,
focusing on relevant metrics.
• Examples of Metrics:
Operational dashboards might track things like sales performance, inventory
levels, customer satisfaction scores, production output, or website traffic.
Operational Dashboard
• Benefits:
• Improved decision-making: By providing a clear view of performance,
operational dashboards enable data-driven decisions.
• Enhanced efficiency: Real-time monitoring allows for quick identification and
resolution of issues, leading to improved efficiency.
• Increased accountability: Dashboards can help track progress towards goals
and hold individuals or teams accountable for their performance.
Operational Dashboard
Operational Dashboard
Analytical Dashboard
• An analytical dashboard is a tool that visualizes and summarizes data
to facilitate analysis and decision-making by presenting key metrics
and trends in an easily digestible format.
• Purpose:
Analytical dashboards are designed to provide a comprehensive
overview of data, enabling users to quickly identify patterns, trends,
and insights that can inform strategic decisions.
Analytical Dashboard
• Key Features:
• Data Visualization: They use charts, graphs, tables, and other visual elements
to represent data in a clear and concise manner.
• Real-time Data: Many dashboards can display real-time data from multiple
sources, allowing users to monitor performance and track progress
continuously.
• Interactive Elements: They often include interactive elements, such as filters
and drill-down capabilities, allowing users to explore the data in more detail.
• Key Performance Indicators (KPIs): Dashboards typically focus on key
performance indicators (KPIs) and other critical metrics that are relevant to
the specific business area or process they are designed to monitor.
Analytical Dashboard
• Benefits:
• Improved Decision-Making: By providing a clear and concise view of data,
dashboards can help users make more informed and timely decisions.
• Enhanced Collaboration: Dashboards can facilitate collaboration by providing
a shared view of data and performance metrics.
• Increased Efficiency: Dashboards can help users identify areas for
improvement and optimize processes.
• Faster Insights: They allow users to quickly identify trends and patterns in the
data, leading to faster insights and better decision-making.
Analytical Dashboard
Tactical Dashboard
• A tactical dashboard is a visual tool used to track and manage a company's
short to medium-term goals, providing detailed insights into ongoing
processes and activities, bridging strategic objectives with operational
execution.
• Purpose:
Tactical dashboards focus on the performance of specific projects,
departments, or processes, helping middle management and department
heads monitor progress and make informed decisions.
• Focus:
They offer real-time or near-real-time data to track the progress of
initiatives against set targets and goals, unlike strategic dashboards that
focus on long-term insights and operational dashboards that monitor day-to-
day activities.
Tactical Dashboard
• Key Features:
• Detailed Insights: Tactical dashboards provide in-depth analysis of
business performance, allowing users to drill down into data and
identify areas for improvement.
• Interactive: They are often interactive, allowing users to filter,
segment, and analyze data to gain a deeper understanding of
performance.
• Focused KPIs: Tactical dashboards typically focus on a smaller set of
key performance indicators (KPIs) relevant to specific areas of the
business.
Tactical Dashboard
• User Base:
• These dashboards are most useful for subject matter experts and
middle management from a particular area of the business.
• Examples:
• Tracking the progress of a specific marketing campaign.
• Monitoring the performance of a sales department.
• Analyzing the efficiency of a manufacturing process.
Tactical Dashboard
A good BI dashboard design
 Makes the complex simple: we have lots of information, lots of
data that changes all the time and different analytical needs and
questions. We want to take all this complexity and make it simple.
 Tells a clear story: we want to be able to connect data to its context
in the business and to answer the viewer’s questions. This is where
the visual layout of a dashboard plays a crucial role.
 Expresses the meaning of the data: the chosen data visualizations
need to correctly represent the data, and the information you want
to extract from it.
 Reveals details as needed: we want each viewer to have access to
the data they need – no less but also no more. Some users might
need to be able to see a more granular view of the data – others
could suffice with an overview.
Poor dashboard design
 Too many widgets (about 30 of them), visualization
and indicators creating visual clutter
 Basic questions such as “what is the total amount of
sales” take much more than 5 seconds to answer
 No organizing principle behind the visual layout –
widgets seem to be strewn randomly
 Tables in the bottom add very little in the way of
insights
 Good Dashboard design
 1. The 5 Second Rule
Your dashboard should provide the relevant information
in about 5 seconds.
 five-second rule – this is the amount of time you or the relevant
stakeholder should need to find the information you’re looking
for upon examining the dashboard.
 Of course, ad-hoc investigation will obviously take longer; but
the most important metrics, the ones that are most frequently
needed for the dashboard user during her workday, should
immediately ‘pop’ from the screen.
2. Logical Layout: The Inverted Pyramid
 Display the most significant insights on the top part
of the dashboard, trends in the middle, and
granular details in the bottom.
  3. Minimalism: Less is More
Each dashboard should contain no more than 5-9
visualizations.
4. Choosing the right data visualization
Select the appropriate type of data visualization according
to its purpose.
Visualization should serve a specific purpose and convey
specific facts in a more effective way than the basic tabular
format.
Dashboard for Healthcare
 encompass a wide variety of organizations and use
cases — from hospitals to medical equipment
manufacturers, and emergency rooms to intensive
care units.

dashboard metrics tracked by healthcare organizations

can be fairly similar to the ones monitored in other
industries such as finance or marketing

 business intelligence in hospitals presents a unique set of

potential insights that can help physicians save lives by
providing more effective and resourceful care to patients
Health care data sources
 Electronic medical records
 Electronic health records
 Specific department data
 Administrative data
 Financial data
Example healthcare metrics (KPI)
 Patient satisfaction
 Physician allocation
 Emergency room waittimes
 Number of occupied beds
Visualize the metrics – to provide more
insights
 Comparison of Cost of addmission in different
departments
Visualize trends and outliers
Hospital resource utilization – Patient
admision and ER stay
Leading diagnoses by number of
patients, cost and stay
Dashboard