complete assignment of programing and networking, Assignments of Programming Languages

Download complete assignment of programing and networking and more Assignments Programming Languages in PDF only on Docsity!

BTEC HND in Computing/ Third Semester)

Business

Intelligence Part

Anil Chhantyal Thapa

STUDENT DECLARATION

I have read and understood Pearson Edexcel Policy on Academic dishonesty and Plagiarism. I can confirm the following details: Programme / Qualification Name: BTEC HND in Computing Student ID / Registration Number: 201902ITA Name: Anil Chhantyal Thapa Centre Name: ISMT College Module Name: Business Intelligence Module Leader: Aashish Kc I confirm that this is my own work and that I have not plagiarized any part of it. I have also noted the assessment criteria and pass mark for assignments. Student Signature: Submitted date: 12/14/ Anil Chhantyal Thapa (BTEC HND in Computing/ Third Semester)

• Part-2......................................................................................................................................................
• organization............................................................................................................................................ P2 Compare the types of support available for business decision- making at varying levels within an
• Introduction............................................................................................................................................
  • Business Decision Making.................................................................................................................
  • Types of Decision Making..................................................................................................................
  • Potential Impact of the Types of Decision making............................................................................
• M2........................................................................................................................................................
• Justify, with specific examples, the key features of business intelligence functionality.....................
• Business intelligence functionality:......................................................................................................
  • Problem-solving................................................................................................................................
  • Functionalities of business intelligence............................................................................................
  • What is Business Intelligence Software?..........................................................................................
  • Key capabilities of Business Intelligence Software..........................................................................
    • 1. Filtering and transforming data................................................................................................
    • 2. Preparing reports & dashboards...............................................................................................
    • 3. Preparing and Cleaning Data....................................................................................................
    • 4. Cloud BI...................................................................................................................................
    • 5. Visualizing Data.......................................................................................................................
    • 6. Analytic Dashboards................................................................................................................
    • 7. Self-Service Data Preparation..................................................................................................
    • 8. Using Predictive models...........................................................................................................
    • 9. Embed Analytic Content..........................................................................................................
    • 10. Adaptive Security...................................................................................................................
    • 11. Data Lineage Tracking...........................................................................................................
• Conclusion............................................................................................................................................
• D2.........................................................................................................................................................
• organizations at operational, tactical and strategic levels.................................................................... Compare and Contrast a range of information Systems and technologies that can be used to support
  • Strategic Level:.................................................................................................................................
  • Operational level:..............................................................................................................................
  • Tactical Level:..................................................................................................................................
• Part 3....................................................................................................................................................
• Introduction..........................................................................................................................................
• Business Intelligence............................................................................................................................
• Business Intelligence being used..........................................................................................................
  • Implementation of BI........................................................................................................................
  • Analytics...........................................................................................................................................
  • Descriptive analysis..........................................................................................................................
  • Predictive analysis............................................................................................................................
• support problem- solving or decision-making at an advanced level.................................................... P4 Design a business intelligence tool, application or interface that can perform a specific task to
• M3 Customize the design to ensure that it is user-friendly and has a functional interface..................
• requirement and identify what customization has been integrated into the design.............................. D3 Provide a critical review of the design in terms of how it meets a specific user or business
  • Let’s take a look at how Power BI and Excel compare....................................................................
  • Conclusion........................................................................................................................................
• Section 2...............................................................................................................................................
• P5 Discuss how business intelligence tools can contribute to effective decision-making...................
• Decision Making..................................................................................................................................
  • Business intelligence tool in decision making:.................................................................................
  • How BI tools helps in decision making?..........................................................................................
• P6..........................................................................................................................................................
• Explore the legal issues involved in the secure exploitation of business intelligence tools................
  • Discovering BI Security Risk:..........................................................................................................
  • Legal Issue involved in the secure exploitation of BI tools..............................................................
• Cybersecurity law:................................................................................................................................
• Social issue:..........................................................................................................................................
• Legal issue:...........................................................................................................................................
  • How can we reduce the BI legal issue?............................................................................................
