Nenokavē un piesakies studiju kursam “Datu pārvaldība” par īpašu dalībnieka cenu!


Laika periodā no 2019. gada 23. maija līdz 9. jūnijam Banku augstskolā norisināsies studiju kurss “Datu pārvaldība” (angļu val.), kurš sadalīts 3 moduļos. Kursa un moduļu apraksts ir skatāms zemāk.

Interesentiem ir iespējams pieteikties gan uz visu kursu, gan atsevišķiem moduļiem.
Lektors – Elchin Jafarov

1.modulis – Excel for Finance – 23/05/2019 – 26/05/2019

2.modulis – Management Information Systems – 06/06/2019 – 09/06/2019

3. modulis – Automation with VBA and R coding – 13/06/2019 – 16/06/2019

  • 1 moduļa cena 300 EUR 180 EUR;
  • Reģistrācijas maksa 20 EUR (piesakoties uzreiz uz vairāk nekā vienu moduli, papildus reģistrācijas maksas netiek piemērotas);
  • Maksa par visu studiju kursu 900 EUR 560 EUR (iekļaujot reģistrācijas maksu);
  • Norises vieta: Banku augstskola Kr.Valdemāra ielā 161;
  • Kafija un uzkodas iekļautas cenā;
  • Valoda – angļu.

Pieteikšanās –  E-pasts:, tālrunis +371 29111462

Data Management

Data is the oil of the contemporary generation. It became one of the most valuable assets, which companies possess. Like crude oil, it could be left “underground”, or simply burned in the furnace, bringing primitive value. But if data mined, processed and treated properly, it could bring a whole level of productivity and make billions of wealth, by fueling the new digital economy. Many leading companies are paying increasing attention and intensively investing capital into data technologies. Interestingly, even simple approaches to managing data can generate plenty of value for your business. How? We will master those in our series of course.

Excel for finance – 23/05/2019 – 26/05/2019

Simply more profession and efficient usage of Excel already can make your work with data enjoyable and considerably more valuable. The course will cover:

  • Addressing objects in Excel and working with objects
  • Data types, variables and arrays in Excel: solving the bugs in multiple Excel file environments
  • Data importing, advanced Power Queries and working with data.
  • Processing textual data
  • Working with date/time
  • Logic flow in Excel: beyond the simple IF
  • Data aggregation (with SUMMIFS/COUTIFS and advanced array formulas)
  • Data query: (LOOKUPs, INDEX/MATCH and OFFSETing)
  • Advanced intelligence dashboards in Excel with slicers, table-relationships and advanced PivotTables.

Management Information Systems – 06/06/2019 – 09/06/2019

The course covers major digital trends in modern organization and elaborates on such buzzwords as Cloud, IoT, Artificial Intelligence, Machine Learning, SaaS, PaaS, IaaS, Big Data, ERP and others. We will concentrate on applied Data Analytics and Business Intelligence by overviewing and using the existing software and solutions for handling and practical usage of data. Our primary tools will be Microsoft Power BI and SQL for database solutions.

Automation with VBA and R coding – 13/06/2019 – 16/06/2019

Boring daily routines with Excel? Visual Basic for Applications (VBA) solves that. In this course we learn and apply basic coding, which helps you to delegate a lot of workflow to the computer. In the second we practice the most powerful data processing and visualization tool – R programming.


VBA track
R track
Excel DOM (Document object Model) Introduction to R-studio and packages
Learning to read the code: it is simple if you try Tidy data and tidyverse package
Writing our own procedures R data frames and tibbles
Coding custom Excel functions Data transformation with dplyr
More on variables, arrays and data types Managing long and wide data
Loops and their usage R pipes (%>% magrittr)
Program flow Powerful visualization with ggplot2 – the grammar of graphics.
Error handling