This course is designed for: - Company managers. - Business and financial analysts. - Managers, heads of departments and specialists of all types and ranks responsible for a specific subject area. - Anyone interested in Business Intelligence and its application. In this course, you will learn how to work independently with Microsoft Excel, a popular software for analysing numerical business data, and analyse large volumes of data using this software. Microsoft Excel has a rich set of different data analysis tools. The course material is divided into 3 parts. The first part contains 7 assignments for Excel spreadsheet data analysis and the second part contains 4 assignments for Excel business charts. The third part is dedicated to pivot tables and contains 12 assignments and detailed instructions. Detailed training material will be provided for the learners.
You will learn about the possibilities of analysing Excel tables and how to use pivot tables to analyse large volumes of data with complex structures. You will also learn how to load data from Excel workbooks, Access and SQL Server data into the Excel internal model. The main expected outcomes of this training are to analyse the performance of companies and organisations based on the available large amounts of digital information. You will acquire the following professional competencies: - Know how to import business intelligence output data from databases and Excel files. - Analyse this data using business charts and pivot tables. - Create interactive dashboards for data analysis with rich visualisations and use them for decision-making.
phone: +370 37 453 445
el. p. julija.melkova@ktu.lt
Dr. Vigintas Šakys is an associate professor at Kaunas University of Technology and a nationally renowned specialist in information technology training. Thousands of local students and graduates have studied and are still studying with the help of textbooks and books written by this specialist, of which he has published more than 20, alone and with co-authors. In recent years, V. Šakys has authored and published a large-scale modern textbook on business intelligence for graduates and students of higher education institutions, as well as several educational books, including a practice book on business intelligence and a remote slide book with video recordings of assignments. The training material contained in these books has been used in the preparation of these training courses.
The training is designed to teach the practical analysis of large-scale data with Excel Power Pivot and Power View plug-ins and the DAX expression programming language
Blended learning / 20 ac. hrs.
The training is designed to provide the knowledge and practical skills to analyse large-scale data with Microsoft Power BI Desktop
Blended learning / 20 ac. hrs.
The training is designed to provide the knowledge and skills to develop and apply econometric models
On-campus learning / 8 ac. hrs.
The training is designed to provide knowledge and skills in the application of statistical methods for the analysis of quantitative data
Distance learning / 40 ac. hrs.
K. Donelaičio St. 73
44249 Kaunas, Lithuania
phone: +370 (671) 36 146
email mvg@ktu.lt
