report:
- pros:
- is a static collection of data given to stakeholders periodically.
- giving snapshots of high level historical data for an organization.
- They can be designed and sent out periodically, often on a weekly or monthly basis, as organized and easy to reference information.
- They're quick to design and easy to use as long as you continually maintain them.
- reports use static data or data that doesn't change once it's been recorded, they reflect data that's already been cleaned and sorted.
- cons:
- reports don't show live, evolving data.
- need regular maintenance and aren't very visually appealing.
Dashboard:
-
pros
- monitors live, incoming data.
- give your team more access to information being recorded
- interact through data by playing with filters
- because they're dynamic, they have long-term value
- If stakeholders need to continually access information, a dashboard can be more efficient than having to pull reports over and over
Benefits |
For Data Analysts |
For Stakeholders |
Centralization |
Sharing a single source of data with all stakeholders |
Working with a comprehensive view of data, initiatives, objectives, projects, processes, and more |
Visualization |
Showing and updating live, incoming data in real time* |
Spotting changing trends and patterns more quickly |
Insightfulness |
Pulling relevant information from different datasets |
Understanding the story behind the numbers to keep track of goals and make data-driven decisions |
Customization |
Creating custom views dedicated to a specific person, project, or presentation of the data |
Drilling down to more specific areas of specialized interest or concern |
-
cons
- they take a lot of time to design and can actually be less efficient than reports
- If the base table breaks at any point, they need a lot of maintenance to get back up and running again.
- Dashboards can sometimes overwhelm people with information too.
Data and Metric
Metric
- A metric is a single, quantifiable type of data that can be used for measurement. Think of it this way.
Data
- starts as a collection of raw facts, until we organize them into individual metrics that represent a single type of data.
ROI, or Return on Investment
- is essentially a formula designed using metrics that let a business know how well an investment is doing.
Creating a dashboard
Here is a process you can follow to create a dashboard:
1. Identify the stakeholders who need to see the data and how they will use it
To get started with this, you need to ask effective questions. SMART question
2. Design the dashboard (what should be displayed)
Use these tips to help make your dashboard design clear, easy to follow, and simple:
- Use a clear header to label the information