5.1 Introduction 5.2 Management Level Wise 5.3 Functional Domain Wise

(1)

V: Analysis and Interpretation of

Business Intelligence Data

Analysis & interpretation of Data Part - I:

Application of Business Intelligence in Indian and Global

companies across different Industry Verticals, Functional

Domains & Management Levels.

5.1 Introduction

5.2 Management Level Wise

5.3 Functional Domain Wise

(2)

V: Analysis and Interpretation of

Business Intelligence Data

Business Intelligence:

Business Intelligence, or BI, refers to the process by which business and companies gather data, analyze it, and re-apply it in order to make the best possible business and financial model for their particular instance. It is a process for increasing the competitive advantage of a business by intelligent use of available data in decision making.

Questionnaire:

The questionnaire includes questions for collecting basic information of the targeted companies and focuses on following Functional domains:

1. Strategic domain

2. Sales & Marketing Domain 3. Operations Domain

As Business intelligence Technology caters mainly to Top level Management and partially Middle level Management personals for making informed decisions and defining strategies, the researcher has designed the questionnaire targeting data collection from following profiles:

Management Level Functional Domains Top Level Management Strategic domain

Strategic Level – Sales

Strategic Level – Marketing

Strategic level- Operations

Middle Level Management Managerial Level- Sales & Marketing

Managerial Level-

Operations

Table 5.1 Management Levels as Respondents

5.1 Introduction

(3)

V: Analysis and Interpretation of

Business Intelligence Data

For collecting the data to analyze the depth of the successful Application of Business intelligence Technology at particular management level in selected functional domain in selected organizations, the researcher used closed ended questionnaire with the scale as shown below:

Table 5.2 Response Scale

Respondents:

As the research was targeted to Analyze the application of Business intelligence focusing on four different Industry verticals:

FMCG Automobile Logistics Retail

The respondents were selected on that basis.

Values Meaning 1 very bad 2 bad 3 Neutral 4 good 5 very good

5.1 Introductions

(4)

V: Analysis and Interpretation of

Business Intelligence Data

The respondents were from Top level Management and Middle level Management to obtain and satisfy the targeted data collection need for the research. Such respondent includes:

Management Level Functional Domains Type of Respondents Top Level Management

Strategic domain CEO, MD, Directors etc..

Strategic Level – Sales

National Sales Head, VP Sales, AVP Sales etc…

Strategic Level – Marketing

National Marketing Head, VP Marketing, AVP Marketing etc… Strategic level-

Operations

COO, National Operations Head, VP Operations / Production, AVP

Operations / Production etc…

Management Level Functional Domains Type of Respondents Middle Level Management Managerial Level- Sales & Marketing

Sales & Marketing Manager, Regional Manager, Business

Development Manager Managerial Level-

Operations

Operations Manager, Production Planning & Control Manager,

Production Manager etc…

Table 5.3 Management Levels & Functional Domains

The data was collected from six different Respondents from various functional domains and Management levels from each targeted organization.

(5)

V: Analysis and Interpretation of

Business Intelligence Data

Industries Covered:

Sr. No.

Indian /

Foreign FMCG Automobile Logistics Retail

1 Indian Amul

India

Ashok

Leyland DTDC Big Bazaar

2 Indian Dabur Bajaj Auto First Flight Easy Day

3 Indian Godrej consumer products Hindustan Motors Gati More (Aditya Birla)

4 Indian ITC KOEL Kingfisher

Cargo Ltd. Reliance 5 Indian Marico Industries M&M Om Logistics RPG Retail 6 Indian Nirma Maruti Udyog Ltd Patel Logistics Shopper’s Stop

7 Indian Parle Agro TATA

Motors

Safe Express

Vishal Mega mart

8 Foreign Coca Cola Ford A.P Moeller Westside

9 Foreign Colgate-Palmolive General Motors DHL Bailian Group 10 Foreign Kraft

Foods Honda Fed Ex carrerfour

11 Foreign Nestle Hyundai Nippon

Express

Loblay's companies

12 Foreign P & G Mico

Bosch Ryder Metro AG

13 Foreign Phillip

Morris Renault

Tnt Post

Group Walmart

14 Foreign Unilever Toyota UPS Woolworth

Table 5.4 Various Indian & Foreign Industries as respondents

(6)

V: Analysis and Interpretation of

Business Intelligence Data

5.2.1.1 Top Level Management Comparison:

Ho: There is no significant difference in agreement level of BI Model at Top level Management of Indian Automobile Companies and Foreign Automobile Companies

H1: There is a significant difference in agreement level of BI Model at Top level Management of Indian Automobile Companies and Foreign Automobile Companies Sr. No. Name of the

Company Top Level Total Average Strategic Domain SL - Sales SL - Marketing SL - Operations 1 KEOL 41 34 34 27 136 34 2 TATA Motors 40 35 38 31 144 36 3 Bajaj Auto 38 37 34 29 138 34.5 4 M & M 40 37 38 33 148 37 5 Ashok Layland 40 23 37 23 123 30.75 6 Maruti 34 34 39 23 130 32.5 7 Hindustan Motors 39 24 38 20 121 30.25 Total 272 224 258 186 940 235 Count 7 7 7 7 7 Average 38.86 32.00 36.86 26.57 134.29 33.57 STDEV 2.34 5.94 2.04 4.76 10.18 2.54 Variance 5.48 35.33 4.14 22.62 103.57 6.47

Sr. No. Name of the Company

Top Level Total Average

Strategic Domain SL - Sales SL - Marketing SL - Operations 1 Mico 40 34 36 29 139 34.75 2 Ford 40 36 38 38 152 38 3 General Motors 45 31 37 27 140 35 4 Hyundai 40 35 31 24 130 32.5 5 Renault 40 35 36 33 144 32.5 6 Toyota 45 31 37 27 140 35 7 Honda 45 32 40 25 142 35.5 Total 295 234 255 203 987 246.75 Count 7 7 7 7 7 Average 42.14 33.43 36.43 29.00 141.00 34.75 STDEV 2.67 2.07 2.76 4.93 6.56 1.89 Variance 7.14 4.29 7.62 24.33 43.00 3.56

Table 5.5 Automobile Industry Top Level Management Data Analysis India vs. Global

5.2 Management

Levels

(7)

V: Analysis and Interpretation of

Business Intelligence Data

As shown in the table, the Highest agreement level of BI Model at top level management at Indian Automobile Manufacturing companies is achieved by Mahindra & Mahindra with the score of 148 along with the average ie. Mean 37 where as in foreign Automobile Manufacturing Companies it is Ford with the highest score of 152 along with the mean 38. Apparently, this shows that there is a difference at an agreement level of BI Model in Indian and Foreign Automobile Manufacturing Companies but after conducting T Test we can conclude as follows:

