COURSES FOR BUSINESS USERS
Training courses included in programme "Training for businesses users" are:
Basic rules for creating reports, charts and data visualization
Workshop objective is to introduce students with Microsoft BI tools and Tableau for the Data Visualization. Through a series of exercises and tasks, student will master the basic functionality of these tools and make a series of reports and exercises.
Reporting using Power Pivot
Objective of this workshop is to introduce students with the concept of modeling tables in star schemas to optimize reporting needs and principles of POWERPIVOT connectivity with external systems, as well as with import of data into POWERPIVOT by combining a variety of data sources (Excel, databases and so on). Student will be able to write the most important formulas for creating reports and analysis. Also, they will see the typical use of POWERPIVOT for analyzes and reports that are most commonly used in controlling.
At the end of the workshop, students are familiar with the concept of PowerQuery tool, how to capture PowerQuery steps, and how to easily modify taken steps. The main goal of this workshop is to master the PowerQuery tool to help automation of the repetitive tasks.
Advanced Excel course
At the end of the workshop students are introduced to the advanced concepts of MS Excel; they will be able to merge multiple tables, create reports using pivot and find out what they are interested in by analyzing data.
VBA – Visual basic – Programming in Excel
Participants get familiar with the introduction to programming, basic concepts, Excel macros, capturing and editing macros in the VB editor, creating Excel applications, connecting to Excel databases, concept of database reporting within Excel.
This workshop elaborates the following topics: the concept of Power BI data preparation, data import, data model design and data analysis and how to select the right visualization technique for message transfer.
Statistics basics for non-mathematicians
The aim of the workshop is to provide non-mathematicians an introduction to statistical analysis of data. Students will get the theoretical background and will use SPSS Statistics, one of the most commonly used tools in statistical analysis, to independently make exercises and examples.
Leading tool for analyzing and visualizing data. There are two workshops that are Tableau oriented, Basic Tableau training and advanced Tableau visualization methods. First covers standard loading data to Tableau, and creating reports and combining them to dashboards and the other is more focused on how to create right visualization and storytelling with data.
Advanced Excel course consists of three one day courses and summarizes most of advanced Excel tools that enable users to use this tool more efficiently.
1. Excel for reporting
Using Power BI and power Query – solves the problem for very large datasets, typical extension to pivot tables, using power query to automate loading and preparing data for reporting.
2. Advanced Excel
Better understanding of formulas such as vlookup, sumif(s), exact, eomonth, PV, PMT, and others, working with graphs, nested functions, pivot table advanced options, filtering and sorting, error handling, and so on…
3. Marcos and Visual basic
Learning the basics of macros. Learning the basics of VBA and Excel object model. Creating user defined functions and mixing them with excel functions. Unleash the power of simple VBA programs to help create flexible and simple solutions in complex Excel tasks.