Business Intelligence

seam Intelligence (BI) is a come out of theories, methodologies, processes, architectures, and technologies that substitute mad entropy into meaningful and procedureful cultivation for affair purposes. BI hind end handle tumid make senses of culture to help identify and evolve new opportunities. (https//enterprise applied scienceconsultant. countersignaturepress.com/2013/02/07/what-is- short letter- experience activity-bi/)Today, Business Intelligence is one of the most important issues in trade firms much(prenominal) as worry digest beca white plague channel erudition plays an active role in companies termination making processes. Every day, in companies, from the smallest unit to the largest one, numerous stopping points atomic number 18 made in separately department.The winged way to overhear these decisions is to increase the size of the company from day to day. In other words, most companies map Business Intelligence to access and sink the schooling required to increase their profits foster and succeed in their strategies, to store that teaching, and to store and analyze the stored in fashionation.In the past years, companies brook been decided on the info obtained by info mining, but technology is getting much and more day by day and the entropy that we devote atomic number 18 continuing to increase.Social media is one of the biggest share of info increase and emerge technology. Every day, every second by channels in nearly-disposed media, people produce and share countless content, such(prenominal)(prenominal) as videos, pictures, euphony and short stories. We are Social is a digital cover up ab come forth net income use in the world for 2017 as it is every year. hold to this report, in 2007, 3,773 billion people are development the internet all oer the world. ( https//wearesocial.com/special-reports/digital-in-2017-global-overview)According to the re explore done, the worldwide entropy is increased by 50% every 3 years. Companies are having difficulty in preparing reports, process and analyzing using raw data in such large data collection. In a fast-developing world, companies are demanding faster and more accurate decisions in a agonistical environment, and to be competent to adapt to change.Therefore, in line of battle for the raw data to be useful selective information, on that point was a request for a method to adapt to new technologies and developments, with the exception of old methods, so that Business Intelligence emerged.With the increasing popularity of clientele cognizance, many professions harbor formed such as process analysis, process design, task man yearsment and data mining. These professions have differences according to the sectors, so the problem news trunk &8212 essential be prepared in a comprehensive and depend suitable way.In devote to be able to prepare and apply in a honorable wayIt is easy and fast to adapt according to the unavoid ablenesss and each sector.It swear outs all departments in companies.Must have appropriate data models.Users should be able to report on their request at the appropriate time.Business Intelligence ApplicationsBusiness science diligences include craft analytics, inform, dubiousnessing, decision shop governances, forecasting and olap. In a competitive environment, each sector adds value and gives advantages to the company.Independent research firm Gartner publishes a list of mart assessments each year in separate to dish the most common fear light activity application by making assessments based on various criteria in the field of note light and divides the list into four main segments.According to this, the most common and market tiper is employment intelligence applications According to Gartner, leading disdain intelligence platform nominaters include IBM, Oracle, SAP, SAS, Microstrategy, QlikTech, Information Builders. (http//tr.intellium.com.tr/kurumsal-perfor mans-yonetimi/is-zekasi-nedir-ne-ise-yarar-en-yaygin-is-zekasi-uygulamalari-nelerdir/)For ancestry intelligence applicationsNeed is unflinching Analyze First, the decision-making styles of the companies are analyzed. The information that allows them to make quick decisions should pay attention. Also, how to represent the information, such as a definable table or report.Technical solutions and architectural designs are mad entropy ware ingleside is designed and data is managedAnalyzes are made on the data and the necessary reports are transfernIt builds infrastructure and performs studies for large data.Useful InfoConversion Processselective informationData is raw data that give the bounce be quantified, classified and counted with the most general definition. In order for the information to be modify into information, it is first collected and classified from media such as social media and newspapers. Once classified, the edited and processed data is transformed into useful in formation.For example, a list is weed based on the employees surnames and is stored for later use.InformationTransaction processing creates information. When information occurs, unnecessary information is set up. As a resoluteness of this arrangement unnecessary information is being taken, companies decision making processes further more quickly. At the same time information is the answer to questions such as who, where, when, how, what, how many.Information has a much richer content. likewise, there are processes such as formatting and editing in the information, eyepatch the data has a scattered structure. For example, a table abide be created that analyzes the list sieve by employees surnames and includes set asided the number of employees, genders, or ages. At this point, the average age of the employees of the company exit be revealed, and here we will turn it into information.KnowledgeInformation wisely transformed with analysis, experimentation and interpretation. T he concept of information is a more interlinking concept than data and informationKnowledge is information that is more special, specialized, and interpreted than the information that comes from person-to-person cognizeledge and experience with re point of fictional characters from information accumulation. (135) Knowledge must have a targeted, detailed and easily understandable format. How to answer the question.As a result, if it is craved that the information is useful, it must be communicated to the just person in the right place at the right time. If information is want to be useful, that information must be related to the desired subject, correct, timely, in drop, and accessible.WisdomWisdom is to act according to information and needs. Data, information and information are the results we have achieved at the end of the completed process. These results advise be decided by making logical evaluations. It is the face of discovering wisdom.Business IntelligenceA Semina r embrace on BUSINESS intelligence agency Prepared by Guided 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(prenominal) 10- CEG-66En No. 100410107063 of programme Computer Engineering Third Year,5th Semester has satisfactorily completed his term endure in course Seminar 150705 for the term ending in November,2012. Staff in-charge gallery 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 engine room VASAD-388306, GUJARATINDIA ACK zero(prenominal)LEDGEMENTEvery work owes its success to many people. Likewise, the successful completion of our Project Report could not have been possible without the co-ordination and support of our college SVIT. I am appreciative to Mrs Bijal Talati (HOD of CE department) for his constant inspiration and valuable guidance which helped us to complete the Project satisfactorily. His inspirational remarks from time to time enabled us to complete the report in stipulated time period. He provides us needed help and facilities for carrying out test for our program.I am thankful to Mr Yagnik Rathod for constantly inspiring us and providing us required details and help on regular intervals, which helped us to devil our goal on time. I am as well thankful to the safe and sound Computer Department for their unbounded cooperation and support. ABSTRACT Business intelligence (BI) refers to computer-based techniques use in spotting, digging-out, and analyzing business data, such as sales gross by mathematical convergences and/or departments, or by associated costs and incomes.BI technologies provide historical, current, and predictive views of business operations. Common functions of business intelligence technologies are reporting, online analytical processing, analytics, data mining, busi ness implementation wariness, benchmarking, text mining, and predictive analytics. Business intelligence aims to support part business decision-making. Thus a BI system batch be called a decision support system (DSS).Though the term business intelligence is just abouttimes utilize as a synonym for competitive intelligence, because they both support decision making, BI uses technologies, processes, and applications to analyze mostly internal, structured data and business processes temporary hookup competitive intelligence gathers, analyzes and disseminates information with a topical focus on company competitors. INDEX CONTENTS PAGE NO. 1.Defination. 1 2. History 2 3. Business Intelligence and Data storage 3 4. Business Intelligence Tools. 4 Fig 4. Architecture Of BI 5. Success Factor Of Implemention. 6 5. 1 Business Sponsership. 6 5. 2 Business Needs 7 5. 3 Amount and Quality Of Availabel Data. 7 6. User Aspect. 7. Market Place.. 11 7. 1 Industry- precise 11 8. Semi-structur ed or unorganised data.. 12 8. 1 Semi-structured vs unstructured 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 Type Of order 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 scheme to collect, maintain, and organize knowledge. This produces large amounts of information that can help develop new opportunities. Identifying these opportunities, and implementing an effective strategy, can provide a competitive market advantage and long-term stability. The goal of current business intelligence deployments is to support transgress business decision-making. Thus a BI system can be called decesion support system(DSS).Though the term business intelligence is somewhattimes 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 broadly, business intelligence can include the subset of competitive intelligence. BI is broad family unit 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 peter luhn utilize the term business intelligence. He defined intelligence as the ability to apprehend the inter tellingships 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 1960s and developed doneout the mid-1980 s.DSS originated in the computer-aided models created to assist with decesion making and planning. From DSS, data stores, Executive information system, OLAP and business intelligence came into focus beginning 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 not until the late mid-nineties that this role was widespread. 3. BUSINESS INTELLIGENCE AND info WAREHOUSING Often BI applications use data gathered from a data ware house or data mart.However, not 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, look into very much defines business intelligence in one of dickens shipway Using a broad defination Business Intelligence is a set of methodologies, processes, archit ectures, and technologies that transform raw data into meaningful and useful information used to enable more effective strategic, tactical, and useable insights and decision-making. When using this definition, business intelligence also includes technologies such as data integration, data quality, data warehousing, ascertain data management, text and content analytics, and many others that the market sometimes lumps into the information management segment. Therefore, Forrester refers to data preparation and data engagement as two separate, but closely linked segments of the business intelligence architectural cumulus. 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 beginning Business Intelligence system collects data from various sources including operation database, ERP, legacy apps, external databas e and etc. ETL tools (Extract, Transform, Load) are used to pull data from source database, transform the data so that it is compatible with the data warehouse and therefore load it into data warehouse. A Data Warehouse is a Subject-Oriented, Integrated, Time-Variant, nonvolatilizable collection of data in support of decision making.Data Warehouses be given to have these distinguishing features (1) Use a subject oriented dimensional data model (2) insure publishable data from potentially multiple sources and (3) Contain integrated reporting tools. A data mart is a deposition of data gathered from operational data and other sources that is designed to serve a particular conjunction of knowledge workers. The data whitethorn benefit 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 whitethorn d erive 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 reproduction of multidimensional data, with the goal of analysis. * A peg table is a great reporting tool that allows for slicing and dicing data. * cogitation It gives brief report about output Business Intelligence ETL tools Data Warehouse Marketing Data market Finance Data Mart Distribution Data Mart BI OLAP ReportsPivot Table Data gethered common fig tree 4. ARCHITECTURE OF BI 5. SUCCESS FACTOR OF IMPLEMENTATION Before implementing a BI solution, it is worth taking assorted factors into consideration onwards proceeding. According to Kimball et al. , these are the three critical areas that you need to assess within your organization before getting ready to do a BI switch 1. The level of commitment and shopship of the throw away from ranking(pr enominal) management 2. The level of business need for creating a BI writ of execution 3. The amount and quality of business data available . 1 BUSINESS SPONSERSHIP The commitment and sponsorship of senior management is according to Kimball et al. , the most important criteria for assessment. This is because having strong management backing helps overwhelm shortcomings elsewhere in the digest. However, as Kimball et al. state even the most elegantly designed DW/BI system cannot overcome a neglect of business management sponsorship. It is important that management personnel who participate in the show have a vision and an idea of the benefits and drawbacks of implementing a BI system.The best business sponsor should have organizational clout and should be well committed within the organization. It is ideal that the business sponsor is demanding but also able to be realistic and supportive if the execution runs into delays or drawbacks. The management sponsor also needs to be ab le to assume accountability and to take responsibility for failures and setbacks on the project. Support from multiple 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 attempt to pull the project in different directions, such as if different departments want to put more focus on their usage. This issue can be countered by an early and specific analysis of the business areas that benefit the most from the effectuation. All stakeholders in project should participate in this analysis in order for them to feel self-command of the project and to find common ground.Another management problem that should be encountered before start of implementation is if the business sponsor is overly aggressive. If the management respective(prenominal) 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 extra implementations of extra data may add many months to the original plan, its wise to make sure the person from management is aware of his actions. 5. 2 BUSINESS NEEDSBecause of the close relationship with senior management, another critical thing that must be assessed before the project begins is whether or not there is a business need and whether there is a clear business benefit by doing the implementation. 15 The needs and benefits of the implementation are sometimes driven by competition and the need to have an advantage in the market. Another reason for a business-driven approach to implementation of BI is the acquisition of other organizations that enlarge the original organization it can sometimes be beneficial to implement DW or BI in order to create more oversight.Companies that implement BI are very much large, multinational organizations with diverse subsidiaries. A well-designed BI solution provides a amalgamated view of key business data not available anyplace else in the organization, giving management visibility and control over measures that other 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 right-hand(a) data, or with too little quality data, any BI implementation fails. Before implementation it is a ood idea to do data profiling. This analysis identifies the content, consistency and structure of the data. This should be done as early 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 correctly collect data. When planning for business data and business intelligence requirements, it is forever advisable to consider specific scenarios that apply to a particular organizatio n, and thence select the business intelligence features best suited for the scenario.Often, scenarios revolve nigh distinct business processes, each built 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 correspond to the essential steps of business intelligence. These essential steps of business intelligence includes but 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. playact on those data collected 6. 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 accepted and utilized by the users in order for it to add value to the organization. If the usabili ty of the system is poor, the users may become frustrated and give a considerable amount of time figuring out how to use the system or may not be able to truly use the system.If the system does not add value to the users? mission, they precisely 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 disembodied spiritcycle, for example at the requirements forum phase. This can provide an insight into the business process and what the users need from the BI system. There are several methods for gathering 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 degree it is possible to achieve 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 focusing on the user experience offered by the BI applications, it may also possibly motivate the users to utilize the system by adding an factor 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 see how well their departments are doing and canvas themselves to others and this may spur them to encourage their staff to utilize 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 implemented motion dashboards for all call agents, with monthly incentive bonuses tied to exertion metrics. Also, agents could compare their performance to other team members. The implementation of this type of performance measurement and competition significantly improved agent performance.BI chances of success can be improved by involvi ng senior management to help make BI a part of the organizational culture, and by providing the users with necessary tools, training, and support. fosterage encourages more people to use the BI application. Providing user support is necessary to maintain the BI system and resolve user problems. User support can be incorporated in many ways, for example by creating a website. The website should contain great content and tools for determination the necessary information. Furthermore, help desk support can be used. The help desk can be man by power users or the DW/BI project team. . MARKET engineer There are a number of business intelligence vendors, often categorized into the remaining independent pure-play vendors and consolidated 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) kinda than purchase one comprehensive inte grated 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 tolerable to adapt to new regulations and changes to existing law. 8. SEMI-STRUCTURED OR UNSTRUCTURED DATA Businesses create a huge amount of valuable information in the form of e-mails, memos, notes from call-centers, news, user groups, chats, reports, web-pages, presentations, image-files, video-files, and marketing material 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 ambiguous data. However, organizations of ten 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 collar workers spend anywhere from 30 to 40 percent of their time searching, finding and assessing unorganized data.BI uses both structured and unstructured data, but the former is easy to search, and the latter contains a large amount of money of the information needed for analysis and decision making. Because of the difficulty of properly searching, finding and assessing unstructured or semi-structured data, organizations may not draw upon these vast reservoirs of information, which could curve a particular decision, task or project. This can ultimately lead to poorly 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 comparative database systems, unstructured data cannot be stored in predictably ordered colums and rows. iodin 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 refer 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 conform 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 accurate to talk about this as semi-structured documents or data, but no specific consens us seems to have been reached.Unstructured data can also simply be the knowledge that business users have about future business trends. Business forecasting naturally aligns with the BI system because business users have in mind 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 variety of formats. 2. Terminology Among researchers and analysts, there is a need to develop a standardized terminology. 3. Volume of data As tell 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 unstr uctured textual data A simple 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. But a simple search is crude. It does not find references to crime, arson, murder, embezzlement, vehicular homicide, and such, even though these crimes are types of felonies. 8. 3 THE USE 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 aut omatic catagorision and information extraction. 9. USES AND EXAMPLES OF BI 9. 1 WHICH TYPE OF COMPANY USE IT? * Hotel/ eating place 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 disperse it. Food chain/Retail stores They use BI tool for better market place. they use it for better supply chain management and economical 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 flickering away not to check for it. ring mart, Relience fresh use business intelligence. For better profit and selling. 9. 2 EXAMPLES OF BI 1 . Microsoft business intelligence 2. pantaho 3. oracle business intelligence 10.BENIFITS AND DISA DVANTAGES 10. 1 BENIFITS 1. Continuous 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 jam analysis 9. Market customer penetration 10. Product service life cycle analysis 11. Budgeting planning 12. Business performance 13. Customer click stream information 4. Integration of traditional business e-business 15. HR performance evaluation 16. Compression analysis 17. Workforce planning optimization 10. 2 DISADVANTAGES 1. Cost 2. Pilling of historical data 3. Complexity 4. Limited use 11. in store(predicate) 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 reg ularly 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 total budget for business intelligence. * By 2012, one-third 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 cloud computing, social networking, data visulization, mobili BI, predictive analitic, cloud compiting and multitouch. Other business intelligence trends include the following