t-Test: Two-Sample Assuming Unequal Variances

Variable 1 Variable 2

Mean 141 134.2857143

Variance 43 103.5714286

Observations 7 7

Hypothesized Mean Difference 0

df 12 t Stat 1.467317771 P(T<=t) one-tail 0.086511442 t Critical one-tail 1.812461123 P(T<=t) two-tail 0.173022885 t Critical two-tail 2.17881283

In a T test for a 95% confidence level, If the significance level is greater than or equal to 0.05 then it signifies that there is no significance difference between implementation of BI at strategic level of Management in Indian companies and Foreign companies at Automobile Manufacturing Industry. From the T test Table we can derive that a significance level of 0 .17 has been achieved. This means the T test is showing no significance difference in agreement level of BI implementation at strategic level of management of foreign viz-a-viz Indian Automobile Manufacturing companies. Hence null hypothesis is accepted (T cal is less than T tab ) because T Cal = 1.467 is less than T tab = 2.178. So, we can conclude that at 95% confidence level there is no significant difference in an agreement level of BI Model at

(8)

V: Analysis and Interpretation of

Business Intelligence Data

Strategic level management of foreign vs. Indian Automobile Manufacturing companies.

5.2.1.2 Middle Level Management Comparison:

Ho: There is no significant difference in agreement level of BI Model at Middle level Management of Indian Automobile Companies and Foreign Automobile

Companies

H1: There is a significant difference in agreement level of BI Model at Middle level Management of Indian Automobile Companies and Foreign Automobile

Companies

Middle Level Total Average ML - Sales & Marketing ML - Operations 1 KEOL 44 47 91 45.5 2 TATA Motors 37 46 83 41.5 3 Bajaj Auto 36 44 80 40 4 M & M 38 43 81 40.5 5 Ashok Layland 33 35 68 34 6 Maruti 32 40 72 36 7 Hindustan Motors 29 36 65 32.5 Total 249 291 540 270 Count 7 7 7 7 Average 35.57 41.57 77.14 38.57 STDEV 4.86 4.72 9.19 4.60 Variance 23.62 22.29 84.48 21.12

Middle Level Total Average ML - Sales & Marketing ML - Operations 1 Mico 36 46 82 41 2 Ford 38 43 81 40.5 3 General Motors 42 51 93 46.5 4 Hyundai 37 47 84 42 5 Renault 38 43 81 40.5 6 Toyota 42 42 84 42 7 Honda 40 51 91 45.5 Total 273 323 596 298 Count 7 7 7 7 Average 39.00 46.14 85.14 42.57 STDEV 2.38 3.76 4.88 2.44 Variance 5.67 14.14 23.81 5.95

5.2 Management

Levels

(9)

V: Analysis and Interpretation of

Business Intelligence Data

As shown in the table, the Highest agreement level of BI Model at Middle level management at Indian Automobile Manufacturing companies is achieved by Kirloskar Oil Engines Limited with the score of 91 along with the average ie. Mean 45.5 where as in foreign Automobile Manufacturing Companies it is Honda with the highest score of 91 along with the mean 45.5. Apparently, this shows that there is a difference at an agreement level of BI Model in Indian and Foreign Automobile Manufacturing Companies but after conducting T Test we can conclude as follows:

Mean 85.1428571 77.14285714

Variance 23.8095238 84.47619048

5.2 Management

Levels

(10)

V: Analysis and Interpretation of

Business Intelligence Data

In a T test for a 95% confidence level, If the significance level is greater than or equal to 0.05 then it signifies that there is no significance difference between implementation of BI at strategic level of Management in Indian companies and Foreign companies at Automobile Manufacturing Industry.

From the T test Table we can derive that a significance level of 0.072 has been achieved. This means the T test is showing no significance difference in agreement level of BI implementation at Middle Level of management of foreign viz-a-viz Indian Automobile Manufacturing companies. Hence null hypothesis is accepted (T cal is less than T tab ) because T Cal = 2.034012 is less than T tab = 2.178. So, we can conclude that at 95% confidence level there is no significant difference in an agreement level of BI Model at Middle level management of foreign vs. Indian Automobile Manufacturing companies.

(11)

V: Analysis and Interpretation of

Business Intelligence Data

5.2.2.1 Top Level Management Comparison:

Sr. No. Name of the Company

Strategic Level SL- Sales SL - Marketing SL - Operations 1 Unilever 46 35 39 30 150 37.5 2 Coca Cola 44 37 35 33 149 37.25 3 Colgate Palmolive 41 32 41 29 143 35.75 4 P & G 44 34 39 32 149 37.25 5 Nestle 45 33 38 25 141 35.25 6 Phillip Morris 43 35 34 30 142 35.5 7 Kraft Food 42 31 33 23 129 32.25 Total 305 237 259 202 1003 250.75 Count 7 7 7 7 7 Average 43.57 33.86 37.00 28.86 143.29 35.82 STDEV 1.72 2.04 3.00 3.63 7.32 1.83 Variance 2.95 4.14 9.00 13.14 53.57 3.35

Strategic Level SL - Sales SL - Marketing SL - Operations 1 Amul India Pvt. Ltd. 44 31 39 23 137 34.25 2 Marico Industries 38 31 34 31 134 33.5 3 ITC 41 34 37 30 142 35.5 4 Parle Agro 34 32 35 29 130 32.5 5 Nirma 41 27 37 29 134 33.5 6 Godrej Consumer Products 42 34 35 33 144 36 7 Dabur 41 35 38 31 145 36.25 Total 281 224 255 206 966 241.5 Count 7 7 7 7 7

Ho: There is no significant difference in agreement level of BI Model at Top level Management of Indian FMCG Companies and Foreign FMCG Companies H1: There is a significant difference in agreement level of BI Model at Top level

Management of Indian FMCG Companies and Foreign FMCG Companies

5.2.2 FMCG Industry Analysis

(12)

V: Analysis and Interpretation of

Business Intelligence Data

Average 40.14 32.00 36.43 29.43 138.00 34.50 STDEV 3.24 2.71 1.81 3.15 5.74 1.44 Variance 10.48 7.33 3.29 9.95 33.00 2.06

Table 5.7 FMCG Industry Top Level Management Data Analysis India vs. Global As shown in the table, the highest agreement level of BI Model at Top level management at Indian FMCG companies is achieved by Dabur with the score of 145 along with the average i.e. Mean 36.25 where as in foreign FMCG Companies it is Unilever with the highest score of 150 along with the mean 37.5. Apparently, this shows that there is a difference at an agreement level of BI Model in Indian and Foreign FMCG Companies but after conducting T Test we can conclude as follows:

