The two-day course aims to acquaint students with the basics of R language. Its content is to learn the basic properties of the R language, data types, variables, basic constructions, objects, exceptions, write scripts, use packages and modules.
The two-day course aims to familiarize students with the possibilities of working with data, to perform data transformations, analysis and visualizations in R. Its content is also to learn how to use packages and modules for work with data and visualizations.
The Azure AI Fundamentals course introduces AI and the Microsoft services students can use to create AI solutions.
This course introduces fundamentals concepts related to artificial intelligence (AI), and the services in Microsoft Azure that can be used to create AI solutions. The course is not designed to teach students to become professional data scientists or software developers, but rather to build awareness of common AI workloads and the ability to identify Azure services to support them.
Designing and Implementing an Azure AI Solution is intended for software developers wanting to build AI infused applications that leverage Azure Cognitive Services, Azure Cognitive Search, and Microsoft Bot Framework. The course will use C# or Python as the programming language.
In this course, the students will explore the objectives of data platform modernization and how it is suitable for given business requirements. The student will learn how to migrate to the three target platforms for SQL based workloads: Azure Virtual Machines, Azure SQL Databases, Azure SQL Database Managed Instances. Student also will learn the benefits and limitations of each target platform, how they can be used to fulfil both business and technical requirements for modern SQL workloads and the available migration tools.
This course will teach the students what is Cosmos DB and how you can migrate MongoDB and Cassandra workloads to Cosmos DB.
This course will enable the students to understand Azure SQL Database, and educate the students on what is required to migrate Open Source Data workloads to Azure SQL Database.
This 4-day instructor led course provides students with analyzing data using Microsoft SQL Server Reporting Services. The course discusses how to use the development tools to create and manage reports, manage, expand Reporting Services and implement self-service BI solutions.
This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.
This 3-day course will teach users how to use Microsoft Power BI, perform data analysis, create dashboards and reports using Microsoft Power BI Desktop. The course includes import and transformation of data, creation and modification of a data model, use of DAX language for calculations, creation of visualizations and publication of results. The course uses the Power BI Desktop tool, the PowerBI.com service and the Power BI Report Server.
This 2-day instructor led course is intended for anyone responsible for analyzing and reporting data with Microsoft Excel. The course goes beyond the capabilities of tables, Pivot tables, charts and Pivot Charts, the Excel Data Model and DAX language.
This 3-day instructor led course provides students with creating a managing data models in Microsoft SQL Server. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, measure groups and learn how to use MDX and DAX.
The three-day course aims to introduce students to the basics of Python. Its content is to learn basic Python features, data types, variables, basic constructs, exceptions, scripts, OOP, packages and modules.
The three-day course aims to familiarize students with the possibilities of working with data, to perform transformations, analysis and visualization in Python. Its content is to learn to use packages and modules for work with data. It focuses mainly on the Pandas, NumPy and Dask libraries and its possibilities in data processing and publication.
Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.