Business Intelligence
Workshop AI
Unfortunately, this course is available only in Czech language. To view information about the course, please switch website into Czech language.
Microsoft Power Platform Functional Consultant
Unfortunately, this course is available only in Czech language. To view information about the course, please switch website into Czech language.
Analyzing Data with SQL Server Reporting Services
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 has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.
Microsoft Power BI Data Analyst
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 course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.
Microsoft Power BI Desktop
Unfortunately, this course is available only in Czech language. To view information about the course, please switch website into Czech language.
DAX in Power BI
Unfortunately, this course is available only in Czech language. To view information about the course, please switch website into Czech language.
Microsoft Power Platform App Maker
Unfortunately, this course is available only in Czech language. To view information about the course, please switch website into Czech language.
Analyzing Data with Excel
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.
Power Query
Unfortunately, this course is available only in Czech language. To view information about the course, please switch website into Czech language.
Developing Data Models using SQL Server Analysis Services
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.
This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.
Basics of Python Language
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.
Data Analysis Using Python
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.