In a T test for a 95% confidence level, If the significance level is greater than or equal to 0.05 then it signifies that there is no significance difference between implementation of BI at strategic level of

Variable 1 Variable 2 Mean 143.2857143 138 Variance 53.57142857 33 Observations 7 7 Hypothesized Mean Difference 0 Df 12 t Stat 1.503022258 P(T<=t) one-tail 0.080493926 t Critical one-tail 1.795884819 P(T<=t) two-tail 0.160987852 t Critical two-tail 2.17881283

5.2 Management

Levels

(13)

V: Analysis and Interpretation of

Business Intelligence Data

Management in Indian companies and Foreign companies at FMCG Industry.

From the T test Table we can derive that a significance level of 0 .16 has been achieved. This means the T test is showing no significance difference in agreement level of BI implementation at strategic level of management of foreign viz-a-viz Indian FMCG companies. Hence null hypothesis is accepted (T cal is less than T tab ) because T Cal = 1.503 is less than T tab = 2.178. So, we can conclude that at 95% confidence level there is no significant difference in an agreement level of BI Model at Strategic level management of foreign vs. Indian FMCG Companies.

(14)

V: Analysis and Interpretation of

Business Intelligence Data

5.2.2.2 Middle Level Management Comparison:

Sr. No.

Name of the Company

Middle Level Total Average

ML - Sales & Marketing ML - Operations 1 Unilever 44 41 85 42.5 2 Coca Cola 43 45 88 44 3 Colgate Palmolive 47 49 96 48 4 P & G 46 46 92 46 5 Nestle 46 46 92 46 6 Phillip Morris 41 45 86 43 7 Kraft Food 46 46 92 46 Total 313 318 631 315.5 Count 7 7 7 7 Average 44.71 45.43 90.14 45.07 STDEV 2.14 2.37 3.93 1.97 Variance 4.57 5.62 15.48 3.87 Sr. No. Name of the Company Middle Level Total Average ML - Sales & Marketing ML - Operations 1 Amul India Pvt. Ltd. 41 34 75 37.5 2 Marico Industries 39 45 84 42 3 ITC 41 45 86 43 4 Parle Agro 37 40 77 38.5 5 Nirma 35 40 75 37.5 6 Godrej Consumer Products 39 44 83 41.5 7 Dabur 40 40 80 40 Total 272 288 560 280 Count 7 7 7 7 Average 38.86 41.14 80.00 40.00 STDEV 2.19 3.93 4.47 2.24 Variance 4.81 15.48 20.00 5.00

Ho: There is no significant difference in agreement level of BI Model at Middle level Management of Indian FMCG Companies and Foreign FMCG Companies H1: There is a significant difference in agreement level of BI Model at Middle level

Management of Indian FMCG Companies and Foreign FMCG Companies

(15)

V: Analysis and Interpretation of

Business Intelligence Data

As shown in the table, the Highest agreement level of BI Model at Middle level management at Indian FMCG companies is achieved by ITC with the score of 86 along with the average ie. Mean 43 where as in foreign FMCG Companies it is Colgate Palmolive with the highest score of 96 along with the mean 48. Apparently, this shows that there is a difference at an agreement level of BI Model in Indian and Foreign FMCG Companies but after conducting T Test we can conclude as follows:

Mean 90.1428571 80

Variance 15.4761905 20

In a T test for a 95% confidence level, If the significance level is greater than or equal to 0.05 then it signifies that there is a significance difference between implementation of BI at strategic level of Management in Indian companies and Foreign companies at FMCG Industry.

(16)

V: Analysis and Interpretation of

Business Intelligence Data

From the T test Table we can derive that a significance level of 0.0007 has been achieved. This means the T test is showing a significance difference in agreement level of BI implementation at Middle level of management of foreign viz-a-viz Indian FMCG companies. Hence null hypothesis is Rejected (T cal is greater than T tab) because T Cal = 4.505 is greater than T tab = 2.178. So, we can conclude that at 95% confidence level there is a significant difference in an agreement level of BI Model at Middle level management of foreign vs. Indian FMCG companies.

(17)

V: Analysis and Interpretation of

Business Intelligence Data

5.2.3.1 Top Level Management Comparison:

Ho: There is no significant difference in agreement level of BI Model at Top level Management of Indian Logistic Companies and Foreign Logistic Companies H1: There is a significant difference in agreement level of BI Model at Top level Management of Indian Logistic Companies and Foreign Logistic Companies

Sr. No.

Name of the Company

Top Level Total

Average Strategic Level SL - Sales SL - Marketing SL - Operations 1 Kingfisher Cargo 39 32 42 30 143 35.75 2 First Flight 45 33 41 28 147 36.75 3 Gati 40 35 37 29 141 35.25 4 Safe Express 42 33 37 29 141 35.25 5 Patel Logistics 42 33 37 33 145 36.25 6 OM Logistics 45 30 39 26 140 35 7 DTDC 43 30 41 33 147 36.75 Total 296 226 274 208 1004 251 Count 7 7 7 7 7 Average 42.29 32.29 39.14 29.71 143.43 35.86 STDEV 2.29 1.80 2.19 2.56 2.94 0.73 Variance 5.24 3.24 4.81 6.57 8.62 0.54 Sr. No. Name of the Company

Average Strategic Level SL - Sales SL - Marketing SL - Operations 1 DHL 41 35 38 31 145 36.25 2 UPS 39 32 39 32 142 35.5 3 Fed Ex 40 35 36 33 144 36 4 Ryder 44 37 38 29 148 37 5 Nippon 44 33 38 29 144 37 6 APM 42 35 36 28 141 35.25 7 TNT 44 37 38 31 150 37.5 Total 294 244 263 213 1014 253.5 Count 7 7 7 7 7 Average 42.00 34.86 37.57 30.43 144.86 36.36 STDEV 2.08 1.86 1.13 1.81 3.18 0.84 Variance 4.33 3.48 1.29 3.29 10.14 0.71

Table 5.9 Logistic Industry Top Level Management Data Analysis India vs. Global

5.2.3 logistic Industry Analysis

(18)

V: Analysis and Interpretation of

Business Intelligence Data

As shown in the table, the Highest agreement level of BI Model at strategic level management at Indian Logistics companies is achieved by First Flight with the score of 147 along with the average ie. Mean 36.75 where as in foreign Logistics Companies it is T & T with the highest score of 150 along with the mean 37. 5. Apparently, this shows that there is a difference at an agreement level of BI Model in Indian and Foreign Logistics l Companies but after conducting T Test we can conclude as follows :

Mean 144.8571429 143.4285714

Variance 10.14285714 8.619047619

In a T test for a 95% confidence level, If the significance level is greater than or equal to 0.05 then it signifies that there is no significance difference between implementation of BI at strategic level of Management in Indian companies and Foreign companies at Logistics Industry.

