BUSINESS INTELLIGENCE

This two-day intensive training program is designed to equip participants with comprehensive understanding and practical skills in data warehousing and ETL processes using modern tools such as Azure Data Factory, SQL Server Analysis Services (SSAS), and Power BI. Participants will engage in both theoretical discussions and hands-on labs to master the creation, implementation, and management of data warehousing solutions, crucial for supporting business intelligence and data-driven decision-making in enterprises.

Training fee per participant (Exclusive of VAT) 44,360,000 VND

Training fee per participant (Inclusive of VAT) 47,908,800 VND

This course is designed for individuals who want to gain a solid understanding of Business Intelligence principles and techniques. Ideal candidates include data analysts, business analysts, marketing managers, and finance professionals seeking to enhance their data-driven decision-making skills.

By the end of this training, participants will be able to:

Understand the core concepts and benefits of data warehousing in business contexts.
Design and implement ETL workflows using Azure Data Factory, focusing on integrating data from various sources, including SAP.
Apply incremental ETL techniques to enhance data processing efficiency.
Utilize SSAS Tabular models for effective data analysis.
Develop insightful data visualizations and dashboards using Power BI

Course Content:
- Module 1: Introduction to Data Warehousing Concepts in Enterprises
- Understanding the need for data warehousing in modern enterprises.
- Exploring key components of a data warehouse architecture.
- Analyzing the benefits and challenges associated with data warehousing.
- Reviewing case studies of successful data warehouse implementations.
- Activities: Interactive presentations, group discussions, and case study analyses.
- Module 2: Building ETL Solutions with Azure Data Factory
- Introduction to Azure Data Factory (ADF) and its role in ETL processes.
- Detailed overview of the ETL (Extract, Transform, Load) cycle.
- Techniques for connecting to diverse data sources.
- Steps for creating effective pipelines in Azure Data Factory to facilitate ETL operations.
- Activities: Hands-on lab on building an ETL pipeline in sample database
- Module 3: Implementing Incremental ETL Process
- Detailed understanding of incremental ETL processes and their importance in large datasets.
- Different techniques for implementing incremental ETL to optimize data refreshes.
- Using Azure Data Factory features to manage incremental ETL tasks.
- Activities: Hands-on lab to implement an incremental ETL process in Azure Data Factory
- Module 4: Implementing Tabular Model in SSAS On-Premise and Visualization with Power BI
- Introduction to SSAS Tabular model and its advantages over other models.
- Techniques for creating and managing tabular models in SSAS.
- Exploring DAX for defining relationships, calculated columns, and measures.
- Introduction to data visualization with Power BI.
- Connecting Power BI to various data sources.
- Building and customizing visualizations and dashboards.
- Activities: Designing a tabular model in SSAS and creating a dashboard in Power BI with a live connection to SSAS.
**** All labs of this course will be based on sample database which is designed by training team.
Trainer Profiles

Form liên hệ

Enrolment Form 2024 – Public Course