Business Intelligence

PDF to download

Analyzing Data with SQL Server Reporting Services

DB-REPORTS

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

PL-300

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.

02/07/2023 - 02/09/2023 cs
21 800 CZK Add to cart
04/04/2023 - 04/06/2023 cs
21 800 CZK Add to cart
06/13/2023 - 06/15/2023 cs
21 800 CZK Add to cart

Microsoft Power BI Desktop

PowerBI

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.

03/14/2023 - 03/16/2023 cs
16 500 CZK Add to cart
05/02/2023 - 05/04/2023 cs
16 500 CZK Add to cart

Analyzing Data with Excel

DB-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.

02/14/2023 - 02/15/2023 cs
11 000 CZK Add to cart
04/25/2023 - 04/26/2023 cs
11 000 CZK Add to cart
06/13/2023 - 06/14/2023 cs
11 000 CZK Add to cart

Developing Data Models using SQL Server Analysis Services

DB-ANALYSIS

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

Python1

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.

01/24/2023 - 01/26/2023 cs
15 600 CZK Add to cart
03/21/2023 - 03/23/2023 cs
15 600 CZK Add to cart
05/09/2023 - 05/11/2023 cs
15 600 CZK Add to cart

Data Analysis Using Python

Python2

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.

02/14/2023 - 02/16/2023 cs
15 600 CZK Add to cart
04/11/2023 - 04/13/2023 cs
15 600 CZK Add to cart
06/06/2023 - 06/08/2023 cs
15 600 CZK Add to cart

Prices do not include VAT. OKsystem a.s. reserves the right to change dates and prices of courses.