Published On Sep 27, 2021
▬▬▬▬▬▬▬▬ DATA WAREHOUSE FULL COURSE ▬▬▬▬▬▬▬▬
0) 00:00 - Topics
1) 04:02 - Introduction
2) 12:03 - Data Warehouse Architecture
3) 17:25 - Data Warehouse Terminologies
4) 44:10 - Business Case Study
5) 46:28 - Data Warehouse Designing
6) 1:04:37 - Data Warehouse Implementation
7) 1:23:14 - SSIS
8) 1:56:29 - Surrogate Key
9) 1:58:54 - Slowly Changing Dimension
10) 2:27:00 - Adding data to Dimension and Incremental Load
11) 2:37:02 - Deploy SSIS Package and SQL Agent Schedule
12) 2:47:31 - SSAS Tabular Model
13) 2:54:13 - Creating Power BI Reports
Installing SQL Server and SSDT SSMS
• Installing SQL Server Analysis Servic...
Adventure works OLTP Database download
https://github.com/Microsoft/sql-serv...
AWN Data warehouse Database Scripts
https://drive.google.com/file/d/1-oEO...
✉ Business Queries / Analytics Consulting ✉ : [email protected]
💬 For Learners Post queries and Interact 💬
Telegram Channel - http://t.me/analyticswithnags
Linkedin Page - / analyticswithnags
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Installation - Pow...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N rows in Power BI ...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power BI DAX Tutorial ...
Power BI Services Playlist 📚📖 • Introduction to Power BI Service (1/30)
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Analysis in Power B...
Data Warehouse Tutorials 📚📖 • Introduction | Data Warehouse Tutoria...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | Course Introduct...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Server Analysis S...
SSIS Tutorials - SQL Server Integration Services 📚📖 • Introduction to SQL Server Integratio...
Power BI Interview Topics 📚📖 • What to Expect in Power BI Interview ...
MSBI (SSIS,SSAS,SSRS) Interview Topics 📚📖 • What to Expect in MSBI (SSIS,SSAS,SSR...
Excel for Data Analysis 📚📖 • Analytics with Nags YouTube Channel O...
Power BI + R 📚📖 • Analytics with Nags YouTube Channel O...
Azure for Analytics - Complete Tutorials 📚📖 • Analytics with Nags YouTube Channel O...
Catch with Nags 📚📖 • Catch Up With Nags - Intro - Week 19 ...
Nags Checklist 📚📖 • 5 Things to Consider when starting Po...
Visuals with Nags 📚📖 • Visuals With Nags - Intro