logo

Data Handling and Business Intelligence : Assignment

18 Pages3573 Words185 Views
   

Added on  2020-01-07

Data Handling and Business Intelligence : Assignment

   Added on 2020-01-07

ShareRelated Documents
Data Handling and BusinessIntelligence
Data Handling and Business Intelligence : Assignment_1
Table of ContentsINTRODUCTION...........................................................................................................................3PART 1............................................................................................................................................3Critically evaluating the strengths and weaknesses of using excel for pre-processing data set..3PART 2............................................................................................................................................8Discussing the advantages and disadvantages of Weka over excel.............................................8Application of clustering method on Audi data.........................................................................11Modification of existing data.....................................................................................................15CONCLUSION..............................................................................................................................17REFERENCES..............................................................................................................................18
Data Handling and Business Intelligence : Assignment_2
INTRODUCTION Data mining may be defined a process which is used to examine the large existingdatabase. By this, business unit can extract or generate new information in the best possiblemanner. Moreover, data mining tools place more emphasis on the conversion of raw data intovaluable information. Thus, data mining tools help business organization in making highlyeffectual as well as profitable decisions and thereby make contribution in the attainment oforganizational goals. The present report is based on the case situations which will present thetools that are used by superstores and Audi dealership for the purpose of data mining. Besidesthis, it will also shed light on the benefits and drawbacks which are associated with traditionaluse of Excel as well as Weka. PART 1Critically evaluating the strengths and weaknesses of using excel for pre-processing data setReasons due to which sales and profit figure of superstore declines over the yearsFigure 1 Calculation of unit costFigure 2 Margin calculation per unit
Data Handling and Business Intelligence : Assignment_3
Figure 3IF statement formulaFigure 4 IF statement formulaFigure 5Lookup formulaFrom the above mentioned table, it has been analyzed that discounting policies which areframed and introduced by supermarkets are not highly effective. Hence, it is one of the mainreasons due to which sales revenue of supermarkets is continuously declining. By making use ofexcel options or functions it has been identified that supermarkets are offering same discounts onproducts irrespective their price level (Wu and et.al., 2014). Hence, it is one of the main factorswhich have high level of impact on the purchasing decision of the customers of supermarket.From the evaluation of data set it has been assessed that 0.07 discount is offered by supermarketson products with the ID of 103 and 107. On the other side, high level of variation takes place inthe price level of such products. Data set presents that price of product with the ID of 103 is
Data Handling and Business Intelligence : Assignment_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Data Handling and Business Intelligence Report
|20
|4181
|293

Data Handling and Business Intelligence of Audi : Report
|19
|3857
|117

Data Handling and Business Intelligence - Report
|20
|3862
|158

Data Handling and Business Intelligence
|17
|3795
|21

Data Handling and Business Intelligence PDF
|20
|3848
|36

Analysis of Data of Superstore: Reasons behind Declined Sales and Profits
|9
|2954
|77