# data[].attributes.body
The final activity requires you 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).

# data[].attributes.body
M1: I want to see the types of courses that is commonly availed.

M2: I want to see the age group of the users.

M3: I want to know when the customers are mostly availing of the service.

BIG IDEA: I want to prepare a marketing plan for the least sold service and presenting this ad to the age group with the highest chance of purchasing. I also want to know when this marketing plan should launch.

# data[].attributes.body
M1: I want to know the most availed type of course

M2: I want to know the most used enrollment source

M3: How many have completed the course

BIG IDEA:

Which type of enrollment source has the most number of students who have availed the course and to identify which platform is the best tool to encourage more students to avail.

# data[].attributes.body
M1: I would like to see the number of Covid-infected people.

M2: I want to demonstrate which city and region have been most affected.

M2: I want to show how many recovered and died during the COVID pandemic.

Big Idea: I want to raise awareness among all people, especially those who are most at risk of being affected and in worse conditions in each city.

# data[].attributes.body
M1: Iwant to know the total number of covid cases

M2: I want to know the age bracket of people affecte by covid

M3: I want to know the region with most affected number of covid cases

Big Ideas: This will prepare the health sectors on who will be the most vulnerable of having a covid and determine the region with high cases of covid to implement strict health protocol

# data[].attributes.body
M1: I want to know the most common course availed by the students

M2: I want to know the source with the most enrollment

M3: I want to know which source has the highest coupons used

BIG IDEA: I want to promote other courses with the least availment and identify the best platform for the different types of students.

# data[].attributes.body
M1: I want to know the most accessed/bought course online

M2: I want to check the most frequent activity online

M3: I want to know the most accessed online channel (FB, Google, Lazada, Shopee)

Big Idea: Create a marketing strategy to increase sales and possibly check if there's a need for a sales support channel

# data[].attributes.body
M1: I want to know how many people are affected by the contagious disease of covid

M2: I want to know the places affected by covid

M3: I want to know the age brackets

Big Idea: I want to present how important it is to make a strict countermeasure on how to lessen or eliminate the numbers of people who are getting affected by covid. I also want to know when is the soonest implementation of the rules or protocols.

# data[].attributes.body
M1: I want to see the number of Obese based on their BMI

M2: I want to see the department of the most common number of those who are Obese from their BMI

M3: I want to know the evaluation for those who are Obese

BIG IDEA: The Employer/HR can have a wellness program for the employees who are Obese for able to reduce the number of pending evaluations/complications on the next APE.

# data[].attributes.body
M1: I want to see what courses are more in demand

M2: I want to know what platform are mostly availing the service

M3. What is the most convenient course?

BIG IDEA: To seek knowledge and skills that not only align with personal interests and passions but also contribute to individual growth and a fulfilling and purpose-driven life.

# data[].attributes.body
M1: I want to know how many employees availed ACU per Dept

M2: I want to know the results of the ACU and segregate the results into Physically fit and with Findings

M3: I want to know the assigned nurse for each employees with Findings (e.g. overweight, obese 1, etc.)

Big Idea: I want to know the complete list for all employees with findings to further evaluate the results of their ACU and to prepare them for a Wellness care correspond to their findings.

# data[].attributes.body
M1: I want to see which country has the highest sales.

M2: I want to see which gender has the most purchases.

M3: I want to see what the best-selling product is.

BIG IDEA: I want to prepare a marketing plan on how we can sell more in the countries where our sales are low.

# data[].attributes.body
M1: I want to know the age group who are more prone in having COVID-19

M2: I want to know the most affected regions

M3: I want to know how many recovered and died during the Pandemic

Big Idea: I want to raise the awareness of people on who are most vulnerable in having Covid-19 and to determine the most affected regions to implement strict protocol.

# data[].attributes.body
M1: I want to see if COVID cases increases daily.

M2: I want to see how many patient recovered from COVID.

M3: I want to know How many Patient died from COVID.

BIG IDEA: I want to tell to people that COVID is not a joke, It can be cured but it is deadly. I want them to be more cautious with their health, especially for their family.

# data[].attributes.body
M1: I want to see how many are Overweight and Obese I to III

