Proposal For BI System Development For Star Max - Essay.

Based on, or within, an organisational environment of your choosing, provide a business case for a proposed BI system development for that organization. This could be a completely new BI system proposal (if there was none already present within your chosen company) or provide proposed changes to the existing BI System within your chosen company. The business case should allow senior management within the selected organization to effectively assess the feasibility of your proposal. You will require you to provide at least the following information:

• An overview of the BI system proposal, which may include the management information it will provide, its possible data source(s) and its underlying technical architecture.
  
  
• How the BI system proposal aligns with the organisation’s corporate strategy.
  
  
• A competitor analysis of their existing BI systems, and what this means for the BI systems proposal for your chosen company.
  
  
• An overview of the current position with respect to MSS within the organization and how the BI system proposal overcomes any weaknesses in these systems.
  
  
• Cost Benefit Analysis.
  
  
• Risk Assessment.

Discussion of BI system

This report aims to present a proposal for a specific BI system for Star Max. A business intelligence proposal alignment with the strategic objectives is provided in this report. An analysis of the Business Intelligent Systems of the competitors of the company is delivered in this report. A brief overview of the existing IS/IT infrastructure evaluation is provided in this report. The architecture of the proposed business intelligence system has been presented in this report. A cost benefit analysis is provided in this report. A detailed risk assessment is presented in this report of Star Max.

The methods, applications, and the technology that is utilised for presentation and the integration of the information of business is known as the Business Intelligence System. The organisation SmartHome Mach intends to utilise the function of BI system for making the decisions of management of the organisation. The company comprises of increased meaningful and tactical decisions of business (Starhome 2018). The company processes the raw data into some meaningful information for making an informed decision of business.

The most common data sources that are utilised by the company are the flat files, web services, databases and several other RSS feeds. The company recently implemented the technology of Customer Relationship Management, E-Commerce, and Enterprise Resource Planning for extracting better and quality data for making informed decisions and plan strategically for the future. The data that is collected from doing business with the customers could then be used for predicting the customer preferences in the future and also provide optimised recommendations to the customer for simplifying the buying process of the customers. The servers and the systems of the company consists of operating systems and databases which supports the company in managing business.

The corporate strategy of the company is that the company aims to expand the segments where Star Max owns a competitive advantage and expand the products offered by the company. The strategy of the company claims to leverage the top position and then pursue the opportunities of growth. The business system proposal to manage the business with improved information aligns with the corporate strategy as proposal provides the company some modification in the BI systems like the access to updated information and accurate information would help them in achieving the strategic goals of the company.

Some of the competitors of Star Max like the company, Syniverse utilises BI system for improving the decision making process. The tools of business intelligence are significantly the data-driven Decision Support Systems and it is often utilised interchangeably with the briefing books, executive information systems and the query tools. These functions are obtained by the features of BI systems in the companies that includes:

The first task of any BI systems is the collection of data from the source systems.. The tools of BI execute this by using several algorithms for quickly sorting the unstructured data, eliminating any redundancies and any error.

This is method of tracking data from the origin to the destination. This method is used for creating, ongoing record system activity as it takes part in several processes to have the updated information regarding the present developments in the market. This method is used in the company for tracking the processes backwards, that means starting at the end results and follow the data to the source for discovering any anomalies that might have happened in the process due to which results are not obtained.

Proposal alignment

Some of the key elements of the competitors of the company are:

• Source systems: This is the initial part in the architecture of the BI system. The data of the organisation is first stored in these databases and this process is considered as significantly important for the organisation. It allows the tracking of data over significant amount of time.
• Data modelling: The modelling of data would help in addressing the accurate information from the sources of data. The modelling of data would help in organising and will help in reducing the cost of replication of storage, and the effort that is required for building a warehouse of data.
• BI hardware: it is necessary for making the decisions on the requirements of hardware for maintaining the maximum performance and a scalable business intelligence system.
• ETL process: in the process of ETL, the extraction of data is done from the operational systems and then they are loaded in a data warehouse.

