Business Information System

Syllabus

Thematic definition of lectures: 1. Business Information system (IS) - characteristics, basic forms of information systems. Basic components of IS - information technology, data, information, knowledge, people. Aspects influencing information systems. IS services and applications. IS application architecture. Specifics of IS for small and medium-sized enterprises. 2. IS functionality for SMEs. Price and cost of IS. Development trends in application software and type application software. 3. Business process modelling - business process modelling, reasons and techniques for modelling. EPC diagrams, their characteristics, tools, basic elements, rules for creating EPC diagrams. Business process visualization in ARIS software. 4. Enterprise Resource Planning (ERP) and Extended ERP category information systems. Functionality of ERP systems in the field of production, logistics, HR and economics. ERP features. Classification of ERP by industry and functional focus, by size of enterprises. Criteria for selection of ERP systems. Traditional ERP solutions versus open source ERP systems - advantages, disadvantages. 5. ERP systems in the cloud, basic models according to the services provided. Comparison of cloud solutions "one-to-one" ERP, "one-to-many" ERP, ERP on customer's servers. Overview of IS products for SMEs. 6. Customer Relationship Management (CRM) systems - CRM philosophy, view through customer relationship processes and through customer relationship development. CRM application architecture - operational, analytical and collaborative parts. 7. Classification of CRM by discipline and functional focus. Typical user and products by discipline and function. Trends in CRM - ERM, Social CRM. 8. Supply chain management (SCM) systems - supply chain, supply chain flows, processes and levels. Processes in the chain in terms of a series of cycles. SCM concepts - chain design and structuring, chain planning, chain operation. Principles of chain management. Classification of APS/SCM systems. 9. Business Intelligence (BI) systems - their role, features, processes, tools. General concept of BI systems architecture and roles of each layer - data transformation components, database components, analytical components, end-user tools, domain expertise. 10. Application areas of use of BI systems. Benefits of BI systems. BI software applications. Basic functionality of Power BI Desktop. 11. Executive information systems - definition, their meaning and use, integration in enterprise architecture. Expert systems - definition, elements of an expert system, its creation, benefits and limitations for the organization. Presentation of specific expert systems in the field of finance, loans, detection of production errors and processes, etc., costs of their acquisition and management. 12. IS implementation principles and procedures - strategic decisions, project management - preparation, IS implementation, operation, maintenance and development. Business manager's guide to IS implementation. 13. Application software procurement process - explanation of the individual steps of the process with all its details (initial preparation phase, deciding type application software or individual software, completing the selection process within each phase), 4 basic criteria for selecting the method of software acquisition. Application software selection evaluation metrics. Thematic definition of exercises: 1. Design of a simple database application for a small enterprise - import of data into a database application program. Correction of data structure. Creation of sessions. Work with other database application objects - forms, queries, reports. Interpretation of query results and output reports. Data and data base as a part of IS. 2. Functionality of economic software for small businesses on the example of Omega accounting software - work in selected modules of invoicing and inventory management, solving a case study of the purchasing process. Generation of reports (balance sheet, profit and loss statement, VAT statement,...) and financial ratios (liquidity, activity, debt, profitability). 3. Functionality of the software application in the field of HR and payroll on the example of the Olymp solution. Processing of personal and work data on employees, generation of payroll data, payroll calculation status, transfer orders. Financial statistics (overview of payroll costs). Generation of reports and exports. Customer relationship management functionality using the example of a software solution for small businesses. 4. Business process modelling in ARIS - rules for creating EPC diagrams (events, activities, logical connectors, additional objects). Visualization of a business process in ARIS using an EPC diagram, demonstration of a modeled process in ARIS with application of diagramming rules. Modelling of a specific business process. 5. Customer relationship management systems - CRM system user interface, basic objects and working with them. Functionality of the Marketing module. Processes taking place in the Marketing module: creating a marketing campaign, approaching a potential customer, implementing customer acquisition activities, acquiring a potential customer, converting a potential customer into a contact/organization, opportunity. 6. CRM system functionality in sales and inventory management - managing the sales process through CRM system. Creation of product and service within a given marketing campaign, conversion of acquired business opportunity into quotation, binding quotation, order received, approval of order received, invoice issued, payment received. Inventory management. 7. CRM system functionality in project management and sales support - project management process in CRM system, creation of project tasks, milestones, and visualization using Gantt chart. Support module functionality - customer process flow, service contract creation, list of sold products, working with customer ticket, customer portal and its functionality. Evaluation of the effectiveness of key indicators in the CRM system and their presentation using dashboard and reporting. 8. Business Intelligence category systems - user interface of Microsoft Power BI (desktop) and basic functionality. Data transformation, validation and editing. Query editor. Applying changes. Data enrichment. 9. Data analysis in BI applications - creating data model, creating calculation formulas, calculations and analysis. Tools for creating data visualizations and graphical groupings of data. 10. Data visualizations, dashboards in BI applications. Interpretation of visualizations and complex dashboards, economic evaluation of outputs, decision making. 11. Solving complex case study in BI application - data import, upload, transformation, editing, enrichment, data model creation, analysis, creation of visualizations, complex dashboard with economic evaluation of output. 12. Simulator of flows running in the SCM system - SCM focusing on individual flows and its comparison with the functionality of the CRM system. Basic rules and purpose of the flow simulator in SCM, implementation of the simulation, analysis of the knowledge gained during the simulation, repetition of the simulation in order to apply the evaluated knowledge and improve the decisions originally taken, evaluation of the simulations and analysis of problem areas. 13. Information systems in business practice - case studies, case study of the use of various information systems in business management, current status - use of information systems in business practice. Presentations of case studies and seminar papers of students.