M2: I want to see how many are pending for further evaluation

M3: I want to know how many are Physically fit for all types of work has minor ailment/defect

BIG IDEA: I want to come up with a plan that will help them get back to their normal weight and be physically fit at work.

# data[].attributes.body
M1: I want to see the most availed item or product

M2: I want to see if what country are the most availer or purchase the items

M3: Identify the gender mostly availing the items

BIG IDEA: Create a plan on how to expand the marketing strategy and identify where and whom to be targeted. Also, analyzing the needs of the other customer per country.

# data[].attributes.body
Data Set 1 (Education)

Minute 1: I want to check the most common enrollment sources for the courses on the education website.

Minute 2: Identify the course or course that have the least number of

enrollees or purchases.

Minute 3: To see the course price relative to the number of enrollees.

Big Idea: To develop a plan to market the least availed course on the website and utilize that course on the most common

enrollment source to boost the number of enrollees.

# data[].attributes.body
M1: I want to know which among the group of men or women is most likely to be obese/overweight.

M2: I want to see the account that is most likely to be obese or in normal weight.

M3: want to understand why most members of the team are overweight or obese.

BIG IDEA: I want to prepare a diet plan for all the employees who are categorized as obese or overweight.

# data[].attributes.body
M1: I want to see which products have the lowest number of purchases.
M2: I want to see which country sells the least number of products with the lowest number of purchases.
M3: I want to know the gender that buys the product with the highest number of sales.

Big Idea: I want to prepare a marketing plan for the product with the lowest sales and create an ad or promotion for the specific countries that show a low number of sales.

# data[].attributes.body
M1: I want to see the employees that are beyond the normal BMI

M2: I want to see the department of the employees

M3: I want to know the number of employees that are under the BMIs: overweight, obese I, obese II and obese III

BIG IDEA: I want to present the current health situation of the employees based on their BMI to their respective department. I also want the management to be aware about this in order to come up with programs that promote health and wellness

# data[].attributes.body
M1: I want to see numbers of the total admitted of covid

M2: I want to see the top region or cities which has the higher admissions

M3: How many recovered from covid

Big ideas: This is to know how to improve more our healthcare services and to focus on the most affected or higher region/cities

# data[].attributes.body
M1: I want to know the most common diagnosis acquired by employees.

M2: I want to see the most numbers of employees who are overweight.

M3: I want to know when the employees mostly availing of the service.

BIG IDEA: I want to prepare a diet plan to ensure a healthy living.

# data[].attributes.body
DataSet 1

M1: I want to see the total amount of sales

M2: I want to see the most availed courses

M3: I want to know where were the courses purchased

Big Idea: This is to promote or either remove/replace the less availed courses. Prepare some coupons for the platforms where customers are mostly purchasing the courses from.

# data[].attributes.body
M1: I want to see data what is the age that is most affected by the COVID

M2: I want to know the number of recoveries

M3: I want to see the data where is the most affected cities with COVID

BIG IDEA: I want to know what are the safety measures to prevent COVID from spreading.

# data[].attributes.body
M1: I want to know the majority of the gender of the increase in covid cases.
M2: I want to see where the majority of the residents where the patient has positive covid.
M3: I also want to know the majority of the age who has been diagnosed with covid.

BIG Idea: I want to prepare a report regarding the most affected individuals based on age, gender, and place who have been diagnosed with COVID-19 to have more strictly imply the protocols.

# data[].attributes.body
M1: I want to see the number of people who underwent the Annual Physical Exam.

M2: I want to know the results of the tests who availed the Annual Physical Exam.

M3: I want to know the lifestyle of the employees.

BIG IDEA: I want to prepare wellness programs for the employees to create a healthy work environment involving various health activities to improve their wellbeing and work productivity.

# data[].attributes.body
M1: I want to see the number of employees that are Physically fit for all types of work has minor ailment/defect/ - Pending for further evaluation

M2: I want to know how many of them has a result under overweight

M3: I want to see the number of employees that are Physically fit for all types of work

BIG IDEA:

To have a wellness and program for all the employees, since the APE can make sure that the employee can safely perform the job

# data[].attributes.body
Dataset 3 APE result

