Enrolment options
Udemy - SQLETLData Warehouse Developer -(MS-SQL, SSIS, SSRS, SSAS) 2022-5
Course modified date: 30 Jan 2025
- Enrolled students: There are no students enrolled in this course.
Guests cannot access this course. Please log in.
Udemy - SQLETLData Warehouse Developer -(MS-SQL, SSIS, SSRS, SSAS) 2022-5
Course content
Sections:
11
•
Activities:
0
•
Resources:
97
- 1 Introduction
- 2 What is a data warehouse
- 3 Databases vs Data warehouse
- 4 What is SQL Server
- 5 SQL Server Editions
- 6 SQL Server Installation Requirements
- 7 Download SQL Server
- 8 Install SQL Server
- 9 Install SSMS
- 10 Connect SSMS to SQL Server
- 11 Install sample database
- 12 Install sample data warehouse database
- 13 Enable SQL Server Agent
- 14 Enable Database settings for data warehouse
- 1 What is Visual Studio
- 2 Installing Visual Studio
- 3 Installing SQL Server Data Tools SSDT
- 4 Install SSDT BI Templates
- 1 Hardware Requirements for data warehouse
- 2 Using FTDW Sizing Tool
- 3 Logical design
- 4 Physical design Part 1
- 5 Physical design Part 2
- 6 Designing Dimension Tables
- 1 What is ETL
- 2 What is SSIS
- 3 introduction to ETL SSIS
- 4 Creating a new SSIS Project
- 5 Exploring data source Part 1
- 6 Exploring data source Part 2
- 7 Introduction to control flow Part 1
- 8 Introduction to control flow Part 2
- 9 Implementing data flow Part 1
- 10 Implementing data flow Part 2
- 1 Debugging SSIS Package Part 1
- 2 Debugging SSIS Package Part 2
- 3 Logging SSIS Package events
- 4 Handling errors in SSIS Package
- 1 Introduction
- 2 Extracting modified data Part 1
- 3 Extracting modified data Part 2
- 4 Extracting modified data Part 3
- 5 Extracting modified data Part 4
- 6 Loading modified data Part 1
- 7 Loading modified data Part 2
- 8 Working with slowly changing dimensions
- 1 Integration services catalogs
- 2 Deploying SSIS Solutions
- 3 Executing a package with SQL Server
- 4 Configuring advanced SSIS Settings
- 1 Installing Data Quality Services
- 2 Cleansing data with data quality services
- 3 Finding duplicate data with data quality services Part 1
- 4 Finding duplicate data with data quality services Part 2
- 5 Using data quality services in SSIS Data Flow
- 10 Previewing report
- 11 Exporting report
- 1 What is SSRS
- 2 Create a report server project
- 3 Create a report definition file
- 4 Configure a data source for the report
- 5 Define a dataset for report
- 6 Add a table to report
- 7 Format report
- 8 Grouping data in report
- 9 Adding totals to the report
- 1 What is SSAS
- 2 Installing SSAS
- 3 Connecting to SSAS
- 4 Create a tabular model project
- 5 Explore tabular model authoring
- 6 Create a connection to data source
- 7 Transform import data
- 8 Mark as data table
- 9 Create table relationships
- 10 Create calculated columns Part 1
- 11 Create calculated columns Part 2
- 12 Creating measures Part 1
- 13 Creating measures Part 2
- 14 Creating measures Part 3
- 15 Create Key Performance Indicators
- 16 Create Perspectives
- 17 Create Hierarchies Part 1
- 18 Create Hierarchies Part 2
- 19 What are partitions
- 20 Creating Partitions
- 21 Creating roles
- 22 Analyze in Excel
- 23 Deploy your model
- 24 Analyze Model
- 1 Introduction to Business Intelligence
- 2 Create a report with SSRS
- 3 Using Reporting services with Data Warehouse Part 1
- 4 Using Reporting services with Data Warehouse Part 2
- 5 Creating new SSAS Project
- 6 Data Analysis with SSAS Part 1
- 7 Data Analysis with SSAS Part 2