From the T test Table we can derive that a significance level of 0.4 has been achieved. This means the T test is showing no significance difference in agreement level of BI implementation at strategic level of

(19)

V: Analysis and Interpretation of

Business Intelligence Data

management of foreign viz-a-viz Indian Logistics companies. Hence null hypothesis is accepted (T cal is less than T tab ) because T Cal = 0.872 is less than T tab = 2.178. So, we can conclude that at 95% confidence level there is no significant difference in an agreement level of BI Model at Strategic level management of foreign vs. Indian Logistics Companies.

(20)

V: Analysis and Interpretation of

Business Intelligence Data

5.2.3.2 Middle Level Management Comparison:

Ho: There is no significant difference in agreement level of BI Model at Middle level Management of Indian Logistic Companies and Foreign Logistic Companies

H1: There is a significant difference in agreement level of BI Model at Middle level Management of Indian Logistic Companies and Foreign Logistic Companies Sr. No. Name of the Company

Middle Level Total Average ML - Sales & Marketing ML - Operations 1 Kingfisher Cargo 41 38 79 39.5 2 First Flight 41 49 90 45 3 Gati 42 45 87 43.5 4 Safe Express 44 47 91 45.5 5 Patel Logistics 41 45 86 43 6 OM Logistics 38 42 80 40 7 DTDC 37 42 79 39.5 Total 284 308 592 296 Count 7 7 7 7 Average 40.57 44.00 84.57 42.29 STDEV 2.37 3.65 5.19 2.60 Variance 5.62 13.33 26.95 6.74 Sr. No. Name of the Company

Middle Level Total Average ML - Sales & Marketing ML - Operations 1 DHL 41 45 86 43 2 UPS 41 45 86 43 3 Fed Ex 38 43 81 40.5 4 Ryder 39 44 83 41.5 5 Nippon 38 44 82 41 6 APM 43 38 81 40.5 7 TNT 46 47 93 46.5 Total 286 306 592 296 Count 7 7 7 7 Average 40.86 43.71 84.57 42.29 STDEV 2.91 2.81 4.28 2.14 Variance 8.48 7.90 18.29 4.57

Table 5.10 Logistic Industry Middle Level Management Data Analysis India vs. Global

(21)

V: Analysis and Interpretation of

Business Intelligence Data

As shown in the table, the Highest agreement level of BI Model at Middle level management at Indian Logistics companies is achieved by Safe Express with the score of 91 along with the average ie. Mean 45.5 where as in foreign Logistics Companies it is T & T with the highest score of 93 along with the mean 46.5. Apparently, this shows that there is a difference at an agreement level of BI Model in Indian and Foreign Logistics Companies but after conducting T Test we can conclude as follows:

In a T test for a 95% confidence level, If the significance level is greater than or equal to 0.05 then it signifies that there is no significance difference between implementation of BI at strategic level of Management in Indian companies and Foreign companies at Logistics Industry.

Variable 1 Variable 2 Mean 84.5714286 84.57142857 Variance 18.2857143 26.95238095 Observations 7 7 Hypothesized Mean Difference 0 Df 12 t Stat 0 P(T<=t) one-tail 0.5 t Critical one-tail 1.78228756 P(T<=t) two-tail 1 t Critical two-tail 2.17881283

5.2 Management

Levels

(22)

V: Analysis and Interpretation of

Business Intelligence Data

From the T test Table we can derive that a significance level of 1 has been achieved. This means the T test is showing no significance difference in agreement level of BI implementation at Middle level of management of foreign viz-a-viz Indian Logistics companies. Hence null hypothesis is Accepted (T cal is less than T tab ) because T Cal = 0 is Less than T tab = 2.178. So, we can conclude that at 95% confidence level there is no significant difference in an agreement level of BI Model at Middle level management of foreign vs. Indian Logistics companies.

(23)

V: Analysis and Interpretation of

Business Intelligence Data

5.2.4.1 Top Level Management Comparison:

Ho: There is no significant difference in agreement level of BI Model at Top level Management of Indian Retail Companies and Foreign Retail Companies H1: There is a significant difference in agreement level of BI Model at Top level

Management of Indian Retail Companies and Foreign Retail Companies

Sr. No. Name of the Company

Average Strategic Level SL - Sales SL - Marketing SL - Operations 1 Reliance 39 35 40 37 151 37.75 2 Big Bazar 43 31 37 27 138 34.5 3 More 42 37 37 31 147 36.75 4 RPG 38 36 39 31 144 36 5 Easy Day 38 32 42 31 143 35.75 6 Vishal Mega Mart 39 33 34 31 137 34.25 7 West Side 39 35 34 31 139 34.75 Total 278 239 263 219 999 249.75 Count 7 7 7 7 7 7 Average 39.71 34.14 37.57 31.29 142.71 35.68 STDEV 1.98 2.19 2.99 2.93 5.12 1.28 Variance 3.90 4.81 8.95 8.57 26.24 1.64 Sr. No. Name of the Company

Strategic Level SL - Sales SL - Marketing SL - Operations 1 Shopper's Stop 42 37 39 31 149 37.25 2 Walmart 40 35 36 33 144 36 3 Carrer Four 41 32 37 31 141 35.25 4 Metro AG 41 33 34 31 139 34.75 5 Wool Worth 42 34 36 32 144 34.75 6 Lobaly 38 32 35 28 133 33.25 7 Bailian 41 32 39 28 140 35 Total 285 235 256 214 990 247.5 Count 7 7 7 7 7 Average 40.71 33.57 36.57 30.57 141.43 35.18 STDEV 1.38 1.90 1.90 1.90 5.00 1.23 Variance 1.90 3.62 3.62 3.62 24.95 1.51

Table 5.11 Retail Industry Top Level Management Data Analysis India vs. Global

5.2 Management

Levels

(24)

V: Analysis and Interpretation of

Business Intelligence Data

As shown in the table, the Highest agreement level of BI Model at strategic level management at Indian Retail companies is achieved by Reliance Industries with the score of 151 along with the average ie. Mean 37.75 where as in foreign Retail Companies it is Shopper’s Stop with the highest score of 149 along with the mean 37.25. Apparently, this shows that there is a difference at an agreement level of BI Model in Indian and Foreign Retail Companies but after conducting T Test we can conclude as follows :

Mean 141.4285714 142.7142857

Variance 24.95238095 26.23809524

df 12 t Stat -0.475443489 P(T<=t) one-tail 0.321504147 t Critical one-tail 1.782287556 P(T<=t) two-tail 0.643008294 t Critical two-tail 2.17881283

In a T test for a 95% confidence level, If the significance level is greater than or equal to 0.05 then it signifies that there is no significance difference between implementation of BI at strategic level of Management in Indian companies and Foreign companies at Retail Industry.

