Excel for Business Intelligence
Discuss about the Business Information System And Business Innovation.
A business information system is a promising field and it includes the strategies that help an guide the professionals to meet the organizational-legal requirements, driving the business innovation, strategic goals and providing assistance to the business that needs to comply with the complex legal systems. Business Information Systems are extensively used for setting an organization’s strategic decision, used by the financial and the accounting managers that use the financial systems for the purpose of the business reporting and financial management (Beynon-Davies 2013). The study deals with a case study of a company named United Milk Products and deals with the business process model.
Table 1: Total orders for the year 2016 to 2018
Total orders 2018 |
Total orders 2017 |
Total orders 2016 |
|
Coles express |
22 |
19 |
15 |
7eleven |
16 |
13 |
11 |
BP |
15 |
12 |
10 |
Bill’s milkbar |
6 |
6 |
5 |
Totals |
59 |
50 |
41 |
Graph 1: Total orders from 2016 to 2018
Table 2: Total crate/carton sold by product code (W32) 2017
Product code |
FM |
WM |
RF |
LF |
SM |
UM |
A2 |
OM |
Quantity |
216 |
117 |
90 |
54 |
48 |
48 |
45 |
36 |
Graph: total carton ordered by product code for the year 2017
From the above table 1, it can be seen that the total number of the orders in the year 2018 is much higher compared to the year 2016 and 2017. The year 2018 has shown an increased number of sales in all the Coles express, 7eleven, BP and Bill’s milkbar. The Coles express is found to be exhibiting the highest number of sales in comparison to Bill’s milkbar, BP and 7eleven. The data reflects the customer order with respect to the Cole express is high in all the 3 years.
The data from the table 2 reflects that flavoured milk is the most favoured product among the customers and it is best selling product in comparison to all other products. The whole milk is the next best product that is favoured by the customers. The next product with the decent number of sales is the reduced fat milk and is the third best seller. This is being ranked between the light milk and whole milk. The rest of the products that range from the low-fat milk to the organic milk have all showed terrible sales performance. The product line in between the low-fat milk and the organic milk showed a big difference in terms of the sales.
United Milk Products needs to develop a mobile compliant version for the purpose of making a new ordering system and thus two different types of the app can be considered. The two options available are mobile webpage app and native standalone app. Among the two different type of the app system, the native standalone app provides the best solution for the United Milk Products business.
Responses
The native standalone apps are installed on a mobile device whether it is running an Android OS or an iOS. The native apps are installed through the Apple’s app store or Google Play. The native standalone app is able to take the full advantage of the different hardware features available on a mobile device. For example, the app can use the contacts, compass, accelerometer, GPS and camera (Jobe 2013). The mobile webpage apps are not actually apps, they are websites and differ in several ways with respect to the native standalone app in terms of feel and look. The mobile webpage app run by a browser and are written in HTML5 (Rastogi et al. 2016).
- The time to load a webpage is reduced and thus the customers do not have to wait for longer times. The mobile apps load faster because a majority of the information is already stored in an app. This makes an app to work even in offline mode (Holzinger, Treitler and Slany 2012).
- Apps act as a constant reminder of a business entity. The presence of an app makes brand visible on a customer’s phone as it always stays visible on the phone. The mobile apps provide a seamless connectivity with the customers and make it valuable tools for the business (Gao et al. 2014).
- The mobile apps capable of increasing the customer engagement. The businesses that use the native apps help in improving the customer engagement by increasing the accessibility. The mobile apps provide the option to seamlessly connect with the customers and make the business viable (Holzinger, Treitler and Slany 2012).
- Apps reduce the cost of the business. When native apps are used it reduces the cost that arises from the sending the newsletters and the SMS messages. Native apps help in communicating directly, instantly and securely with the customers. Apps are also potential in reducing the staff workload through the phone calls and information requests (Gao et al. 2014).
- The user interface of the app will include the different types of the products offered by the UMP. The UI or the user interface will have the account for the login of the customers. The products offered by the UMP must have sections that can be categorized into various types. After ordering a product, the app must be providing a feature of tracking the order from packaging to delivery.
- Budget considerations for the app development will require as an app developer who will work for the development and working on the future bugs. After developing the app, it needs to be submitted to the Google play store and the Apple app store which will require 25 dollars and 99 dollars respectively as a onetime fee (Xanthopoulos and Xinogalos 2013).
Web analytics can be described as the analysis, reporting and the collection of the website data. The focus is put on identifying measures that are based on the user and the organizational goals and this utilizes the website data in order to determine the failure and the success of the goals (Chaffey and Patron 2012).
Social network analysis can be defined as the measuring and map the relationship and the flows between the URLs, computer, organizations, groups and people and the other connected knowledge and information entities (Burt, Kilduff and Tasselli 2013).
Customer relationship management can be described as the guidelines, practices and the principles that an organization follows when it interacts with its customers (Wang and Feng 2012).
Web analytics- the environment from where the information is collected are the data from the customer satisfaction surveys, keyword research tools, user testing, multivariate testing, heat maps, scroll-tracking and click through, web analytics tools, page level surveys. The types of the information that are collected are the website search, search visits to a website, online user that are coming to a website (Hammer and Hammer, International Business Machines Corp 2012). The benefits that arise from the web analytics are as follows:
- Web analytics provides an insight into the data.
- Enables communication with the stakeholders.
- Is not restricted towards only providing the traffic reports.
- Encourages the data-driven environment for the purpose of decision making (Järvinen and Karjaluoto 2015).
Social network analysis- the environment from where the data is collected are from the online social networking sites. The information that is collected is information from the URLs, knowledge or the information entities, computers, organizations, groups and people that are associated with the social network. The benefits that arise from the data that are collected through the social network analysis helps the organizations to know the personalized tastes of the customers, the trends that they follow, also helps the organizations to make products that are more customer-centric (Waters 2014).
Cybersecurity measures
Customer relationship management- the environment where the data are collected are from the cloud-based systems that provide the real-time data through the computer and the smartphone that are connected to the internet. The types of information that are collected are the organizational and the direct interaction between the customer, service and sales-related processes, analysis and the forecasting of the customer behaviours and the trends. One of the major benefits of such customer relationship management is the real-time retrieval and the analysis of the data (Kumar and Reinartz 2018).
Deterrent |
Detective |
Preventing |
Compensation |
Corrective |
Recovery |
|
Administration |
Policy |
Review of the incident reports |
Processes that include the user registration |
Rotation of the jobs, supervision, guidebooks. |
Termination |
Data breach plan |
Operational |
Warning banner |
Logs, data breach systems |
Password for login, data breach prevention systems. |
Firewall workstations |
Checkpoint restart, unplug, isolate and terminate the connections |
Fault tolerance, local backups, redundant array of independent disks (RAID) |
Technical |
Security provisions |
Data breach alarms |
Firewall systems |
Ant-hacking teams and systems |
Anti-hacking and anti-data theft systems |
Data backup into separate systems. |
In Australia, there is a Privacy Amendment (Private Sector) Act 2000
The act requires that the data needs to be shared, stored and collected that are based on certain guidelines and also places guidelines that do not allow the personal information to be shared overseas.it also mentions that the individuals must be given an opportunity wherever it is applicable and the personal information must be given an option of anonymity (Legislation.gov.au 2018).
Conclusion
From the above study, it can be concluded that the business information system is vital for the viability and the and the cut-throat competition that the organization goes through. The companies rely on the effective managerial decisions and strategic planning for the purpose of greater managerial transparency and organizational conduct. The assignment deals with a case study company called the United Milk Products and it is planning to introduce the mobile app-based ordering system that will help increase the sales of the UMP products. The latest business also takes into account of the business information system like the cybersecurity and the customer privacy laws.
Reference
Beynon-Davies, P., 2013. Business information systems. Palgrave Macmillan.
Burt, R.S., Kilduff, M. and Tasselli, S. 2013, Social network analysis: Foundations and frontiers on advantage. Annual review of psychology, 64, pp.527-547.
Chaffey, D. and Patron, M. 2012, From web analytics to digital marketing optimization: Increasing the commercial value of digital analytics. Journal of Direct, Data and Digital Marketing Practice, 14(1), pp.30-45.
Gao, J., Bai, X., Tsai, W.T. and Uehara, T. 2014, Mobile application testing: a tutorial. Computer, 47(2), pp.46-55.
Hammer, E.R. and Hammer, S.C., International Business Machines Corp 2012, Determining web analytics information. U.S. Patent 8,234,370.
Holzinger, A., Treitler, P. and Slany, W. 2012. August. Making apps useable on multiple different mobile platforms: On interoperability for business application development on smartphones. In International Conference on Availability, Reliability, and Security (pp. 176-189). Springer, Berlin, Heidelberg.
Järvinen, J. and Karjaluoto, H. 2015, The use of Web analytics for digital marketing performance measurement. Industrial Marketing Management, 50, pp.117-127.
Jobe, W. 2013, Native apps vs. mobile web apps. International Journal of Interactive Mobile Technologies (iJIM), 7(4), pp.27-32.
Kumar, V. and Reinartz, W. 2018, Customer relationship management: Concept, strategy, and tools. Springer.
Legislation.gov.au 2018, “Privacy Amendment (Private Sector) Act 2000”, Legislation.gov.au, viewed 28 May, 2018, <https://www.legislation.gov.au/Details/C2004A00748>.
Rastogi, V., Shao, R., Chen, Y., Pan, X., Zou, S. and Riley, R. 2016, Detecting Hidden Attacks through the Mobile App-Web Interfaces. In 2016 Network and Distributed System Security Symposium (NDSS). The Internet.
Wang, Y. and Feng, H. 2012, Customer relationship management capabilities: Measurement, antecedents and consequences. Management Decision, 50(1), pp.115-129.
Waters, N. 2014, Social network analysis. In Handbook of regional science (pp. 725-740). Springer Berlin Heidelberg.
Xanthopoulos, S. and Xinogalos, S. 2013, A comparative analysis of cross-platform development approaches for mobile applications. In Proceedings of the 6th Balkan Conference in Informatics (pp. 213-220). ACM.