• M4........................................................................................................................................................
• tools to enhance or improve operations................................................................................................ Conduct research to identify specific examples of organizations that have used business intelligence
  • Justification:......................................................................................................................................
• D4.........................................................................................................................................................
• them more competitive within the market, taking security legislation into consideration................... Evaluate how organizations could use business intelligence to extend their target audience and make - Talking about the competitive market.......................................................................................... - To Beat the Competition, Know the Competition:....................................................................... - The Overall Best Source of Data..................................................................................................
  • Access Information efficiently.........................................................................................................
  • Align KPIs (Key overall performance Indicator) With Business Strategies....................................
  • Empower Employees........................................................................................................................
  • Efficient data Entry and Reporting...................................................................................................
  • Better Customer Insights..................................................................................................................
  • Access sales Information..................................................................................................................
  • Save Money......................................................................................................................................
  • Increase Productivity........................................................................................................................
  • Better security...................................................................................................................................
• Conclusion............................................................................................................................................
• References............................................................................................................................................

Types of Decision Making Figure 1 Type of decission making (rapid-business, n.d.) There are three main classifications or types of decision making supported by business intelligence. They can be characterized by their frequency and impact on the organization. The impact can be quantified in terms of risk of failure or mishap and by the level of financial success achieved. It can take many years for the consequences of a decision to appear. The time for the effect of a decision to be seen is a useful and important way of classifying the potential impact of decisions. There are three types  Strategic  Tactical  Routine or Operational Each of these types of decision can also be defined by the type of data needed to support them. These decisions should be classed as data driven decision making. Anil Chhantyal Thapa (BTEC HND in Computing/ Third Semester)

Potential Impact of the Types of Decision making The following chart depicts the frequency of decision and types of decision making against its potential impact on the organization. Figure 2 types of decision making and the impact Anil Chhantyal Thapa (BTEC HND in Computing/ Third Semester)

Tactical Decisions Tactical preparation is carried out at the middle administration level, which includes, in particular, the allocation of resources and the use of resources to attain organizational goals. Tactical plans cover shorter timeframes and are associated with less ambiguity and consequently decrease threat in contrast to strategic planning. Tactical stage manufacturing planning is a medium-term planning process. (Planning length ranging from 2 to three years). Tactical guidance is more often than not involved with finding out exactly how the resources of the employer will be used to accomplish the strategic objectives of the organization. Tactical planning entails much less ambiguity and consequently less hazard compared to strategic planning. Mainly planning requires statistics generated internally are more frequent e.g. weekly, monthly. Examples would be:  Change product pricing  Reschedule work  Reorganize a department The impact of these types of decision is of a medium nature in terms of risk to the organisation and impact on profitability. The data used to drive this type of decision is usually found in summaries of routine transactions e.g. sales orders from the next level or classification. Tactical decisions include:  Establishing parameters for measuring operational efficiency and productivity.  Making plans to improve utilization of existing resources.  Prepare equipment and manpower planning.  Planning for modernization of the facilitates and automation.  Specific technology and tools to enhance production efficiency or productivity.  Prepares work plans for process redesign, methods improvement and job design.  Make or buy decision.  Projections regarding skill requirements for future work assignment and prepare the skill development plans.  Planning for medium term maintenance (preventive and condition monitoring) to enhance the availability of production facilities. Characteristics of Tactical decision:  Planning for the medium term ranging between 2–3 years.  Focus is on fixing performance parameters and generating data to compare actual and planned performance and taking steps to reduce gap between planned and actual. Anil Chhantyal Thapa (BTEC HND in Computing/ Third Semester)

 Prepares plans for effective utilization of existing resources.  Plans to enhance equipment availability and overall productivity of the production function. The examples of tactical decisions are as follows:  Reschedule work  Maintaining a house  Change product pricing  Reorganize a department  Action performed on the daily basis. Operational or Routine Decisions Operational planning selections are taken at the backside administration stage and these are events decisions. These plans are prepared to establish the actions quintessential to reap the operational objectives. We span a shorter period, i.e. within a year. There is no or very little confusion about these plans and the information wanted is internal. They are set out in precise quantitative terms and can be set out in phrases of time and targets. Lower-level administration establishes operating strategies and the planning duration is (maximum) one year. These plans shall set out the actions indispensable to gain the operational objectives. Such plans are deterministic in that the variance is very small. The plans are expressed in terms of actions that can be quantified.are usually very frequent e.g. hourly, daily but can have a lesser impact on the organisation. For example  How to answer a sales enquiry  Approve a quotation  Approve an Invoice The data used to drive this decision type is usually prescribed or defined in the procedures and rules of the organisation. (rapid-business-intelligence-success, 2021) Operational examples could include product positioning or pricing. Tactical decisions could include financial outlays to gain competitive advantage. Strategic business decisions could include priorities, goals setting and forecasting for the future, global diversification etc. Characteristics of Operational Level Production Plans:

1. Plans are definite, and action oriented.
2. Plans are expressed in terms of parameters, which can be quantified.
3. Plans give the detailed instructions regarding. a. What is to be done? b. Who should do? Anil Chhantyal Thapa (BTEC HND in Computing/ Third Semester)

of names, and is used in distinct business, science, and social science domains. In contemporary enterprise world, facts evaluation performs a function in making decisions greater scientific and helping businesses operate extra effectively. Data mining is a particular information analysis technique that focuses on statistical modeling and information discovery for predictive alternatively than basically descriptive purposes, whilst commercial enterprise brain covers statistics analysis that relies heavily on aggregation, focusing often on business information. In commercial enterprise giant wide variety of records has to be analyze. In order to do that we used enterprise brain software. For example: believe university as open on line registration for the new pupil so that students can ship their information from online. In the online form, many data has to be crammed some may also give write records and some can give incorrect so facts need to be analyzed. In number column some can supply incorrect number or variety which is now not even smartphone number. Problem-solving BI Tools solve many problems which occur in daily business. Such as:  Poor performance Management  Slow market response  Losing customers  Chaos in Day to day Oerations  Wasting tine on Compiling Multiple System Instead of Analysis Data  Reliance on Tech Terms to develop Custom Reports  Limited access to data Anil Chhantyal Thapa (BTEC HND in Computing/ Third Semester)

Functionalities of business intelligence For the past decade, data has turned out to be the most valued commodity for many businesses. Data informs both small and major decision-making, eventually setting the course of an organization’s entire strategy. Each day, about 2.5 quintillion of data is created and it would be bad business if all this is ignored. Organizations that adopt BI tools profit from understandable and actionable data that they can use to optimize business performance. Business Intelligence streamlines operations, reduces workload and improves productivity. This is all possible through critical BI capabilities. For users, perhaps the most important aspect of modern reporting tools is that they are available inside the apps that they use to conduct their daily work routines. According to a PAT RESEARCH report, 84% of business users agree that gaining access to business intelligence is crucial. Regrettably, almost 67% of business users still have to toggle between standalone spread sheets and other applications to get to the information they need. Luckily, modern BI platforms are giving application teams new ways to engage their users with the latest reports, dashboards and embedded analytics. And companies are reporting increased in revenue as result of business intelligence. Anil Chhantyal Thapa (BTEC HND in Computing/ Third Semester)

Business intelligence software tools can be distributed in a number of ways including:  Cloud Computing implementation: public cloud, hybrid cloud or private cloud which are SaaS: hosted  On-premise install: installed in-house using either a leased or owned equipment. Key capabilities of Business Intelligence Software

1. Filtering and transforming data Data filtering involves reorganizing, transforming, summarizing, aggregating, and dis-aggregating data. Transformation creates, modifies or passes data to target structures such as tables, and files. Business Intelligence software provides the ability to filter and transform data. 2. Preparing reports & dashboards Reports allow you to place large amounts of data into multi-dimensional tables, charts, and dashboards. Dashboard is a graphical user interface that provides at-a-glance views of key performance indicators (KPIs). The dashboard provides a pictorial representation of data generated by reports and visualization of data in pictorial format helps us to understand the stats in a quick manner. 3. Preparing and Cleaning Data All Business intelligence capabilities, functionalities and features focus on data. However, that data must first be collected. Data collection is done from multiple sources such as legacy systems, operational erp, crm and other MIS Business Intelligence tools do this by sorting unstructured data, deleting matching entries and mistakes as it goes. Once the raw unstructured data has been turned into structured data, it then can be analyzed. After collection and organization, the business intelligence software creates and runs probes against data sets so as to draw actionable insights from the disarray of unstructured data. These insights can then be presented in data visualizations like charts, infographics, graphs¸ animations and dashboards. The visualizations make the analytical results easy for the human mind to process and understand, which helps administrations make data-driven decisions. Anil Chhantyal Thapa (BTEC HND in Computing/ Third Semester)

