Mercado, Ian V.
BSIT – 3109
Fundamentals of Business Analytics
Activity Data Visualizations
Table 1 A: MONTHLY SALES DATA OF AIR COMPRESSORS AT KIRKLAND INDUSTRIES
DATA
MONTHLY SALES DATA OF AIR COMPRESSORS AT KIRKLAND
INDUSTRIES
Sales
210
195
185
170 175
160
150 145
125 120 120
115
VISUALIZATION OF DATA
INTERPRETATION
The figure above shows the chart and linear trend line created through Excel. This
shows the monthly sales data of air compressors at Kirkland industries through lines. A
point is plotted on the line chart. This chart show the monthly sales of air compressor is
not consistent. In Jul air compressors have a highest sales and the lowest sales is in
Dec.
Table 1 B: REGIONAL SALES DATA BY MONTH FOR AIR COMPRESSORSAT KIRKLAND
INDUSTRIES
DATA
REGIONAL SALES DATA BY MONTH FOR AIR COMPRESSORS AT
KIRKLAND INDUSTRIES
160
140 135
120 115
120 110
95 100 100 100
100 85
75 75 80
80 65 65 70
55 60 60
60 45 50 50
40 40 40
40
20
0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales($100) North Sales($100) South
VISUALIZATION OF DATA
INTERPRETATION
The figure above shows the clustered column chart and created through Excel.
This chart contains the regional sales data by month for air compressor at Kirkland
industries it is separated by North (blue) and South (orange). This chart show that the
North have most sales rather than south. The highest sales of north are 135 and the
lowest is 40. The highest sales of south are 80 and the lowest is 40.
Table 2 A: SALES DATA OF COMPUTER AND PERIPHERALS AT SOUTHBOUND INC.
DATA
SALES DATA OF COMPUTER AND PHERIPERALS AT
SOUTHBOUND INC.
14
2015 15
39
12
90
2014 17
40
13
13
2013 10
45
12
78
2012 12
34
20
0 10 20 30 40 50 60 70 80 90 100
Desktop Computer Laptops Monitors Printers
VISUALIZATION OF DATA
INTERPRETATION
The figure above shows the clustered bar chart and created through Excel. This
chart contains the sales data of computer and peripherals at southbound Inc. This chart
shows the sales of computer parts by year
Table 2 B: SALES DATA OF COMPUTER AND PERIPHERALS AT SOUTHBOUND INC.
DATA
VISUALIZATION OF DATA
SALES DATA OF COMPUTER AND
PHERIPHERALS AT SOUTHBOUND INC.
Canada USA Russia Norway Germany
60
10
50 12
12 9
9 11
40 13
10 10 9
30 2
8
9 5 9
11
20 10 9
6 14
6 7 7
10 3 6
0
1994 1998 2002 2006 2010
INTERPRETATION
The figure above shows the stacked area chart and created through Excel. This
chart contains sales data of computer and peripherals at southbound Inc. This chart
shows the sales by 4 years in 5 countries.
Table 3: WHERE DO YOU GET MOST OF YOUR NEWS ABOUT NATIONAL AND
INTERNATIONAL ISSUES
DATA
WHERE DO YOU GET MOST OF YOUR NEWS ABOUT
NATIONAL AND INTERNATIONAL ISSUES?
90% 82% 80%
80% 74% 74% 73% 72% 74%
70% 70%
70% 66%
60%
50%
50% 45% 46%
42% 40% 41%
40% 36% 36% 34% 35% 35%
32% 31%
30% 21% 24%
21% 24% 24%
18% 20%
18% 20% 18% 17%
20% 13% 14% 16% 14% 13% 16%
10%
0%
2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010
Television Newspaper Internet Radio
VISUALIZATION OF DATA
INTERPRETATION
The figure above shows the clustered column chart and created through Excel.
This chart contains where can you get most of your news about national and
international issues. This chart show what people uses year by year to know the news in
national and international. The most medium that used is the television and the lowest is
the radio and internet.
Table 4: SALES DATA FOR A STATIONERY COMPANY
DATA
VISUALIZATION OF DATA
SALES DATA OF STATIONERY COMPANY
100
90
80
70
60
50
40
30
20
10
0
s t a l a l a l s t s t a l a l s t s t a l s t s t ci l e r ci l e n ci l e r ci l ci l ci l e r ci l e r e r
Ea entr entr entr We Ea entr entr We Ea entr Ea Ea Pen ind Pen P Pen ind Pen Pen Pen ind Pen ind ind
C C C C C C B B B B B
INTERPRETATION
The figure above shows the clustered column chart and created through Excel.
This chart contains sales data of stationery company. This chart shows how many
products were sold.
Table 5: SEASONAL HIGH AND LOW TEMPERATURES
DATA
SEASONAL HIGH AND LOW TEMPERATURES
120
100
80
60
40
20
0
i
nt
a
or
e on ago and llas ver roit ton City eles am lis l le ns rk ia ix gh ouis
la st c l a n t s i po shvi rlea Yo lph eon bur .l
At l tim B o i
Ch lev
e D De De
Hou
sa
s
A ng M
ne a a O e w de Ph itts St
Ba C n
Ka Los in N w N hi l a P
M Ne P
January High January Low July High July Low
VISUALIZATION OF DATA
INTERPRETATION
The figure above shows the clustered column chart and created through Excel.
This chart contains seasonal high and low temperature. This chart shows high and low
temperature in some countries.
