This is complete Datawarehouse course in which we had tried to cover important concepts which will be helpful for cracking Data Analyst interviews..
Below are the topics covered in this video:
=================================
00:00:00 Introduction
00:01:21 Overview of Topics
00:04:41 What is DataWarehouse ?
00:09:34 Facts vs Dimensions
00:19:25 Quiz 1
00:20:56 Role Playing Dimensions
00:27:24 Slowly Changing Dimensions
00:40:15 Junk Dimensions
00:48:05 Degenerate Dimensions
00:54:51 Conformed Dimensions
01:04:57 Quiz 2
01:06:26 Types of Measures
01:14:38 Transactional Fact Table
01:22:09 Periodic Snapshot Fact Table
01:30:56 Accumulating Snapshot Fact Table
01:41:37 Fact-less Fact Table
01:49:53 Quiz 3
01:51:24 OLAP vs OLTP
02:03:26 What are DataMarts ?
02:17:09 Star Schema
==========================================
Checkout our SQL Interview Question Video:
[ Ссылка ]
Do watch our DAX 7 Hour Course:
[ Ссылка ]
Important Links:
⭐⭐⭐Power Query Videos playlist:📚📚
---------------------------------------------------------------------
[ Ссылка ]
⭐⭐⭐Data Modelling in Power BI videos playlist:📚📚
--------------------------------------------------------------------------------------------
[ Ссылка ]
⭐⭐⭐Power BI Interview Questions Playlist:📚📚
------------------------------------------------------------------------------------
[ Ссылка ]
⭐⭐⭐Power BI Concepts Playlist:📚📚
---------------------------------------------------------------------
[ Ссылка ]
⭐⭐⭐SQL Interview Questions Playlist:📚📚
---------------------------------------------------------------------
[ Ссылка ]
**********************************************************************
Website : [ Ссылка ]
Instagram : @house.of.concepts
**********************************************************************
#beginners #interview #interviews #database #sql #like #share #subscribe #excel #datanalytics #datascience #fullstack #tutorial #course #interview #project #mysql #window functions #pivoting
Ещё видео!