TOP Analytics courses for advanced

The course teaches the PL/SQL language version of Oracle 11g R2: software constructs such as procedures, functions, packages and triggers; some of the standard packages; dynamic SQL; Bulk data downloads using collections; ways to influence the compilation of PL/SQL code and the dependency management mechanism. The tool used is Oracle SQL Developer.

Learn to professionally create financial models in Excel to assess the state of business in different sectors of the economy and growth prospects. You will be able to apply for a promotion or organize effective management of your own business. Master the preparation of financial statements and carrying out plan-factual analysis. You will be able to evaluate companies using different methods, including DCF.

A practical online course, where in 4 months of training you will learn to competently control sales, marketing, finance and logistics of the company. You will understand how to effectively attract clients, organize the work of your sales department and increase your company’s market share.

In this course, you will learn how to access and process data from a range of data sources, including both relational and non-relational data. This course will also cover how to implement proper security standards and policies across the entire spectrum of Power BI, including datasets and groups. * *the course is taught in partnership with the ARMKYBERSEC Academy

Training. The program volume is 72 hours. If you want to learn how to develop a strategy, actively develop and win, this course was created especially for you!!! Engage in business development, not routine operations, and we will help you with this!

Expand your Excel skills: create macros, automate similar calculations using scenarios, scripts for similar calculations, implement new ones using the VBA programming language functions.

• From perceptron to GAN: only practical cases • Add 8 projects to your portfolio • Flexible learning path, support from a community of experts, consultations with a mentor

This program will help you learn how to build models with random factors for quantities with different types of distributions. To make it easier to master the course materials, you will need a basic understanding of linear models (general and generalized), basic knowledge of R and the ability to create simple .html documents using rmarkdown and knitr.

This is a course about data visualization and the basics of working with Tableau. It is suitable for those who want to be able to draw good quality graphics quickly and efficiently (and no programming required!). The ability to build graphs and communicate your data is already a basic necessity for working with them. The practice is built around Tableau (one of the most popular BI tools). Tableau is one of the top skills on the market right now, so that would be a +1 great line for a resume. And the lecture part will allow you to distinguish bad graphs from good ones and laugh together at 3D paycharts.

Learn to evaluate the solvency of all levels of a business or individual using financial analysis. We will tell you how to identify possible falsification of documents and collect reliable information about the borrower. We will teach you how to build financial models based on scenario forecasts and test covenants.

You will learn to build financial models from scratch to analyze the company's position and its growth opportunities. You will understand how to conduct plan-fact analysis and evaluate a business using various methods, including DCF. You will be able to move to a higher position or build financial models for your company.

The latest version of Microsoft Office 365/2021 has a built-in programming language called Visual Basic for Applications (VBA) still remains the main most important means of automating the work of users with office applications. The largest number of application tasks that require the use of macros arise when working with Excel spreadsheets. Experienced users can independently cope with Microsoft Excel 365/2021/2019 automation issues if they master the capabilities of macro programming in VBA.

4,3

1 review

Advanced training program. The course teaches the SQL query language and the procedural programming language PL/pgSQL of the PostgreSQL DBMS. During the course, students will master creating queries, commands for changing data, creating PL/pgSQL blocks, using cursors, triggers, creating functions and other program objects in PL/pgSQL and SQL.

• Take your data engineering to the next level • Learn to build architecture and automate pipelines for analytics areas with high workload• Become part of a professional community and learn to work with technologies used by the world's top companies