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.