Data Handling and Business Intelligence PDF

DATA HANDLING
AND BUSINESS
INTELLIGENCE
1

TABLE OF CONTENTS
INTRODUCTION...........................................................................................................................3
2 MS Excel.......................................................................................................................................3
a Superstore data..........................................................................................................................3
......................................................................................................................................................4
......................................................................................................................................................4
b. Advantages and disadvantage of using excel for data analysis...............................................6
3. WEKA..........................................................................................................................................7
a.i. J48 algorithms........................................................................................................................7
a.ii. SimpleKmeans....................................................................................................................10
Modifying the existing data level..............................................................................................14
b. Advantages and disadvantage of using Weka for data analysis............................................15
CONCLUSION..............................................................................................................................16
REFERENCES..............................................................................................................................18
Illustration Index
Illustration 1: Cost............................................................................................................................3
Illustration 2: Margin per unit..........................................................................................................4
Illustration 3: IF formula..................................................................................................................5
Illustration 4: LOOKUP formula.....................................................................................................5
Illustration 5: Decision tree output................................................................................................10
Illustration 6: Decision tree............................................................................................................10
Illustration 7: Numcluster of finance and TT................................................................................13
2

INTRODUCTION
Data handling is the most important task under which business organize all information
and interpret the same for the purpose of extracting valid outcome. Business intelligence is
another important aspect under which company shed light upon collecting valid data and
drawing valid outcome of the same. It is because collected data are analyzed in the light of aim
and objectives of business. Present report is based on case study of Audi dealership data under
which Weka software has been applied. It would be effective to apply suitable software and draw
valid outcome from the collected information. In addition to this, advantages and disadvantages
of Excel for data analysis has also been explained. Moreover, pros and cons and Weka are
explained stated clearly to meet research objectives. All these software are required for data
analysis as it is important to take appropriate decision regarding selection of suitable strategy to
improve business performance.
2 MS EXCEL
a Superstore data
Reasons for decreasing sales and profitability of Audi care
Illustration 1: Cost
3

Illustration 2: Margin per unit
4