อบรม Designing Business Intelligence And Data Warehouse Solutions with Microsoft SQL Server 2017 Database สอนโดยมืออาชีพ

หัวข้อการอบรม

Module 1: Introduction to Business Intelligence and Data Modeling

  • Lesson 1: Elements of an Enterprise BI Solution
  • Lesson 2: Overview of BI Solution

Module 2: Creating SSIS Package

  • Lesson 1: ETL Operations
  • Lesson 2: Data Warehouse Operations
  • Lesson 3: Analysis Services Operations
  • Lesson 4: Reporting Services Operations

Module 3: Designing and Implementing ETL

  • Lesson 1: Designing an ETL Solution (Extraction Transformation Load)
  • Lesson 2: Designing and Implementing Control Flow
  • Lesson 3: Designing and Implementing Data Flow

Module 4: Deploy SSIS Package

  • Lesson 1: Installing SSIS and Deploying Packages
  • Lesson 2: Executing and Securing Packages
  • Lesson 3: Executing and Securing Packages

Module 5: Implementing Data Warehouse

  • Lesson 1: Data Warehouse Design Overview
  • Lesson 2: Designing Dimension Tables
  • Lesson 3: Designing Fact Table

Module 6: Creating Multidimensional Databases

  • Lesson 1: Using Multidimensional Model
  • Lesson 2: Using MDX language
  • Lesson 3: Cubes and Dimensions
  • Lesson 4: Measures and Measure Groups
  • Lesson 5: Tabular Data Model

Module 7: Designing a Reporting Services Solution

  • Lesson 1: Designing Reports
  • Lesson 2: Connect Database BI

Module 8: Designing a Microsoft Excel-Based Reporting Solution

  • Lesson 1: Using Excel for Data Analysis and Reporting
  • Lesson 2: PowerPivot for Excel
  • Lesson 3: Power View for Excel

Module 9: Designing Power BI Desktop for Business Analytics

  • Lesson 1: Installing Power BI
  • Lesson 2: Overview of Power BI
  • Lesson 3: Connect Database BI
  • Lesson 4: Using Power BI

สนใจอบรมติดต่อ

  • โทร: 02-652-7060
  • อีเมล: info@ctt-center.co.th