1652 Adanced Use of Excel for Data Management in Business Environment

1652 Adanced Use of Excel for Data Management in Business Environment

  • Study programme and level: University degree programme Public sector governance 1st Cycle
  • 2nd or 3rd year
  • 6 ECTS
  • Course type: Elective
  • Lectures: 30
  • Other forms of study: 90
  • Individual work: 60
  • Lecturer: Mitja Dečman, PhD

1. Objectives and competences


  • student understands and uses data modelling for information retrieval
  • student is able to use software tools for querying data in databases based on business data
  • student knows methods and tools for data querying and analysing
  • student know software tools for data transfer to web environment
  • student understands concepts of web presentation of data and information
  • student can break down and analyse web presentations.


  • student develops capabilities of usage of information and telecommunication technology for gathering, management and distribution of data
  • is able to individually build and make data models, adapted analyses, dashboards and develop key performance indicators
  • knows how to use basic DAX for dynamic analysis
  • can use Excel PowerPivot, PowerView in PowerMap.

2. Content

  • The impact of information technology on the process of gathering, analysis and presenting data and information
  • Excel functionalities for data analysis and information gathering
  • Excel functionalities for data visualization
  • The use of Excel's Power Pivot Tool
  • The use of Excel's Power Map Tool using database and multiple tables
  • Introducing Web technologies
  • Web presentation approaches for data
  • Mark-up languages for presenting data on the Web (HTML and XML)
  • Practical implementation of simple Web presentations of data

3. Readings

  • DEČMAN, M. (2017). Napredna raba excela za uporabo podatkov v poslovnem okolju prosojnice. Fakulteta za upravo, Ljubljana.
  • McFedries, P. (2016). Teach yourself visually Excel 2016, Indianapolis: J. Wiley & Sons, cop. 2016. Izbrana poglavja, 120 str.
  • Collie, R., in Singh, A. (2016). Power Pivot and Power BI: The Excel User’s Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016 (2 edition). Uniontown, OH: Holy Macro! Books. Izbrana poglavja, 80 str.
  • Vsebine v spletni učilnici.

4. Intended learning outcomes


  • knows and uses practical approach toward data modelling.
  • knows software tools for data management in business environment
  • can independently construct a simple database and analytically manage data
  • knows the concepts of web presentation of data and information.

5. Learning and teaching methods

  • student preparations for lectures
  • lecture
  • practical work in laboratory
  • e-learning

6. Assessment

  • written or spoken exam (40%)
  • practical exam (60%)

To get the final grade the following condition must be met:
Exam must be positive (must more than 50 %),
Al segments must be positive (more than 50 %).