# data[].attributes.attachment_link.title
Belandres, Rea -  Dashboards using PivotTables

# data[].attributes.body
Minute 1: I want to show my audience who is the most affected region based on the mortality rate.

Minute 2: They need to know which city has the most affected by covid 19.

Minute 3: I want to show the percentage of how many patients are affected by the covid for the specific city.

The big idea: I want to convince them to provide or add more accredited clinics and hospitals under the city which affected the most impact.

# data[].attributes.body
I want to present the percentage of LOA issuance of Customer Support Specialist in London from July to September 2023.

I want to identify the highest percentage of the type of LOA issued by CSS on the 3rd Quarter of 2023.

I want to identify the percentage of LOA per type from July to September 2023.

BIG IDEA: I want to reveal to the Account in London their Outpatient availment based on the LOA issuance from July to September 2023.

# data[].attributes.attachment_link.title
Nancy Alfaro-Review of Creating Charts in Excel (1)

# data[].attributes.attachment_link.title
Nancy Alfaro - Psychology in Data Storytelling

# data[].attributes.attachment_link.title
Rizza Natividad-Review of Creating Charts in Excel

# data[].attributes.attachment_link.title
Rizza Natividad - Psychology in Data Storytelling

# data[].attributes.body
Minute 1: I want my audience to know the total number of covid cases for the month of March 2020 vs. April 2020.

Minute 2: They have to see a comparison of the age groups that COVID has affected.

Minute 3: I'd like to display the rate of mortality as well as the number of admitted patients who recovered.

BIG IDEA:

- I am highlighting to them the that the highest mortality rate is ages in 40-70 years of age.

# data[].attributes.attachment_link.title
M00 Review of Creating Charts in Excel - Altero

# data[].attributes.attachment_link.title
M00 Review of Creating Charts in Excel_APRILEEN CONSUL

# data[].attributes.body
Minute 1:

I WANT MY AUDIENCE TO KNOW THE TOTAL NUMBER OF COVID CASE

Minute 2:

THEY NEED TO SEE HOW MANY MALE AND FEMALE ADMITTED PER REGION

Minute 3:

I WANT TO SHOW THEM THE TOTAL NUMBER DIED

BIG IDEA:

I WANT TO ENCOURAGE THEM THE IMPORTANCE IN COMPLIANCE OF COVID PROTOCOLS

<<You need a chart that shows effect of compliance>>

# data[].attributes.body
Minute 1: I want my audience to know the number of employees who is eligible for APE

<<This seems not aligned with your big idea>

Minute 2:

What department has the greatest number of people with abnormal BMI readings? That is what I want my audience to know.

Minute 3:

I would like to display the percentage of overweight people in each division or department.

Big Idea: My intention is to motivate the management to try to reduce the number of overweight workers.

# data[].attributes.body
I want my audience to know how many of the members availed the APE has significant finding.

They need to see which department has the highest pending for evaluation.

<This visual is not aligned with your big idea>

I want to show the percentage of such increase to do recommendations regarding to their health.

Big Idea:

For the report, to show the highest cause of the significant findings. DDo some recommendations.

# data[].attributes.body
Minute 1: I want my audience to know the importance of health and wellness based on the data gathered from the Annual Check Up.

Minute 2: They need to see which departments has the most numbers of attendance/compliance.

Minute 3: To show the percentage of which departments that needs focus to comply.

Big Idea:

I want the management to make an effort in promoting the compliance of ACU for those department for proper monitoring of their health.

# data[].attributes.body
Minute 1: I want my audience to know the effects of having yearly APE

<<This is note related to your big idea>>

Minute 2: They need to know that any age can be overweight.

Minute 3: I want to show the percentage of BMI in any age.

BIG IDEA: I want to encourage the employees to do exercise and have a healthy diet.

# data[].attributes.headline
Marjorie Rivera - APE Result Presentation

# data[].attributes.subject
Marjorie Rivera - APE Result Presentation

# data[].attributes.body
Minute 1: To know the importance of the ACU availment

Minute 2: To present the health status of the employees

Minute 3: To show  how much the percentage (BMI results)on the status of the employees

The Big Idea:  For this report, most of the employees has minor ailment/defect but still they are fit to work. Let’s ensure that the our management will mandate all employees to avail ACU every year and will have a work life balance.

# data[].attributes.body
Covid cases

3 Minute Story

