Business Intelligence

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.

Microsoft Power BI Desktop

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.

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.

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.