Apply for a special participant price for the “Data Management” study course!

13.05.2020.

During the period from 14th May to 7th June 2020, the BA School of Business and Finance offers to participate in a study course a “Data Management” which divided into 3 modules. The description of the course and modules is shown below.

Leads can apply for both the entire course and individual modules. The lectures will be online, as “hands-on sessions”, discussion and practical work non-stop.

Lecturer – Elchin Jafarov

Time of lectures:

IV, V 18:00-19:30, 19:40-21:00

VI,VII 09:00-10:30, 10:40-12:10, 13:00-14:30, 14:40-16:10

1st module – Excel for Finance – 14/05/2020 – 17/05/2020

2nd module – Management Information Systems – 28/05/2020 – 31/05/2020

3rd module – Automation and Programming – 04/06/2020 – 07/06/2020

  • 1 module price 300 EUR 180 EUR;
  • Registration fee 20 EUR (no additional registration fees apply when applied for more than one module);
  • Fee for the entire course of study 900 EUR 560 EUR (including registration fee);
  • Location: Online;
  • Language – English.

Registration –  E-mail: Tatjana.Mavrenko@ba.lv

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.

Management Information Systems

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 the Microsoft Power ecosystem, like Power Query, Power Pivot and Power BI (business intelligence).

Excel for finance

Simply more professional 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, PowerQuery and working with data.
  • Processing textual data
  • Working with date/time
  • Logic flow in Excel: beyond the simple IF
  • Wide and Long data
  • Data aggregation (with SUMMIFS/COUTIFS and advanced array formulas)
  • Data query using PowerQuery appends and merges
  • Advanced intelligence dashboards in Excel with slicers, table-relationships and advanced PoverPivot tables.

Power BI

Business intelligence requires powerful tools, and one of them is PowerBI. We will actively learn PowerBI functionality and apply it for creating measures and advanced analytics using DAX data analytics language.

  • Power BI interface
  • What can and cannot be done in Power BI
  • More on data extraction using PowerQuery
  • Data table relationships in Power BI
  • Creating calculated columns
  • Creating measures using DAX syntax
  • Advanced measures with iterators
  • Creating powerful dashboards
  • Using third party visuals

Automation with VBA and R coding

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.

VBA track

  • Excel DOM (Document Object Model)
  • Learning to read the code: it is simple if you try
  • Writing our own procedures
  • Coding custom Excel functions
  • More on variables, arrays and data types
  • Loops and their usage
  • Program flow
  • Error handling