Minute 1: I want my audience to know the most affected age group of covid cases.

Minute 2: They need to see the comparison of gender affected by covid.

Minute 3: I want to show the place where the most affected covid cases.

Objective (Big idea): The dashboard should show the most affected of Covid. The goal is to see where and who needs more awareness on covid.

# data[].attributes.headline
Marjorie Rivera - APE Result presentation

# data[].attributes.subject
Marjorie Rivera - APE Result presentation

# data[].attributes.body
Minute 1: To know the importance of the ACU availment

<<How are you going to show the importance of ACU availment?>>

Minute 2: To present the health status of the employees

Minute 3: To show how much the percentage (BMI results)on the status of the employees

The Big Idea: For this report, most of the employees has minor ailment/defect but still they are fit to work. Let’s ensure that the our management will mandate all employees to avail ACU every year and will have a work life balance.

# data[].attributes.body
1. I want my audience to know the higher and lower Sales in annual from year 2022.

2. I want them to have the overiew of Sales tracker for the month of higher sales and decreased Sales.

I want to provide a sample and to how the sales movement in the market and to provide awareness to all my audience.

Big IDEA: To have them the Idea on how market value move over the year.

# data[].attributes.body
​Minute 1: I want my audience to know the ​numbers of employees who ​undergone APE for this year 2023​.

Minute 2:​ They need to see ​the number of employees based on the result of BMI.

Minute 3:​ I want to show the percentage of employee who are overweight.

The Big Idea: I want to encourage the management to make an effort to lower down the numbers of employees who are overweight.

# data[].attributes.headline
Janice Altero - APE Result (focus on BMI)

# data[].attributes.subject
Janice Altero - APE Result (focus on BMI)

# data[].attributes.body
Minute 1 - I want my audience to know the BMI result of each employee in each APE site

Minute 2 - the overall count of each BMI result in each APE Site

Minute 3 - the percentage of BMI results in each APE site

<SWAP THE ORDER, Minute 3 is more generic>>

The BIG idea = to let my audience know how many employees are physically fit and who are not

# data[].attributes.body
Mirasol Solano

Minute 1: To introduce the most enrolled educational website

Minute 2: To show course price for students

Minute 3: To show the percentage difference of education website, course type & course price enrolled

BIG IDEA: The list of educational websites that students can use in their online learning

# data[].attributes.body
Minute 1: I want to show you the data that we have for March and April 2020 we have reported 5,223.

Minute 2: Most of reported cases is in City of Manila, with the total of 451 peoples with the ages between 30 to 50 years old. 

Minute 3: This is to show how important the lockdown to the areas because of increasing of cases and to give LGU a decision making to implement ECQ /GCQ

Big idea: Because of this cases, the LGU decided to implement lockdown on the areas. 

# data[].attributes.body
Minute 1: I want the audience to know the volume of cases in NCR sites

Minute 2: They need to see the increase count of the Admitted cases based on the Age Group in NCR

<< This visual seems not aligned with your objectives and other charts>>

Minute 3: I want to show the percentage of increased Covid cases in NCR.

The Big Idea:

While exerting an effort to NCR, I want the government not just to focus on the giving resolution (providing PPEs, deploying staffs/doctors, medicines) in NCR sites but to also look in the Provincial sites to prevent the increasing of Covid cases in the Country.

# data[].attributes.body
Min. 1 - I want to now my audience to know what platform or app that needs to improve on the year 2022-2023.

Min. 2 - They need to see that Lazada app is hard to use that's why there are only few students used this platforms.

Min. 3 - I want to show the percentage difference in using the platforms we use to convince them to improve the platform for 2023-2024 enrollment.

Big Idea - I want to encourage the management to improve the platforms, like easy to use but complete to have more users and to see the worth of using the platform.

# data[].attributes.body
Minute 1: I want my audience to know the effect of self awareness with regards to their physical health.

Minute 2: They need to see the significance of health awareness.

Minute 3: I want to show the percentage difference of the employees who is not engaging with health awareness.

The Big Idea:

I want to encourage the management to do more health awareness programs to be able to prevent health issues and problems.

# data[].attributes.body
1. I want my audience to know the higher and lower Sales in annual from year 2022.

2. I want them to have the overiew of Sales tracker for the month of higher sales and decreased Sales.

I want to provide a sample and to how the sales movement in the market and to provide awareness to all my audience.