Figure 4 Top Key capabilites of Business Intelligence Software Anil Chhantyal Thapa (BTEC HND in Computing/ Third Semester)

and theories, expect changes in the competitive landscape and influence data for investigative purpose.

8. Using Predictive models Predictive modeling involves creating, testing and validating a model to best predict the probability of an outcome. One or more classifiers can be used in predictive Modelling to assess the possibility of a data set fitting in another set. Predictive modelling is one of the most valuable features of BI software. This capability allows businesses to predict market trends, sales, staffing needs, profits and losses among other things. 9. Embed Analytic Content Embedded analytics is a set of capabilities that are tightly incorporated into existing systems like ERP, CRM, financial systems, and marketing automation. It involves the incorporation of business intelligence tools and capabilities into business software including enterprise planning (ERP), Customer relationship management (CRM), financial systems and marketing automation. Integration enables business users to have easy access to Business Intelligence tools while executing everyday tasks. Having real-time accesses enables more conversant and effective decision-making. Analytics functionality embedded within business software includes data visualization, dashboards¸ self-service analytics, benchmarking, visual workflows, interactive and static reports as well as mobile reports. 10. Adaptive Security In today’s threat landscape, it is impossible to talk about data without discussing data security. Whether the goal is to limit access inside an agency or protect data from outside threat¸ information and application security are top of mind for many firms especially in verticals like finance and healthcare. For any application crews adding or improving the embedded analytics in their app, one of the issue with security is that it often means reproducing their current security efforts, taking up a large amount of time and resources. The majority of BI tools force developers to recreate the same validation and authorization models they have included in other systems inside a new BI application. This is why adaptive security is one of the business intelligence capabilities that is transforming the BI market. With adaptive security, product teams can incorporate existing security measures into new applications, which will significantly reduce the burden on security personnel as well as developers. 11. Data Lineage Tracking Understanding how data is created, how it is shared and what becomes of it is crucial to properly using it. Data lineage is a process that tracks data from its source to where it moves over its lifetime. Tracking data lineage generates a complete, continuous record of system activity as it goes through various procedures. It can be represented visually to follow its movement from source of destination in order to help businesses understand how and why different data points changed. This Business Anil Chhantyal Thapa (BTEC HND in Computing/ Third Semester)

Intelligence capability is especially important when handling Big Data. (predictiveanalyticstoday.com, 2021) Conclusion BI professional spends much of their time building and maintaining ETL. Most BI tools were developed decades ago for a much simpler data setting and have not kept up with the quickly developing business data landscape. Instead of undertaking intricate transformations and incorporating data sources inside expensive and complex ETL software, modern Business Intelligence software enable businesses to create links between data sources faster within their BI environment. Users can define their own key metrics, allowing BI teams to focus on more strategic analytics and more complex data sources. D Compare and Contrast a range of information Systems and technologies that can be used to support organizations at operational, tactical and strategic levels. There are six different types of information system technologies that can be used in support of operational, tactical and strategic levels in organizations. Figure 5 different types of information systems  Transaction processing system- The program is run at the operational level that is required to support operations management. This system's processes include reviewing, validating, naming, sorting, combining, measuring, etc. The above are the inputs and the outputs are Tables, Auction reports and Information reports. Examples of TPS are System for payments and funds transfers, reservation system, payroll system,etc. (techopedia, techopedia.com,

Anil Chhantyal Thapa (BTEC HND in Computing/ Third Semester)