From the T test Table we can derive that a significance level of 0 .64 has been achieved. This means the T test is showing no significance

(25)

V: Analysis and Interpretation of

Business Intelligence Data

difference in agreement level of BI implementation at strategic level of management of foreign viz-a-viz Indian Retail companies. Hence null hypothesis is accepted (T cal is less than T tab) because T Cal = 0.475 is less than T tab = 2.178. So, we can conclude that at 95% confidence level there is no significant difference in an agreement level of BI Model at Strategic level management of foreign vs. Indian Retail Companies.

(26)

V: Analysis and Interpretation of

Business Intelligence Data

5.2.4.2 Middle Level Management Comparison:

Ho: There is no significant difference in agreement level of BI Model at Middle level Management of Indian Retail Companies and Foreign Retail Companies

H1: There is a significant difference in agreement level of BI Model at Middle level Management of Indian Retail Companies and Foreign Retail Companies Sr. No. Name of the Company

Middle Level Total Average ML - Sales & Marketing ML - Operations 1 Reliance 40 44 84 42 2 Big Bazar 42 64 106 53 3 More 42 45 87 43.5 4 RPG 41 48 89 44.5 5 Easy Day 41 45 86 43 6 Vishal Mega Mart 43 44 87 43.5 7 West Side 38 45 83 41.5 Total 287 335 622 311 Count 7 7 7 7 Average 41.00 47.86 88.86 44.43 STDEV 1.63 7.24 7.82 3.91 Variance 2.67 52.48 61.14 15.29

Middle Level Total Average ML - Sales & Marketing ML - Operations 1 Shopper's Stop 41 48 89 44.5 2 Walmart 38 43 81 40.5 3 Carrer Four 42 44 86 43 4 Metro AG 41 45 86 43 5 Wool Worth 40 44 84 42 6 Lobaly 44 46 90 45 7 Bailian 42 47 89 44.5 Total 288 317 605 302.5 Count 7 7 7 7 Average 41.14 45.29 86.43 43.21 STDEV 1.86 1.80 3.21 1.60 Variance 3.48 3.24 10.29 2.57

Table 5.12 Retail Industry Middle Level Management Data Analysis India vs. Global

(27)

V: Analysis and Interpretation of

Business Intelligence Data

As shown in the table, the Highest agreement level of BI Model at Middle level management at Indian Retail companies is achieved by Big Bazar with the score of 106 along with the average ie. Mean 53 where as in foreign Retail Companies it is Lobaly with the highest score of 90 along with the mean 45. Apparently, this shows that there is a difference at an agreement level of BI Model in Indian and Foreign Retail Companies but after conducting T Test we can conclude as follows:

Mean 86.4285714 88.85714286

Variance 10.2857143 61.14285714

df 12 t Stat -0.76026311 P(T<=t) one-tail 0.23445426 t Critical one-tail 1.85954804 P(T<=t) two-tail 0.46890852 t Critical two-tail 2.17881283

In a T test for a 95% confidence level, If the significance level is greater than or equal to 0.05 then it signifies that there is no significance difference between implementation of BI at strategic level of Management in Indian companies and Foreign companies at Retail Industry.

From the T test Table we can derive that a significance level of 0.46 has been achieved. This means the T test is showing no significance

(28)

V: Analysis and Interpretation of

Business Intelligence Data

difference in agreement level of BI implementation at Middle level of management of foreign viz-a-viz Indian Retail companies. Hence null hypothesis is Accepted (T cal is less than T tab) because T Cal = 0.76 is Less than T tab = 2.178. So, we can conclude that at 95% confidence level there is no significant difference in an agreement level of BI Model at Middle level management of foreign vs. Indian Retail companies.

(29)

V: Analysis and Interpretation of

Business Intelligence Data

5.3.1.1 Analysis of Strategic domain at Automobile Manufacturing

Industry in Foreign v/s Indian Companies:

Sr.

No.

Name of the

Company

Strategic

domain

Total

1 KEOL 41 41 2 TATA Motors 40 40 3 Bajaj Auto 38 38 4 M & M 40 40 5 Ashok Layland 40 40 6 Maruti 34 34 7 Hindustan Motors 39 39 Total 272 272 Count 7 7 Average 38.86 38.86 STDEV 2.34 2.34 Variance 5.48 5.48 Sr. No. Name of the Company Strategic domain Total 1 Mico 40 40 2 Ford 40 40 3 General Motors 45 45 4 Hyundai 40 40 5 Renault 40 40

5.3 Functional

Domains

(30)

V: Analysis and Interpretation of

Business Intelligence Data

6 Toyota 45 45 7 Honda 45 45 Total 295 295 Count 7 7 Average 42.14 42.14 STDEV 2.67 2.67 Variance 7.14 7.14

Table 5.13 Analysis of Strategic domain at Automobile Manufacturing Industry in Foreign v/s Indian Companies

As shown in the table, the highest agreement level of BI Model at Strategic domain at Indian Automobile Manufacturing companies is achieved by Kirloskar Oil Engines Limited with the score of 41 where as in foreign Automobile Manufacturing Companies there are three companies such as General Motors, Toyota and Honda with the highest score of 45. Apparently, this shows that there is a difference at an agreement level of BI Model in Indian and Foreign Automobile Manufacturing Companies at Strategic domain but after conducting T Test we can conclude as follows:

H0: There is no Significant Difference in the Agreement Level of BI Model in Indian Automobile Manufacturing Companies At functional domain of Strategic domain at functional domain of Strategic domain. H1: There is a Significant Difference in the Agreement Level of BI Model in Indian Automobile Manufacturing Companies At functional domain of Strategic domain at functional domain of Strategic domain.

T Test Table Variable 1 Variable 2 Mean 42.14285714 38.85714286 Variance 7.142857143 5.476190476 Observations 7 7

5.3 Functional

Domains

(31)

V: Analysis and Interpretation of

Business Intelligence Data

Hypothesized Mean Difference 0 df 12 t Stat 2.447177812 P(T<=t) one-tail 0.01537577 t Critical one-tail 1.782287556 P(T<=t) two-tail 0.03075154 t Critical two-tail 2.17881283

In a T test for a 95% confidence level, if the significance level is greater than or equal to 0.05 then it signifies that there is no significance difference between implementation of BI at Top level of Management in Indian companies and foreign companies at Automobile Manufacturing Industry.

From the T test Table we can derive that two tailed significance level of 0.03 has been achieved. This means the T test is showing a significance difference in agreement level of BI implementation at Strategic domain of foreign viz-a-viz Indian Automobile Manufacturing companies. Hence null hypothesis is Rejected (T cal is More than T tab) because T Cal = 2.447178 is More than T tab = 2.178. So, we can conclude that at 95% confidence level there is a significant difference in an agreement level of BI Model at Strategic domain of foreign vs. Indian Automobile Manufacturing companies

