Data Handling and Business Intelligence Report

Added on - 07 Jan 2020

  • 20

    Pages

  • 4181

    Words

  • 107

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 4 of 20 pages
DATA HANDLING AND BUSINESS INTELLIGENCE
TABLE OF CONTENTSPart 1............................................................................................................................................................................................................3Reasons for decline in sales of the business firm....................................................................................................................................3Pros and cons of using excel for data analysis........................................................................................................................................6Part 2............................................................................................................................................................................................................9Why Weka must be used to gain competitive advantage........................................................................................................................9Advantage and disadvantage of Weka over excel (Pros and cons of using Weka for data analysis)......................................................9Application of J48 algorithm on data set in Weka................................................................................................................................10Application of clustering method on Audi data.....................................................................................................................................13Need to add new columns in data..........................................................................................................................................................19CONCLUSION..........................................................................................................................................................................................19REFRENCES.................................................................................................................................................................................................................20Figure 1 Output table of decision tree in Weka...........................................................................................................................................8Figure 2Decision tree in Weka....................................................................................................................................................................9Figure 3 Cluster of finance and TT............................................................................................................................................................12Figure 4 Cluster of finance and A4............................................................................................................................................................13Figure 5 Cluster of finance and RS7..........................................................................................................................................................15
INTRODUCTIONWith passage of time usage of analytics is increasing at the workplace.It is inevitable to use business intelligence because byusing same roadblocks in business growth can be identified and remove in specific time period.Business firms are often usinganalytics to analyze the business situations and making prediction about likelihood about happening of certain event. In the currentresearch report comparison of excel and Weka is made. Merits and demerits of excel and Weka are explained in detail. In the first partof the report sales data is analyzed and reason due to which firm sales declined is identified. Apart from this, in the second part of thereport data that is related to Audi are analyzed by using decision tree J48 algorithm and K-means clustering method. Results of thesestatistical tools are also explained in detail and strategy that Audi must form in order to enhance sales of its cars are also identified.Part 1Reasons for decline in sales of the business firmFigure1Calculation of unit costFigure2Margin calculation per unit
Figure3IF statement formulaFigure4IF statement formulaFigure5Lookup formulaeThere are two main reason that are responsible for decline in the firm sales one is discount and other is margin on sales. It can beobserved from the data set that some products whose price is high then there are less margin on same. On other hand, there are someproducts whose price is very low then margin on them is low. For example in case of product delivery truck in row ID 2383 (164) itcan be seen that margin on the product whose sales value is 5472 margin of 0.59 is earned. Whereas, on same product whose deliveryID is 2484(165) earned margin is 0.77 for the product whose value is 1810. This example clearly reflects that when product price islow higher margin is earned and in product whose price is high lower margin is earned. Moreover, it is common trend in the data setthere is not a high difference in the margin of the product that is sold at high or low price. This is the reason due to which firm isearning low profit in its business. This was all about margin and sales that is related to the firm.
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document