Business-Intelligence, Study Guides, Projects, Research of Business Informatics

Download Business-Intelligence and more Study Guides, Projects, Research Business Informatics in PDF only on Docsity! Higher Nationals Internal verification of assessment decisions – BTEC (RQF) INTERNAL VERIFICATION – ASSESSMENT DECISIONS Programme title Assessor Internal Verifier Unit 14: Business Intelligence 1 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Unit(s) Assignment title Student’s name Pradeeban.A List which assessment criteria the Assessor has awarded. Pass Merit Distinction 2 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Assessor signature Date Internal Verifier signature Date Programme Leader signature (if required) Date Confirm action completed Remedial action taken Give details: 5 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Assessor signature Date Internal Verifier signature Date Programme Leader signature (if required) Date 6 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Higher Nationals - Summative Assignment Feedback Form Student Name/ID Pradeeban.A / COL-A -064620 Unit Title Unit 14: Business Intelligence Assignment Number Assessor Submission Date Date Received 1st submission 7 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Descripts M4 D4 Grade: Assessor Signature: Date: Resubmission Feedback: Grade: Assessor Signature: Date: 10 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Internal Verifier’s Comments: Signature & Date: * Please note that grade decisions are provisional. They are only confirmed once internal and external moderation has taken place and grades decisions have been agreed at the assessment board. Assignment Feedback Formative Feedback: Assessor to Student Action Plan 11 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Summative feedback 12 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Assignment 01 15 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence General Guidelines 1. A cover page or title page should be attached to your assignment. Use page 1 of this assignment brief as your cover page and make sure all details are accurately filled. 2. The entire assignment brief should be attached as the first section of your assignment. 3. The assignment should be prepared using a word processing software. 4. The assignment should be word processing in an A4 sized paper. 5. Allow 1” margin on top, bottom and right sides of the paper and 1.25” on the left side (for binding). Word Processing Rules 16 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence 1. The font size should be 12 point, and should be in the style of Time New Roman. 2. Set line spacing to 1.5. Justify all paragraphs. 3. Ensure that all headings are consistent in terms of size and font style. 4. Use footer function on the word processor to insert your name, unit, assignment no, and page number on each page. This is useful if individual sheets get detached from the submission. 5. Use the spell check and grammar check function of the word processing application to review the use of language on your assignment. 17 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Student Declaration I hereby, declare that I know what plagiarism entails, namely to use another’s work and to present it as my own without attributing the sources in the correct form. I further understand what it means to copy another’s work. 1. I know that plagiarism is a punishable offence because it constitutes theft. 2. I understand the plagiarism and copying policy of Edexcel UK. 3. I know what the consequences will be if I plagiarise or copy another’s work in any of the assignments for this program. 4. I declare therefore that all work presented by me for every aspect of my program, will be my own, and where I have made use of another’s work, I will attribute the source in the correct way. 5. I acknowledge that the attachment of this document signed or not, constitutes a binding agreement between myself and Edexcel UK. 6. I understand that my assignment will not be considered as submitted if this document is not attached to the assignment. 20 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence ddeeban44@gmail.com 25/12/2020 Student’s Signature: Date: (Provide E-mail ID) (Provide Submission Date) 21 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Higher National Diploma in Business Assignment Brief Student Name /ID Number Pradeeban.A / COL/A-064620 Unit Number and Title Unit 14 : Business Intelligence Academic Year 2017/18 Unit Tutor 22 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence LO1 Discuss business processes and the mechanisms used to support business decision- making. LO2 Compare the tools and technologies associated with business intelligence functionality LO3 Demonstrate the use of business intelligence tools and technologies LO4 Discuss the impact of business intelligence tools and technologies for effective decision- making purposes and the legal/regulatory context in which they are used 25 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Assignment Brief and Guidance: Business processes are pivotal to the operation, functionality and accomplishment of organisational goals. As a collection or set of tasks/activities, business processes ensure that the end goal of delivering a service or product to a customer is accomplished successfully. Scenario: 26 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Data and information is core to any organization and business process. The necessity of having meaningful information is the key driver for effective decision making and problem- solving. Business intelligence has evolved from technologies such as decision support systems (DSS) to include tools and methods associated with data mining, data integration, data quality and data warehousing in conjunction with other information management systems and applications. Suppose you are recently recruited as a Business Analyst to a leading Sri Lankan Organisation. As your initial project, you are required to prepare a management report to the Board of Directors including the following details. Task 1: Background details of the organization. Identify and explain different business processes and supporting processes models used at the selected organisation with examples . 27 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Task 4 4.1Discuss the importance and the impact of business intelligence tools and technologies that can be used by the organization for effective decision making 4.2Describe the legal/ regulatory issues involved in the secure exploitation of business intelligence tools in an organization. What are the legal issues you can identify in the system designed by you. Identify new Business Intelligence trends and technologies that can be further enhance the operational activities in the selected organizational context 30 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Evaluate how organizations could use business intelligence to extend their target audience and make them more competitive within the market, taking security legislation into consideration Contents 31 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Introduction Business intelligence (BI)..........................................................................................34 Task 1.............................................................................................................................................37 1.1 Background details of the organization...................................................................................37 1.2 Business processing.................................................................................................................39 PLUCKING...................................................................................................................................39 WITHERING................................................................................................................................40 ROLLING.....................................................................................................................................40 FERMENTATION.........................................................................................................................41 DRYING.......................................................................................................................................42 GRADING (SIFTING)....................................................................................................................42 GRADING (SIFTING)....................................................................................................................43 Business Supporting process..........................................................................................................44 raw materials are easy to access...............................................................................................44 Supporting Infrastructure..........................................................................................................45 Reputation..................................................................................................................................45 High demand, both domestically and internationally...............................................................46 Quality Standards.......................................................................................................................47 Value Addition............................................................................................................................48 Lion Logo....................................................................................................................................49 32 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence performance has been recognized particularly for small and medium enterprises (SMEs) (Guarda et al., 2013) through improving decision support (Singh and Singh, 2013). Nowadays BI becomes an emerging trend in administering the decision making for conducting the changing environment (Isık et al., 2013), and learning to take opportunities emerging form changing circumstances (Guarda et al., 2013). BI is an information system (IS) led application that integrates the process and technology to lead to the decision making for managers and end users (Miah, 2014). It plays a significant role in analysing the business environment and providing the decision making in achieving competitive advantages emerging from uncertain often changes within the environment (Burton et al., 2006, Isık et al., 2013). The current business environment is characterised with geopolitics and economic power (Lenssen et al., 2012), complexity of new information, free market trading, and high intensity of competition because of rapid acceleration of technological advancement (Chi et al., 2009). The growing rate of technological advancement amplified industrial revolution in the world (Orlikowski and Barley, 2001). Growing effects of information systems, new emergent in technology, rapid industrial revolution, and the globalization (Al-ma, 2013) cause business environment is progressively being more turbulent (Cavalcante et al., 2011), which is beyond the management capacity of SMEs. Newness in the business competition creates new opportunities and threats for businesses (Stodder, 2013), which become the issue of business survival and development. Taking opportunities and encountering unexpected threats open a challenge for SMEs. Therefore, reviewing and restructuring the business decision become on priority. 35 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence The decision making is an emerging trend for practical solution in conducting the changing environment (Chai et al., 2013). As BI is the decision making aid, SMEs require reconfiguring BI for new decision making in conducting new changes within the environment (Stodder, 2013). It is important to note that SMEs have not only begun using BI in improving decision support (Guarda et al., 2013), they occupy a big portion of BI users. For example, approximately 85 percent of BI user firms are SMEs in Southwest China (Zhi and Guixian, 2010). Precisely, it is evident that an appropriate level of BI application and SME’s rigor position have significant effects in enhancing insights to each other. However, SMEs are characterised with limited capability that constrains new innovation of BI in businesses (Ponelis and Britz, 2011) although it is vital for new decision of SMEs. From the viewpoint of interaction, BI and SMEs can be considered as two distinct entities. In analysing the above discussion, two limitations are apparent that BI may face lack of reconfiguration or new innovation due to SME’s incapability and SMEs face difficulties to restructure decision making due to lack of BI reconfiguration. In effects, both entities fail to benefit each other, which confine integrated contribution to national economic development. Considering this issue, our study aims to identify the social reality view of relevant interaction between BI and SMEs that may enable them learn from each other for their individual development. We conducted a theoretical analysis for building a theoretical framework that may represent an integrated view of previous studies relevant to this study context. 36 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Although research on theoretical link among BI and SMEs is vast to date (example . Grabova et al., 2010, Zhi and Guixian, 2010, Ponelis and Britz, 2011, Guarda et al., 2013, Ponis and Christou, 2013, Tarek and Adel, 2016), research on how BI and SMEs learn from each other, that produces new contribution into IS-led business domain, is sparse. Therefore, this study is entailed to generate new understanding on learning issue among BI and SMEs Task 1 1.1 Background details of the organization. journey began in 1992 when the government of Sri Lanka decided to privatize the “Management” of the then existing 22 Regional Plantation Companies which consisted of Tea, 37 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence WITHERING No sooner it is received at the factory, the leaf is weighed and spread on troughs. Withering, is a process, where conditioned air is circulated between the leaves, initially to remove any surface moisture and thereafter to concentrate and chemically breakdown the tea juices. It takes 10 hours to 14 hours for the physical and chemical changes to take place, and bring the leaf to soft and rubbery condition suitable for the next stage of manufacture. ROLLING Is the process by which the leaf is twisted and the leaf cell walls ruptured to bring the juices to the surface of the leaf. The rolling machines have deep jacket, a pressure cap to apply pressure on the leaf, and the table itself has battens and a cone at the center to twist the leaf. There are also the more modern “Rotor vane” machines, which also give the same twisting and turning effect. This process takes about 20 to 30 minutes. 40 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Thereafter to separate the twisted leaf from the untwisted, and to reduce the heat buildup, the rolled leaf is passed over a roll breaker. This machine has meshed which separate rolled leaf. The unrolled is put back into the rollers for further rolling whilst the rolled leaf is fermented. FERMENTATION Of the tea juices is an essential process in the manufacture of black tea. Fermentation is the oxidization of the enzymes in the juices, which bring out the flavor, strength and the color of the liquors and infusions. Fermentations is generally carried out on glass or tiled tables. As fermentation progresses there is a color change of the leaf from greenish to coppery brown. The degree of fermentation is judged by the color and aroma. 41 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence DRYING The primary objective of drying is the extraction of moisture and the arresting of fermentation. The fermented leaf contains from 45% to 50% moisture. The leaf is passed through driers, which have circuits of trays with perforation, on which are conveyed the fermented leaf. The drying process takes about 20 to 25 minutes and the initial temperature is about 120 Degrees F(50 Degrees C) and is finished off at a temperature of 200 Degrees F (93 Degrees C) to 220 degrees F (105 Degrees C) . The moisture content of the teas when drying is completed is approximately 2% to 3% and the coppery brown fermented tea particles are now back. GRADING (SIFTING) The fired teas after cooling are graded / sifted according to size and shape, as the trade demands. The different grades of tea are identified nomenclature. On completion of the grading, teas are stored in airtight bins of boxes. The sifting is carried out on a series of grading 42 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Supporting Infrastructure As tea is one of the most lucrative businesses in the country, much supporting infrastructure has been built to accommodate its demand. As such, as a potential owner of a tea business, you will have easy access to machinery needed for the production process of tea leaves. Reputation Sri Lankan tea is a globally recognized product. As such, when launching your product, you will already have a ready consumer base. 45 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence High demand, both domestically and internationally Tea is one of the most widely consumed beverages in the world. Therefore, there is always a demand for your product both domestically and internationally. With the rise in popularity of bubble tea with younger consumers, the f&b industry has also shown a rise in their demand for tea products. Specialties Associated With Products Sri Lankan tea recognized as Ceylon Tea in the world is renowned for its high quality, aroma, and taste. As the third largest tea producer and perhaps the second largest exporter in the world, Sri Lanka is in the forefront of tea exports to the world market. This is a position that Sri Lanka has maintained over the years. There are three major geographical zones for tea cultivation in the country and the production of each cultivation has unique features in it. High/Upcountry: Above 1,200 m Nuwara Eliya - Delicately fragrant • Udapussellawa - Exquisitely tangy • Uva - Exotically aromatic • Dimbula - Refreshingly mellow Mid-Country: Between 600 m. - 1,200 m. 46 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence • Kandy - Intensely full-bodied Low-Country: Below 600 m. • Sabaragamuwa - Smooth & full-bodied • Ruhuna - Distinctively unique Uva teas from Eastern Highlands contain unique seasonal characters and are widely used in many quality blends particular in Germany and Japan. The medium grown teas provide thick coloury varieties which are popular in Australia, Europe, Japan and North America. The teas produced in low grown areas are mainly popular in Western Asia, Middle Eastern countries and CIS and BRICS countries. Most factories in these areas produced what are known as leafy grade of tea where the tea leaves are well twisted and can grade into long particles. Quality Standards Sri Lankan Tea industry maintains the highest quality in the world market and ISO 3720 is the minimum standard applies for the products. Sri Lanka has the capability to produce the cleanest tea in the world in terms of minimum pesticide residues. Methyl Bromide was removed from 47 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence 1.3 Business processes the organization in different levels and processes A business process is a series of step performed by a group of stakeholders to achieve a concrete goal these steps are repeated many times sometimes by multiple users and ideally in a standardized and optimized way A business process can be manual or automat if manual the process is achieved without the aid of automation or assisting technology if automated a technology aid been put into place which assists users in implementing the process in a more accurate standardized or optimized manner it is the fundamental building block for several related ideas such as business process management process automation In other words a business can be defined as a collection liked tasks which find their end in the delivery of a service or product to a client A business process has also been defined as a set of activities and tasks that once completed will accomplish an organization goal the process must involve clearly Defined input and a single output these inputs are made up of all of the factors which contribute (either directly or indirectly ) to the added value of a service or product these factors can be categorized into management process operational process and supporting business process Operational processes Operational processes (or primary processes): Operational or primary processes deal with the core business and value chain. These processes deliver value to the customer by helping to 50 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence produce a product or service. Operational processes represent essential business activities that accomplish business objectives, e.g., generating revenue. Some examples of this include taking customer orders and managing bank accounts. Supporting processes Supporting processes (or secondary processes): Support processes are the processes which do not deliver the final product/service to the client, but it creates an environment that is suitable for the primary processes to function smoothly. These processes do not directly generate value to the customer. Having said that, the support processes are also vital for the enterprise Supporting processes back core processes and functions within an organization. Examples of supporting or management processes include accounting, HR management and workplace safety. One key differentiator between operational and support processes is that support processes do not provide value to customers directly. Management processes Management processes do not add value to the end customer. These processes are more oriented to monitoring and analyzing the business activities. These processes deal in up scaling the business, introducing new verticals and bringing innovation to the firm. Management processes are goal oriented and aim at designing and achieving tangible as well as intangible targets. Management processes measure, monitor and control activities related to business procedures and systems. Examples of management processes include internal communications, 51 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence governance, strategic planning, budgeting, and infrastructure or capacity management. Like supporting processes, management processes do not provide value directly to the customers. References Sri Lanka Export Development Board , INDUSTRY CAPABILITY REPORT Type of Business Processes business processes span industries, both vertical and hotel and can include any type of business operation Examples include Manufacturing product assembly process, a quality assurance process, a corrective/prevue maintenance process  Finance an Invoicing process, a billing process, a risk management process 52 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence  Compliance - a safety audit, a legal check Sales Information Technology Quotes/ Pricing –     Incised & Fix Underwriting   IT request Management Contract Approval . Access Control Now Cent Onboard   Portfolio Manager Compensation Change Control Meeting Planning App/System Support RFP admin   Legal Finance Contract Management Invoice admin Invitation Procurement New Flip/Case Management Project Budget Approval Regulatory Filing Expense Management Legal Doc Management budge Panning Customer Service Human Resources Case Management Recruitment Client Feedback New Hire Onboarding Inquiry Management Compensation Pan & Admin 55 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Escalation Management Benefits Administration SAM management Performance Management Support Services Training   Employee State Change   Transfer /Relocation   leave Management Compliance Product development and Research Know Your Customer Requirement Patriot Act Product Specifications Sarbanes Oy Change Request Man HIPAA Research Basel Lifecycle Management GLBA   FISMA   Manufacturing Marketing Resource prominent Adverting Order Management Events Management Change request Packaging a Poring Trading Partner Management Communication Deed /Recall Man Creative Development Equipment/System Repair   Quality Assurance   Operations Inventory Management 56 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Order Furmint Clint Management Events Management Facts Management Award Distribution 57 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Unstructured data Unstructured data is a data which is not organized in a predefined manner or does not have a predefined data model, thus it is not a good fit for a mainstream relational database. So for Unstructured data, there are alternative platforms for storing and managing, it is increasingly prevalent in IT systems and is used by organizations in a variety of business intelligence and analytics applications. Example: Word, PDF, Text, Media logs. PROPERTIES STRUCTURED DATA SEMI-STRUCTURED DATA UNSTRUCTURED DATA 60 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Technology It is based on Relational database table It is based on XML/RDF(Resource Description Framework). It is based on character and binary data   Transaction management Matured transaction and various concurrency techniques Transaction is adapted from DBMS not matured No transaction management and no concurrency   Version management Versioning over tuples, row, tables Versioning over tuples or graph is possible Versioned as a whole 61 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Flexibility It is schema dependent and less flexible It is more flexible than structured data but less flexible than unstructured data It is more flexible and there is absence of schema Scalability It is very difficult to scale DB schema It’s scaling is simpler than structured data It is more scalable. 62 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence program used for enhancing the content itself. The content gets entry to software are useful for human beings inside the field of digital content. Collaborative Microsoft software program: These are regularly net-based totally software program, which contains using extra than 1 character. Enterprise Infrastructure software: It helps the software systems in an employer. Normally, the one of a-kind databases, email servers, and so on., are covered under this class. Media Development software program: This software is utilized by human beings in both the print and the digital software program 65 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Application Suite Microsoft Office, iWork, Open Office, etc., are examples of utility suite, as they arrive bundled with a number of packages like the phrase processor, spreadsheet, and so forth. Enterprise Resource Software There are extraordinary varieties of software that come beneath the class. The examples are consumer relationship management software program, economic software program, medical billing software, departmental software program, time management software, IT Helpdesk software program, church control software program, manufacturing software, etc. 66 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Content Access Software Most folks have definitely used this form of the software program. As a count of truth, internet browsers are nothing but content material get right of entry to software. The other examples are media players, help browsers, and so on. Collaborative Software The examples of collaborative software are emails, blogs, Wikipedia, etc. 67 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence locate hazards for the identical because, in the long run, the cause of all these devices is to perform many obligations with their assistance. Application Software The one-of-a-kind forms of utility software are utilized by person customers and business companies as nicely, and that they have many benefits of doing so. This consists of the phrase processing software program, database software, multimedia software, modifying software program, and many another one of a kind sorts as nicely. All these software programs are both furnished in my opinion, or they are packaged collectively and offered through enterprise to commercial enterprise sellers. When an entire type of them are integrated collectively and offered to an enterprise, they are able to soak up the shape of employer software, instructional software, simulation software program, statistics employee software, and so forth. 70 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence 1.6 Advantages of using application software as a mechanism for business processing. Advantages When you start to compare, you will discover that the pros outweigh the cons very easily. With that in thoughts, right here are a number of their maximum famous and widely time honoured blessings. Note that during this scenario, we are speaking of utility software this is designed for a selected purpose, for use either by way of individuals or by using organizations. The chance of viruses invading custom-made programs could be very small, given that any business that incorporates it can restrict access and may provide with the method to guard their community as well Program 71 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Licensed application software receives regular updates from the developer for safety motives. Additionally, the also regularly sends personnel to accurate any problems which can get up occasionally Their single biggest advantage is that they meet the exact needs of the user. Since they are designed specifically with one purpose in mind, the user knows that he has to use one specific software to accomplish his task. Disadvantages As is the case with all such subjects, there are certain dangers of such software program as nicely. Though these aren’t spoken approximately very frequently, nor are they highlighted, the reality is that they do exist and have an effect on positive users. But humans have time-honored those misgivings and nevertheless keep to apply for such software program because their utility and significance is a lot greater profound than their weaknesses. 72 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence customer sentiment, improve the customer experience, and for quality assurance purposes, just to name a few. Predictive Modeling Predictive modeling is a BI technique that utilizes statistical techniques to create models that could be used in forecasting probabilities and trends. With predictive modeling, it is possible to predict the value for a particular data item as well as the attributes using multiple statistical models. 75 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence OLAP Online analytical processing is a technique for solving analytical problems with different dimensions. The most important value in OLAP is its multidimensional aspect that lets users identify problems from different perspectives. OLAP could be used to complete tasks such as budgeting, CRM data analysis, and financial forecasting. Data Mining Data mining is a technique for discovering patterns in huge datasets and often incorporates database systems, statistics, and machine learning to find these patterns. Data mining is an integral process for data management as well as the pre-processing of data since it ensures appropriate data structuring. End users could also use data mining to create models that reveal 76 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence these patterns. For instance, a business could mine CRM data to predict which leads will most likely buy a certain solution or product. Model Visualization The model visualization technique is used to transform the discovered facts into histograms, plots, charts and other visuals that aid in proper interpretation of the insights 77 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Dundas BI Dundas BI is a browser-based BI tool that allows users to connect to multiple data sources in real-time. It provides great visualizations in tables, graphs and charts that could be customized and viewed from mobile devices and desktops. Users can easily build reports and extract certain performance metrics for purposes of analysis. Dundas offers support to all company types and across different industries. Here are few valued competences of Microsoft Power BI tool: 80 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Integrates seamlessly with existing applications: Power BI integrates easily with your existing business environment allowing you to adopt analytics and reporting capabilities. Microsoft Azure consultants can also help in leveraging this intuitive tool to embed interactive visuals in your applications easily. Rich personalized dashboards: The crowning feature of Power BI is the information dashboards, which can be customized to meet the exact need of any enterprise. You can easily embed the dashboards and BI reports in the applications to provide a unified user experience 81 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence No memory and speed constraints: Shifting an existing BI system to powerful cloud environment with Power BI embedded eliminates memory and speed constraints ensuring data is quickly retrievable and analyzed. Extracting business intelligence rapidly and accurately: It helps in transforming your enterprise data into rich visuals, thus extracting business intelligence for enhanced decision making. 82 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Data Management Technology Data management technology refers to methods used by business to organize, secure, store, and retrieve information. Every company, no matter how large or small it may be, creates an infinite amount of data through its every day activities. Data management technology, typically in the form of software, is used to draw meaningful conclusions and formulate actionable goals Database Access Software An explanation of Style Intelligence's architecture and ability to access multiple, disparate databases, any via a JDBC connector as well as OLAP cubes, flat files, Web services and other databases. Database access software is a core component of Nessoft’s business intelligence software platform. The software can access multiple, disparate databases, any via a JDBC connector as well as OLAP cubes, flat files, Web services and other databases. Speedy Data Access is enabled by Nessoft’s patent-pending Data Block technology across a variety of data sources including relational databases, multi-dimensional databases, Web services, 85 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence flat files and more. 86 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Task 2 2.1 Business Decision making at different levels of the organizational structure 87 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence 2. It helps to achieve the competitive advantages and to develop core competence 3. It helps to develop strengths and eliminate weaknesses to encash the available opportunities 4. It gives direction to growth and development of business 5. Strategic level planning lays foundations for tactical goals and operational goals 90 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence 5. These planning decisions are critical to success or failure of the organization. 6. Strategic decisions are to be taken with less information and also in the environment of uncertainty 7. and risk All the strategic level planning is always associated with risk and it is used in some futuristic assumption 91 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Tactical Decision Semi Structured Decision) These decisions relate to the implementation of strategy decisions They are directed towards developing divisional plans structuring workflows establishing distribution channel, acquisition of resources such men materials and money the downs are taken at the middle level of management Tactical decisions cover shorter time (between three to five year) frames and is associated with less uncertainty and hence lower risk as compared to strategic decisions Tactical planning involves less uncertainty and hence lower A compared to strategic planning Mainly the planning requires internally generated data 92 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence 6. Prepares work plans for process redesign, methods improvement and job design. 7. Make or buy decision 8. A Projections regarding soil requirements for future work assignment and prepare the skill development plans 95 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence 9. Planning for medium term maintenance (preventive and condition monitor to enhance the availability of production facilities. Operational Decisions (Structured Decision) These decisions relate to day to-day operations of the enterprise. They have a short term horizon (maximum One year as they are taken repetitively. These decisions are based on facts regarding the events and do not require much of business judgments. Operational decisions are taken at lower levels of management. As the information is needed for helping the manager to take rational well informed decisions, information systems need to focus on the process of managerial decision making Normally these types of decisions are frequent, detailed and arrow focused deterministic in the sense that uncertainty is very low. The decisions are expressed in terms of action, which can be quantified. 96 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence Characteristics of Operational Decisions 1. Plans are definite and action oriented 2. Plans are expressed in terms of parameters, which can be quantified, 97 | P a g e Pradeeban.A Col/A-064620 Unit_14 Business Intelligence