(32)

V: Analysis and Interpretation of

Business Intelligence Data

5.3.1.2 Analysis of Sales & Marketing domain of Automobile

Manufacturing Industry in Foreign v/s Indian Companies:

Sr. No. Name of the Company SL - Sales SL - Marketing ML - Sales & Marketing Total 1 KEOL 34 34 44 112 2 TATA Motors 35 38 37 110 3 Bajaj Auto 37 34 36 107 4 M & M 37 38 38 113 5 Ashok Layland 23 37 33 93 6 Maruti 34 39 32 105 7 Hindustan Motors 24 38 29 91 Total 224 258 249 731 Count 7 7 7 7 Average 32.00 36.86 35.57 104.43 STDEV 5.94 2.04 4.86 8.94 Variance 35.33 4.14 23.62 79.95 Sr. No. Name of the Company SL - Sales SL - Marketing ML - Sales & Marketing Total 1 Mico 34 36 36 106 2 Ford 36 38 38 112 3 General Motors 31 37 42 110 4 Hyundai 35 31 37 103 5 Renault 35 36 38 109 6 Toyota 31 37 42 110 7 Honda 32 40 40 112 Total 234 255 273 762

5.3 Functional

Domains

(33)

V: Analysis and Interpretation of

Business Intelligence Data

Count 7 7 7 7

Average 33.43 36.43 39.00 108.86

STDEV 2.07 2.76 2.38 3.29

Variance 4.29 7.62 5.67 10.81

Table 5.14 Analysis of Sales & Marketing domain at Automobile Manufacturing Industry in Foreign v/s Indian Companies

As shown in the table, the highest agreement level of BI Model at Sales and Marketing Domain of Indian Automobile Manufacturing companies is achieved by Kirloskar Oil Engines Limited with the score of 112 where as in foreign Automobile Manufacturing Companies there are two companies such as Ford and Honda with the highest score of 112. Apparently, this shows that there is no difference at an agreement level of BI Model in Indian and Foreign Automobile Manufacturing Companies at Sales and Marketing Domain and after conducting T Test we can conclude as follows:

H0: There is no Significant Difference in the Agreement Level of BI Model in Indian Automobile Manufacturing Companies at functional domain of Sales and Marketing.

H1: There is a Significant Difference in the Agreement Level of BI Model in Indian Automobile Manufacturing Companies at functional domain of Sales and Marketing.

T Test Table Variable 1 Variable 2 Mean 108.857143 104.428571 Variance 10.8095238 79.952381 Observations 7 7 Hypothesized Mean Difference 0

5.3 Functional

Domains

(34)

V: Analysis and Interpretation of

Business Intelligence Data

From the T test Table we can derive that a two tiled significance level of 0.25 has been achieved. This means the T test is showing no significance difference in agreement level of BI implementation at Sales and Marketing Domain of foreign viz-a-viz Indian Automobile Manufacturing companies. Hence null hypothesis is Accepted (T cal is Less than T tab) because T Cal = 1.2298 is less than T tab = 2.178. So, we can conclude that at 95% confidence level there is no significant difference in an agreement level of BI Model at Sales and Marketing Domain of foreign vs. Indian Automobile Manufacturing companies.

(35)

V: Analysis and Interpretation of

Business Intelligence Data

5.3.1.3 Analysis of Operational domain - of Automobile Manufacturing

Industry in Foreign v/s Indian Companies:

Sr. No. Name of the Company SL - Operations ML - Operations Total 1 KEOL 27 47 74 2 TATA Motors 31 46 77 3 Bajaj Auto 29 44 73 4 M & M 33 43 76 5 Ashok Layland 23 35 58 6 Maruti 23 40 63 7 Hindustan Motors 20 36 56 Total 186 291 477 Count 7 7 7 Average 26.57 41.57 68.14 STDEV 4.76 4.72 8.90 Variance 22.62 22.29 79.14 Sr. No. Name of the Company SL - Operations ML - Operations Total 1 Mico 29 46 75 2 Ford 38 43 81 3 General Motors 27 51 78 4 Hyundai 24 47 71 5 Renault 33 43 76 6 Toyota 27 42 69 7 Honda 25 51 76

5.3 Functional

Domains

(36)

V: Analysis and Interpretation of

Business Intelligence Data

Total 206 323 529

Count 7 7 7

Average 29.00 46.14 75.14

STDEV 4.93 3.76 4.06

Variance 24.33 14.14 16.48

Table 5.15 Analysis of Operations domain at Automobile Manufacturing Industry in Foreign v/s Indian Companies

As shown in the table, the highest agreement level of BI Model at Operations Domain of Indian Automobile Manufacturing companies is achieved by TATA Motors with the score of 77 where as in foreign Automobile Manufacturing Companies it is achieved by Ford with the highest score of 81. Apparently, this shows that there is a difference at an agreement level of BI Model in Indian and Foreign Automobile Manufacturing Companies at Operations Domain and after conducting T Test we can conclude as follows:

H0: There is no Significant Difference in the Agreement Level of BI Model in Indian Automobile Manufacturing Companies at functional domain of Operations.

H1: There is a Significant Difference in the Agreement Level of BI Model in Indian Automobile Manufacturing Companies at functional domain of Operations. T Test Table Variable 1 Variable 2 Mean 75.14285714 68.14286 Variance 16.47619048 79.14286 Observations 7 7 Hypothesized Mean Difference 0

5.3 Functional

Domains

(37)

V: Analysis and Interpretation of

Business Intelligence Data

From the T test Table we can derive that a two tiled significance level of 0.094 has been achieved. This means the T test is showing no significance difference in agreement level of BI implementation at Operations Domain of foreign viz-a-viz Indian Automobile Manufacturing companies. Hence null hypothesis is Accepted (T cal is Less than T tab) because T Cal = 1.8939 is less than T tab = 2.178. So, we can conclude that at 95% confidence level there is no significant difference in an agreement level of BI Model at Operations Domain of foreign vs. Indian Automobile Manufacturing companies.

(38)

V: Analysis and Interpretation of

Business Intelligence Data

5.3.2.1 Analysis of Strategic domain at FMCG Industry in Foreign v/s

Indian Companies:

Sr. No. Name of the Company Strategic domain Total 1 Unilever 46 46 2 Coca Cola 44 44 3 Colgate Palmolive 41 41 4 P & G 44 44 5 Nestle 45 45 6 Phillip Morris 43 43 7 Kraft Food 42 42 Total 305 305 Count 7 7 Average 43.57 43.57 STDEV 1.72 1.72 Variance 2.95 2.95 Sr. No. Name of the Company Strategic domain Total 1 Amul India Pvt. Ltd. 44 44 2 Marico Industries 38 38 3 ITC 41 41 4 Parle Agro 34 34 5 Nirma 41 41 6 Godrej Consumer Products 42 42 7 Dabur 41 41 Total 281 281

