Month No of Ratings
Jun 1876
Jul 2420
Aug 1081
Sep 205
No of Ratings
1876
2420
1081
205
Next Example
Q: Display the highest sales and lowest sales visually
Business Situation 1
Date 1-Jul 2-Jul 3-Jul 4-Jul 5-Jul 6-Jul 7-Jul 8-Jul 9-Jul 10-Jul 11-Jul 12-Jul 13-Jul 14-Jul
Sales 5166 8109 2526 7969 5393 5663 6906 5638 5562 8089 11694 5457 14227 7872
Q: Display the highest sales and lowest sales visually while Higher values should be in Green and Lower Values shou
Business Situation 2
Date 1-Jul 2-Jul 3-Jul 4-Jul 5-Jul 6-Jul 7-Jul 8-Jul 9-Jul 10-Jul 11-Jul 12-Jul 13-Jul 14-Jul
Sales 5166 8109 2526 7969 5393 5663 6906 5638 5562 8089 11694 5457 14227 7872
Q: Display the highest sales and lowest sales visually, while Highest values(7500 and above) should be in Green and
Business Situation 3
Date 1-Jul 2-Jul 3-Jul 4-Jul 5-Jul 6-Jul 7-Jul 8-Jul 9-Jul 10-Jul 11-Jul 12-Jul 13-Jul 14-Jul
Sales 5166 8109 2526 7969 5393 5663 6906 5638 5562 8089 11694 5457 14227 7872
15-Jul 16-Jul 17-Jul 18-Jul 19-Jul 20-Jul 21-Jul 22-Jul 23-Jul 24-Jul 26-Jul 27-Jul 28-Jul 29-Jul 30-Jul 31-Jul
7407 3135 7905 8716 7725 7571 10567 9517 4363 2637 1826 5185 5833 2662 2995 956
N
e
x
t
en and Lower Values should not be highlighted
15-Jul 16-Jul 17-Jul 18-Jul 19-Jul 20-Jul 21-Jul 22-Jul 23-Jul 24-Jul 26-Jul 27-Jul 28-Jul 29-Jul 30-Jul 31-Jul
7407 3135 7905 8716 7725 7571 10567 9517 4363 2637 1826 5185 5833 2662 2995 956
N
e
x
t
N
e
x
t
ve) should be in Green and lowest value(5000 and below) should be in red
15-Jul 16-Jul 17-Jul 18-Jul 19-Jul 20-Jul 21-Jul 22-Jul 23-Jul 24-Jul 26-Jul 27-Jul 28-Jul 29-Jul 30-Jul 31-Jul
7407 3135 7905 8716 7725 7571 10567 9517 4363 2637 1826 5185 5833 2662 2995 956
Next Example
N
e
x
t
N
e
x
t
N
e
x
t
Next Example
Q: Give a comparison Between Online and Physical Orders Visually
Business Situation 4
Product Online
Aloo Shots Pizzabun 1330
Crispy Chole Pizzabun 5395
Large Paneer Tikka Pizzabun 21000
Medium Crispy Chole Pizzabun 18365
Minty Pizzabun 2520
Paneer Tikka Pizzabun 6624
Q:
Do a Comparison Study for the Products Sold,
let Online and Physical Sales be independent
Business Situation 5
Product Online
Aloo Shots Pizzabun 1330
Crispy Chole Pizzabun 5395
Large Paneer Tikka Pizzabun 21000
Medium Crispy Chole Pizzabun 18365
Minty Pizzabun 2520
Paneer Tikka Pizzabun 6624
Q: Give a comparison Between Online and Physical Orders visually, Do not
display the Values (Only the Visual)
Business Situation 6
Product Online Growth
Aloo Shots Pizzabun 124
Crispy Chole Pizzabun 95
Large Paneer Tikka Pizzabun 3200
Medium Crispy Chole Pizzabun -83
Minty Pizzabun 62
Paneer Tikka Pizzabun -230
Q: Give a comparitive visual study, Do not display the Values (Only the
Visual) and the negative values should go the opposite way.
Business Situation 7
Product Online Growth
Aloo Shots Pizzabun 124
Crispy Chole Pizzabun 95
Large Paneer Tikka Pizzabun 840
Medium Crispy Chole Pizzabun -83
Minty Pizzabun 62
Paneer Tikka Pizzabun -230
nd Physical Orders Visually
Physical Visit
1995
21600
11378
12460
1680
5904
N
e
x
t
the Products Sold,
s be independent
Physical Visit
1995
21600
11378
12460
1680
5904
N
e
x
t
Physical Orders visually, Do not
y the Visual)
In store Growth
-165
216
1650
124
68
5904 N
e
x
t
display the Values (Only the
uld go the opposite way.
In store Growth
-165
216
648
124
68
590
Next Example
Give a comparative visual study in indicators for all the products, but for each
Q:
independantly
Business Situation 8
Product Jan Sales Feb Sales
Aloo Shots Pizzabun 3325 4,846
Crispy Chole Pizzabun 11245 16,388
Large Paneer Tikka Pizzabun 43250 63,029
Medium Crispy Chole Pizzabun 21970 32,017
Minty Pizzabun 4200 6,121
Paneer Tikka Pizzabun 12528 18,257
Q: Give a comparative visual study in indicators for all the products
Business Situation 9
Product Sales Avg Discount %
Aloo Shots Pizzabun 3325 46%
Crispy Chole Pizzabun 11245 50%
Large Paneer Tikka Pizzabun 43250 46%
Medium Crispy Chole Pizzabun 21970 45%
Minty Pizzabun 4200 47%
Paneer Tikka Pizzabun 12528 44%
Q: Give a comparative visual study in indicators for all the products
Business Situation 10
Product Sales Avg Discount %
Aloo Shots Pizzabun 3325 46%
Crispy Chole Pizzabun 11245 50%
Large Paneer Tikka Pizzabun 43250 46%
Medium Crispy Chole Pizzabun 21970 45%
Minty Pizzabun 4200 47%
Paneer Tikka Pizzabun 12528 44%
Q: Give a comparative visual study in indicators for all the products
Business Situation 11
Product Sales Avg Discount %
Aloo Shots Pizzabun 3325 46%
Crispy Chole Pizzabun 11245 50%
Large Paneer Tikka Pizzabun 43250 46%
Medium Crispy Chole Pizzabun 21970 45%
Minty Pizzabun 4200 47%
Paneer Tikka Pizzabun 12528 44%
the products, but for each month
Mar Sales
7,062
23,882
43,249
46,660
8,920
26,607
N
e
x
t
ors for all the products
No of Products Sold
196
1422
395
708
673
1334
N
e
x
t
ors for all the products
No of Products Sold
196
1422
395
708
673
1334
N
e
x
t
ors for all the products
No of Products Sold
196
1422
395
708
673
1334
Next Example
Q: Highlight the Top 10 days of sales throughout the month
Business Situation 12
Date 1-Jul 2-Jul 3-Jul 4-Jul 5-Jul 6-Jul 7-Jul 8-Jul 9-Jul 10-Jul 11-Jul 12-Jul 13-Jul 14-Jul
Sales 5166 8109 2526 7969 5393 5663 6906 5638 5562 8089 11694 5457 14227 7872
Q: Highlight the Bottom 10 days of sales throughout the month
Business Situation 13
Date 1-Jul 2-Jul 3-Jul 4-Jul 5-Jul 6-Jul 7-Jul 8-Jul 9-Jul 10-Jul 11-Jul 12-Jul 13-Jul 14-Jul
Sales 5166 8109 2526 7969 5393 5663 6906 5638 5562 8089 11694 5457 14227 7872
Q: Highlight the Top 3 and Bottom 3 days of sales throughout the month
Business Situation 14
Date 1-Jul 2-Jul 3-Jul 4-Jul 5-Jul 6-Jul 7-Jul 8-Jul 9-Jul 10-Jul 11-Jul 12-Jul 13-Jul 14-Jul
Sales 5166 8109 2526 7969 5393 5663 6906 5638 5562 8089 11694 5457 14227 7872
15-Jul 16-Jul 17-Jul 18-Jul 19-Jul 20-Jul 21-Jul 22-Jul 23-Jul 24-Jul 26-Jul 27-Jul 28-Jul 29-Jul 30-Jul 31-Jul
7407 3135 7905 8716 7725 7571 10567 9517 4363 2637 1826 5185 5833 2662 2995 956
N
e
x
t
15-Jul 16-Jul 17-Jul 18-Jul 19-Jul 20-Jul 21-Jul 22-Jul 23-Jul 24-Jul 26-Jul 27-Jul 28-Jul 29-Jul 30-Jul 31-Jul
7407 3135 7905 8716 7725 7571 10567 9517 4363 2637 1826 5185 5833 2662 2995 956
N
e
x
t
15-Jul 16-Jul 17-Jul 18-Jul 19-Jul 20-Jul 21-Jul 22-Jul 23-Jul 24-Jul 26-Jul 27-Jul 28-Jul 29-Jul 30-Jul 31-Jul
7407 3135 7905 8716 7725 7571 10567 9517 4363 2637 1826 5185 5833 2662 2995 956
N
e
x
t
N
e
x
t
