Vistula School of Hospitality

AVAILABLE TRAININGS

• Data Analyst-32h

  ⇒ W-16h Data analysis in MS Excel

  You will learn more about:

  • preparation of data for analysis
  • creation of sheets
  • use of various Excel functions
  • data analysis and evaluation
  • carrying out forecasts and simulations
  • use of scenarios
  • carrying out analyzes with the use of a pivot table

  ⇒ W-16h Using Power Pivot tool in data analysis

  You will learn more about:

  • downloading data to the Power Pivot too
  • building and managing database relationships
  • creating tables and pivot charts based on prepared data
  • the use of Data Analysis Expressions

• Advanced Data Analyst-48h

  ⇒ T-24h MS 40364 Basics of database administration

  You will learn more about:

  • key concepts regarding databases
  • creating database object
  • data manipulation
  • data storage
  • selected issues of database administration

   

  ⇒ W-24h Downloading and modification of data from the SQL database

  You will learn more about:

  • basic concepts of database structure
  • connecting the client application to the database
  • obtaining information about database objects
  • defining the data source for the SELECT command
  • selecting columns and the use of aliases
  • filtering data, combining files
  • sorting the result set
  • grouping data (GROUP BY), aggregating data using aggregate functions (sum, average, minimum, max, counter)
  • the use of selected built-in functions
  • conversion of data types, the use of stored procedures
  • the use of auxiliary permanent and temporary tables
  • adding new rows using the INSERT command
  • modifying the existing data using the UPDATE command
  • deleting data using the DELETE command
  • MS SQL Window functions: ranking, aggregation, offset, analytic, MS SQL Pivot LINPIVOT, MS SQL Spatial Data, VS SQL XML. VS SQL JSON.

• Cloud Aplication Developer-112h

  ⇒ T-40h MS 20483 Programming in C#

  This training will allow you to gain knowledge about:

  • C language syntax
  • methods, exception handling and application monitoring
  • structure and enumeration
  • creating collection classes
  • creating a hierarchy of classes using inheritance
  • reading and writing data locally
  • accessing databases
  • remote accessing data via WS and Cloud
  • user interface design for graphic applications
  • ensuring application performance through multithreading and asynchrony
  • integration of unmanaged code
  • code management
  • data encryption and decryption

   

  ⇒ T-32h MS 20532 Creating Solutions for Microsoft Azure

  During this training you will learn more about:

  • introduction to the Microsoft Azure platform
  • creating a development environment using Azure virtual machines
  • hosting web applications on the Azure platform
  • storing SQL data in Azure
  • designing flexible applications in the cloud
  • management of cloud services in Azure
  • non-logical data storage in Azure
  • storing and the use of files in Azure Storage
  • communication strategy design using queues and service bus
  • Azure infrastructure management
  • automation of integration with Azure resources
  • securing web applications in Azure
  • maintaining and monitoring web application solutions in Azure

   

  ⇒ T-40h MS 20487 Programming of WEB Services and Azure Services

  During this training you will learn more about:

  • introduction to cloud technology services
  • accessing data using the Entity Framework
  • creating and using ASP.NET Web API services
  • expanding and protecting services written with the use of Web API
  • creating services using WCF
  • services hosting
  • Windows Azure Service Bus
  • implementation of services
  • storing data through Windows Azure Storage
  • monitoring and diagnostics
  • authentication and access management
  • service scaling
  • Appendix A: Designing and extending WCF services
  • Appendix B: Securing services written using WCF

• Team Leader-48h

  ⇒  CT-32h Team Skills and Leadership (Team Management and Leadership)

  During this training you will learn about:

   

  Team management through:

  • defining roles in a team
  • identification of manager values and behaviors
  • recognizing your own style of management to increase the efficiency of individual people and teams
  • organization of your own work and the work of the team

   

  How to increase teamwork efficiency by:

  • analysis of the influence of the leadership style on the team’s performance based on case study
  • defining the importance of team performance in achieving organizational goals
  • recognizing and eliminating poor results
  • application of incentive techniques to increase team and individual performance
  • resolving conflicts

   

  ⇒  W-16h Training of Creative Thinking Techniques and Problem Solving

  During this training you will learn:

  • how to effectively identify problems in the workplace
  • methods of generating appropriate solutions
  • techniques of delegating activities within given solutions
  • methods for assessing solutions and monitoring their implementation