# data[].attributes.body
Minute 1: I want my audience to know the total number of covid patient

Minute 2: They need to see the total number of covid patient per area.

Minute 3: I want to show the total percentage which city has the highest number of patient

Big Idea: I want to encourage DOH to which city they have to focus in proving covid advisory and guidelines

# data[].attributes.body
MINUTE 1: I want my audience to know the outcome of the APE results ( BMI-normal, overweight, obese 1

MINUTE 2 : I want my audience to know what department has the highest employees with abnormal BMI results.

MINUTE 3: I want to show the percentage of employees with normal BMI, overweight and obese 1.

BIG IDEA: I want the nurses to know what department needs weight management program to help our employees to achieve maximum health benefit.

# data[].attributes.body
Minute 1: I want my audience to know which platforms are more usable for enrollment from September 2022 to January 2023

Minute 2: They need to see which platforms are more user-friendly for enrollment.

Minute 3: I want to display the percentage of platforms that are more convenient for enrollment.

BIG IDEA: I want to encourage everyone to explore the various types and conveniences offered by different enrollment platforms

# data[].attributes.body
M1: I want my audience to know which course are in demand for the school year 2022 - 2023

M2: Which platform are often used by the enrolees to proceed witht he enrollment

M3: Which platform to invest more in advertising the courses offered by the school

BIG IDEA: I want to encourage the management to determined which platform should they invest more to advertise the courses offerer

# data[].attributes.headline
3-minute Story (Dataset4 Sales Tracker)- Posadas, Jovic

# data[].attributes.subject
3-minute Story (Dataset4 Sales Tracker)- Posadas, Jovic

# data[].attributes.body
Minute 1:

I want my audience to know which product popular amongst our subscribers/consumers.

Minute 2:

My audience must be able to interpret which product is most sought after & who is the top consumer.

Minute 3:

I want to persuade management to increase production of the particularly popular product being purchased.

Big Idea:

I want to persuade management to focus on the increase of production, marketing &/or advertising of our popular products.

# data[].attributes.body
Minute 1: To present the increase of death claims in 2022-2023

Minute 2: To see the volume of claims in consumer, corporate and dedicated

Minute 3: I want to show the volume and increase of death claim which will help them to add manpower

The Big Idea:

I want the management to build a team that is solely in-charge and process death claim concerns. Which will help to process and monitor the death claim concerns.

# data[].attributes.body
Minute 1: I want my audience to be encouraged and to know how important the yearly APE in the company.

Minute 2: I want my audience to know the percentage of people who have already complied with the APE.

Minute 3: They need to see the percentage per department that has already been done in APE.

The Big Idea: I want my audience to be reminded of the yearly APE in the company.

# data[].attributes.body
I want to scrutinize the Customer Support Unit Primary Care Network direction from January 2023 to October 2023.

I want to identify the Customer Support Specialist with the highest Primary Care Network direction from January up to date.

I want to present the percentage per category of Primary Care Network direction from January up to date.

BIG IDEA: I want to reveal to the Customer Support Unit team on their contribution in the company by directing members in Primary Care Network.

# data[].attributes.body
Minute 1: I want my audience to know if age/age group, gender, location affects the possibilty to acquire COVID in year 2020

Minute 2:

They need to know if indeed age/age group, gender and location has relevance for acquiring the virus to do further precautions

Minute 3: I want to show how much is the percentage difference of those who acquired covid based on age/age group, gender/location

BIG IDEA: I want to encourage them to do preventive measures to avoid acquiring the virus

# data[].attributes.body
Minute 1: I want my audience to know the number of employees eligible for APE for year 2023

Minute 2: They need to see the number of employees from each department who took on the yearly APE.

Minute 3: I want to show the percentage rate for BMIs of this year’s APE.

The BIG idea: I want to encourage all of the employees to comply on the yearly APE mandated by the company to know if each employee are physically fit to work.

# data[].attributes.body
Minute 1: year-to-year comparison; OR

country-level; OR

broad aspect

Minute 2: monthly or yearly or quarterly comparison; OR

regional-level ; provincial-level; OR

specific aspect

Minute 3: detailed visual to influence the decision

BIG IDEA:

# data[].attributes.body
The final activity requires that you work together as a group to come up with a dashboard based on any of the data sets below. You can also use real data (you may scramble your data like change name, change hospital names, change actual numbers to prevent showing real data).