The management support systems of the company are utilised for focusing on the managerial utilisation of the resources of information. The three kinds of management support systems that are presently utilised by the company are:

Decision support systems: These systems are designed for backing the process of decision making in the company by the managers for improving the competence of the managers and improve the proficiency of the whole enterprise. For example, at the organisation Star Max, the managers gain significantly updated information about the present market developments and the business environment for making better informed decisions.

Executive information systems: The utilisation of DSS is extensively done in the company for providing better informed decisions to the managers for strategically plan the growth of the company. The executive information system is utilised by the company is done for providing the executives of the company with fast access and updated, specific information and the reports of execution with the facilities for personalised analysis and information. For example, the managers use the information gathered using the information systems to make informed decisions.

Expert systems: A business expert system performs the tasks of receiving a problem from a user, then identifies the requirements of the data, analyses the associated data against the rules of decision. These systems also simulate the activities of humans and keeps on systematising and capturing the knowledge of business, extends the capabilities of decision-making for allowing other individuals to use the experiences of decision. Artificial intelligence systems are implemented in several sector of the business for providing automated solutions to the issues of the queries.

The existing infrastructure of the company consists of computers with remote access to the internet, firewall implemented for securing the network, a small business server, computer systems of front desk of the organisation, accounting, and executive management connected to the protected network and the storage place of cloud that is provided by an external vendor for managing the data of the organisation.

This is a business intelligence system with the Microsoft BI stack. The requirements of the proposed system are the implementation of the SQL server and Microsoft SQL server 2012 and the implementation of Sharepoint 2013, which have the data sources as databases, cloud services, LOB applications and the OData feeds.

NPV of all costs $ 1, 58,612.18

Overall NPV $ 3, 35,996.20

Overall ROI 2. 1184

Annual Income: $ 1, 08,000.00

Total assets: $ 79, 8000

ROA: $ 1.25 

For implementing the BI system in the organisation, the predicted hardware cost could be considered as $65,000.00, the cost of required software is $800.00, the salaries of the development team is predicted as $9,000.00 and the cost of training could be considered as$5,000.00.

Risk register

Prioritisation of risk with the development of the risk matrix can be an effective approach towards bringing a quantitative method for the restriction and minimization of the impact of risks to an extent. This is the following risk matrix that is based on the analysis focussed in the section above:

Analysis of the BI systems of the competitors

Conclusion

Therefore, it can concluded that the BI system implementation in the Star Max is executed with modified technologies. The company SmartHome Mach is a company that is trusted of over 300 of the leading telecom of the world. The company provides the best services and solutions for the retail roaming and end-to-end wholesale for over two decades that addresses the needs of business of several stakeholders all over the organisation like the marketing, finance, IoT, and fraud.  The company could implement the proposed BI system for improving the business of the organisation. A cost benefit analysis has been done and a risk assessment matrix has been provided.

Accorsi, R., Manzini, R. and Maranesi, F., 2014. A decision-support system for the design and management of warehousing systems. Computers in Industry, 65(1), pp.175-186.

Cabrerizo, F.J., Morente-Molinera, J.A., Pérez, I.J., López-Gijón, J. and Herrera-Viedma, E., 2015. A decision support system to develop a quality management in academic digital libraries. Information Sciences, 323, pp.48-58.

Catthoor, F., Wuytack, S., de Greef, G.E., Banica, F., Nachtergaele, L. and Vandecappelle, A., 2013. Custom memory management methodology: Exploration of memory organisation for embedded multimedia system design. Springer Science & Business Media.

Demesouka, O.E., Vavatsikos, A.P. and Anagnostopoulos, K.P., 2013. Suitability analysis for siting MSW landfills and its multicriteria spatial decision support system: method, implementation and case study. Waste management, 33(5), pp.1190-1206.