• Project Manager (Agile)-56h

  ⇒ CS-24h Prince2® Foundation

  This training will allow you to gain knowledge about:

  • PRINCE2® rules and business justification
  • final product
  • strategic project management
  • quality, plans, risks in a project
  • control and completion of a project stage and delivery of products
  • project closure

   

  ⇒ W-16h Effective Team Management and Team Motivation Skills

  During this workshop you will gain knowledge about:

  • defining the significance of a vision, mission and values
  • employee involvement in relation to organization strategies, motivation
    theories, leadership styles that help increase the effectiveness of individual people and teams

   

  ⇒ W-16h Agile for Project Managers

  During this workshop you will gain knowledge about:

  • Agile philosophy
  • Roles and responsibilities in the project
  • Managing the Agile project
  • Agile processes and products
  • Communication within the project
  • Setting priorities
  • Steering the Agile project
  • Planning agile projects

• Advanced Project Manager -56h

  ⇒ CT-24h Prince2® Foundation

  During this training you will gain knowledge about:

  • PRINCE2® Methodology (Effective Project Management)
  • key issues necessary for the effective use of the PRINCE2® methodology,
    including the correct start-up, conscious running and controlled closure of
    the project

   

  ⇒ CS-24h Prince2® Agile Practitioner

  During this training you will learn more about:

  • project management using Agile techniques based on the PRINCE2 AgileTM
    guide (organization, risk management, product development, progress
    visualization tools)

   

  ⇒ W-8h Business simulation using Citta Ideale business type game

  During this workshop you will gain knowledge about:

  • effective use of Agile philosophies and techniques in complex, multi-team
    project environments
  • possibilities of independent decision making
  • analyzing the achieved results in order to draw conclusions for the future
  • daily work practices of Scrum teams
  • planning and coordination of a complex agile project
  • ways of cooperating with the corporate governance bodies of the PRINCE2®
    methodology (Effective Project Management)

• Specialist for managing suppliers in IT projects -72h

  ⇒ W-16h How to talk about services with the Business?

  During this workshop you will gain knowledge about:

  • building the Business – IT and IT – Supplier partner relations
  • roles at the interface between IT and Sub-suppliers: Suppliers Manager,
    Contract Manager and Sub-supplier
  • effective service level management – process, goals, key steps, products,
    challenges
  • effective supplier management – process, goals, key steps, products,
    challenges

   

  ⇒ CT-24h PRINCE2® Foundation

  This training will allow you to gain knowledge about:

  • PRINCE2® Methodology (Effective Project Management)
  • key issues necessary for the effective use of the PRINCE2® methodology,
    including the correct start-up, conscious running and controlled closure of
    the project

   

  ⇒ W-16h SLA agreements for IT services delivery (SLA)

  During this workshop you will learn more about:

  • creating good contracts for the provision of IT services (SLAs, OLA contracts with external suppliers)
  • daily contract management
  • reporting and acceptance of provided services

   

  ⇒ W-16h Purchasing Negotiations

  During this workshop you will learn more about:

  • the essence of purchasing negotiations
  • evaluation of the negotiating partner
  • exerting influence on the negotiating partner
  • techniques used during purchasing negotiations
  • selected elements of training assertiveness used in negotiations

• Sales Specialist-40h

  ⇒ W-24h IT support for budgeting provided services

  During this workshop you will learn about:

  • preparation data for analysis
  • organizing the data on the sheet
  • monitoring data correctness with respect to defined assumptions
  • creating sheets and reports
  • using built-in functions
  • making investment decisions in the context of the results of the analysis
  • using scenarios to compare simulation values
  • analysis of reports using a PivotTable and PivotChart report
  • integrating Microsoft Excel with other programs

   

  ⇒ W-16h Using CRM type of applications

  During this workshop you will learn:

  • account and contacts data management
  • handling activities
  • bidding, ordering
  • scheduling the salesman’s work
  • queue management
  • sales analysis

