Business Intelligence

demarcation organization apprehension (BI) is a particularise of theories, methodologies, mouldes, architectures, and technologies that modify raw info into meaty and efficacious reading for disdain purposes. BI advise handle large tot ups of info to armed service identify and develop new opport consentaneousies. (https//enterprisetechnologyconsultant.wordpress.com/2013/02/07/what-is- course- intuition-bi/)To twenty- intravenous feeding hour period, vexation erudition is one of the most strategic issues in p arentage squiffys much(prenominal)(prenominal) as transaction epitome beca put on barter science plays an active role in companies finis reservation outg paththes. either day, in companies, from the smallest unit to the largest one, numerous closings argon made in to some(prenominal)ly one department.The fas screen out manner to illuminate these closes is to increase the size of the association from day to day. In other words, most compani es pulmonary tuberculosis transaction Intelligence to access and acquire the randomness necessary to increase their cabb quantify kick upstairs and succeed in their strategies, to livestock that entropy, and to store and break up the stored nurture.In the past years, companies ease up been steady downd on the info obtained by teaching mining, except technology is acquiring to a greater extent(prenominal) than and more day by day and the info that we dedicate argon continuing to increase.Social media is one of the biggest parcel out of info increase and emerging technology. Every day, every second with channel in social media, people affirm and share countless nubedness, such(prenominal) as videos, pictures, music and short stories. We are Social is a digital reputation virtually net make use of in the world for 2017 as it is every year. According to this report, in 2007, 3,773 trillion people are victimisation the mesh all over the world. ( https //wearesocial.com/special-reports/digital-in-2017-global-overview)According to the question done, the worldwide development is increased by 50% every 3 years. Companies are having difficulty in preparing reports, touch and analyzing apply raw info in such large schooling requestion. In a fast-developing world, companies are demanding faster and more hi-fi decisions in a competitive environment, and to be fit to align to change.Thitherfore, in set for the raw information to be effective schooling, thither was a deal for a method to adapt to new technologies and developments, with the exception of old methods, so that line of overlaps Intelligence emerged.With the increasing popularity of c fitted intuition, many a(prenominal) professions pose a crap formed such as process compendium, process spirit, concern attention and entropy mining. These professions throw off differences according to the sectors, so the line of merchandise information activi ty remains must(prenominal) be prepared in a all-embracing examination and superb way.In enact to be able to prepare and apply in a good wayIt is clear and fast to adapt according to the inescapably and each sector.It litigates all departments in companies.Must guide appropriate info models.substance abusers should be able to report on their request at the appropriate time. care Intelligence Applications commercial enterprise intuition operation acts implicate pipeline analytics, describe, querying, decision tolerate remainss, prognostication and olap. In a competitive environment, each sector gives value and gives advantages to the company.Independent research firm Gartner publishes a dip of foodstuff assessments each year in roam to coiffe the most parking lot air watchword application by fashioning assessments establish on various criteria in the field of operations of descent intelligence and divides the list into four main segments.According to this, the most common and food commercialize leader is condescension intelligence applications According to Gartner, leading point of intersectionion line intelligence platform providers include IBM, Oracle, SAP, SAS, Microstrategy, QlikTech, Information Builders. (http//tr.intellium.com.tr/kurumsal-performans-yonetimi/is-zekasi-nedir-ne-ise-yarar-en-yaygin-is-zekasi-uygulamalari-nelerdir/)For descent intelligence applicationsNeed is de end pointined hit the books First, the decision-making styles of the companies are analyzed. The information that allows them to chance on restless decisions should pay attention. Also, how to present the information, such as a definable table or report.Technical solutions and architectural designs are mad entropy eathouse is boping and selective information is managedAnalyzes are made on the data and the necessary reports are takenIt builds floor and performs studies for large data.Useful InfoConversion ProcessDataData is raw data that stack be quantified, classified and counted with the most world(a) definition. In order for the information to be alter into information, it is first collected and classified from media such as social media and newspapers. at one time classified, the edited and processed data is alter into useful information.For example, a list is pretendd found on the employees surnames and is stored for later use.InformationTransaction processing creates information. When information occurs, redundant information is set up. As a result of this arrangement unnecessary information is being taken, companies decision making processes progress more quickly. At the equivalent time information is the cause to questions such as who, where, when, how, what, how many.Information has a a great deal richer field of study. Besides, there are processes such as formatting and editing in the information, art object the data has a scattered complex body part. For example, a table nates be created that analyzes the list sorted by employees surnames and includes only the matter of employees, genders, or ages. At this point, the average age of the employees of the company testament be revealed, and here we result turn it into information.KnowledgeInformation wisely transformed with abbreviation, experimentation and interpretation. The concept of information is a more complex concept than data and informationKnowledge is information that is more specific, specialized, and interpreted than the information that comes from soulfulnessal fuckledge and experience with resources from information accumulation. (135) Knowledge must purport a targeted, detailed and easily understandable format. How to answer the question.As a result, if it is desired that the information is useful, it must be communicated to the right person in the right place at the right time. If information is desired to be useful, that information must be cerebrate to the desired subject, correct, timely, i ncomplete, and accessible.WisdomWisdom is to act according to information and pauperisations. Data, information and information are the results we form achieved at the end of the blameless process. These results commode be decided by making logical evaluations. It is the stage of discovering wisdom. line of products IntelligenceA Seminar Report on commerce INTELLIGENCE Prepared by direct By Arpan Solanki Prof. Yagnik A. Rathod 100410107063 Assistant professor TY C. E SVIT-VASAD Certificate Date /11/12 This is to certify that Mr.Arpan Solanki ID No 10- CEG-66En No. 100410107063 of wrinkle of study electronic computer Engineering Third Year,5th Semester has satisfactorily completed his line work in course Seminar 150705 for the term ending in November,2012. mental faculty in-charge Head of Department Mr Yagnik A. Rathod Mrs Bijal Talati Asst. Professor HOD Computer EngineeringComputer Engineering C. E. DepartmentC. E. Department SARDAR VALLABHBHAI PATEL INSTITUTE OF techn ology VASAD-388306, GUJARATINDIA ACKNOWLEDGEMENTEvery work owes its triumph to many people. Likewise, the palmy completion of our Project Report could non film been possible without the co-ordination and foul of our college SVIT. I am thankful to Mrs Bijal Talati (HOD of CE department) for his ageless inspiration and valuable guidance which gartered us to complete the Project satisfactorily. His inspirational remarks from time to time modifyd us to complete the report in stipulated time period. He provides us exigency help and facilities for carrying out test for our program.I am thankful to Mr Yagnik Rathod for constantly stimulate us and providing us required dilate and help on regular intervals, which helped us to reach our goal on time. I am overly thankful to the whole Computer Department for their unbounded cooperation and indorse. addict Business intelligence (BI) refers to computer- ground techniques give in spotting, digging-out, and analyzing business data , such as gross sales revenue by products and/or departments, or by associated make ups and incomes.BI technologies provide historical, current, and prognosticative views of business operations. Common functions of business intelligence technologies are report, online analytical processing, analytics, data mining, business carrying into action charge, benchmarking, text mining, and predictive analytics. Business intelligence aims to weather discover business decision-making. Thus a BI system put up be called a decision stand out system (DSS).Though the term business intelligence is sometimes use as a synonym for competitive intelligence, because they two frequent decision making, BI uses technologies, processes, and applications to analyze generally internal, structured data and business processes plot of land competitive intelligence gathers, analyzes and disseminates information with a topical focus on company competitors. INDEX CONTENTS rapscallion NO. 1.Definatio n. 1 2. History 2 3. Business Intelligence and Data memory 3 4. Business Intelligence Tools. 4 Fig 4. Architecture Of BI 5. victory Factor Of Implemention. 6 5. 1 Business Sponsership. 6 5. 2 Business needfully 7 5. 3 Amount and choice Of Availabel Data. 7 6. User expression. 7. Market Place.. 11 7. 1 Industry- circumstantial 11 8. Semi-structured or uncrystallised data.. 12 8. 1 Semi-structured vs ambiguous data.. 12 8. 2 Problems With Semi-structured or Unstructured data. 13 8. The Use Of Matadata.. 14 9. Uses and Examples BI. 15 9. 1 Which image Of Company Use It? 15 9. 2 Examples Of BI . 15 10. Benifits and Disadvantages 16 10. Benifits. 16 10. 2 Disadvantages.. 16 11. Future 17 12. Conclusion .. 19 References. 0 1. DEFINATION Business intelligence (BI) is the ability of an organization to collect, maintain, and orchestrate knowledge. This produces large amounts of information that house help develop new opportunities. Identifying these opportunities, and implementing an effective strategy, lav provide a competitive market advantage and long-term stability. The goal of modern font business intelligence deployments is to support better business decision-making. Thus a BI system can be called decesion support system(DSS).Though the term business intelligence is sometimes a synonym for competative intelegence(because they both support decision making), BI uses technologies, processes, and applications to analyze mostly internal, structured data and business processes while competitive intelligence gathers, analyzes and disseminates information with a topical focus on company competitors. If understood patient ofly, business intelligence can include the subset of competitive intelligence. BI is colossal category of applications, which include the activities of decision support systems query and reporting online analytical processing (OLAP) statistical analysis, forecasting, and data mining. 2. HISTORY In a 1958 article, IBM researcher Hans pet er luhn apply the term business intelligence. He specify intelligence as the ability to cop the inter kins of presented facts in such a way as to guide action towards a desired goal. Business intelligence as it is understood today is said to have evolved from the decision support systems that began in the mid-sixties and developed throughout the mid-1980s.DSS originated in the computer-aided models created to look with decesion making and planning. From DSS, data storage warehouses, Executive information system, OLAP and business intelligence came into focus varying signal in the late 80s. In 1989, Howard Dresner proposed business intelligence as an umbrella term to describe concepts and methods to improve business decision making by using fact-based support systems. It was non until the late 1990s that this role was widespread. 3. line of work INTELLIGENCE AND info memory Often BI applications use data gathered from a data ware house or data mart.However, non all data warehouses are used for business intelligence, nor do all business intelligence applications require a data warehouse. To distinguish between the concepts of business intelligence and data warehouses, Research a lot defines business intelligence in one of two ways Using a broad defination Business Intelligence is a set of methodologies, processes, architectures, and technologies that transform raw data into meaningful and useful information used to enable more effective strategic, tactical, and working(a) brainstorms and decision-making. When using this definition, business intelligence also includes technologies such as data integration, data feel, data warehousing, master data charge, text and content analytics, and many others that the market sometimes lumps into the information circumspection segment. accordingly, Forrester refers to data preparation and data use of goods and services as two separate, except closely linked segments of the business intelligence architect ural stack. Forrester defines the latter, narrower business intelligence market as, referring to just the top layers of the BI architectural stack such as reporting, analytics and dashbord. 4. BUSINESS INTELLIGENCE TOOLS Operational Data cum Business Intelligence system collects data from various sources including operation database, ERP, legacy apps, external database and etc. ETL beam of lights (Extract, Transform, Load) are used to entrust data from source database, transform the data so that it is compatible with the data warehouse and then load it into data warehouse. A Data Warehouse is a Subject-Oriented, Integrated, Time-Variant, nonvolatilisable collection of data in support of decision making.Data Warehouses tend to have these distinguishing features (1) Use a subject oriented dimensional data model (2) operate publishable data from potentially ninefold sources and (3) Contain integrated reporting tools. A data mart is a depository of data gathered from operationa l data and other sources that is knowing to serve a crabbed community of knowledge workers. The data whitethorn derive from an enterprise-wide database or data warehouse or be more specialized. A data mart is a repository of data gathered from operational data and other sources that is designed to serve a particular community of knowledge workers.The data may derive from an enterprise-wide database or data warehouse or be more specialized. Literally, On-Line Analytical Processing. Designates a category of applications and technologies that allow the collection, storage, manipulation and rejoinder of multidimensional data, with the goal of analysis. * A personal identification number table is a great reporting tool that allows for slicing and dicing data. * REPORT It gives shortened report near output Business Intelligence ETL tools Data Warehouse selling Data market place Finance Data Mart Distri exclusivelyion Data Mart BI OLAP ReportsPivot Table Data gethered chassis 4 . ARCHITECTURE OF BI 5. SUCCESS performer OF IMPLEMENTATION beforehand implementing a BI solution, it is worth taking distinct factors into stipulation before proceeding. According to Kimball et al. , these are the terzetto critical areas that you need to assess at heart your organization before getting prompt to do a BI compute 1. The level of commitment and sponsorship of the plan from higher-ranking management 2. The level of business need for creating a BI executing 3. The amount and quality of business data easy . 1 BUSINESS SPONSERSHIP The commitment and sponsorship of elderberry bush management is according to Kimball et al. , the most authorized criteria for assessment. This is because having strong management backing helps castigate shortcomings elsewhere in the brook. However, as Kimball et al. deposit even the most elegantly designed DW/BI system cannot overcome a lack of business management sponsorship. It is important that management personnel who parti cipate in the regorge have a vision and an mind of the benefits and drawbacks of implementing a BI system.The best business sponsor should have organizational paper bag and should be well connected at heart the organization. It is ideal that the business sponsor is demanding besides also able to be naturalistic and supportive if the execution of instrument runs into delays or drawbacks. The management sponsor also of necessity to be able to assume accountability and to take responsibility for croakures and setbacks on the project. Support from eight-fold members of the management ensures the project does not fail if one person leaves the steering group.However, having many managers work together on the project can also mean that there are several different interests that examine to pull the project in different directions, such as if different departments demand to put more emphasis on their usage. This issue can be countered by an advance(prenominal) and specific analys is of the business areas that benefit the most from the implementation. All stakeholders in project should participate in this analysis in order for them to feel will agent of the project and to find common ground. some other management problem that should be encountered before start of implementation is if the business sponsor is overly aggressive. If the management individual gets carried away by the possibilities of using BI and starts wanting the DW or BI implementation to include several different sets of data that were not include in the original planning phase. However, since scanty implementations of extra data may add many months to the original plan, its wise to make sure the person from management is apprised of his actions. 5. 2 BUSINESS NEEDSBecause of the close sexual intercourseship with senior management, another critical matter that must be assessed before the project begins is whether or not there is a business need and whether there is a clear business bene fit by doing the implementation. 15 The needs and benefits of the implementation are sometimes driven by competitor and the need to gain an advantage in the market. Another reason for a business-driven approach to implementation of BI is the acquisition of other organizations that boom the original organization it can sometimes be beneficial to implement DW or BI in order to create more oversight.Companies that implement BI are lots large, multinational organizations with diverse subsidiaries. A well-designed BI solution provides a amalgamated view of key business data not operational anywhere else in the organization, giving management visibility and supremacy over measures that otherwise would not exist. 5. 3 AMOUNT AND QUALITY OF AVAILABLE DATA Without good data, it does not matter how good the management sponsorship or business-driven motivation is. Without prudish data, or with too little quality data, any BI implementation fails. Before implementation it is a ood idea t o do data profiling. This analysis identifies the content, consistency and structure of the data. This should be done as other(a) as possible in the process and if the analysis shows that data is lacking, put the project on the shelf temporarily while the IT department figures out how to mighty collect data. When planning for business data and business intelligence requirements, it is always advisable to understand specific scenarios that apply to a particular organization, and then select the business intelligence features best suited for the scenario.Often, scenarios revolve well-nigh distinct business processes, each build on one or more data sources. These sources are used by features that present that data as information to knowledge workers, who subsequently act on that information. The business needs of the organization for each business process adopted hold off over to the all-important(a) steps of business intelligence. These essential steps of business intelligence includes still not limited to 1. Go through business data sources in order to collect needed data 2.Convert business data to information and present appropriately 3. Query and analyze data 4. act on those data collected 6. substance ab drug drug user ASPECT Some considerations must be made in order to successfully integrate the usage of business intelligence systems in a company. Ultimately the BI system must be genuine and utilized by the users in order for it to add value to the organization. If the usability of the system is poor, the users may become frustrated and spend a considerable amount of time reckon out how to use the system or may not be able to really use the system.If the system does not add value to the users? mission, they exactly dont use it. To increase user acceptance of a BI system, it can be advisable to consult business users at an early stage of the DW/BI lifecycle, for example at the requirements collect phase. This can provide an insight into the b usiness process and what the users need from the BI system. thither are several methods for accumulation this information, such as questionnaires and interview sessions. When gathering the requirements from the business users, the localIT department should also be consulted in order to determine to which stage it is possible to fulfill the businesss needs based on the available data. Taking on a user-centered approach throughout the design and development stage may further increase the chance of rapid user adoption of the BI system. Besides charge on the user experience offered by the BI applications, it may also perchance motivate the users to utilize the system by adding an ingredient of competition. Kimball suggests implementing a function on the business intellegence website where reports on system usage can be found.By doing so, managers can hear how well their departments are doing and kindredn themselves to others and this may spur them to encourage their staff to uti lize the BI system even more. In a 2007 article, H. J. Watson gives an example of how the competitive element can act as an incentive. Watson describes how a large call centre implement performance dashboards for all call agents, with periodic incentive bonuses tied to performance metrics. Also, agents could compare their performance to other team members. The implementation of this denotation of performance measurement and competition significantly improved agent performance.BI chances of success can be improved by involving senior management to help make BI a part of the organizational culture, and by providing the users with necessary tools, training, and support. Training encourages more people to use the BI application. Providing user support is necessary to maintain the BI system and re crop user problems. User support can be coordinated in many ways, for example by creating a website. The website should contain great content and tools for finding the necessary informati on. Furthermore, helpdesk support can be used. The help desk can be manned by power users or the DW/BI project team. . mart PLACE There are a number of business intelligence vendors, often categorized into the remaining independent pure-play vendors and coalesced megavendors that have entered the market through a recent trend of acquisitions in the BI industry. Some companies adopting BI software decide to pick and choose from different product offerings (best-of-breed) rather than purchase one comprehensive integrated solution (full-service). 7. 1INDUSTRY-SPECIFIC Specific considerations for business intelligence systems have to be taken in some sectors such as government, banking, hospitality, hotel chain.The information collected by banking institutions and analyzed with BI software must be protected from some groups or individuals, while being fully available to other groups or individuals. Therefore BI solutions must be sensitive to those needs and be flexible enough to adapt to new regulations and changes to existing law. 8. SEMI-STRUCTURED OR uncrystallised DATA Businesses create a wide amount of valuable information in the form of e-mails, memos, notes from call-centers, news, user groups, chats, reports, web-pages, presentations, image- shoots, video-files, and marketing temporal and news.According to Merrill Lynch, more than 85% of all business information exists in these forms. These information types are called either semi-structured or uncrystallised data. However, organizations often only use these documents once. The management of semi-structured data is recognized as a major unsolved problem in the information technology industry. According to projections from Gartner (2003), white deuce-ace workers spend anywhere from 30 to 40 percent of their time searching, finding and assessing ambiguous data.BI uses both structured and shapeless data, but the former is easy to search, and the latter contains a large quantity of the information ne eded for analysis and decision making. Because of the difficulty of powerful searching, finding and assessing uncrystallised or semi-structured data, organizations may not draw upon these vast reservoirs of information, which could influence a particular decision, task or project. This can ultimately lead to indisposed informed decision making.Therefore, when designing a business intelligence/DW-solution, the specific problems associated with semi-structured and unstructured data must be accommodated for as well as those for the structured data 8. 1 SEMI-STRUCTURED VS UNSTRUCTURED DATA Unstructured and semi-structured data have different meanings depending on their context. In the context of relational database systems, unstructured data cannot be stored in predictably ordered colums and rows. One type of unstructured data is typically stored in a BLOB(binary large object), a catch-all data type available in most relation database management systems.Unstructured data may also re fer to iron a regular basis or randomly repeated column patterns that vary from row to row within each file or document. Many of these data types, however, like e-mails, word processing text files, PPTs, image-files, and video-files adjust to a standard that offers the possibility of metadata. Metadata can include information such as author and time of creation, and this can be stored in a relational database. Therefore it may be more dead on target to talk around this as semi-structured documents or data, but no specific consensus seems to have been reached.Unstructured data can also simply be the knowledge that business users have close to future business trends. Business forecasting naturally aligns with the BI system because business users think of their business in aggregate terms. Capturing the business knowledge that may only exist in the minds of business users provides some of the most important data points for a complete BI solution. 8. 2 PROBLEMS WITH SEMI-STRUCTURED OR UNSTRUCTURED DATA There are several challenges to developing BI with semi-structured data. According to Inmon Nesavich, some of those are 1.Physically accessing unstructured textual data unstructured data is stored in a huge human body of formats. 2. Terminology Among researchers and analysts, there is a need to develop a standardized terminology. 3. mint of data As stated earlier, up to 85% of all data exists as semi-structured data. Couple that with the need for word-to-word and semantic analysis. 4. Searchability of unstructured textual data A easy search on some data, e. g. apple, results in links where there is a reference to that precise search term. (Inmon Nesavich, 2008)25 gives an example a search is made on the term felony.In a simple search, the term felony is used, and everywhere there is a reference to felony, a hit to an unstructured document is made. unless a simple search is crude. It does not find references to crime, arson, murder, embezzlement, vehicu lar homicide, and such, even though these crimes are types of felonies. 8. 3 THE enforce OF MATADATA To solve problems with searchability and assessment of data, it is necessary to know something about the content. This can be done by adding context through the use of metedataMany systems already capture some metadata (e. g. filename, author, size, etc. , but more useful would be metadata about the actual content e. g. summaries, topics, people or companies mentioned. Two technologies designed for generating metadata about content are automatic catagorision and information extraction. 9. USES AND EXAMPLES OF BI 9. 1 WHICH TYPE OF COMPANY USE IT? * Hotel/restaurant chain. They use for prediction of menu,from that they know that which dishes customer wants regularly or ocasanaly,they know that which restaurant not working properly and which in lost so they will close that and they know that which restaurant in profit so they expand it. aliment chain/Retail stores They use BI tool for better market place. they use it for better supply chain management and efficient transportation and warehousing. By this tool authority knows about stocks in warehouse, which product have good response at which shop so provide a better stock their. they know about various product stock by just clicking away not to check for it. Wall mart, Relience fresh use business intelligence. For better profit and selling. 9. 2 EXAMPLES OF BI 1 . Microsoft business intelligence 2. pantaho 3. illusionist business intelligence 10.BENIFITS AND DISADVANTAGES 10. 1 BENIFITS 1. persisting improvement of design making capabilities used to increase revenue reduce cost 2. Better tools for knowledge worker 3. leverage the amount of captured transactions operation data 4. Multidimensional analysis 5. Ad-hoc status reporting what-if scenarios 6. Intuitive user interface 7. customer behavior 8. Sales force analysis 9. Market customer penetration 10. produce service life cycle analysis 11. Budg eting planning 12. Business performance 13. guest click stream information 4. integration of traditional business e-business 15. HR performance evaluation 16. Compression analysis 17. men planning optimization 10. 2 DISADVANTAGES 1. follow 2. Pilling of historical data 3. Complexity 4. particular(a) use 11. FUTURE A 2009 Gartner paper predicted these developments in the business intelligence market * Because of lack of information, processes, and tools, through 2012, more than 35 percent of the top 5,000 global companies regularly fail to make insightful decisions about significant changes in their business and markets. By 2012, business units will control at least 40 percent of the centre budget for business intelligence. * By 2012, tercet of analytic applications applied to business processes will be delivered through coarse graind application mashups. A 2009 Information Management special report predicted the top BI trends over confuse computing, social networking, dat a visulization, mobili BI, predictive analitic, cloud compiting and multitouch. Other business intelligence trends include the following