George, J., Kumar, V. and Kumar, S., 2015, July. Data warehouse design considerations for a healthcare business intelligence system. In World congress on engineering.

Griggs, D., Stafford-Smith, M., Gaffney, O., Rockström, J., Öhman, M.C., Shyamsundar, P., Steffen, W., Glaser, G., Kanie, N. and Noble, I., 2013. Policy: Sustainable development goals for people and planet. Nature, 495(7441), p.305.

Hadad, Y., Keren, B. and Laslo, Z., 2013. A decision-making support system module for project manager selection according to past performance. International Journal of Project Management, 31(4), pp.532-541.

Horita, F.E., de Albuquerque, J.P., Degrossi, L.C., Mendiondo, E.M. and Ueyama, J., 2015. Development of a spatial decision support system for flood risk management in Brazil that combines volunteered geographic information with wireless sensor networks. Computers & Geosciences, 80, pp.84-94.

I??K, Ö., Jones, M.C. and Sidorova, A., 2013. Business intelligence success: The roles of BI capabilities and decision environments. Information & Management, 50(1), pp.13-23.

Kennedy, A., Rogers, A., Chew-Graham, C., Blakeman, T., Bowen, R., Gardner, C., Lee, V., Morris, R. and Protheroe, J., 2014. Implementation of a self-management support approach (WISE) across a health system: a process evaluation explaining what did and did not work for organisations, clinicians and patients. Implementation Science, 9(1), p.129.

Kimball, R., Ross, M., Becker, B., Mundy, J. and Thornthwaite, W., 2015. The kimball group reader: Relentlessly practical tools for data warehousing and business intelligence remastered collection. John Wiley & Sons.

Knabke, T. and Olbrich, S., 2013, January. Understanding Information System Agility--The Example of Business Intelligence. In System Sciences (HICSS), 2013 46th Hawaii International Conference on (pp. 3817-3826). IEEE.

Kumar, D., Singh, J. and Singh, O.P., 2013. A fuzzy logic based decision support system for evaluation of suppliers in supply chain management practices. Mathematical and Computer Modelling, 58(11-12), pp.1679-1695.

Kumar, V., Holt, D., Ghobadian, A. and Garza-Reyes, J.A., 2015. Developing green supply chain management taxonomy-based decision support system. International Journal of Production Research, 53(21), pp.6372-6389.

Li, X., Hsieh, J.P.A. and Rai, A., 2013. Motivational differences across post-acceptance information system usage behaviors: An investigation in the business intelligence systems context. Information systems research, 24(3), pp.659-682.

Lin, H.F., 2014. Understanding the determinants of electronic supply chain management system adoption: Using the technology–organization–environment framework. Technological Forecasting and Social Change, 86, pp.80-92.

Nedelcu, B., 2013. Business intelligence systems. Database Systems Journal, 4(4), pp.12-20.

Sangar, A.B. and Iahad, N.B.A., 2013. Critical factors that affect the success of business intelligence systems (BIS) implementation in an organization. International Journal of Scientific & Technology Research, 2(2), pp.176-180.

Sauter, V.L., 2014. Decision support systems for business intelligence. John Wiley & Sons.

Starhome. (2018). Home Page - Starhome. [online] Available at: https://www.starhomemach.com/ [Accessed 5 Dec. 2018].

Tank, D.M., 2015. Enable better and timelier decision-making using real-time business intelligence system. International Journal of Information Engineering and Electronic Business, 7(1), p.43.

Tsuji, G.Y., Hoogenboom, G. and Thornton, P.K. eds., 2013. Understanding options for agricultural production (Vol. 7). Springer Science & Business Media.

Turban, E., Sharda, R., Delen, D. and Efraim, T., 2014. Decision support and business intelligence systems (Vol. 9). Pearson.

Vukši?, V.B., Bach, M.P. and Popovi?, A., 2013. Supporting performance management with business process management and business intelligence: A case analysis of integration and orchestration. International journal of information management, 33(4), pp.613-619.