• Accounting and finance department specialist -88h

  ⇒ W-24h Analysis of financial and accounting data in Microsoft Excel

  During this workshop you will learn more about:

  • preparing data to conduct a financial analysis
  • organizing the data on the sheet
  • monitoring data correctness of with respect to defined assumptions
  • creating financial sheets
  • use of financial functions
  • investment assessment and analysis
  • making investment decisions in the context of a changing financial situation
  • financial forecasting and simulation
  • using scenarios to compare the value of financial sheets
  • analysis of financial statements using the PivotTable and PivotChart report
  • integration of Microsoft Excel with other programs

   

  ⇒ W-40h Support for full accounting in the enterprise using industry-specific software

  During this workshop you will learn more about:

  • account assignment and booking of documents
  • the use of an automatic account assignment
  • preparing e-Declaration and e-transfers
  • VAT registers handling
  • cost planning

   

  ⇒ W-16h Fixed asset management using industry-specific software

  During this workshop you will gain knowledge about:

  • keeping records of fixed assets of the enterprise
  • keeping equipment records
  • handling fixed assets
  • depreciation calculation

   

  ⇒ W-8h Analysis and reporting of data using industry-specific software

  During this workshop you will gain knowledge about:

  • creating multidimensional financial analyzes
  • creating multidimensional analyzes in the area of controlling

• HR & Payroll Specialist-72h

  ⇒ W-24h The Use of Excel by an HR & Payroll Specialist

  During this workshop you will learn more about:

  • preparing data for analysis
  • organizing data on the sheet
  • monitoring the correctness of data with respect to defined assumptions
  • creating HR and payroll statements
  • using financial functions
  • using scenarios to compare the values of generated sheets
  • data visualization
  • analysis of reports using a PivotTable and PivotChart report
  • Microsoft Excel integration with other programs

   

  ⇒ W-24h Support of industry-specific software for HR and payroll processes

  During this workshop you will learn more about:

  • creating HR and payroll documents and declarations
  • servicing civil law contracts
  • remuneration budgeting and settlement
  • exporting of data to the Płatnik program and the use of PFRON system

  ⇒ W-16h The use of the Płatnik program

  During this workshop you will gain knowledge about:

  • data import in the Płatnik program
  • creating and handling sets of settlement declarations
  • bilateral information exchange with the Social Insurance Institution system

  ⇒ W-8h Analysis of data and reporting using industry-specific software

  During this workshop you will gain knowledge about:

  • creating multidimensional analyzes in the HR area
  • use of IT applications for recording and analyzing of concluded contracts
    (employment contract, contract of mandate or task-specific contract)
  • exporting to generally used file formats

• Leasing Specialist-32h

  • ⇒ W-16h Basic use of IT applications supporting the process of concluding a leasing contract

    During this workshop you will learn more about:

    • handling customer records
    • establishing new contracts
    • servicing active contracts
    • contracts transfer and closure

    ⇒ W-16h Basic use of applications conducting financial and accounting processes in leasing

    During this workshop you will learn more about:

    • booking documents regarding leasing contracts
    • settlement of accounts with Users
    • invoicing and re-invoicing
    • the use of VAT registers and generating reports

• Transport and aerospace industry specialist -120h/person|36 persons|: certified training

  ⇒ CT-60h Basics of air transport and air transport management

  During this training you will learn more about:

  • the emergence and development of the aerospace industry
  • operational and business functions of an airline
  • key airline employees – their responsibilities, tasks and areas of responsibility
  • ways of effective management
  • crisis management

  ⇒ CT-60h Basics of the aerospace industry and management of an aerospace industry company

  During this training you will learn more about:

  • the emergence, development and the present of the aerospace industry
  • international and regional aerospace organizations and institutions
  • key employees of aerospace institutions and organizations – their duties,
    tasks and areas of responsibility