Business intelligence and data warehousing

Introduction to Business Intelligence as Analytical System

This module provides an overview of Business Intelligence and data analysis, emphasizing the importance of analytical systems in the business context. Participants will gain insights into how data is analyzed and will be introduced to the fundamental concepts of Business Intelligence.

Designing a Data Warehouse

In this module, participants will learn the steps to design and implement analytical databases, including the multidimensional model OLTP. They will explore the process of designing a data warehouse and understand the requirements for OLAP in a practical business intelligence project.

The ETL process and Analytical queries with SQL

Participants will delve into the Extract, Transform, and Load (ETL) process and learn how to execute analytical queries using SQL. They will explore typical OLAP operations and gain hands-on experience in formulating analytical queries for a bookstore scenario.

Predictive Analytics with Data mining

This module focuses on the process of data mining and introduces participants to the ID3 algorithm. Participants will gain a comprehensive understanding of data mining, engage in formative exercises, and apply predictive analytics techniques to real-world scenarios.

The problem of integration and analysis of unstructured data

Participants will explore different data types based on the structure of data and learn to integrate, store, and analyze unstructured data effectively. This module provides insights into handling unstructured data and its significance in the context of business intelligence and data warehousing.

Big Data and Hadoop Framework

Participants will gain a clear understanding of Big Data, the analysis of unstructured data, and the concepts of the Hadoop Framework. They will engage in practical labs to apply their knowledge and develop the skills necessary for analyzing data using the Hadoop framework for business intelligence purposes.