5.3 Functional

Domains

5.3.2 FMCG Industry Analysis

(39)

V: Analysis and Interpretation of

Business Intelligence Data

Count 7 7

Average 40.14 40.14

STDEV 3.24 3.24

Variance 10.48 10.48

Table 5.16 Analysis of Strategic domain at FMCG Industry in Foreign v/s Indian Companies

As shown in the table, the highest agreement level of BI Model at Strategic domain at Indian FMCG companies is achieved by Amul India Pvt. Limited with the score of 44 where as in foreign FMCG Companies it is achieved by Unilever with the highest score of 46. Apparently, this shows that there is a difference at an agreement level of BI Model in Indian and Foreign FMCG Companies at Strategic domain but after conducting T Test we can conclude as follows:

H0: There is no Significant Difference in the Agreement Level of BI Model in Indian FMCG Companies functional domain of Strategic domain.

H1: There is a Significant Difference in the Agreement Level of BI Model in Indian FMCG Companies functional domain of Strategic domain. T Test Table Variable 1 Variable 2 Mean 43.57142857 40.14285714 Variance 2.952380952 10.47619048 Observations 7 7 Hypothesized Mean Difference 0 df 12 t Stat 2.475410991 P(T<=t) one-tail 0.017627945 t Critical one-tail 1.833112933

5.3 Functional

Domains

(40)

V: Analysis and Interpretation of

Business Intelligence Data

P(T<=t) two-tail 0.035255891

t Critical two-tail 2.17881283

From the T test Table we can derive that two tailed significance level of 0.03 has been achieved. This means the T test is showing a significance difference in agreement level of BI implementation at Strategic domain of foreign viz-a-viz Indian FMCG Companies. Hence null hypothesis is Rejected (T cal is More than T tab) because T Cal = 2.4754 is More than T tab = 2.178. So, we can conclude that at 95% confidence level there is a significant difference in an agreement level of BI Model at Strategic domain of foreign vs. Indian FMCG Companies.

5.3.2.2 Analysis of Sales & Marketing domain of FMCG Industry in

Foreign v/s Indian Companies:

Sr. No Name of the Company SL - Sales SL - Marketing ML - Sales & Marketing Total 1 Unilever 35 39 44 118 2 Coca Cola 37 35 43 115 3 Colgate Palmolive 32 41 47 120 4 P & G 34 39 46 119 5 Nestle 33 38 46 117 6 Phillip Morris 35 34 41 110

5.3 Functional

Domains

(41)

V: Analysis and Interpretation of

Business Intelligence Data

7 Kraft Food 31 33 46 110 Total 237 259 313 809 Count 7 7 7 7 Average 33.86 37.00 44.71 115.57 STDEV 2.04 3.00 2.14 4.12 Variance 4.14 9.00 4.57 16.95 Sr. No Name of the Company SL - Sales SL - Marketing ML - Sales & Marketing Total 1 Amul India Pvt. Ltd. 31 39 41 111 2 Marico Industries 31 34 39 104 3 ITC 34 37 41 112 4 Parle Agro 32 35 37 104 5 Nirma 27 37 35 99 6 Godrej Consumer Products 34 35 39 108 7 Dabur 35 38 40 113 Total 224 255 272 751 Count 7 7 7 7 Average 32.00 36.43 38.86 107.29 STDEV 2.71 1.81 2.19 5.15 Variance 7.33 3.29 4.81 26.57

Table 5.17 Analysis of Sales & Marketing domain at FMCG Industry in Foreign v/s Indian Companies

As shown in the table, the highest agreement level of BI Model at Sales and Marketing Domain of Indian FMCG Companies is achieved by Dabur with the score of 113 where as in foreign FMCG Companies it is

(42)

V: Analysis and Interpretation of

Business Intelligence Data

achieved by Colgate Palmolive with the highest score of 120. Apparently, this shows that there is a difference at an agreement level of BI Model in Indian and Foreign FMCG Companies at Sales and Marketing Domain and after conducting T Test we can conclude as follows:

H0: There is no Significant Difference in the Agreement Level of BI Model in Indian FMCG Companies At functional domain of Sales and Marketing.

H1: There is a Significant Difference in the Agreement Level of BI Model in Indian FMCG Companies At functional domain of Sales and Marketing. T Test Table Variable 1 Variable 2 Mean 115.571429 107.285714 Variance 16.952381 26.5714286 Observations 7 7 Hypothesized Mean Difference 0 df 12 t Stat 3.32288662 P(T<=t) one-tail 0.00339821 t Critical one-tail 1.79588482 P(T<=t) two-tail 0.00679642 t Critical two-tail 2.17881283

(43)

V: Analysis and Interpretation of

Business Intelligence Data

From the T test Table we can derive that a two tiled significance level of 0.006 has been achieved. This means the T test is showing a significance difference in agreement level of BI implementation at Sales and Marketing Domain of foreign viz-a-viz Indian FMCG Companies. Hence null hypothesis is Rejected (T cal is More than T tab) because T Cal = 3.3229 is More than T tab = 2.178. So, we can conclude that at 95% confidence level there is a significant difference in an agreement level of BI Model at Sales and Marketing Domain of foreign vs. Indian FMCG Companies.

5.3.2.3 Analysis of Operations domain of FMCG Industry in Foreign

v/s Indian Companies:

Sr. No. Name of the Company SL - Operations ML - Operations Total 1 Unilever 30 41 71 2 Coca Cola 33 45 78 3 Colgate Palmolive 29 49 78 4 P & G 32 46 78 5 Nestle 25 46 71 6 Phillip Morris 30 45 75 7 Kraft Food 23 46 69 Total 202 318 520 Count 7 7 7 Average 50.50 45.43 74.29 STDEV 61.31 2.37 3.90

5.3 Functional

Domains

(44)

V: Analysis and Interpretation of

Business Intelligence Data

Variance 3758.57 5.62 15.24 Sr. No. Name of the Company SL - Operations ML - Operations Total 1 Amul India Pvt. Ltd. 23 34 57 2 Marico Industries 31 45 76 3 ITC 30 45 75 4 Parle Agro 29 40 69 5 Nirma 29 40 69 6 Godrej Consumer Products 33 44 77 7 Dabur 31 40 71 Total 206 288 494 Count 7 7 7 Average 51.50 41.14 70.57 STDEV 62.50 3.93 6.83 Variance 3905.71 15.48 46.62