M1: I want to see the most visited sites.

M2: I want to know which department/units complied.

M3: I want to know who are physically fit.

BIG IDEA: I want to prepare a plan for how to make employees' health and fit.

# data[].attributes.body
M1: I want to know the age group getting admitted

M2: I want to know the recovery and death rate of the age group

M3: I want to see the location with high 'admitted' rates

Big Idea:

To determine which location to focus on providing safety measures

# data[].attributes.body
M1: I want to see the course type that students want to enroll.

M2: I want to see the sales based on course type. from highest to lowest

M3: I want to know what is the most common platform used for enrollment.

Big Idea: I want to know the future trend of professions based on the current courses that students most commonly enrolled. I also want the government to focus on the type of services/products based on the current trend that most commonly enrolled for future economic growth.

# data[].attributes.body
M1: I want to see which product has the most number of orders.

M2: I want to know who (including the gender) is the frequent buyer and from which continent or country.

M3: I want to check which month has the highest sales.

BIG IDEA: I want to prepare a sales strategy to boost sales in months and areas that need the most, if there is a necessity to remove or improve some products in the line, and concentrate on selling to target demographics.

# data[].attributes.body
M1: I want to see the types of benefits that is most availed.

M2: I want to see the age bracket of the product.

M3: I want to see the price of product.

BIG IDEA: I want to prepare a Sales presentation for the applying Agent/Sales that will help and make an impact with the highest chance purchasing of the product.

# data[].attributes.body
M1: I want to determine the number or Covid infected person.

M2: I want to determine which area has a higher number of recovered patients from Covid

M3: I want to show then recovery percentage per area

Big Idea: I want to determine the safety precaution of some specific area with higher percentage of COVID recovery.

# data[].attributes.body
M1: I'd like to see what kinds of courses are typically available.

M2: I would like to know which tool is the most effective for enrolling in the course.

M3:I'd like to see the age range of the users.

Big idea: I want to create an advertisement for the most sold services and focus it on the age group with the best likelihood of purchase. I'd also like to know when the campaign will be online.

# data[].attributes.body
M1: I want to see the age group of the buyers.

M2: I want to see the types of product that is commonly avialed.

M3: I want to know the most country who availed the product.

BIG IDEA:

I want to show other countries the products that are sold online also strategy

# data[].attributes.body
M1: I want to see the results of ACU specifically for Uric acid and Cholesterol levels of targeted participants.

M2: I want to see their age and gender bracket.

M3: I want to see what are their lifestyle

Big Idea: I want to prepare an awareness program for employees regarding their health and wellness related to conditions that they may get with the 2 specified blood components.

# data[].attributes.body
M1: I would like to know which country has the most availability of the items.

M2: I want to see the most popular item.

M3: To determine which gender is primarily using the item.

BIG IDEA: Make a plan on how to broaden the marketing approach and decide who and where to target.

# data[].attributes.body
M1. I want to know the total number of patients admitted due to covid cases.

M2. I want to know the areas most affected by COVID.

M3. I want to know how many patients have recovered from COVID.

BIG IDEA:

To present the current health situation to the areas that are most affected by COVID for awareness and to promote preventive strategies for COVID Symptoms.

# data[].attributes.body
Data: Sales Report

M1: I want to see the demographic of the customers (Gender,Continent, Country)

M2: I want to see the sales performance per month

M3: I want to see the most saleable product

Big Idea: I want to present which among the products needs more boosting/marketing and also who and what country to target and what strategy to do during months with low sales performance.

# data[].attributes.attachment_link.title
M00 Review of Creating Charts in Excel_Bruce Fulgencio

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

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

# data[].attributes.attachment_link.description
Create a new spreadsheet and edit with others at the same time -- from your computer, phone or tablet. Get stuff done with or without an internet connection. Use Sheets to edit Excel files. Free from Google.

# data[].attributes.attachment_link.title
M00 Review of Creating Charts in Excel_Bruce Fulgencio

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

# data[].attributes.attachment_link.description
Create a new spreadsheet and edit with others at the same time -- from your computer, phone or tablet. Get stuff done with or without an internet connection. Use Sheets to edit Excel files. Free from Google.