73436 - Laboratory of Information Technology for Business

Academic Year 2017/2018

  • Docente: Ercole Vagnozzi
  • Credits: 4
  • Language: Italian
  • Teaching Mode: Traditional lectures
  • Campus: Bologna
  • Corso: First cycle degree programme (L) in Business Administration (cod. 8871)

Course contents

Course contents

PART I- INTRODUCTION

1. THE INFORMATION MANAGEMENT IN A COMPANY
2. ACCOUNTING SYSTEMS for Enterprises (EDP)
3. ACCOUNTING MANAGEMENT SYSTEMS for enterprises (ERP)
4. MONO-SYSTEMS AND CLIENT / SERVER

PART II - ADMINISTRATIVE / ACCOUNTING FIELD -Aaccounting Management system settings

1. PARAMETERSCONFIGURATION
2. AUDITORS' PLAN
3. ACCOUNTING CAUSALS
4. RECORDINGS OF FIRST NOTE
5. PRINTS:
a. THE JOURNAL BOOK
b. BUDGET
c. VAT REGISTERS

PART III - USE OF a MANAGEMENT Prgram

1. PURCHASE FORM
2. SALES FORM
3. GENERAL ACCOUNTING MODULE
4. OBSERVATIONS AT THE END OF THE YEAR

PART IV - BUSINESS INTELLIGENCE
- ETL (extract load transformation) of data and system settings with BI software QLIKVIEW or SPAGOBI

1. standard Interface of the query formulation
2. Drill Down
3. roll up
4. Data Cube (slice-and-dice)

Readings/Bibliography

-The course includes theoretical skills be studied through lecture notes deposited on campus link https://campus.cib.unibo.it

- the use of two softwares available in the lab and to be downloaded:


Management system called ODOO or openerp to download

ETL (Extract Transformation Load) through software and workbench manual available in green lab and sto download at: http://www.mysql.it/products/workbench/


Business intelligence software named QlikView full of examples and downloadable manual from the link http://www.qlikview.com/it

Teaching methods

The course provides a comprehensive overview on the use of computerized accounting systems, dealing with a point of view of both theoretical and practical issues related to the main business processes and their automation.

Assessment methods

The final evaluation will cover the following modules:
1. Case studys to be directly solved through the accounting management system and the creation of the BI system;
2.open questions on theoretical topics presented in class

Teaching tools

The course will take place almost exclusively with the use of PC
The softwares used are in the bibliography

Links to further information

http://www.serice.it

Office hours

See the website of Ercole Vagnozzi