Table 5.18 Analysis of Operations Domain at FMCG Industry in Foreign v/s Indian Companies

As shown in the table, the highest agreement level of BI Model at Operations Domain of Indian FMCG Companies is achieved by Godrej Consumer Products with the score of 77 where as in foreign FMCG Companies it is achieved by three companies namely Colgate Palmolive, Coca Cola and P & G with the highest score of 78. Apparently, this shows that there is a little difference at an agreement

(45)

V: Analysis and Interpretation of

Business Intelligence Data

level of BI Model in Indian and Foreign FMCG Companies at Operations Domain and after conducting T Test we can conclude as follows:

H0: There is no Significant Difference in the Agreement Level of BI Model in Indian FMCG Companies At functional domain of Operations. H1: There is no Significant Difference in the Agreement Level of BI Model in Indian FMCG Companies At functional domain of Operations.

T Test Table Variable 1 Variable 2 Mean 74.28571 70.57142857 Variance 15.2381 46.61904762 Observations 7 7 Hypothesized Mean Difference 0 df 12 t Stat 1.24948 P(T<=t) one-tail 0.119971 t Critical one-tail 1.812461 P(T<=t) two-tail 0.239943 t Critical two-tail 2.178813

(46)

V: Analysis and Interpretation of

Business Intelligence Data

From the T test Table we can derive that a two tiled significance level of 0.24 has been achieved. This means the T test is showing no significance difference in agreement level of BI implementation at Operations Domain of foreign viz-a-viz Indian FMCG Companies. Hence null hypothesis is Accepted (T cal is Less than T tab) because T Cal = 1.24948 is less than T tab = 2.178. So, we can conclude that at 95% confidence level there is no significant difference in an agreement level of BI Model at Operations Domain of foreign vs. Indian FMCG Companies.

(47)

V: Analysis and Interpretation of

Business Intelligence Data

5.3.3.1 Analysis of Strategic domain at Logistics Industry in Foreign v/s

Indian Companies:

Sr. No. Name of the Company Strategic domain Total 1 Kingfisher Cargo 39 39 2 First Flight 45 45 3 Gati 40 40 4 Safe Express 42 42 5 Patel Logistics 42 42 6 OM Logistics 45 45 7 DTDC 43 43 Total 296 296 Count 7 7 Average 42.29 42.29 STDEV 2.29 2.29 Variance 5.24 5.24 Sr. No. Name of the Company Strategic domain Total 1 DHL 41 41 2 UPS 39 39 3 Fed Ex 40 40 4 Ryder 44 44 5 Nippon 44 44 6 APM 42 42 7 TNT 44 44 Total 294 294 Count 7 7

5.3.3 Logistics Industry Analysis

(48)

V: Analysis and Interpretation of

Business Intelligence Data

Average 42.00 42.00

STDEV 2.08 2.08

Variance 4.33 4.33

Table 5.19 Analysis of Strategic Domain at Logistic Industry in Foreign v/s Indian Companies

As shown in the table, the highest agreement level of BI Model at Strategic domain at Indian LOGISTICS companies is achieved by First Flight and Om Logistics with the score of 45 where as in foreign LOGISTICS Companies it is achieved by Ryder, Nippon and TNT with the highest score of 44. Apparently, this shows that there is a difference at an agreement level of BI Model in Indian and Foreign LOGISTICS Companies at Strategic domain but after conducting T Test we can conclude as follows:

H0: There is no Significant Difference in the Agreement Level of BI Model in Indian LOGISTICS Companies at functional domain of Strategic domain.

H1: There is a Significant Difference in the Agreement Level of BI Model in Indian LOGISTICS Companies at functional domain of Strategic domain. T Test Table Variable 1 Variable 2 Mean 42 42.28571429 Variance 4.333333333 5.238095238 Observations 7 7 Hypothesized Mean Difference 0 df 12 t Stat 0.244338889 P(T<=t) one-tail 0.405548073 t Critical one-tail 1.782287556

5.3 Functional

Domains

(49)

V: Analysis and Interpretation of

Business Intelligence Data

P(T<=t) two-tail 0.811096145

t Critical two-tail 2.17881283

In a T test for a 95% confidence level, if the significance level is greater than or equal to 0.05 then it signifies that there is no significance difference between implementation of BI at Top level of Management in Indian companies and foreign companies at Logistics Industry.

From the T test Table we can derive that two tailed significance level of 0.81 has been achieved. This means the T test is showing no significance difference in agreement level of BI implementation at Strategic domain of foreign viz-a-viz Indian LOGISTICS Companies. Hence null hypothesis is Accepted (T cal is Less than T tab) because T Cal = 0.2443 is Less than T tab = 2.178. So, we can conclude that at 95% confidence level there is no significant difference in an agreement level of BI Model at Strategic domain of foreign vs. Indian LOGISTICS Companies.

5.3.3.2 Analysis of Sales & Marketing domain of Logistics Industry in

Foreign v/s Indian Companies:

Sr. No.

Name of the Company

SL - Sales SL - Marketing ML - Sales & Marketing Total 1 Kingfisher Cargo 32 42 41 115 2 First Flight 33 41 41 115 3 Gati 35 37 42 114 4 Safe Express 33 37 44 114 5 Patel Logistics 33 37 41 111 6 OM Logistics 30 39 38 107 7 DTDC 30 41 37 108 Total 226 274 284 784

5.3 Functional

Domains

(50)

V: Analysis and Interpretation of

Business Intelligence Data

Count 7 7 7 7 Average 32.29 39.14 40.57 112.00 STDEV 1.80 2.19 2.37 3.37 Variance 3.24 4.81 5.62 11.33 Sr. No. Name of the Company SL - Sales SL - Marketing ML - Sales & Marketing Total 1 DHL 35 38 41 114 2 UPS 32 39 41 112 3 Fed Ex 35 36 38 109 4 Ryder 37 38 39 114 5 Nippon 33 38 38 109 6 APM 35 36 43 114 7 TNT 37 38 46 121 Total 244 263 286 793 Count 7 7 7 7 Average 34.86 37.57 40.86 113.29 STDEV 1.86 1.13 2.91 4.07 Variance 3.48 1.29 8.48 16.57

Table 5.20 Analysis of Sales & Marketing Domain at Logistic Industry in Foreign v/s Indian Companies

As shown in the table, the highest agreement level of BI Model at Sales and Marketing Domain of Indian LOGISTICS Companies is achieved by Kingfisher Cargo and First Flight with the score of 115 where as in foreign LOGISTICS Companies it is achieved by DHL, Ryder and APM with the highest score of 114. Apparently, this shows that there is a difference at an agreement level of BI Model in Indian and Foreign LOGISTICS Companies at Sales and Marketing Domain and after conducting T Test we can conclude as follows: