logo

Data Handling and Business Intelligence of Audi : Report

19 Pages3857 Words117 Views
   

Added on  2020-01-23

Data Handling and Business Intelligence of Audi : Report

   Added on 2020-01-23

ShareRelated Documents
DATA HANDLING AND BUSINESSINTELLIGNECE
Data Handling and Business Intelligence of Audi : Report_1
TABLE OF CONTENTSPart A...............................................................................................................................................3Reasons for decline in sales of the business firm........................................................................3Pros and cons of using excel........................................................................................................5Part 2................................................................................................................................................8Reasons for using Weka to gain competitive advantage.............................................................8Merits and dermis of Weka in comparison to excel (Pros and cons of using excel for dataanalysis).......................................................................................................................................9Application of J48 algorithm on data set in Weka......................................................................9Application of clustering method on Audi data.........................................................................12Modification of existing data.....................................................................................................17CONCLUSION..............................................................................................................................17REFERENCES..............................................................................................................................18Figure 1 Output table of decision tree in Weka...............................................................................8Figure 2Decision tree in Weka........................................................................................................9Figure 3 Cluster of finance and TT................................................................................................11Figure 4 Cluster of finance and A4................................................................................................12Figure 5 Cluster of finance and RS7..............................................................................................14
Data Handling and Business Intelligence of Audi : Report_2
INTRODUCTIONAnalytics is the industry that is growing at fast rate across the globe. It is necessary to dodata analysis because one by using it identify reasons and solution of the business problems. Inthe current research study sales data of the firm is analyzed by using Excel software. Reasonsdue to which sales of the firm declined is identified. In the second part of the report, in Wekasoftware data is analyzed and results are interpreted. Along with this, strategy that Audi mustfollow in order to enhance sales is also described in the report. At end of the report,modifications that are required in the current data set are determined and reasons due to whichsuch modifications must be done in the data set is also explainedPart AReasons for decline in sales of the business firmFigure 1 Calculation of unit costFigure 2 Margin calculation per unitFigure 3IF statement formula
Data Handling and Business Intelligence of Audi : Report_3
Figure 4 IF statement formulaFigure 5Lookup formulaeOn analysis of the data set it is identified that there are two basic reason due to which salesof the business in reduced in the specific duration. One of the main reason that is responsible forreduction in sales is discount and other one is profit margin on units that are old to the customers.It is identified on analysis of figures that there are few products whose price is very high butthere margin is very low. This means that firm is even sell its product at very high price then alsoit is not earning higher amount of profit on sales. Contrary, to this in case of some products it isfind out that there price is very low but then also high margin is earned on them. For instance foron delivery truck whose row ID 2383 sales value is 5472 and profit on same is 0.59. Contrary tothis, item with ID number 2484 profit of 0.77 is gained and sales price of the relevant product is1810. On analysis of the example that is given above it can be find out that higher amount ofmargin is earned when product is sold at low price. Inverse to this when price of product is lowthen in that case high amount of margin is earned. Second thing that comes in light on analysis offacts and figures is that even products are sold at high and low price big difference does notcome in the margin that is earned on the varied products. These are the basic factors or mistakesthat are made by the firm and consequently loss is faced in the business. There must be balancebetween sales price, margin and discount in respect to specific product. Discount is anotherfactor that is also responsible for the poor performance of the business firm.There are different items that have varied price but similar amount of discount is given onthem. This is the big mistake that is made by the firm in its business. For instance on the productthat is in the row ID 103 product value is equivalent to 2781. Discount on relevant product is0.07. Inverse to this case it can be observed that on the product that is in the row ID is 107 price
Data Handling and Business Intelligence of Audi : Report_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
|3862
|158

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

Weka Advantages and Disadvantages
|22
|4340
|1896

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

Data Handling and Business Intelligence : Assignment
|18
|3573
|185

Identification of Whether Firm is in Profit or in loss
|21
|3757
|45